PulseUI

Clone Tools
  • last updated a few seconds ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Updating after review.

Adding changes as of today for MERGE to UPDATE statements.

Need to verify case statements as I see some syntax mismatch.

Select statements are tested.

Merge branch 'PUL-7220_Enterprise_DB_POC' of https://auapgpdgitapp01.genpt.net/Pulse/PulseUI into PUL-7220_Enterprise_DB_POC

Updating Merge statements to Insert statements

PUL-7241. Rewrite SP_PULSE_RULES SP

    • -61
    • +107
    /pulsedb/procedures/us_sp_pulse_rules.sql
PUL-7249. Rewrite PRE_SITE_PARAMETER_LOAD SP

PUL-7243. Rewrite VIRTUAL_SITE_PART_EXCHANGE SP

PUL-7242. Rewrite UPDATE_SITE_PARAMETER_FOR_SITE SP

    • -307
    • +329
    /pulsedb/procedures/update_site_parameter_for_site.sql
PUL-7240. Rewrite SESSION_CUBIC_MEASUREMENT SP

PUL-7239. Rewrite CALCULATE_PULSE_SESSION_TOTALS SP

    • -16
    • +16
    /pulsedb/procedures/calculate_pulse_session_totals.sql
PUL-7237. Rewrite CALC_TOTAL_SAVE_ORD_RET SP

    • -119
    • +142
    /pulsedb/procedures/calc_total_save_ord_ret.sql
PUL-7248. Rewrite SANITY_CHECK_APPEND SP

PUL-7238. Rewrite CAL_FORECAST_CRITICALITY_SESS SP

    • -47
    • +155
    /pulsedb/procedures/cal_forecast_criticality_sess.sql
PUL-7236. Rewrite CAL_DECOUPLE_TOTALS_UP SP

PUL-7223 Rewrite CREATE_NEW_SESSION SP

PUL-7234. Rewrite UPDATE_ORQTY_SITE_SESSION_TMP SP

    • -83
    • +119
    /pulsedb/procedures/update_orqty_site_session_tmp.sql
PUL-7229. Rewrite STOCK_IT SP

    • -45
    • +71
    /pulsedb/procedures/stock_it.sql
PUL-7230. Rewrite SP_LINK_ALL_CHILDREN SP

PUL-7227. Rewrite REVERT_TO_RECOMMENDED SP

PUL-7233. Rewrite REVERT_DECLINE_ORDER_RETURN SP

PUL-7228. Rewrite LINK_TO_PARENT SP

    • -74
    • +92
    /pulsedb/procedures/link_to_parent.sql
PUL-7232. Rewrite CALCULATE_TOTALS_UP SP

PUL-7231. Rewrite CALC_SPA_TOTALS_BELOW SP

PUL-7224. Rewrite ADD_SIMILAR_PARTS SP

    • -167
    • +151
    /pulsedb/procedures/add_similar_parts.sql
PUL-7223. Rewrite CREATE_NEW_SESSION SP

PUL-7226. Rewrite UNLINK_HIERARCHY_FROM_PARENT SP

PUL-7235. Rewrite CAL_TOTALS_SITE_SESS_HIER_TMP SP

    • -213
    • +294
    /pulsedb/procedures/cal_totals_site_sess_hier_tmp.sql
PUL-7225. Rewrite SAVE_SLIDER_VALUE SP

    • -11
    • +12
    /pulsedb/procedures/save_slider_value.sql
PUL-7225. Rewrite SAVE_SLIDER_VALUE SP

    • -54
    • +86
    /pulsedb/procedures/save_slider_value.sql
PUL-7220_Enterprise_DB_POC initial commit