[Home] [Help]
528:
529: If ((p_new_total_amount = p_old_total_amount) and (nvl(p_old_frcst_date,to_date('01/01/1900','DD/MM/RRRR')) = nvl(p_new_frcst_date,to_date('01/01/1900','DD/MM/RRRR'))) and (nvl(p_old_rolling_frcst_flg,'#') = nvl(p_new_rolling_frcst_flg,'#'))) then
530: Update as_sales_credits_denorm
531: Set object_version_number = nvl(object_version_number,0) + 1, last_update_date = SYSDATE
532: ,last_updated_by = NVL(FND_GLOBAL.login_id,-1)
533: ,creation_date = SYSDATE
534: ,created_by = p_new_created_by
535: ,last_update_login = p_new_last_update_login
536: ,lead_line_id = p_new_lead_line_id
574: End If;
575: convert_amounts(l_currency_code, trunc(nvl(l_decision_date,p_new_creation_date)), l_total_amount,l_sc_amount,l_converted_won_amount,l_converted_weighted_amount, l_conversion_status_flag);
576: Update as_sales_credits_denorm
577: Set object_version_number = nvl(object_version_number,0) + 1, last_update_date = sysdate
578: ,last_updated_by = NVL(FND_GLOBAL.login_id,-1)
579: ,creation_date = sysdate
580: ,created_by = p_new_created_by
581: ,last_update_login = p_new_last_update_login
582: ,lead_line_id = p_new_lead_line_id
1065: Set object_version_number = nvl(object_version_number,0) + 1, sales_credit_id = p_new_sales_credit_id
1066: ,opportunity_last_update_date = as_sc_denorm.scd_opp_last_upd_date(1)
1067: ,opportunity_last_updated_by = as_sc_denorm.scd_opp_last_upd_by(1)
1068: ,last_update_date = sysdate
1069: ,last_updated_by = NVL(FND_GLOBAL.login_id,-1)
1070: ,creation_date = sysdate
1071: ,created_by = p_new_created_by
1072: ,last_update_login = p_new_last_update_login
1073: ,sales_group_id = p_new_salesgroup_id
1294: (p_new_sales_credit_id
1295: ,as_sc_denorm.scd_opp_last_upd_date(1)
1296: ,as_sc_denorm.scd_opp_last_upd_by(1)
1297: ,sysdate
1298: ,NVL(FND_GLOBAL.login_id,-1)
1299: ,SYSDATE
1300: ,p_new_created_by
1301: ,p_new_last_update_login
1302: ,p_new_salesgroup_id