384: sold_to_site_use_id = decode(hdr_sold_to_site_use_id_tab(i),null,sold_to_site_use_id,hdr_sold_to_site_use_id_tab(i)),
385: end_customer_site_use_id = decode(hdr_end_cust_site_use_id_tab(i),null,end_customer_site_use_id,hdr_end_cust_site_use_id_tab(i)),
386: end_customer_id = decode(hdr_end_cust_id_tab(i),null,end_customer_id,hdr_end_cust_id_tab(i)),
387: last_update_date = sysdate,
388: last_updated_by = arp_standard.profile.user_id,
389: last_update_login = arp_standard.profile.last_update_login,
390: request_id = req_id,
391: program_application_id = arp_standard.profile.program_application_id ,
392: program_id = arp_standard.profile.program_id,
385: end_customer_site_use_id = decode(hdr_end_cust_site_use_id_tab(i),null,end_customer_site_use_id,hdr_end_cust_site_use_id_tab(i)),
386: end_customer_id = decode(hdr_end_cust_id_tab(i),null,end_customer_id,hdr_end_cust_id_tab(i)),
387: last_update_date = sysdate,
388: last_updated_by = arp_standard.profile.user_id,
389: last_update_login = arp_standard.profile.last_update_login,
390: request_id = req_id,
391: program_application_id = arp_standard.profile.program_application_id ,
392: program_id = arp_standard.profile.program_id,
393: program_update_date = SYSDATE,
387: last_update_date = sysdate,
388: last_updated_by = arp_standard.profile.user_id,
389: last_update_login = arp_standard.profile.last_update_login,
390: request_id = req_id,
391: program_application_id = arp_standard.profile.program_application_id ,
392: program_id = arp_standard.profile.program_id,
393: program_update_date = SYSDATE,
394: lock_control = lock_control+1
395: WHERE header_id = hdr_header_id_tab(i)
388: last_updated_by = arp_standard.profile.user_id,
389: last_update_login = arp_standard.profile.last_update_login,
390: request_id = req_id,
391: program_application_id = arp_standard.profile.program_application_id ,
392: program_id = arp_standard.profile.program_id,
393: program_update_date = SYSDATE,
394: lock_control = lock_control+1
395: WHERE header_id = hdr_header_id_tab(i)
396: RETURNING last_update_date bulk collect into dbi_header_update_date_tab;
702: deliver_to_org_id = decode(hhst_deliver_to_org_id_tab(i),null,deliver_to_org_id,hhst_deliver_to_org_id_tab(i)),
703: end_customer_site_use_id = decode(hhst_end_cust_site_use_id_tab(i),null,end_customer_site_use_id,hhst_end_cust_site_use_id_tab(i)),
704: end_customer_id = decode(hhst_end_cust_id_tab(i),null,end_customer_id,hhst_end_cust_id_tab(i)),
705: last_update_date = sysdate,
706: last_updated_by = arp_standard.profile.user_id,
707: last_update_login = arp_standard.profile.last_update_login,
708: request_id = req_id,
709: program_application_id = arp_standard.profile.program_application_id ,
710: program_id = arp_standard.profile.program_id,
703: end_customer_site_use_id = decode(hhst_end_cust_site_use_id_tab(i),null,end_customer_site_use_id,hhst_end_cust_site_use_id_tab(i)),
704: end_customer_id = decode(hhst_end_cust_id_tab(i),null,end_customer_id,hhst_end_cust_id_tab(i)),
705: last_update_date = sysdate,
706: last_updated_by = arp_standard.profile.user_id,
707: last_update_login = arp_standard.profile.last_update_login,
708: request_id = req_id,
709: program_application_id = arp_standard.profile.program_application_id ,
710: program_id = arp_standard.profile.program_id,
711: program_update_date = SYSDATE
705: last_update_date = sysdate,
706: last_updated_by = arp_standard.profile.user_id,
707: last_update_login = arp_standard.profile.last_update_login,
708: request_id = req_id,
709: program_application_id = arp_standard.profile.program_application_id ,
710: program_id = arp_standard.profile.program_id,
711: program_update_date = SYSDATE
712: WHERE header_id = hhst_header_id_tab(i);
713:
706: last_updated_by = arp_standard.profile.user_id,
707: last_update_login = arp_standard.profile.last_update_login,
708: request_id = req_id,
709: program_application_id = arp_standard.profile.program_application_id ,
710: program_id = arp_standard.profile.program_id,
711: program_update_date = SYSDATE
712: WHERE header_id = hhst_header_id_tab(i);
713:
714: g_count := sql%rowcount;
871: and m.request_id = req_id
872: and m.process_flag = 'N'
873: and m.set_number = set_num),
874: last_update_date = sysdate,
875: last_updated_by = arp_standard.profile.user_id,
876: last_update_login = arp_standard.profile.last_update_login,
877: request_id = req_id,
878: program_application_id =arp_standard.profile.program_application_id,
879: program_id = arp_standard.profile.program_id,
872: and m.process_flag = 'N'
873: and m.set_number = set_num),
874: last_update_date = sysdate,
875: last_updated_by = arp_standard.profile.user_id,
876: last_update_login = arp_standard.profile.last_update_login,
877: request_id = req_id,
878: program_application_id =arp_standard.profile.program_application_id,
879: program_id = arp_standard.profile.program_id,
880: program_update_date = sysdate
874: last_update_date = sysdate,
875: last_updated_by = arp_standard.profile.user_id,
876: last_update_login = arp_standard.profile.last_update_login,
877: request_id = req_id,
878: program_application_id =arp_standard.profile.program_application_id,
879: program_id = arp_standard.profile.program_id,
880: program_update_date = sysdate
881: where ship_to_org_id in (select m.duplicate_site_id
882: from ra_customer_merges m
875: last_updated_by = arp_standard.profile.user_id,
876: last_update_login = arp_standard.profile.last_update_login,
877: request_id = req_id,
878: program_application_id =arp_standard.profile.program_application_id,
879: program_id = arp_standard.profile.program_id,
880: program_update_date = sysdate
881: where ship_to_org_id in (select m.duplicate_site_id
882: from ra_customer_merges m
883: where m.process_flag = 'N'
898: and m.request_id = req_id
899: and m.process_flag = 'N'
900: and m.set_number = set_num),
901: last_update_date = sysdate,
902: last_updated_by = arp_standard.profile.user_id,
903: last_update_login = arp_standard.profile.last_update_login,
904: request_id = req_id,
905: program_application_id =arp_standard.profile.program_application_id,
906: program_id = arp_standard.profile.program_id,
899: and m.process_flag = 'N'
900: and m.set_number = set_num),
901: last_update_date = sysdate,
902: last_updated_by = arp_standard.profile.user_id,
903: last_update_login = arp_standard.profile.last_update_login,
904: request_id = req_id,
905: program_application_id =arp_standard.profile.program_application_id,
906: program_id = arp_standard.profile.program_id,
907: program_update_date = sysdate
901: last_update_date = sysdate,
902: last_updated_by = arp_standard.profile.user_id,
903: last_update_login = arp_standard.profile.last_update_login,
904: request_id = req_id,
905: program_application_id =arp_standard.profile.program_application_id,
906: program_id = arp_standard.profile.program_id,
907: program_update_date = sysdate
908: where invoice_to_org_id in (select m.duplicate_site_id
909: from ra_customer_merges m
902: last_updated_by = arp_standard.profile.user_id,
903: last_update_login = arp_standard.profile.last_update_login,
904: request_id = req_id,
905: program_application_id =arp_standard.profile.program_application_id,
906: program_id = arp_standard.profile.program_id,
907: program_update_date = sysdate
908: where invoice_to_org_id in (select m.duplicate_site_id
909: from ra_customer_merges m
910: where m.process_flag = 'N'
924: and m.request_id = req_id
925: and m.process_flag = 'N'
926: and m.set_number = set_num),
927: last_update_date = sysdate,
928: last_updated_by = arp_standard.profile.user_id,
929: last_update_login = arp_standard.profile.last_update_login,
930: request_id = req_id,
931: program_application_id =arp_standard.profile.program_application_id,
932: program_id = arp_standard.profile.program_id,
925: and m.process_flag = 'N'
926: and m.set_number = set_num),
927: last_update_date = sysdate,
928: last_updated_by = arp_standard.profile.user_id,
929: last_update_login = arp_standard.profile.last_update_login,
930: request_id = req_id,
931: program_application_id =arp_standard.profile.program_application_id,
932: program_id = arp_standard.profile.program_id,
933: program_update_date = sysdate
927: last_update_date = sysdate,
928: last_updated_by = arp_standard.profile.user_id,
929: last_update_login = arp_standard.profile.last_update_login,
930: request_id = req_id,
931: program_application_id =arp_standard.profile.program_application_id,
932: program_id = arp_standard.profile.program_id,
933: program_update_date = sysdate
934: where deliver_to_org_id in (select m.duplicate_site_id
935: from ra_customer_merges m
928: last_updated_by = arp_standard.profile.user_id,
929: last_update_login = arp_standard.profile.last_update_login,
930: request_id = req_id,
931: program_application_id =arp_standard.profile.program_application_id,
932: program_id = arp_standard.profile.program_id,
933: program_update_date = sysdate
934: where deliver_to_org_id in (select m.duplicate_site_id
935: from ra_customer_merges m
936: where m.process_flag = 'N'
956: and m.process_flag = 'N'
957: and m.request_id = req_id
958: and m.set_number = set_num),
959: last_update_date = sysdate,
960: last_updated_by = arp_standard.profile.user_id,
961: last_update_login = arp_standard.profile.last_update_login,
962: request_id = req_id,
963: program_application_id =arp_standard.profile.program_application_id,
964: program_id = arp_standard.profile.program_id,
957: and m.request_id = req_id
958: and m.set_number = set_num),
959: last_update_date = sysdate,
960: last_updated_by = arp_standard.profile.user_id,
961: last_update_login = arp_standard.profile.last_update_login,
962: request_id = req_id,
963: program_application_id =arp_standard.profile.program_application_id,
964: program_id = arp_standard.profile.program_id,
965: program_update_date = sysdate
959: last_update_date = sysdate,
960: last_updated_by = arp_standard.profile.user_id,
961: last_update_login = arp_standard.profile.last_update_login,
962: request_id = req_id,
963: program_application_id =arp_standard.profile.program_application_id,
964: program_id = arp_standard.profile.program_id,
965: program_update_date = sysdate
966: where sold_to_org_id in (select m.duplicate_id
967: from ra_customer_merges m
960: last_updated_by = arp_standard.profile.user_id,
961: last_update_login = arp_standard.profile.last_update_login,
962: request_id = req_id,
963: program_application_id =arp_standard.profile.program_application_id,
964: program_id = arp_standard.profile.program_id,
965: program_update_date = sysdate
966: where sold_to_org_id in (select m.duplicate_id
967: from ra_customer_merges m
968: where m.process_flag = 'N'
984: and m.process_flag = 'N'
985: and m.request_id = req_id
986: and m.set_number = set_num),
987: last_update_date = sysdate,
988: last_updated_by = arp_standard.profile.user_id,
989: last_update_login = arp_standard.profile.last_update_login,
990: request_id = req_id,
991: program_application_id =arp_standard.profile.program_application_id,
992: program_id = arp_standard.profile.program_id,
985: and m.request_id = req_id
986: and m.set_number = set_num),
987: last_update_date = sysdate,
988: last_updated_by = arp_standard.profile.user_id,
989: last_update_login = arp_standard.profile.last_update_login,
990: request_id = req_id,
991: program_application_id =arp_standard.profile.program_application_id,
992: program_id = arp_standard.profile.program_id,
993: program_update_date = sysdate
987: last_update_date = sysdate,
988: last_updated_by = arp_standard.profile.user_id,
989: last_update_login = arp_standard.profile.last_update_login,
990: request_id = req_id,
991: program_application_id =arp_standard.profile.program_application_id,
992: program_id = arp_standard.profile.program_id,
993: program_update_date = sysdate
994: where sold_to_site_use_id in (select m.duplicate_id
995: from ra_customer_merges m
988: last_updated_by = arp_standard.profile.user_id,
989: last_update_login = arp_standard.profile.last_update_login,
990: request_id = req_id,
991: program_application_id =arp_standard.profile.program_application_id,
992: program_id = arp_standard.profile.program_id,
993: program_update_date = sysdate
994: where sold_to_site_use_id in (select m.duplicate_id
995: from ra_customer_merges m
996: where m.process_flag = 'N'
1012: and m.process_flag = 'N'
1013: and m.request_id = req_id
1014: and m.set_number = set_num),
1015: last_update_date = sysdate,
1016: last_updated_by = arp_standard.profile.user_id,
1017: last_update_login = arp_standard.profile.last_update_login,
1018: request_id = req_id,
1019: program_application_id =arp_standard.profile.program_application_id,
1020: program_id = arp_standard.profile.program_id,
1013: and m.request_id = req_id
1014: and m.set_number = set_num),
1015: last_update_date = sysdate,
1016: last_updated_by = arp_standard.profile.user_id,
1017: last_update_login = arp_standard.profile.last_update_login,
1018: request_id = req_id,
1019: program_application_id =arp_standard.profile.program_application_id,
1020: program_id = arp_standard.profile.program_id,
1021: program_update_date = sysdate
1015: last_update_date = sysdate,
1016: last_updated_by = arp_standard.profile.user_id,
1017: last_update_login = arp_standard.profile.last_update_login,
1018: request_id = req_id,
1019: program_application_id =arp_standard.profile.program_application_id,
1020: program_id = arp_standard.profile.program_id,
1021: program_update_date = sysdate
1022: where end_customer_site_use_id in (select m.duplicate_id
1023: from ra_customer_merges m
1016: last_updated_by = arp_standard.profile.user_id,
1017: last_update_login = arp_standard.profile.last_update_login,
1018: request_id = req_id,
1019: program_application_id =arp_standard.profile.program_application_id,
1020: program_id = arp_standard.profile.program_id,
1021: program_update_date = sysdate
1022: where end_customer_site_use_id in (select m.duplicate_id
1023: from ra_customer_merges m
1024: where m.process_flag = 'N'
1042: and m.process_flag = 'N'
1043: and m.request_id = req_id
1044: and m.set_number = set_num),
1045: last_update_date = sysdate,
1046: last_updated_by = arp_standard.profile.user_id,
1047: last_update_login = arp_standard.profile.last_update_login,
1048: request_id = req_id,
1049: program_application_id =arp_standard.profile.program_application_id,
1050: program_id = arp_standard.profile.program_id,
1043: and m.request_id = req_id
1044: and m.set_number = set_num),
1045: last_update_date = sysdate,
1046: last_updated_by = arp_standard.profile.user_id,
1047: last_update_login = arp_standard.profile.last_update_login,
1048: request_id = req_id,
1049: program_application_id =arp_standard.profile.program_application_id,
1050: program_id = arp_standard.profile.program_id,
1051: program_update_date = sysdate
1045: last_update_date = sysdate,
1046: last_updated_by = arp_standard.profile.user_id,
1047: last_update_login = arp_standard.profile.last_update_login,
1048: request_id = req_id,
1049: program_application_id =arp_standard.profile.program_application_id,
1050: program_id = arp_standard.profile.program_id,
1051: program_update_date = sysdate
1052: where end_customer_id in (select m.duplicate_id
1053: from ra_customer_merges m
1046: last_updated_by = arp_standard.profile.user_id,
1047: last_update_login = arp_standard.profile.last_update_login,
1048: request_id = req_id,
1049: program_application_id =arp_standard.profile.program_application_id,
1050: program_id = arp_standard.profile.program_id,
1051: program_update_date = sysdate
1052: where end_customer_id in (select m.duplicate_id
1053: from ra_customer_merges m
1054: where m.process_flag = 'N'
1167: and m.request_id = req_id
1168: and m.process_flag = 'N'
1169: and m.set_number = set_num),
1170: last_update_date = sysdate,
1171: last_updated_by = arp_standard.profile.user_id,
1172: last_update_login = arp_standard.profile.last_update_login,
1173: request_id = req_id,
1174: program_application_id =arp_standard.profile.program_application_id,
1175: program_id = arp_standard.profile.program_id,
1168: and m.process_flag = 'N'
1169: and m.set_number = set_num),
1170: last_update_date = sysdate,
1171: last_updated_by = arp_standard.profile.user_id,
1172: last_update_login = arp_standard.profile.last_update_login,
1173: request_id = req_id,
1174: program_application_id =arp_standard.profile.program_application_id,
1175: program_id = arp_standard.profile.program_id,
1176: program_update_date = sysdate
1170: last_update_date = sysdate,
1171: last_updated_by = arp_standard.profile.user_id,
1172: last_update_login = arp_standard.profile.last_update_login,
1173: request_id = req_id,
1174: program_application_id =arp_standard.profile.program_application_id,
1175: program_id = arp_standard.profile.program_id,
1176: program_update_date = sysdate
1177: where ship_to_org_id in (select m.duplicate_site_id
1178: from ra_customer_merges m
1171: last_updated_by = arp_standard.profile.user_id,
1172: last_update_login = arp_standard.profile.last_update_login,
1173: request_id = req_id,
1174: program_application_id =arp_standard.profile.program_application_id,
1175: program_id = arp_standard.profile.program_id,
1176: program_update_date = sysdate
1177: where ship_to_org_id in (select m.duplicate_site_id
1178: from ra_customer_merges m
1179: where m.process_flag = 'N'
1193: and m.request_id = req_id
1194: and m.process_flag = 'N'
1195: and m.set_number = set_num),
1196: last_update_date = sysdate,
1197: last_updated_by = arp_standard.profile.user_id,
1198: last_update_login = arp_standard.profile.last_update_login,
1199: request_id = req_id,
1200: program_application_id =arp_standard.profile.program_application_id,
1201: program_id = arp_standard.profile.program_id,
1194: and m.process_flag = 'N'
1195: and m.set_number = set_num),
1196: last_update_date = sysdate,
1197: last_updated_by = arp_standard.profile.user_id,
1198: last_update_login = arp_standard.profile.last_update_login,
1199: request_id = req_id,
1200: program_application_id =arp_standard.profile.program_application_id,
1201: program_id = arp_standard.profile.program_id,
1202: program_update_date = sysdate
1196: last_update_date = sysdate,
1197: last_updated_by = arp_standard.profile.user_id,
1198: last_update_login = arp_standard.profile.last_update_login,
1199: request_id = req_id,
1200: program_application_id =arp_standard.profile.program_application_id,
1201: program_id = arp_standard.profile.program_id,
1202: program_update_date = sysdate
1203: where invoice_to_org_id in (select m.duplicate_site_id
1204: from ra_customer_merges m
1197: last_updated_by = arp_standard.profile.user_id,
1198: last_update_login = arp_standard.profile.last_update_login,
1199: request_id = req_id,
1200: program_application_id =arp_standard.profile.program_application_id,
1201: program_id = arp_standard.profile.program_id,
1202: program_update_date = sysdate
1203: where invoice_to_org_id in (select m.duplicate_site_id
1204: from ra_customer_merges m
1205: where m.process_flag = 'N'
1219: and m.request_id = req_id
1220: and m.process_flag = 'N'
1221: and m.set_number = set_num),
1222: last_update_date = sysdate,
1223: last_updated_by = arp_standard.profile.user_id,
1224: last_update_login = arp_standard.profile.last_update_login,
1225: request_id = req_id,
1226: program_application_id =arp_standard.profile.program_application_id,
1227: program_id = arp_standard.profile.program_id,
1220: and m.process_flag = 'N'
1221: and m.set_number = set_num),
1222: last_update_date = sysdate,
1223: last_updated_by = arp_standard.profile.user_id,
1224: last_update_login = arp_standard.profile.last_update_login,
1225: request_id = req_id,
1226: program_application_id =arp_standard.profile.program_application_id,
1227: program_id = arp_standard.profile.program_id,
1228: program_update_date = sysdate
1222: last_update_date = sysdate,
1223: last_updated_by = arp_standard.profile.user_id,
1224: last_update_login = arp_standard.profile.last_update_login,
1225: request_id = req_id,
1226: program_application_id =arp_standard.profile.program_application_id,
1227: program_id = arp_standard.profile.program_id,
1228: program_update_date = sysdate
1229: where deliver_to_org_id in (select m.duplicate_site_id
1230: from ra_customer_merges m
1223: last_updated_by = arp_standard.profile.user_id,
1224: last_update_login = arp_standard.profile.last_update_login,
1225: request_id = req_id,
1226: program_application_id =arp_standard.profile.program_application_id,
1227: program_id = arp_standard.profile.program_id,
1228: program_update_date = sysdate
1229: where deliver_to_org_id in (select m.duplicate_site_id
1230: from ra_customer_merges m
1231: where m.process_flag = 'N'
1250: and m.process_flag = 'N'
1251: and m.request_id = req_id
1252: and m.set_number = set_num),
1253: last_update_date = sysdate,
1254: last_updated_by = arp_standard.profile.user_id,
1255: last_update_login = arp_standard.profile.last_update_login,
1256: request_id = req_id,
1257: program_application_id =arp_standard.profile.program_application_id,
1258: program_id = arp_standard.profile.program_id,
1251: and m.request_id = req_id
1252: and m.set_number = set_num),
1253: last_update_date = sysdate,
1254: last_updated_by = arp_standard.profile.user_id,
1255: last_update_login = arp_standard.profile.last_update_login,
1256: request_id = req_id,
1257: program_application_id =arp_standard.profile.program_application_id,
1258: program_id = arp_standard.profile.program_id,
1259: program_update_date = sysdate
1253: last_update_date = sysdate,
1254: last_updated_by = arp_standard.profile.user_id,
1255: last_update_login = arp_standard.profile.last_update_login,
1256: request_id = req_id,
1257: program_application_id =arp_standard.profile.program_application_id,
1258: program_id = arp_standard.profile.program_id,
1259: program_update_date = sysdate
1260: where sold_to_org_id in (select m.duplicate_id
1261: from ra_customer_merges m
1254: last_updated_by = arp_standard.profile.user_id,
1255: last_update_login = arp_standard.profile.last_update_login,
1256: request_id = req_id,
1257: program_application_id =arp_standard.profile.program_application_id,
1258: program_id = arp_standard.profile.program_id,
1259: program_update_date = sysdate
1260: where sold_to_org_id in (select m.duplicate_id
1261: from ra_customer_merges m
1262: where m.process_flag = 'N'
1470: and m.request_id = req_id
1471: and m.process_flag = 'N'
1472: and m.set_number = set_num),
1473: last_update_date = sysdate,
1474: last_updated_by = arp_standard.profile.user_id,
1475: last_update_login = arp_standard.profile.last_update_login,
1476: request_id = req_id,
1477: program_application_id =arp_standard.profile.program_application_id,
1478: program_id = arp_standard.profile.program_id,
1471: and m.process_flag = 'N'
1472: and m.set_number = set_num),
1473: last_update_date = sysdate,
1474: last_updated_by = arp_standard.profile.user_id,
1475: last_update_login = arp_standard.profile.last_update_login,
1476: request_id = req_id,
1477: program_application_id =arp_standard.profile.program_application_id,
1478: program_id = arp_standard.profile.program_id,
1479: program_update_date = sysdate
1473: last_update_date = sysdate,
1474: last_updated_by = arp_standard.profile.user_id,
1475: last_update_login = arp_standard.profile.last_update_login,
1476: request_id = req_id,
1477: program_application_id =arp_standard.profile.program_application_id,
1478: program_id = arp_standard.profile.program_id,
1479: program_update_date = sysdate
1480: where ship_to_org_id in (select m.duplicate_site_id
1481: from ra_customer_merges m
1474: last_updated_by = arp_standard.profile.user_id,
1475: last_update_login = arp_standard.profile.last_update_login,
1476: request_id = req_id,
1477: program_application_id =arp_standard.profile.program_application_id,
1478: program_id = arp_standard.profile.program_id,
1479: program_update_date = sysdate
1480: where ship_to_org_id in (select m.duplicate_site_id
1481: from ra_customer_merges m
1482: where m.process_flag = 'N'
1536: and m.request_id = req_id
1537: and m.process_flag = 'N'
1538: and m.set_number = set_num),
1539: last_update_date = sysdate,
1540: last_updated_by = arp_standard.profile.user_id,
1541: last_update_login = arp_standard.profile.last_update_login,
1542: request_id = req_id,
1543: program_application_id =arp_standard.profile.program_application_id,
1544: program_id = arp_standard.profile.program_id,
1537: and m.process_flag = 'N'
1538: and m.set_number = set_num),
1539: last_update_date = sysdate,
1540: last_updated_by = arp_standard.profile.user_id,
1541: last_update_login = arp_standard.profile.last_update_login,
1542: request_id = req_id,
1543: program_application_id =arp_standard.profile.program_application_id,
1544: program_id = arp_standard.profile.program_id,
1545: program_update_date = sysdate
1539: last_update_date = sysdate,
1540: last_updated_by = arp_standard.profile.user_id,
1541: last_update_login = arp_standard.profile.last_update_login,
1542: request_id = req_id,
1543: program_application_id =arp_standard.profile.program_application_id,
1544: program_id = arp_standard.profile.program_id,
1545: program_update_date = sysdate
1546: where invoice_to_org_id in (select m.duplicate_site_id
1547: from ra_customer_merges m
1540: last_updated_by = arp_standard.profile.user_id,
1541: last_update_login = arp_standard.profile.last_update_login,
1542: request_id = req_id,
1543: program_application_id =arp_standard.profile.program_application_id,
1544: program_id = arp_standard.profile.program_id,
1545: program_update_date = sysdate
1546: where invoice_to_org_id in (select m.duplicate_site_id
1547: from ra_customer_merges m
1548: where m.process_flag = 'N'
1602: and m.request_id = req_id
1603: and m.process_flag = 'N'
1604: and m.set_number = set_num),
1605: last_update_date = sysdate,
1606: last_updated_by = arp_standard.profile.user_id,
1607: last_update_login = arp_standard.profile.last_update_login,
1608: request_id = req_id,
1609: program_application_id =arp_standard.profile.program_application_id,
1610: program_id = arp_standard.profile.program_id,
1603: and m.process_flag = 'N'
1604: and m.set_number = set_num),
1605: last_update_date = sysdate,
1606: last_updated_by = arp_standard.profile.user_id,
1607: last_update_login = arp_standard.profile.last_update_login,
1608: request_id = req_id,
1609: program_application_id =arp_standard.profile.program_application_id,
1610: program_id = arp_standard.profile.program_id,
1611: program_update_date = sysdate
1605: last_update_date = sysdate,
1606: last_updated_by = arp_standard.profile.user_id,
1607: last_update_login = arp_standard.profile.last_update_login,
1608: request_id = req_id,
1609: program_application_id =arp_standard.profile.program_application_id,
1610: program_id = arp_standard.profile.program_id,
1611: program_update_date = sysdate
1612: where deliver_to_org_id in (select m.duplicate_site_id
1613: from ra_customer_merges m
1606: last_updated_by = arp_standard.profile.user_id,
1607: last_update_login = arp_standard.profile.last_update_login,
1608: request_id = req_id,
1609: program_application_id =arp_standard.profile.program_application_id,
1610: program_id = arp_standard.profile.program_id,
1611: program_update_date = sysdate
1612: where deliver_to_org_id in (select m.duplicate_site_id
1613: from ra_customer_merges m
1614: where m.process_flag = 'N'
1673: and m.process_flag = 'N'
1674: and m.request_id = req_id
1675: and m.set_number = set_num),
1676: last_update_date = sysdate,
1677: last_updated_by = arp_standard.profile.user_id,
1678: last_update_login = arp_standard.profile.last_update_login,
1679: request_id = req_id,
1680: program_application_id =arp_standard.profile.program_application_id,
1681: program_id = arp_standard.profile.program_id,
1674: and m.request_id = req_id
1675: and m.set_number = set_num),
1676: last_update_date = sysdate,
1677: last_updated_by = arp_standard.profile.user_id,
1678: last_update_login = arp_standard.profile.last_update_login,
1679: request_id = req_id,
1680: program_application_id =arp_standard.profile.program_application_id,
1681: program_id = arp_standard.profile.program_id,
1682: program_update_date = sysdate
1676: last_update_date = sysdate,
1677: last_updated_by = arp_standard.profile.user_id,
1678: last_update_login = arp_standard.profile.last_update_login,
1679: request_id = req_id,
1680: program_application_id =arp_standard.profile.program_application_id,
1681: program_id = arp_standard.profile.program_id,
1682: program_update_date = sysdate
1683: where sold_to_org_id in (select m.duplicate_id
1684: from ra_customer_merges m
1677: last_updated_by = arp_standard.profile.user_id,
1678: last_update_login = arp_standard.profile.last_update_login,
1679: request_id = req_id,
1680: program_application_id =arp_standard.profile.program_application_id,
1681: program_id = arp_standard.profile.program_id,
1682: program_update_date = sysdate
1683: where sold_to_org_id in (select m.duplicate_id
1684: from ra_customer_merges m
1685: where m.process_flag = 'N'
1747: and m.process_flag = 'N'
1748: and m.request_id = req_id
1749: and m.set_number = set_num),
1750: last_update_date = sysdate,
1751: last_updated_by = arp_standard.profile.user_id,
1752: last_update_login = arp_standard.profile.last_update_login,
1753: request_id = req_id,
1754: program_application_id =arp_standard.profile.program_application_id,
1755: program_id = arp_standard.profile.program_id,
1748: and m.request_id = req_id
1749: and m.set_number = set_num),
1750: last_update_date = sysdate,
1751: last_updated_by = arp_standard.profile.user_id,
1752: last_update_login = arp_standard.profile.last_update_login,
1753: request_id = req_id,
1754: program_application_id =arp_standard.profile.program_application_id,
1755: program_id = arp_standard.profile.program_id,
1756: program_update_date = sysdate
1750: last_update_date = sysdate,
1751: last_updated_by = arp_standard.profile.user_id,
1752: last_update_login = arp_standard.profile.last_update_login,
1753: request_id = req_id,
1754: program_application_id =arp_standard.profile.program_application_id,
1755: program_id = arp_standard.profile.program_id,
1756: program_update_date = sysdate
1757: where sold_to_site_use_id in (select m.duplicate_id
1758: from ra_customer_merges m
1751: last_updated_by = arp_standard.profile.user_id,
1752: last_update_login = arp_standard.profile.last_update_login,
1753: request_id = req_id,
1754: program_application_id =arp_standard.profile.program_application_id,
1755: program_id = arp_standard.profile.program_id,
1756: program_update_date = sysdate
1757: where sold_to_site_use_id in (select m.duplicate_id
1758: from ra_customer_merges m
1759: where m.process_flag = 'N'
1820: and m.process_flag = 'N'
1821: and m.request_id = req_id
1822: and m.set_number = set_num),
1823: last_update_date = sysdate,
1824: last_updated_by = arp_standard.profile.user_id,
1825: last_update_login = arp_standard.profile.last_update_login,
1826: request_id = req_id,
1827: program_application_id =arp_standard.profile.program_application_id,
1828: program_id = arp_standard.profile.program_id,
1821: and m.request_id = req_id
1822: and m.set_number = set_num),
1823: last_update_date = sysdate,
1824: last_updated_by = arp_standard.profile.user_id,
1825: last_update_login = arp_standard.profile.last_update_login,
1826: request_id = req_id,
1827: program_application_id =arp_standard.profile.program_application_id,
1828: program_id = arp_standard.profile.program_id,
1829: program_update_date = sysdate
1823: last_update_date = sysdate,
1824: last_updated_by = arp_standard.profile.user_id,
1825: last_update_login = arp_standard.profile.last_update_login,
1826: request_id = req_id,
1827: program_application_id =arp_standard.profile.program_application_id,
1828: program_id = arp_standard.profile.program_id,
1829: program_update_date = sysdate
1830: where
1831: end_customer_site_use_id in (select m.duplicate_id
1824: last_updated_by = arp_standard.profile.user_id,
1825: last_update_login = arp_standard.profile.last_update_login,
1826: request_id = req_id,
1827: program_application_id =arp_standard.profile.program_application_id,
1828: program_id = arp_standard.profile.program_id,
1829: program_update_date = sysdate
1830: where
1831: end_customer_site_use_id in (select m.duplicate_id
1832: from ra_customer_merges m
1893: and m.process_flag = 'N'
1894: and m.request_id = req_id
1895: and m.set_number = set_num),
1896: last_update_date = sysdate,
1897: last_updated_by = arp_standard.profile.user_id,
1898: last_update_login = arp_standard.profile.last_update_login,
1899: request_id = req_id,
1900: program_application_id =arp_standard.profile.program_application_id,
1901: program_id = arp_standard.profile.program_id,
1894: and m.request_id = req_id
1895: and m.set_number = set_num),
1896: last_update_date = sysdate,
1897: last_updated_by = arp_standard.profile.user_id,
1898: last_update_login = arp_standard.profile.last_update_login,
1899: request_id = req_id,
1900: program_application_id =arp_standard.profile.program_application_id,
1901: program_id = arp_standard.profile.program_id,
1902: program_update_date = sysdate
1896: last_update_date = sysdate,
1897: last_updated_by = arp_standard.profile.user_id,
1898: last_update_login = arp_standard.profile.last_update_login,
1899: request_id = req_id,
1900: program_application_id =arp_standard.profile.program_application_id,
1901: program_id = arp_standard.profile.program_id,
1902: program_update_date = sysdate
1903: where end_customer_id in (select m.duplicate_id
1904: from ra_customer_merges m
1897: last_updated_by = arp_standard.profile.user_id,
1898: last_update_login = arp_standard.profile.last_update_login,
1899: request_id = req_id,
1900: program_application_id =arp_standard.profile.program_application_id,
1901: program_id = arp_standard.profile.program_id,
1902: program_update_date = sysdate
1903: where end_customer_id in (select m.duplicate_id
1904: from ra_customer_merges m
1905: where m.process_flag = 'N'
2345: deliver_to_org_id = decode(line_deliver_to_org_id_tab(i),null,deliver_to_org_id,line_deliver_to_org_id_tab(i)),
2346: end_customer_site_use_id = decode(line_end_cust_site_use_id(i),null,end_customer_site_use_id,line_end_cust_site_use_id(i)),
2347: end_customer_id = decode(line_end_cust_id_tab(i),null,end_customer_id,line_end_cust_id_tab(i)),
2348: last_update_date = sysdate,
2349: last_updated_by = arp_standard.profile.user_id,
2350: last_update_login = arp_standard.profile.last_update_login,
2351: request_id = req_id,
2352: program_application_id = arp_standard.profile.program_application_id ,
2353: program_id = arp_standard.profile.program_id,
2346: end_customer_site_use_id = decode(line_end_cust_site_use_id(i),null,end_customer_site_use_id,line_end_cust_site_use_id(i)),
2347: end_customer_id = decode(line_end_cust_id_tab(i),null,end_customer_id,line_end_cust_id_tab(i)),
2348: last_update_date = sysdate,
2349: last_updated_by = arp_standard.profile.user_id,
2350: last_update_login = arp_standard.profile.last_update_login,
2351: request_id = req_id,
2352: program_application_id = arp_standard.profile.program_application_id ,
2353: program_id = arp_standard.profile.program_id,
2354: program_update_date = SYSDATE,
2348: last_update_date = sysdate,
2349: last_updated_by = arp_standard.profile.user_id,
2350: last_update_login = arp_standard.profile.last_update_login,
2351: request_id = req_id,
2352: program_application_id = arp_standard.profile.program_application_id ,
2353: program_id = arp_standard.profile.program_id,
2354: program_update_date = SYSDATE,
2355: lock_control = lock_control+1
2356: WHERE line_id = line_line_id_tab(i)
2349: last_updated_by = arp_standard.profile.user_id,
2350: last_update_login = arp_standard.profile.last_update_login,
2351: request_id = req_id,
2352: program_application_id = arp_standard.profile.program_application_id ,
2353: program_id = arp_standard.profile.program_id,
2354: program_update_date = SYSDATE,
2355: lock_control = lock_control+1
2356: WHERE line_id = line_line_id_tab(i)
2357: RETURNING last_update_date bulk collect into dbi_line_update_date_tab;
2662: deliver_to_org_id = decode(lhst_deliver_to_org_id_tab(i),null,deliver_to_org_id,lhst_deliver_to_org_id_tab(i)),
2663: end_customer_site_use_id = decode(lhst_end_cust_site_use_id_tab(i),null,end_customer_site_use_id,lhst_end_cust_site_use_id_tab(i)),
2664: end_customer_id = decode(lhst_end_cust_id_tab(i),null,end_customer_id,lhst_end_cust_id_tab(i)),
2665: last_update_date = sysdate,
2666: last_updated_by = arp_standard.profile.user_id,
2667: last_update_login = arp_standard.profile.last_update_login,
2668: request_id = req_id,
2669: program_application_id = arp_standard.profile.program_application_id ,
2670: program_id = arp_standard.profile.program_id,
2663: end_customer_site_use_id = decode(lhst_end_cust_site_use_id_tab(i),null,end_customer_site_use_id,lhst_end_cust_site_use_id_tab(i)),
2664: end_customer_id = decode(lhst_end_cust_id_tab(i),null,end_customer_id,lhst_end_cust_id_tab(i)),
2665: last_update_date = sysdate,
2666: last_updated_by = arp_standard.profile.user_id,
2667: last_update_login = arp_standard.profile.last_update_login,
2668: request_id = req_id,
2669: program_application_id = arp_standard.profile.program_application_id ,
2670: program_id = arp_standard.profile.program_id,
2671: program_update_date = SYSDATE
2665: last_update_date = sysdate,
2666: last_updated_by = arp_standard.profile.user_id,
2667: last_update_login = arp_standard.profile.last_update_login,
2668: request_id = req_id,
2669: program_application_id = arp_standard.profile.program_application_id ,
2670: program_id = arp_standard.profile.program_id,
2671: program_update_date = SYSDATE
2672: WHERE line_id = lhst_line_id_tab(i);
2673:
2666: last_updated_by = arp_standard.profile.user_id,
2667: last_update_login = arp_standard.profile.last_update_login,
2668: request_id = req_id,
2669: program_application_id = arp_standard.profile.program_application_id ,
2670: program_id = arp_standard.profile.program_id,
2671: program_update_date = SYSDATE
2672: WHERE line_id = lhst_line_id_tab(i);
2673:
2674: g_count := sql%rowcount;
2797: and m.request_id = req_id
2798: and m.process_flag = 'N'
2799: and m.set_number = set_num),
2800: last_update_date = sysdate,
2801: last_updated_by = arp_standard.profile.user_id,
2802: last_update_login = arp_standard.profile.last_update_login,
2803: request_id = req_id,
2804: program_application_id =arp_standard.profile.program_application_id,
2805: program_id = arp_standard.profile.program_id,
2798: and m.process_flag = 'N'
2799: and m.set_number = set_num),
2800: last_update_date = sysdate,
2801: last_updated_by = arp_standard.profile.user_id,
2802: last_update_login = arp_standard.profile.last_update_login,
2803: request_id = req_id,
2804: program_application_id =arp_standard.profile.program_application_id,
2805: program_id = arp_standard.profile.program_id,
2806: program_update_date = sysdate
2800: last_update_date = sysdate,
2801: last_updated_by = arp_standard.profile.user_id,
2802: last_update_login = arp_standard.profile.last_update_login,
2803: request_id = req_id,
2804: program_application_id =arp_standard.profile.program_application_id,
2805: program_id = arp_standard.profile.program_id,
2806: program_update_date = sysdate
2807: where ship_to_org_id in (select m.duplicate_site_id
2808: from ra_customer_merges m
2801: last_updated_by = arp_standard.profile.user_id,
2802: last_update_login = arp_standard.profile.last_update_login,
2803: request_id = req_id,
2804: program_application_id =arp_standard.profile.program_application_id,
2805: program_id = arp_standard.profile.program_id,
2806: program_update_date = sysdate
2807: where ship_to_org_id in (select m.duplicate_site_id
2808: from ra_customer_merges m
2809: where m.process_flag = 'N'
2823: and m.request_id = req_id
2824: and m.process_flag = 'N'
2825: and m.set_number = set_num),
2826: last_update_date = sysdate,
2827: last_updated_by = arp_standard.profile.user_id,
2828: last_update_login = arp_standard.profile.last_update_login,
2829: request_id = req_id,
2830: program_application_id =arp_standard.profile.program_application_id,
2831: program_id = arp_standard.profile.program_id,
2824: and m.process_flag = 'N'
2825: and m.set_number = set_num),
2826: last_update_date = sysdate,
2827: last_updated_by = arp_standard.profile.user_id,
2828: last_update_login = arp_standard.profile.last_update_login,
2829: request_id = req_id,
2830: program_application_id =arp_standard.profile.program_application_id,
2831: program_id = arp_standard.profile.program_id,
2832: program_update_date = sysdate
2826: last_update_date = sysdate,
2827: last_updated_by = arp_standard.profile.user_id,
2828: last_update_login = arp_standard.profile.last_update_login,
2829: request_id = req_id,
2830: program_application_id =arp_standard.profile.program_application_id,
2831: program_id = arp_standard.profile.program_id,
2832: program_update_date = sysdate
2833: where invoice_to_org_id in (select m.duplicate_site_id
2834: from ra_customer_merges m
2827: last_updated_by = arp_standard.profile.user_id,
2828: last_update_login = arp_standard.profile.last_update_login,
2829: request_id = req_id,
2830: program_application_id =arp_standard.profile.program_application_id,
2831: program_id = arp_standard.profile.program_id,
2832: program_update_date = sysdate
2833: where invoice_to_org_id in (select m.duplicate_site_id
2834: from ra_customer_merges m
2835: where m.process_flag = 'N'
2849: and m.request_id = req_id
2850: and m.process_flag = 'N'
2851: and m.set_number = set_num),
2852: last_update_date = sysdate,
2853: last_updated_by = arp_standard.profile.user_id,
2854: last_update_login = arp_standard.profile.last_update_login,
2855: request_id = req_id,
2856: program_application_id =arp_standard.profile.program_application_id,
2857: program_id = arp_standard.profile.program_id,
2850: and m.process_flag = 'N'
2851: and m.set_number = set_num),
2852: last_update_date = sysdate,
2853: last_updated_by = arp_standard.profile.user_id,
2854: last_update_login = arp_standard.profile.last_update_login,
2855: request_id = req_id,
2856: program_application_id =arp_standard.profile.program_application_id,
2857: program_id = arp_standard.profile.program_id,
2858: program_update_date = sysdate
2852: last_update_date = sysdate,
2853: last_updated_by = arp_standard.profile.user_id,
2854: last_update_login = arp_standard.profile.last_update_login,
2855: request_id = req_id,
2856: program_application_id =arp_standard.profile.program_application_id,
2857: program_id = arp_standard.profile.program_id,
2858: program_update_date = sysdate
2859: where deliver_to_org_id in (select m.duplicate_site_id
2860: from ra_customer_merges m
2853: last_updated_by = arp_standard.profile.user_id,
2854: last_update_login = arp_standard.profile.last_update_login,
2855: request_id = req_id,
2856: program_application_id =arp_standard.profile.program_application_id,
2857: program_id = arp_standard.profile.program_id,
2858: program_update_date = sysdate
2859: where deliver_to_org_id in (select m.duplicate_site_id
2860: from ra_customer_merges m
2861: where m.process_flag = 'N'
2879: and m.process_flag = 'N'
2880: and m.request_id = req_id
2881: and m.set_number = set_num),
2882: last_update_date = sysdate,
2883: last_updated_by = arp_standard.profile.user_id,
2884: last_update_login = arp_standard.profile.last_update_login,
2885: request_id = req_id,
2886: program_application_id =arp_standard.profile.program_application_id,
2887: program_id = arp_standard.profile.program_id,
2880: and m.request_id = req_id
2881: and m.set_number = set_num),
2882: last_update_date = sysdate,
2883: last_updated_by = arp_standard.profile.user_id,
2884: last_update_login = arp_standard.profile.last_update_login,
2885: request_id = req_id,
2886: program_application_id =arp_standard.profile.program_application_id,
2887: program_id = arp_standard.profile.program_id,
2888: program_update_date = sysdate
2882: last_update_date = sysdate,
2883: last_updated_by = arp_standard.profile.user_id,
2884: last_update_login = arp_standard.profile.last_update_login,
2885: request_id = req_id,
2886: program_application_id =arp_standard.profile.program_application_id,
2887: program_id = arp_standard.profile.program_id,
2888: program_update_date = sysdate
2889: where sold_to_org_id in (select m.duplicate_id
2890: from ra_customer_merges m
2883: last_updated_by = arp_standard.profile.user_id,
2884: last_update_login = arp_standard.profile.last_update_login,
2885: request_id = req_id,
2886: program_application_id =arp_standard.profile.program_application_id,
2887: program_id = arp_standard.profile.program_id,
2888: program_update_date = sysdate
2889: where sold_to_org_id in (select m.duplicate_id
2890: from ra_customer_merges m
2891: where m.process_flag = 'N'
3100: and m.request_id = req_id
3101: and m.process_flag = 'N'
3102: and m.set_number = set_num),
3103: last_update_date = sysdate,
3104: last_updated_by = arp_standard.profile.user_id,
3105: last_update_login = arp_standard.profile.last_update_login,
3106: request_id = req_id,
3107: program_application_id =arp_standard.profile.program_application_id,
3108: program_id = arp_standard.profile.program_id,
3101: and m.process_flag = 'N'
3102: and m.set_number = set_num),
3103: last_update_date = sysdate,
3104: last_updated_by = arp_standard.profile.user_id,
3105: last_update_login = arp_standard.profile.last_update_login,
3106: request_id = req_id,
3107: program_application_id =arp_standard.profile.program_application_id,
3108: program_id = arp_standard.profile.program_id,
3109: program_update_date = sysdate
3103: last_update_date = sysdate,
3104: last_updated_by = arp_standard.profile.user_id,
3105: last_update_login = arp_standard.profile.last_update_login,
3106: request_id = req_id,
3107: program_application_id =arp_standard.profile.program_application_id,
3108: program_id = arp_standard.profile.program_id,
3109: program_update_date = sysdate
3110: where ship_to_org_id in (select m.duplicate_site_id
3111: from ra_customer_merges m
3104: last_updated_by = arp_standard.profile.user_id,
3105: last_update_login = arp_standard.profile.last_update_login,
3106: request_id = req_id,
3107: program_application_id =arp_standard.profile.program_application_id,
3108: program_id = arp_standard.profile.program_id,
3109: program_update_date = sysdate
3110: where ship_to_org_id in (select m.duplicate_site_id
3111: from ra_customer_merges m
3112: where m.process_flag = 'N'
3168: and m.request_id = req_id
3169: and m.process_flag = 'N'
3170: and m.set_number = set_num),
3171: last_update_date = sysdate,
3172: last_updated_by = arp_standard.profile.user_id,
3173: last_update_login = arp_standard.profile.last_update_login,
3174: request_id = req_id,
3175: program_application_id =arp_standard.profile.program_application_id,
3176: program_id = arp_standard.profile.program_id,
3169: and m.process_flag = 'N'
3170: and m.set_number = set_num),
3171: last_update_date = sysdate,
3172: last_updated_by = arp_standard.profile.user_id,
3173: last_update_login = arp_standard.profile.last_update_login,
3174: request_id = req_id,
3175: program_application_id =arp_standard.profile.program_application_id,
3176: program_id = arp_standard.profile.program_id,
3177: program_update_date = sysdate
3171: last_update_date = sysdate,
3172: last_updated_by = arp_standard.profile.user_id,
3173: last_update_login = arp_standard.profile.last_update_login,
3174: request_id = req_id,
3175: program_application_id =arp_standard.profile.program_application_id,
3176: program_id = arp_standard.profile.program_id,
3177: program_update_date = sysdate
3178: where invoice_to_org_id in (select m.duplicate_site_id
3179: from ra_customer_merges m
3172: last_updated_by = arp_standard.profile.user_id,
3173: last_update_login = arp_standard.profile.last_update_login,
3174: request_id = req_id,
3175: program_application_id =arp_standard.profile.program_application_id,
3176: program_id = arp_standard.profile.program_id,
3177: program_update_date = sysdate
3178: where invoice_to_org_id in (select m.duplicate_site_id
3179: from ra_customer_merges m
3180: where m.process_flag = 'N'
3236: and m.request_id = req_id
3237: and m.process_flag = 'N'
3238: and m.set_number = set_num),
3239: last_update_date = sysdate,
3240: last_updated_by = arp_standard.profile.user_id,
3241: last_update_login = arp_standard.profile.last_update_login,
3242: request_id = req_id,
3243: program_application_id =arp_standard.profile.program_application_id,
3244: program_id = arp_standard.profile.program_id,
3237: and m.process_flag = 'N'
3238: and m.set_number = set_num),
3239: last_update_date = sysdate,
3240: last_updated_by = arp_standard.profile.user_id,
3241: last_update_login = arp_standard.profile.last_update_login,
3242: request_id = req_id,
3243: program_application_id =arp_standard.profile.program_application_id,
3244: program_id = arp_standard.profile.program_id,
3245: program_update_date = sysdate
3239: last_update_date = sysdate,
3240: last_updated_by = arp_standard.profile.user_id,
3241: last_update_login = arp_standard.profile.last_update_login,
3242: request_id = req_id,
3243: program_application_id =arp_standard.profile.program_application_id,
3244: program_id = arp_standard.profile.program_id,
3245: program_update_date = sysdate
3246: where deliver_to_org_id in (select m.duplicate_site_id
3247: from ra_customer_merges m
3240: last_updated_by = arp_standard.profile.user_id,
3241: last_update_login = arp_standard.profile.last_update_login,
3242: request_id = req_id,
3243: program_application_id =arp_standard.profile.program_application_id,
3244: program_id = arp_standard.profile.program_id,
3245: program_update_date = sysdate
3246: where deliver_to_org_id in (select m.duplicate_site_id
3247: from ra_customer_merges m
3248: where m.process_flag = 'N'
3305: and m.request_id = req_id
3306: and m.process_flag = 'N'
3307: and m.set_number = set_num),
3308: last_update_date = sysdate,
3309: last_updated_by = arp_standard.profile.user_id,
3310: last_update_login = arp_standard.profile.last_update_login,
3311: request_id = req_id,
3312: program_application_id =arp_standard.profile.program_application_id,
3313: program_id = arp_standard.profile.program_id,
3306: and m.process_flag = 'N'
3307: and m.set_number = set_num),
3308: last_update_date = sysdate,
3309: last_updated_by = arp_standard.profile.user_id,
3310: last_update_login = arp_standard.profile.last_update_login,
3311: request_id = req_id,
3312: program_application_id =arp_standard.profile.program_application_id,
3313: program_id = arp_standard.profile.program_id,
3314: program_update_date = sysdate
3308: last_update_date = sysdate,
3309: last_updated_by = arp_standard.profile.user_id,
3310: last_update_login = arp_standard.profile.last_update_login,
3311: request_id = req_id,
3312: program_application_id =arp_standard.profile.program_application_id,
3313: program_id = arp_standard.profile.program_id,
3314: program_update_date = sysdate
3315: where intmed_ship_to_org_id in (select m.duplicate_site_id
3316: from ra_customer_merges m
3309: last_updated_by = arp_standard.profile.user_id,
3310: last_update_login = arp_standard.profile.last_update_login,
3311: request_id = req_id,
3312: program_application_id =arp_standard.profile.program_application_id,
3313: program_id = arp_standard.profile.program_id,
3314: program_update_date = sysdate
3315: where intmed_ship_to_org_id in (select m.duplicate_site_id
3316: from ra_customer_merges m
3317: where m.process_flag = 'N'
3379: and m.process_flag = 'N'
3380: and m.request_id = req_id
3381: and m.set_number = set_num),
3382: last_update_date = sysdate,
3383: last_updated_by = arp_standard.profile.user_id,
3384: last_update_login = arp_standard.profile.last_update_login,
3385: request_id = req_id,
3386: program_application_id =arp_standard.profile.program_application_id,
3387: program_id = arp_standard.profile.program_id,
3380: and m.request_id = req_id
3381: and m.set_number = set_num),
3382: last_update_date = sysdate,
3383: last_updated_by = arp_standard.profile.user_id,
3384: last_update_login = arp_standard.profile.last_update_login,
3385: request_id = req_id,
3386: program_application_id =arp_standard.profile.program_application_id,
3387: program_id = arp_standard.profile.program_id,
3388: program_update_date = sysdate
3382: last_update_date = sysdate,
3383: last_updated_by = arp_standard.profile.user_id,
3384: last_update_login = arp_standard.profile.last_update_login,
3385: request_id = req_id,
3386: program_application_id =arp_standard.profile.program_application_id,
3387: program_id = arp_standard.profile.program_id,
3388: program_update_date = sysdate
3389: where sold_to_org_id in (select m.duplicate_id
3390: from ra_customer_merges m
3383: last_updated_by = arp_standard.profile.user_id,
3384: last_update_login = arp_standard.profile.last_update_login,
3385: request_id = req_id,
3386: program_application_id =arp_standard.profile.program_application_id,
3387: program_id = arp_standard.profile.program_id,
3388: program_update_date = sysdate
3389: where sold_to_org_id in (select m.duplicate_id
3390: from ra_customer_merges m
3391: where m.process_flag = 'N'
3456: and m.process_flag = 'N'
3457: and m.request_id = req_id
3458: and m.set_number = set_num),
3459: last_update_date = sysdate,
3460: last_updated_by = arp_standard.profile.user_id,
3461: last_update_login = arp_standard.profile.last_update_login,
3462: request_id = req_id,
3463: program_application_id =arp_standard.profile.program_application_id,
3464: program_id = arp_standard.profile.program_id,
3457: and m.request_id = req_id
3458: and m.set_number = set_num),
3459: last_update_date = sysdate,
3460: last_updated_by = arp_standard.profile.user_id,
3461: last_update_login = arp_standard.profile.last_update_login,
3462: request_id = req_id,
3463: program_application_id =arp_standard.profile.program_application_id,
3464: program_id = arp_standard.profile.program_id,
3465: program_update_date = sysdate
3459: last_update_date = sysdate,
3460: last_updated_by = arp_standard.profile.user_id,
3461: last_update_login = arp_standard.profile.last_update_login,
3462: request_id = req_id,
3463: program_application_id =arp_standard.profile.program_application_id,
3464: program_id = arp_standard.profile.program_id,
3465: program_update_date = sysdate
3466: where end_customer_site_use_id in (select m.duplicate_id
3467: from ra_customer_merges m
3460: last_updated_by = arp_standard.profile.user_id,
3461: last_update_login = arp_standard.profile.last_update_login,
3462: request_id = req_id,
3463: program_application_id =arp_standard.profile.program_application_id,
3464: program_id = arp_standard.profile.program_id,
3465: program_update_date = sysdate
3466: where end_customer_site_use_id in (select m.duplicate_id
3467: from ra_customer_merges m
3468: where m.process_flag = 'N'
3531: and m.process_flag = 'N'
3532: and m.request_id = req_id
3533: and m.set_number = set_num),
3534: last_update_date = sysdate,
3535: last_updated_by = arp_standard.profile.user_id,
3536: last_update_login = arp_standard.profile.last_update_login,
3537: request_id = req_id,
3538: program_application_id =arp_standard.profile.program_application_id,
3539: program_id = arp_standard.profile.program_id,
3532: and m.request_id = req_id
3533: and m.set_number = set_num),
3534: last_update_date = sysdate,
3535: last_updated_by = arp_standard.profile.user_id,
3536: last_update_login = arp_standard.profile.last_update_login,
3537: request_id = req_id,
3538: program_application_id =arp_standard.profile.program_application_id,
3539: program_id = arp_standard.profile.program_id,
3540: program_update_date = sysdate
3534: last_update_date = sysdate,
3535: last_updated_by = arp_standard.profile.user_id,
3536: last_update_login = arp_standard.profile.last_update_login,
3537: request_id = req_id,
3538: program_application_id =arp_standard.profile.program_application_id,
3539: program_id = arp_standard.profile.program_id,
3540: program_update_date = sysdate
3541: where end_customer_id in (select m.duplicate_id
3542: from ra_customer_merges m
3535: last_updated_by = arp_standard.profile.user_id,
3536: last_update_login = arp_standard.profile.last_update_login,
3537: request_id = req_id,
3538: program_application_id =arp_standard.profile.program_application_id,
3539: program_id = arp_standard.profile.program_id,
3540: program_update_date = sysdate
3541: where end_customer_id in (select m.duplicate_id
3542: from ra_customer_merges m
3543: where m.process_flag = 'N'
3731: and m.request_id = req_id
3732: and m.process_flag = 'N'
3733: and m.set_number = set_num),
3734: last_update_date = sysdate,
3735: last_updated_by = arp_standard.profile.user_id,
3736: last_update_login = arp_standard.profile.last_update_login
3737: where attribute_value in (select to_char(m.duplicate_site_id)
3738: from ra_customer_merges m
3739: where m.process_flag = 'N'
3732: and m.process_flag = 'N'
3733: and m.set_number = set_num),
3734: last_update_date = sysdate,
3735: last_updated_by = arp_standard.profile.user_id,
3736: last_update_login = arp_standard.profile.last_update_login
3737: where attribute_value in (select to_char(m.duplicate_site_id)
3738: from ra_customer_merges m
3739: where m.process_flag = 'N'
3740: and m.request_id = req_id
3799: and m.request_id = req_id
3800: and m.process_flag = 'N'
3801: and m.set_number = set_num),
3802: last_update_date = sysdate,
3803: last_updated_by = arp_standard.profile.user_id,
3804: last_update_login = arp_standard.profile.last_update_login
3805: where attribute_value in (select to_char(m.duplicate_site_id)
3806: from ra_customer_merges m
3807: where m.process_flag = 'N'
3800: and m.process_flag = 'N'
3801: and m.set_number = set_num),
3802: last_update_date = sysdate,
3803: last_updated_by = arp_standard.profile.user_id,
3804: last_update_login = arp_standard.profile.last_update_login
3805: where attribute_value in (select to_char(m.duplicate_site_id)
3806: from ra_customer_merges m
3807: where m.process_flag = 'N'
3808: and m.request_id = req_id
3868: and m.request_id = req_id
3869: and m.process_flag = 'N'
3870: and m.set_number = set_num),
3871: last_update_date = sysdate,
3872: last_updated_by = arp_standard.profile.user_id,
3873: last_update_login = arp_standard.profile.last_update_login
3874: where attribute_value in (select to_char(m.duplicate_id)
3875: from ra_customer_merges m
3876: where m.process_flag = 'N'
3869: and m.process_flag = 'N'
3870: and m.set_number = set_num),
3871: last_update_date = sysdate,
3872: last_updated_by = arp_standard.profile.user_id,
3873: last_update_login = arp_standard.profile.last_update_login
3874: where attribute_value in (select to_char(m.duplicate_id)
3875: from ra_customer_merges m
3876: where m.process_flag = 'N'
3877: and m.request_id = req_id
4089: and m.request_id = req_id
4090: and m.process_flag = 'N'
4091: and m.set_number = set_num),
4092: last_update_date = sysdate,
4093: last_updated_by = arp_standard.profile.user_id,
4094: last_update_login = arp_standard.profile.last_update_login
4095: where value_string in (select to_char(m.duplicate_site_id)
4096: from ra_customer_merges m
4097: where m.process_flag = 'N'
4090: and m.process_flag = 'N'
4091: and m.set_number = set_num),
4092: last_update_date = sysdate,
4093: last_updated_by = arp_standard.profile.user_id,
4094: last_update_login = arp_standard.profile.last_update_login
4095: where value_string in (select to_char(m.duplicate_site_id)
4096: from ra_customer_merges m
4097: where m.process_flag = 'N'
4098: and m.request_id = req_id
4157: and m.request_id = req_id
4158: and m.process_flag = 'N'
4159: and m.set_number = set_num),
4160: last_update_date = sysdate,
4161: last_updated_by = arp_standard.profile.user_id,
4162: last_update_login = arp_standard.profile.last_update_login
4163: where value_string in (select to_char(m.duplicate_site_id)
4164: from ra_customer_merges m
4165: where m.process_flag = 'N'
4158: and m.process_flag = 'N'
4159: and m.set_number = set_num),
4160: last_update_date = sysdate,
4161: last_updated_by = arp_standard.profile.user_id,
4162: last_update_login = arp_standard.profile.last_update_login
4163: where value_string in (select to_char(m.duplicate_site_id)
4164: from ra_customer_merges m
4165: where m.process_flag = 'N'
4166: and m.request_id = req_id
4225: and m.request_id = req_id
4226: and m.process_flag = 'N'
4227: and m.set_number = set_num),
4228: last_update_date = sysdate,
4229: last_updated_by = arp_standard.profile.user_id,
4230: last_update_login = arp_standard.profile.last_update_login
4231: where value_string in (select to_char(m.duplicate_site_id)
4232: from ra_customer_merges m
4233: where m.process_flag = 'N'
4226: and m.process_flag = 'N'
4227: and m.set_number = set_num),
4228: last_update_date = sysdate,
4229: last_updated_by = arp_standard.profile.user_id,
4230: last_update_login = arp_standard.profile.last_update_login
4231: where value_string in (select to_char(m.duplicate_site_id)
4232: from ra_customer_merges m
4233: where m.process_flag = 'N'
4234: and m.request_id = req_id
4293: and m.request_id = req_id
4294: and m.process_flag = 'N'
4295: and m.set_number = set_num),
4296: last_update_date = sysdate,
4297: last_updated_by = arp_standard.profile.user_id,
4298: last_update_login = arp_standard.profile.last_update_login
4299: where value_string in (select to_char(m.duplicate_id)
4300: from ra_customer_merges m
4301: where m.process_flag = 'N'
4294: and m.process_flag = 'N'
4295: and m.set_number = set_num),
4296: last_update_date = sysdate,
4297: last_updated_by = arp_standard.profile.user_id,
4298: last_update_login = arp_standard.profile.last_update_login
4299: where value_string in (select to_char(m.duplicate_id)
4300: from ra_customer_merges m
4301: where m.process_flag = 'N'
4302: and m.request_id = req_id
4365: and m.request_id = req_id
4366: and m.process_flag = 'N'
4367: and m.set_number = set_num),
4368: last_update_date = sysdate,
4369: last_updated_by = arp_standard.profile.user_id,
4370: last_update_login = arp_standard.profile.last_update_login
4371: where src_constant_value in (select to_char(m.duplicate_site_id)
4372: from ra_customer_merges m
4373: where m.process_flag = 'N'
4366: and m.process_flag = 'N'
4367: and m.set_number = set_num),
4368: last_update_date = sysdate,
4369: last_updated_by = arp_standard.profile.user_id,
4370: last_update_login = arp_standard.profile.last_update_login
4371: where src_constant_value in (select to_char(m.duplicate_site_id)
4372: from ra_customer_merges m
4373: where m.process_flag = 'N'
4374: and m.request_id = req_id
4433: and m.request_id = req_id
4434: and m.process_flag = 'N'
4435: and m.set_number = set_num),
4436: last_update_date = sysdate,
4437: last_updated_by = arp_standard.profile.user_id,
4438: last_update_login = arp_standard.profile.last_update_login
4439: where src_constant_value in (select to_char(m.duplicate_site_id)
4440: from ra_customer_merges m
4441: where m.process_flag = 'N'
4434: and m.process_flag = 'N'
4435: and m.set_number = set_num),
4436: last_update_date = sysdate,
4437: last_updated_by = arp_standard.profile.user_id,
4438: last_update_login = arp_standard.profile.last_update_login
4439: where src_constant_value in (select to_char(m.duplicate_site_id)
4440: from ra_customer_merges m
4441: where m.process_flag = 'N'
4442: and m.request_id = req_id
4501: and m.request_id = req_id
4502: and m.process_flag = 'N'
4503: and m.set_number = set_num),
4504: last_update_date = sysdate,
4505: last_updated_by = arp_standard.profile.user_id,
4506: last_update_login = arp_standard.profile.last_update_login
4507: where src_constant_value in (select to_char(m.duplicate_site_id)
4508: from ra_customer_merges m
4509: where m.process_flag = 'N'
4502: and m.process_flag = 'N'
4503: and m.set_number = set_num),
4504: last_update_date = sysdate,
4505: last_updated_by = arp_standard.profile.user_id,
4506: last_update_login = arp_standard.profile.last_update_login
4507: where src_constant_value in (select to_char(m.duplicate_site_id)
4508: from ra_customer_merges m
4509: where m.process_flag = 'N'
4510: and m.request_id = req_id
4570: and m.request_id = req_id
4571: and m.process_flag = 'N'
4572: and m.set_number = set_num),
4573: last_update_date = sysdate,
4574: last_updated_by = arp_standard.profile.user_id,
4575: last_update_login = arp_standard.profile.last_update_login
4576: where src_constant_value in (select to_char(m.duplicate_id)
4577: from ra_customer_merges m
4578: where m.process_flag = 'N'
4571: and m.process_flag = 'N'
4572: and m.set_number = set_num),
4573: last_update_date = sysdate,
4574: last_updated_by = arp_standard.profile.user_id,
4575: last_update_login = arp_standard.profile.last_update_login
4576: where src_constant_value in (select to_char(m.duplicate_id)
4577: from ra_customer_merges m
4578: where m.process_flag = 'N'
4579: and m.request_id = req_id
4738: and m.request_id = req_id
4739: and m.process_flag = 'N'
4740: and m.set_number = set_num),
4741: last_update_date = sysdate,
4742: last_updated_by = arp_standard.profile.user_id,
4743: last_update_login = arp_standard.profile.last_update_login
4744: where value_string in (select to_char(m.duplicate_site_id)
4745: from ra_customer_merges m
4746: where m.process_flag = 'N'
4739: and m.process_flag = 'N'
4740: and m.set_number = set_num),
4741: last_update_date = sysdate,
4742: last_updated_by = arp_standard.profile.user_id,
4743: last_update_login = arp_standard.profile.last_update_login
4744: where value_string in (select to_char(m.duplicate_site_id)
4745: from ra_customer_merges m
4746: where m.process_flag = 'N'
4747: and m.request_id = req_id
4806: and m.request_id = req_id
4807: and m.process_flag = 'N'
4808: and m.set_number = set_num),
4809: last_update_date = sysdate,
4810: last_updated_by = arp_standard.profile.user_id,
4811: last_update_login = arp_standard.profile.last_update_login
4812: where value_string in (select to_char(m.duplicate_site_id)
4813: from ra_customer_merges m
4814: where m.process_flag = 'N'
4807: and m.process_flag = 'N'
4808: and m.set_number = set_num),
4809: last_update_date = sysdate,
4810: last_updated_by = arp_standard.profile.user_id,
4811: last_update_login = arp_standard.profile.last_update_login
4812: where value_string in (select to_char(m.duplicate_site_id)
4813: from ra_customer_merges m
4814: where m.process_flag = 'N'
4815: and m.request_id = req_id
4874: and m.request_id = req_id
4875: and m.process_flag = 'N'
4876: and m.set_number = set_num),
4877: last_update_date = sysdate,
4878: last_updated_by = arp_standard.profile.user_id,
4879: last_update_login = arp_standard.profile.last_update_login
4880: where value_string in (select to_char(m.duplicate_site_id)
4881: from ra_customer_merges m
4882: where m.process_flag = 'N'
4875: and m.process_flag = 'N'
4876: and m.set_number = set_num),
4877: last_update_date = sysdate,
4878: last_updated_by = arp_standard.profile.user_id,
4879: last_update_login = arp_standard.profile.last_update_login
4880: where value_string in (select to_char(m.duplicate_site_id)
4881: from ra_customer_merges m
4882: where m.process_flag = 'N'
4883: and m.request_id = req_id
4943: and m.request_id = req_id
4944: and m.process_flag = 'N'
4945: and m.set_number = set_num),
4946: last_update_date = sysdate,
4947: last_updated_by = arp_standard.profile.user_id,
4948: last_update_login = arp_standard.profile.last_update_login
4949: where value_string in (select to_char(m.duplicate_id)
4950: from ra_customer_merges m
4951: where m.process_flag = 'N'
4944: and m.process_flag = 'N'
4945: and m.set_number = set_num),
4946: last_update_date = sysdate,
4947: last_updated_by = arp_standard.profile.user_id,
4948: last_update_login = arp_standard.profile.last_update_login
4949: where value_string in (select to_char(m.duplicate_id)
4950: from ra_customer_merges m
4951: where m.process_flag = 'N'
4952: and m.request_id = req_id
5095: and m.process_flag = 'N'
5096: and m.set_number = set_num),
5097: last_update_date = sysdate,
5098:
5099: last_updated_by = arp_standard.profile.user_id,
5100: last_update_login = arp_standard.profile.last_update_login
5101: where hold_entity_id in (select m.duplicate_site_id
5102: from ra_customer_merges m
5103: where m.process_flag = 'N'
5096: and m.set_number = set_num),
5097: last_update_date = sysdate,
5098:
5099: last_updated_by = arp_standard.profile.user_id,
5100: last_update_login = arp_standard.profile.last_update_login
5101: where hold_entity_id in (select m.duplicate_site_id
5102: from ra_customer_merges m
5103: where m.process_flag = 'N'
5104: and m.request_id = req_id
5163: and m.request_id = req_id
5164: and m.process_flag = 'N'
5165: and m.set_number = set_num),
5166: last_update_date = sysdate,
5167: last_updated_by = arp_standard.profile.user_id,
5168: last_update_login = arp_standard.profile.last_update_login
5169: where hold_entity_id in (select m.duplicate_site_id
5170: from ra_customer_merges m
5171: where m.process_flag = 'N'
5164: and m.process_flag = 'N'
5165: and m.set_number = set_num),
5166: last_update_date = sysdate,
5167: last_updated_by = arp_standard.profile.user_id,
5168: last_update_login = arp_standard.profile.last_update_login
5169: where hold_entity_id in (select m.duplicate_site_id
5170: from ra_customer_merges m
5171: where m.process_flag = 'N'
5172: and m.request_id = req_id
5231: and m.process_flag = 'N'
5232: and m.request_id = req_id
5233: and m.set_number = set_num),
5234: last_update_date = sysdate,
5235: last_updated_by = arp_standard.profile.user_id,
5236: last_update_login = arp_standard.profile.last_update_login
5237: where hold_entity_id in (select m.duplicate_id
5238: from ra_customer_merges m
5239: where m.process_flag = 'N'
5232: and m.request_id = req_id
5233: and m.set_number = set_num),
5234: last_update_date = sysdate,
5235: last_updated_by = arp_standard.profile.user_id,
5236: last_update_login = arp_standard.profile.last_update_login
5237: where hold_entity_id in (select m.duplicate_id
5238: from ra_customer_merges m
5239: where m.process_flag = 'N'
5240: and m.request_id = req_id
5343: and m.request_id = req_id
5344: and m.process_flag = 'N'
5345: and m.set_number = set_num),
5346: last_update_date = sysdate,
5347: last_updated_by = arp_standard.profile.user_id,
5348: last_update_login = arp_standard.profile.last_update_login
5349: where line_location_id in (select m.duplicate_site_id
5350: from ra_customer_merges m
5351: where m.process_flag = 'N'
5344: and m.process_flag = 'N'
5345: and m.set_number = set_num),
5346: last_update_date = sysdate,
5347: last_updated_by = arp_standard.profile.user_id,
5348: last_update_login = arp_standard.profile.last_update_login
5349: where line_location_id in (select m.duplicate_site_id
5350: from ra_customer_merges m
5351: where m.process_flag = 'N'
5352: and m.request_id = req_id
5467: and m.request_id = req_id
5468: and m.process_flag = 'N'
5469: and m.set_number = set_num),
5470: last_update_date = sysdate,
5471: last_updated_by = arp_standard.profile.user_id,
5472: last_update_login = arp_standard.profile.last_update_login
5473: where site_use_id in (select m.duplicate_site_id
5474: from ra_customer_merges m
5475: where m.process_flag = 'N'
5468: and m.process_flag = 'N'
5469: and m.set_number = set_num),
5470: last_update_date = sysdate,
5471: last_updated_by = arp_standard.profile.user_id,
5472: last_update_login = arp_standard.profile.last_update_login
5473: where site_use_id in (select m.duplicate_site_id
5474: from ra_customer_merges m
5475: where m.process_flag = 'N'
5476: and m.request_id = req_id
5529: and m.request_id = req_id
5530: and m.process_flag = 'N'
5531: and m.set_number = set_num),
5532: last_update_date = sysdate,
5533: last_updated_by = arp_standard.profile.user_id,
5534: last_update_login = arp_standard.profile.last_update_login
5535: where customer_id in (select m.duplicate_id
5536: from ra_customer_merges m
5537: where m.process_flag = 'N'
5530: and m.process_flag = 'N'
5531: and m.set_number = set_num),
5532: last_update_date = sysdate,
5533: last_updated_by = arp_standard.profile.user_id,
5534: last_update_login = arp_standard.profile.last_update_login
5535: where customer_id in (select m.duplicate_id
5536: from ra_customer_merges m
5537: where m.process_flag = 'N'
5538: and m.request_id = req_id
5660: FORALL i in sets_set_id_tab.FIRST..sets_set_id_tab.LAST
5661: UPDATE OE_SETS S
5662: SET ship_to_org_id = sets_ship_to_org_id_tab(i),
5663: update_date = sysdate,
5664: updated_by = arp_standard.profile.user_id,
5665: update_login = arp_standard.profile.last_update_login
5666: WHERE set_id = sets_set_id_tab(i);
5667:
5668: g_count := sql%rowcount;
5661: UPDATE OE_SETS S
5662: SET ship_to_org_id = sets_ship_to_org_id_tab(i),
5663: update_date = sysdate,
5664: updated_by = arp_standard.profile.user_id,
5665: update_login = arp_standard.profile.last_update_login
5666: WHERE set_id = sets_set_id_tab(i);
5667:
5668: g_count := sql%rowcount;
5669:
5828: FORALL i in attrib_id_tab.FIRST..attrib_id_tab.LAST
5829: UPDATE OE_PRICE_ADJ_ATTRIBS S
5830: SET pricing_attr_value_from = to_char(attrib_value_from_tab(i)),
5831: last_update_date = sysdate,
5832: last_updated_by = arp_standard.profile.user_id,
5833: last_update_login = arp_standard.profile.last_update_login
5834: WHERE price_adj_attrib_id = attrib_id_tab(i);
5835:
5836: g_count := sql%rowcount;
5829: UPDATE OE_PRICE_ADJ_ATTRIBS S
5830: SET pricing_attr_value_from = to_char(attrib_value_from_tab(i)),
5831: last_update_date = sysdate,
5832: last_updated_by = arp_standard.profile.user_id,
5833: last_update_login = arp_standard.profile.last_update_login
5834: WHERE price_adj_attrib_id = attrib_id_tab(i);
5835:
5836: g_count := sql%rowcount;
5837:
6144: ship_to_org_id = decode(hdr_ship_to_org_id_tab(i),null,ship_to_org_id,hdr_ship_to_org_id_tab(i)),
6145: deliver_to_org_id = decode(hdr_deliver_to_org_id_tab(i),null,deliver_to_org_id,hdr_deliver_to_org_id_tab(i)),
6146: sold_to_site_use_id = decode(hdr_sold_to_site_use_id_tab(i),null,sold_to_site_use_id,hdr_sold_to_site_use_id_tab(i)),
6147: last_update_date = sysdate,
6148: last_updated_by = arp_standard.profile.user_id,
6149: last_update_login = arp_standard.profile.last_update_login,
6150: request_id = req_id,
6151: program_application_id = arp_standard.profile.program_application_id ,
6152: program_id = arp_standard.profile.program_id,
6145: deliver_to_org_id = decode(hdr_deliver_to_org_id_tab(i),null,deliver_to_org_id,hdr_deliver_to_org_id_tab(i)),
6146: sold_to_site_use_id = decode(hdr_sold_to_site_use_id_tab(i),null,sold_to_site_use_id,hdr_sold_to_site_use_id_tab(i)),
6147: last_update_date = sysdate,
6148: last_updated_by = arp_standard.profile.user_id,
6149: last_update_login = arp_standard.profile.last_update_login,
6150: request_id = req_id,
6151: program_application_id = arp_standard.profile.program_application_id ,
6152: program_id = arp_standard.profile.program_id,
6153: program_update_date = SYSDATE,
6147: last_update_date = sysdate,
6148: last_updated_by = arp_standard.profile.user_id,
6149: last_update_login = arp_standard.profile.last_update_login,
6150: request_id = req_id,
6151: program_application_id = arp_standard.profile.program_application_id ,
6152: program_id = arp_standard.profile.program_id,
6153: program_update_date = SYSDATE,
6154: lock_control = lock_control+1
6155: WHERE header_id = hdr_header_id_tab(i);
6148: last_updated_by = arp_standard.profile.user_id,
6149: last_update_login = arp_standard.profile.last_update_login,
6150: request_id = req_id,
6151: program_application_id = arp_standard.profile.program_application_id ,
6152: program_id = arp_standard.profile.program_id,
6153: program_update_date = SYSDATE,
6154: lock_control = lock_control+1
6155: WHERE header_id = hdr_header_id_tab(i);
6156:
6358: and m.request_id = req_id
6359: and m.process_flag = 'N'
6360: and m.set_number = set_num),
6361: last_update_date = sysdate,
6362: last_updated_by = arp_standard.profile.user_id,
6363: last_update_login = arp_standard.profile.last_update_login,
6364: request_id = req_id,
6365: program_application_id =arp_standard.profile.program_application_id,
6366: program_id = arp_standard.profile.program_id,
6359: and m.process_flag = 'N'
6360: and m.set_number = set_num),
6361: last_update_date = sysdate,
6362: last_updated_by = arp_standard.profile.user_id,
6363: last_update_login = arp_standard.profile.last_update_login,
6364: request_id = req_id,
6365: program_application_id =arp_standard.profile.program_application_id,
6366: program_id = arp_standard.profile.program_id,
6367: program_update_date = sysdate
6361: last_update_date = sysdate,
6362: last_updated_by = arp_standard.profile.user_id,
6363: last_update_login = arp_standard.profile.last_update_login,
6364: request_id = req_id,
6365: program_application_id =arp_standard.profile.program_application_id,
6366: program_id = arp_standard.profile.program_id,
6367: program_update_date = sysdate
6368: where ship_to_org_id in (select m.duplicate_site_id
6369: from ra_customer_merges m
6362: last_updated_by = arp_standard.profile.user_id,
6363: last_update_login = arp_standard.profile.last_update_login,
6364: request_id = req_id,
6365: program_application_id =arp_standard.profile.program_application_id,
6366: program_id = arp_standard.profile.program_id,
6367: program_update_date = sysdate
6368: where ship_to_org_id in (select m.duplicate_site_id
6369: from ra_customer_merges m
6370: where m.process_flag = 'N'
6424: and m.request_id = req_id
6425: and m.process_flag = 'N'
6426: and m.set_number = set_num),
6427: last_update_date = sysdate,
6428: last_updated_by = arp_standard.profile.user_id,
6429: last_update_login = arp_standard.profile.last_update_login,
6430: request_id = req_id,
6431: program_application_id =arp_standard.profile.program_application_id,
6432: program_id = arp_standard.profile.program_id,
6425: and m.process_flag = 'N'
6426: and m.set_number = set_num),
6427: last_update_date = sysdate,
6428: last_updated_by = arp_standard.profile.user_id,
6429: last_update_login = arp_standard.profile.last_update_login,
6430: request_id = req_id,
6431: program_application_id =arp_standard.profile.program_application_id,
6432: program_id = arp_standard.profile.program_id,
6433: program_update_date = sysdate
6427: last_update_date = sysdate,
6428: last_updated_by = arp_standard.profile.user_id,
6429: last_update_login = arp_standard.profile.last_update_login,
6430: request_id = req_id,
6431: program_application_id =arp_standard.profile.program_application_id,
6432: program_id = arp_standard.profile.program_id,
6433: program_update_date = sysdate
6434: where invoice_to_org_id in (select m.duplicate_site_id
6435: from ra_customer_merges m
6428: last_updated_by = arp_standard.profile.user_id,
6429: last_update_login = arp_standard.profile.last_update_login,
6430: request_id = req_id,
6431: program_application_id =arp_standard.profile.program_application_id,
6432: program_id = arp_standard.profile.program_id,
6433: program_update_date = sysdate
6434: where invoice_to_org_id in (select m.duplicate_site_id
6435: from ra_customer_merges m
6436: where m.process_flag = 'N'
6490: and m.request_id = req_id
6491: and m.process_flag = 'N'
6492: and m.set_number = set_num),
6493: last_update_date = sysdate,
6494: last_updated_by = arp_standard.profile.user_id,
6495: last_update_login = arp_standard.profile.last_update_login,
6496: request_id = req_id,
6497: program_application_id =arp_standard.profile.program_application_id,
6498: program_id = arp_standard.profile.program_id,
6491: and m.process_flag = 'N'
6492: and m.set_number = set_num),
6493: last_update_date = sysdate,
6494: last_updated_by = arp_standard.profile.user_id,
6495: last_update_login = arp_standard.profile.last_update_login,
6496: request_id = req_id,
6497: program_application_id =arp_standard.profile.program_application_id,
6498: program_id = arp_standard.profile.program_id,
6499: program_update_date = sysdate
6493: last_update_date = sysdate,
6494: last_updated_by = arp_standard.profile.user_id,
6495: last_update_login = arp_standard.profile.last_update_login,
6496: request_id = req_id,
6497: program_application_id =arp_standard.profile.program_application_id,
6498: program_id = arp_standard.profile.program_id,
6499: program_update_date = sysdate
6500: where deliver_to_org_id in (select m.duplicate_site_id
6501: from ra_customer_merges m
6494: last_updated_by = arp_standard.profile.user_id,
6495: last_update_login = arp_standard.profile.last_update_login,
6496: request_id = req_id,
6497: program_application_id =arp_standard.profile.program_application_id,
6498: program_id = arp_standard.profile.program_id,
6499: program_update_date = sysdate
6500: where deliver_to_org_id in (select m.duplicate_site_id
6501: from ra_customer_merges m
6502: where m.process_flag = 'N'
6561: and m.process_flag = 'N'
6562: and m.request_id = req_id
6563: and m.set_number = set_num),
6564: last_update_date = sysdate,
6565: last_updated_by = arp_standard.profile.user_id,
6566: last_update_login = arp_standard.profile.last_update_login,
6567: request_id = req_id,
6568: program_application_id =arp_standard.profile.program_application_id,
6569: program_id = arp_standard.profile.program_id,
6562: and m.request_id = req_id
6563: and m.set_number = set_num),
6564: last_update_date = sysdate,
6565: last_updated_by = arp_standard.profile.user_id,
6566: last_update_login = arp_standard.profile.last_update_login,
6567: request_id = req_id,
6568: program_application_id =arp_standard.profile.program_application_id,
6569: program_id = arp_standard.profile.program_id,
6570: program_update_date = sysdate
6564: last_update_date = sysdate,
6565: last_updated_by = arp_standard.profile.user_id,
6566: last_update_login = arp_standard.profile.last_update_login,
6567: request_id = req_id,
6568: program_application_id =arp_standard.profile.program_application_id,
6569: program_id = arp_standard.profile.program_id,
6570: program_update_date = sysdate
6571: where sold_to_org_id in (select m.duplicate_id
6572: from ra_customer_merges m
6565: last_updated_by = arp_standard.profile.user_id,
6566: last_update_login = arp_standard.profile.last_update_login,
6567: request_id = req_id,
6568: program_application_id =arp_standard.profile.program_application_id,
6569: program_id = arp_standard.profile.program_id,
6570: program_update_date = sysdate
6571: where sold_to_org_id in (select m.duplicate_id
6572: from ra_customer_merges m
6573: where m.process_flag = 'N'
6634: and m.process_flag = 'N'
6635: and m.request_id = req_id
6636: and m.set_number = set_num),
6637: last_update_date = sysdate,
6638: last_updated_by = arp_standard.profile.user_id,
6639: last_update_login = arp_standard.profile.last_update_login,
6640: request_id = req_id,
6641: program_application_id =arp_standard.profile.program_application_id,
6642: program_id = arp_standard.profile.program_id,
6635: and m.request_id = req_id
6636: and m.set_number = set_num),
6637: last_update_date = sysdate,
6638: last_updated_by = arp_standard.profile.user_id,
6639: last_update_login = arp_standard.profile.last_update_login,
6640: request_id = req_id,
6641: program_application_id =arp_standard.profile.program_application_id,
6642: program_id = arp_standard.profile.program_id,
6643: program_update_date = sysdate
6637: last_update_date = sysdate,
6638: last_updated_by = arp_standard.profile.user_id,
6639: last_update_login = arp_standard.profile.last_update_login,
6640: request_id = req_id,
6641: program_application_id =arp_standard.profile.program_application_id,
6642: program_id = arp_standard.profile.program_id,
6643: program_update_date = sysdate
6644: where sold_to_site_use_id in (select m.duplicate_id
6645: from ra_customer_merges m
6638: last_updated_by = arp_standard.profile.user_id,
6639: last_update_login = arp_standard.profile.last_update_login,
6640: request_id = req_id,
6641: program_application_id =arp_standard.profile.program_application_id,
6642: program_id = arp_standard.profile.program_id,
6643: program_update_date = sysdate
6644: where sold_to_site_use_id in (select m.duplicate_id
6645: from ra_customer_merges m
6646: where m.process_flag = 'N'
6939: ship_to_org_id = decode(line_ship_to_org_id_tab(i),null,ship_to_org_id,line_ship_to_org_id_tab(i)),
6940: intmed_ship_to_org_id = decode(line_intmed_ship_to_org_id_tab(i),null,intmed_ship_to_org_id,line_intmed_ship_to_org_id_tab(i)),
6941: deliver_to_org_id = decode(line_deliver_to_org_id_tab(i),null,deliver_to_org_id,line_deliver_to_org_id_tab(i)),
6942: last_update_date = sysdate,
6943: last_updated_by = arp_standard.profile.user_id,
6944: last_update_login = arp_standard.profile.last_update_login,
6945: request_id = req_id,
6946: program_application_id = arp_standard.profile.program_application_id ,
6947: program_id = arp_standard.profile.program_id,
6940: intmed_ship_to_org_id = decode(line_intmed_ship_to_org_id_tab(i),null,intmed_ship_to_org_id,line_intmed_ship_to_org_id_tab(i)),
6941: deliver_to_org_id = decode(line_deliver_to_org_id_tab(i),null,deliver_to_org_id,line_deliver_to_org_id_tab(i)),
6942: last_update_date = sysdate,
6943: last_updated_by = arp_standard.profile.user_id,
6944: last_update_login = arp_standard.profile.last_update_login,
6945: request_id = req_id,
6946: program_application_id = arp_standard.profile.program_application_id ,
6947: program_id = arp_standard.profile.program_id,
6948: program_update_date = SYSDATE,
6942: last_update_date = sysdate,
6943: last_updated_by = arp_standard.profile.user_id,
6944: last_update_login = arp_standard.profile.last_update_login,
6945: request_id = req_id,
6946: program_application_id = arp_standard.profile.program_application_id ,
6947: program_id = arp_standard.profile.program_id,
6948: program_update_date = SYSDATE,
6949: lock_control = lock_control+1
6950: WHERE line_id = line_line_id_tab(i);
6943: last_updated_by = arp_standard.profile.user_id,
6944: last_update_login = arp_standard.profile.last_update_login,
6945: request_id = req_id,
6946: program_application_id = arp_standard.profile.program_application_id ,
6947: program_id = arp_standard.profile.program_id,
6948: program_update_date = SYSDATE,
6949: lock_control = lock_control+1
6950: WHERE line_id = line_line_id_tab(i);
6951:
7277: ship_to_org_id = decode(lhst_ship_to_org_id_tab(i),null,ship_to_org_id,lhst_ship_to_org_id_tab(i)),
7278: intmed_ship_to_org_id = decode(lhst_intmed_ship_to_org_id_tab(i),null,intmed_ship_to_org_id,lhst_intmed_ship_to_org_id_tab(i)),
7279: deliver_to_org_id = decode(lhst_deliver_to_org_id_tab(i),null,deliver_to_org_id,lhst_deliver_to_org_id_tab(i)),
7280: last_update_date = sysdate,
7281: last_updated_by = arp_standard.profile.user_id,
7282: last_update_login = arp_standard.profile.last_update_login,
7283: request_id = req_id,
7284: program_application_id = arp_standard.profile.program_application_id ,
7285: program_id = arp_standard.profile.program_id,
7278: intmed_ship_to_org_id = decode(lhst_intmed_ship_to_org_id_tab(i),null,intmed_ship_to_org_id,lhst_intmed_ship_to_org_id_tab(i)),
7279: deliver_to_org_id = decode(lhst_deliver_to_org_id_tab(i),null,deliver_to_org_id,lhst_deliver_to_org_id_tab(i)),
7280: last_update_date = sysdate,
7281: last_updated_by = arp_standard.profile.user_id,
7282: last_update_login = arp_standard.profile.last_update_login,
7283: request_id = req_id,
7284: program_application_id = arp_standard.profile.program_application_id ,
7285: program_id = arp_standard.profile.program_id,
7286: program_update_date = SYSDATE
7280: last_update_date = sysdate,
7281: last_updated_by = arp_standard.profile.user_id,
7282: last_update_login = arp_standard.profile.last_update_login,
7283: request_id = req_id,
7284: program_application_id = arp_standard.profile.program_application_id ,
7285: program_id = arp_standard.profile.program_id,
7286: program_update_date = SYSDATE
7287: WHERE line_id = lhst_line_id_tab(i);
7288:
7281: last_updated_by = arp_standard.profile.user_id,
7282: last_update_login = arp_standard.profile.last_update_login,
7283: request_id = req_id,
7284: program_application_id = arp_standard.profile.program_application_id ,
7285: program_id = arp_standard.profile.program_id,
7286: program_update_date = SYSDATE
7287: WHERE line_id = lhst_line_id_tab(i);
7288:
7289: g_count := sql%rowcount;
7427: and m.process_flag = 'N'
7428: and m.request_id = req_id
7429: and m.set_number = set_num),
7430: last_update_date = sysdate,
7431: last_updated_by = arp_standard.profile.user_id,
7432: last_update_login = arp_standard.profile.last_update_login,
7433: request_id = req_id,
7434: program_application_id =arp_standard.profile.program_application_id,
7435: program_id = arp_standard.profile.program_id,
7428: and m.request_id = req_id
7429: and m.set_number = set_num),
7430: last_update_date = sysdate,
7431: last_updated_by = arp_standard.profile.user_id,
7432: last_update_login = arp_standard.profile.last_update_login,
7433: request_id = req_id,
7434: program_application_id =arp_standard.profile.program_application_id,
7435: program_id = arp_standard.profile.program_id,
7436: program_update_date = sysdate
7430: last_update_date = sysdate,
7431: last_updated_by = arp_standard.profile.user_id,
7432: last_update_login = arp_standard.profile.last_update_login,
7433: request_id = req_id,
7434: program_application_id =arp_standard.profile.program_application_id,
7435: program_id = arp_standard.profile.program_id,
7436: program_update_date = sysdate
7437: where sold_to_org_id in (select m.duplicate_id
7438: from ra_customer_merges m
7431: last_updated_by = arp_standard.profile.user_id,
7432: last_update_login = arp_standard.profile.last_update_login,
7433: request_id = req_id,
7434: program_application_id =arp_standard.profile.program_application_id,
7435: program_id = arp_standard.profile.program_id,
7436: program_update_date = sysdate
7437: where sold_to_org_id in (select m.duplicate_id
7438: from ra_customer_merges m
7439: where m.process_flag = 'N'