APPS.OE_CUST_MERGE dependencies on STANDARD

Line 552: last_updated_by = arp_standard.profile.user_id,

548: 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)),
549: 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)),
550: end_customer_id = decode(hdr_end_cust_id_tab(i),null,end_customer_id,hdr_end_cust_id_tab(i)),
551: last_update_date = sysdate,
552: last_updated_by = arp_standard.profile.user_id,
553: last_update_login = arp_standard.profile.last_update_login,
554: request_id = req_id,
555: program_application_id = arp_standard.profile.program_application_id ,
556: program_id = arp_standard.profile.program_id,

Line 553: last_update_login = arp_standard.profile.last_update_login,

549: 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)),
550: end_customer_id = decode(hdr_end_cust_id_tab(i),null,end_customer_id,hdr_end_cust_id_tab(i)),
551: last_update_date = sysdate,
552: last_updated_by = arp_standard.profile.user_id,
553: last_update_login = arp_standard.profile.last_update_login,
554: request_id = req_id,
555: program_application_id = arp_standard.profile.program_application_id ,
556: program_id = arp_standard.profile.program_id,
557: program_update_date = SYSDATE,

Line 555: program_application_id = arp_standard.profile.program_application_id ,

551: last_update_date = sysdate,
552: last_updated_by = arp_standard.profile.user_id,
553: last_update_login = arp_standard.profile.last_update_login,
554: request_id = req_id,
555: program_application_id = arp_standard.profile.program_application_id ,
556: program_id = arp_standard.profile.program_id,
557: program_update_date = SYSDATE,
558: lock_control = lock_control+1
559: WHERE header_id = hdr_header_id_tab(i)

Line 556: program_id = arp_standard.profile.program_id,

552: last_updated_by = arp_standard.profile.user_id,
553: last_update_login = arp_standard.profile.last_update_login,
554: request_id = req_id,
555: program_application_id = arp_standard.profile.program_application_id ,
556: program_id = arp_standard.profile.program_id,
557: program_update_date = SYSDATE,
558: lock_control = lock_control+1
559: WHERE header_id = hdr_header_id_tab(i)
560: and hdr_duplicate_flag_tab(i) = 'N'; --Added for Duplicate Check bug 8883694,9349882 ,9558975

Line 994: last_updated_by = arp_standard.profile.user_id,

990: deliver_to_org_id = decode(hhst_deliver_to_org_id_tab(i),null,deliver_to_org_id,hhst_deliver_to_org_id_tab(i)),
991: 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)),
992: end_customer_id = decode(hhst_end_cust_id_tab(i),null,end_customer_id,hhst_end_cust_id_tab(i)),
993: last_update_date = sysdate,
994: last_updated_by = arp_standard.profile.user_id,
995: last_update_login = arp_standard.profile.last_update_login,
996: request_id = req_id,
997: program_application_id = arp_standard.profile.program_application_id ,
998: program_id = arp_standard.profile.program_id,

Line 995: last_update_login = arp_standard.profile.last_update_login,

991: 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)),
992: end_customer_id = decode(hhst_end_cust_id_tab(i),null,end_customer_id,hhst_end_cust_id_tab(i)),
993: last_update_date = sysdate,
994: last_updated_by = arp_standard.profile.user_id,
995: last_update_login = arp_standard.profile.last_update_login,
996: request_id = req_id,
997: program_application_id = arp_standard.profile.program_application_id ,
998: program_id = arp_standard.profile.program_id,
999: program_update_date = SYSDATE

Line 997: program_application_id = arp_standard.profile.program_application_id ,

993: last_update_date = sysdate,
994: last_updated_by = arp_standard.profile.user_id,
995: last_update_login = arp_standard.profile.last_update_login,
996: request_id = req_id,
997: program_application_id = arp_standard.profile.program_application_id ,
998: program_id = arp_standard.profile.program_id,
999: program_update_date = SYSDATE
1000: WHERE header_id = hhst_header_id_tab(i);
1001:

Line 998: program_id = arp_standard.profile.program_id,

994: last_updated_by = arp_standard.profile.user_id,
995: last_update_login = arp_standard.profile.last_update_login,
996: request_id = req_id,
997: program_application_id = arp_standard.profile.program_application_id ,
998: program_id = arp_standard.profile.program_id,
999: program_update_date = SYSDATE
1000: WHERE header_id = hhst_header_id_tab(i);
1001:
1002: g_count := sql%rowcount;

Line 1173: last_updated_by = arp_standard.profile.user_id,

1169: and m.request_id = req_id
1170: and m.process_flag = 'N'
1171: and m.set_number = set_num),
1172: last_update_date = sysdate,
1173: last_updated_by = arp_standard.profile.user_id,
1174: last_update_login = arp_standard.profile.last_update_login,
1175: request_id = req_id,
1176: program_application_id =arp_standard.profile.program_application_id,
1177: program_id = arp_standard.profile.program_id,

Line 1174: last_update_login = arp_standard.profile.last_update_login,

1170: and m.process_flag = 'N'
1171: and m.set_number = set_num),
1172: last_update_date = sysdate,
1173: last_updated_by = arp_standard.profile.user_id,
1174: last_update_login = arp_standard.profile.last_update_login,
1175: request_id = req_id,
1176: program_application_id =arp_standard.profile.program_application_id,
1177: program_id = arp_standard.profile.program_id,
1178: program_update_date = sysdate

Line 1176: program_application_id =arp_standard.profile.program_application_id,

1172: last_update_date = sysdate,
1173: last_updated_by = arp_standard.profile.user_id,
1174: last_update_login = arp_standard.profile.last_update_login,
1175: request_id = req_id,
1176: program_application_id =arp_standard.profile.program_application_id,
1177: program_id = arp_standard.profile.program_id,
1178: program_update_date = sysdate
1179: where ship_to_org_id in (select m.duplicate_site_id
1180: from ra_customer_merges m

Line 1177: program_id = arp_standard.profile.program_id,

1173: last_updated_by = arp_standard.profile.user_id,
1174: last_update_login = arp_standard.profile.last_update_login,
1175: request_id = req_id,
1176: program_application_id =arp_standard.profile.program_application_id,
1177: program_id = arp_standard.profile.program_id,
1178: program_update_date = sysdate
1179: where ship_to_org_id in (select m.duplicate_site_id
1180: from ra_customer_merges m
1181: where m.process_flag = 'N'

Line 1200: last_updated_by = arp_standard.profile.user_id,

1196: and m.request_id = req_id
1197: and m.process_flag = 'N'
1198: and m.set_number = set_num),
1199: last_update_date = sysdate,
1200: last_updated_by = arp_standard.profile.user_id,
1201: last_update_login = arp_standard.profile.last_update_login,
1202: request_id = req_id,
1203: program_application_id =arp_standard.profile.program_application_id,
1204: program_id = arp_standard.profile.program_id,

Line 1201: last_update_login = arp_standard.profile.last_update_login,

1197: and m.process_flag = 'N'
1198: and m.set_number = set_num),
1199: last_update_date = sysdate,
1200: last_updated_by = arp_standard.profile.user_id,
1201: last_update_login = arp_standard.profile.last_update_login,
1202: request_id = req_id,
1203: program_application_id =arp_standard.profile.program_application_id,
1204: program_id = arp_standard.profile.program_id,
1205: program_update_date = sysdate

Line 1203: program_application_id =arp_standard.profile.program_application_id,

1199: last_update_date = sysdate,
1200: last_updated_by = arp_standard.profile.user_id,
1201: last_update_login = arp_standard.profile.last_update_login,
1202: request_id = req_id,
1203: program_application_id =arp_standard.profile.program_application_id,
1204: program_id = arp_standard.profile.program_id,
1205: program_update_date = sysdate
1206: where invoice_to_org_id in (select m.duplicate_site_id
1207: from ra_customer_merges m

Line 1204: program_id = arp_standard.profile.program_id,

1200: last_updated_by = arp_standard.profile.user_id,
1201: last_update_login = arp_standard.profile.last_update_login,
1202: request_id = req_id,
1203: program_application_id =arp_standard.profile.program_application_id,
1204: program_id = arp_standard.profile.program_id,
1205: program_update_date = sysdate
1206: where invoice_to_org_id in (select m.duplicate_site_id
1207: from ra_customer_merges m
1208: where m.process_flag = 'N'

Line 1226: last_updated_by = arp_standard.profile.user_id,

1222: and m.request_id = req_id
1223: and m.process_flag = 'N'
1224: and m.set_number = set_num),
1225: last_update_date = sysdate,
1226: last_updated_by = arp_standard.profile.user_id,
1227: last_update_login = arp_standard.profile.last_update_login,
1228: request_id = req_id,
1229: program_application_id =arp_standard.profile.program_application_id,
1230: program_id = arp_standard.profile.program_id,

Line 1227: last_update_login = arp_standard.profile.last_update_login,

1223: and m.process_flag = 'N'
1224: and m.set_number = set_num),
1225: last_update_date = sysdate,
1226: last_updated_by = arp_standard.profile.user_id,
1227: last_update_login = arp_standard.profile.last_update_login,
1228: request_id = req_id,
1229: program_application_id =arp_standard.profile.program_application_id,
1230: program_id = arp_standard.profile.program_id,
1231: program_update_date = sysdate

Line 1229: program_application_id =arp_standard.profile.program_application_id,

1225: last_update_date = sysdate,
1226: last_updated_by = arp_standard.profile.user_id,
1227: last_update_login = arp_standard.profile.last_update_login,
1228: request_id = req_id,
1229: program_application_id =arp_standard.profile.program_application_id,
1230: program_id = arp_standard.profile.program_id,
1231: program_update_date = sysdate
1232: where deliver_to_org_id in (select m.duplicate_site_id
1233: from ra_customer_merges m

Line 1230: program_id = arp_standard.profile.program_id,

1226: last_updated_by = arp_standard.profile.user_id,
1227: last_update_login = arp_standard.profile.last_update_login,
1228: request_id = req_id,
1229: program_application_id =arp_standard.profile.program_application_id,
1230: program_id = arp_standard.profile.program_id,
1231: program_update_date = sysdate
1232: where deliver_to_org_id in (select m.duplicate_site_id
1233: from ra_customer_merges m
1234: where m.process_flag = 'N'

Line 1258: last_updated_by = arp_standard.profile.user_id,

1254: and m.process_flag = 'N'
1255: and m.request_id = req_id
1256: and m.set_number = set_num),
1257: last_update_date = sysdate,
1258: last_updated_by = arp_standard.profile.user_id,
1259: last_update_login = arp_standard.profile.last_update_login,
1260: request_id = req_id,
1261: program_application_id =arp_standard.profile.program_application_id,
1262: program_id = arp_standard.profile.program_id,

Line 1259: last_update_login = arp_standard.profile.last_update_login,

1255: and m.request_id = req_id
1256: and m.set_number = set_num),
1257: last_update_date = sysdate,
1258: last_updated_by = arp_standard.profile.user_id,
1259: last_update_login = arp_standard.profile.last_update_login,
1260: request_id = req_id,
1261: program_application_id =arp_standard.profile.program_application_id,
1262: program_id = arp_standard.profile.program_id,
1263: program_update_date = sysdate

Line 1261: program_application_id =arp_standard.profile.program_application_id,

1257: last_update_date = sysdate,
1258: last_updated_by = arp_standard.profile.user_id,
1259: last_update_login = arp_standard.profile.last_update_login,
1260: request_id = req_id,
1261: program_application_id =arp_standard.profile.program_application_id,
1262: program_id = arp_standard.profile.program_id,
1263: program_update_date = sysdate
1264: where sold_to_org_id in (select m.duplicate_id
1265: from ra_customer_merges m

Line 1262: program_id = arp_standard.profile.program_id,

1258: last_updated_by = arp_standard.profile.user_id,
1259: last_update_login = arp_standard.profile.last_update_login,
1260: request_id = req_id,
1261: program_application_id =arp_standard.profile.program_application_id,
1262: program_id = arp_standard.profile.program_id,
1263: program_update_date = sysdate
1264: where sold_to_org_id in (select m.duplicate_id
1265: from ra_customer_merges m
1266: where m.process_flag = 'N'

Line 1286: last_updated_by = arp_standard.profile.user_id,

1282: and m.process_flag = 'N'
1283: and m.request_id = req_id
1284: and m.set_number = set_num),
1285: last_update_date = sysdate,
1286: last_updated_by = arp_standard.profile.user_id,
1287: last_update_login = arp_standard.profile.last_update_login,
1288: request_id = req_id,
1289: program_application_id =arp_standard.profile.program_application_id,
1290: program_id = arp_standard.profile.program_id,

Line 1287: last_update_login = arp_standard.profile.last_update_login,

1283: and m.request_id = req_id
1284: and m.set_number = set_num),
1285: last_update_date = sysdate,
1286: last_updated_by = arp_standard.profile.user_id,
1287: last_update_login = arp_standard.profile.last_update_login,
1288: request_id = req_id,
1289: program_application_id =arp_standard.profile.program_application_id,
1290: program_id = arp_standard.profile.program_id,
1291: program_update_date = sysdate

Line 1289: program_application_id =arp_standard.profile.program_application_id,

1285: last_update_date = sysdate,
1286: last_updated_by = arp_standard.profile.user_id,
1287: last_update_login = arp_standard.profile.last_update_login,
1288: request_id = req_id,
1289: program_application_id =arp_standard.profile.program_application_id,
1290: program_id = arp_standard.profile.program_id,
1291: program_update_date = sysdate
1292: where sold_to_site_use_id in (select m.duplicate_id
1293: from ra_customer_merges m

Line 1290: program_id = arp_standard.profile.program_id,

1286: last_updated_by = arp_standard.profile.user_id,
1287: last_update_login = arp_standard.profile.last_update_login,
1288: request_id = req_id,
1289: program_application_id =arp_standard.profile.program_application_id,
1290: program_id = arp_standard.profile.program_id,
1291: program_update_date = sysdate
1292: where sold_to_site_use_id in (select m.duplicate_id
1293: from ra_customer_merges m
1294: where m.process_flag = 'N'

Line 1314: last_updated_by = arp_standard.profile.user_id,

1310: and m.process_flag = 'N'
1311: and m.request_id = req_id
1312: and m.set_number = set_num),
1313: last_update_date = sysdate,
1314: last_updated_by = arp_standard.profile.user_id,
1315: last_update_login = arp_standard.profile.last_update_login,
1316: request_id = req_id,
1317: program_application_id =arp_standard.profile.program_application_id,
1318: program_id = arp_standard.profile.program_id,

Line 1315: last_update_login = arp_standard.profile.last_update_login,

1311: and m.request_id = req_id
1312: and m.set_number = set_num),
1313: last_update_date = sysdate,
1314: last_updated_by = arp_standard.profile.user_id,
1315: last_update_login = arp_standard.profile.last_update_login,
1316: request_id = req_id,
1317: program_application_id =arp_standard.profile.program_application_id,
1318: program_id = arp_standard.profile.program_id,
1319: program_update_date = sysdate

Line 1317: program_application_id =arp_standard.profile.program_application_id,

1313: last_update_date = sysdate,
1314: last_updated_by = arp_standard.profile.user_id,
1315: last_update_login = arp_standard.profile.last_update_login,
1316: request_id = req_id,
1317: program_application_id =arp_standard.profile.program_application_id,
1318: program_id = arp_standard.profile.program_id,
1319: program_update_date = sysdate
1320: where end_customer_site_use_id in (select m.duplicate_id
1321: from ra_customer_merges m

Line 1318: program_id = arp_standard.profile.program_id,

1314: last_updated_by = arp_standard.profile.user_id,
1315: last_update_login = arp_standard.profile.last_update_login,
1316: request_id = req_id,
1317: program_application_id =arp_standard.profile.program_application_id,
1318: program_id = arp_standard.profile.program_id,
1319: program_update_date = sysdate
1320: where end_customer_site_use_id in (select m.duplicate_id
1321: from ra_customer_merges m
1322: where m.process_flag = 'N'

Line 1344: last_updated_by = arp_standard.profile.user_id,

1340: and m.process_flag = 'N'
1341: and m.request_id = req_id
1342: and m.set_number = set_num),
1343: last_update_date = sysdate,
1344: last_updated_by = arp_standard.profile.user_id,
1345: last_update_login = arp_standard.profile.last_update_login,
1346: request_id = req_id,
1347: program_application_id =arp_standard.profile.program_application_id,
1348: program_id = arp_standard.profile.program_id,

Line 1345: last_update_login = arp_standard.profile.last_update_login,

1341: and m.request_id = req_id
1342: and m.set_number = set_num),
1343: last_update_date = sysdate,
1344: last_updated_by = arp_standard.profile.user_id,
1345: last_update_login = arp_standard.profile.last_update_login,
1346: request_id = req_id,
1347: program_application_id =arp_standard.profile.program_application_id,
1348: program_id = arp_standard.profile.program_id,
1349: program_update_date = sysdate

Line 1347: program_application_id =arp_standard.profile.program_application_id,

1343: last_update_date = sysdate,
1344: last_updated_by = arp_standard.profile.user_id,
1345: last_update_login = arp_standard.profile.last_update_login,
1346: request_id = req_id,
1347: program_application_id =arp_standard.profile.program_application_id,
1348: program_id = arp_standard.profile.program_id,
1349: program_update_date = sysdate
1350: where end_customer_id in (select m.duplicate_id
1351: from ra_customer_merges m

Line 1348: program_id = arp_standard.profile.program_id,

1344: last_updated_by = arp_standard.profile.user_id,
1345: last_update_login = arp_standard.profile.last_update_login,
1346: request_id = req_id,
1347: program_application_id =arp_standard.profile.program_application_id,
1348: program_id = arp_standard.profile.program_id,
1349: program_update_date = sysdate
1350: where end_customer_id in (select m.duplicate_id
1351: from ra_customer_merges m
1352: where m.process_flag = 'N'

Line 1469: last_updated_by = arp_standard.profile.user_id,

1465: and m.request_id = req_id
1466: and m.process_flag = 'N'
1467: and m.set_number = set_num),
1468: last_update_date = sysdate,
1469: last_updated_by = arp_standard.profile.user_id,
1470: last_update_login = arp_standard.profile.last_update_login,
1471: request_id = req_id,
1472: program_application_id =arp_standard.profile.program_application_id,
1473: program_id = arp_standard.profile.program_id,

Line 1470: last_update_login = arp_standard.profile.last_update_login,

1466: and m.process_flag = 'N'
1467: and m.set_number = set_num),
1468: last_update_date = sysdate,
1469: last_updated_by = arp_standard.profile.user_id,
1470: last_update_login = arp_standard.profile.last_update_login,
1471: request_id = req_id,
1472: program_application_id =arp_standard.profile.program_application_id,
1473: program_id = arp_standard.profile.program_id,
1474: program_update_date = sysdate

Line 1472: program_application_id =arp_standard.profile.program_application_id,

1468: last_update_date = sysdate,
1469: last_updated_by = arp_standard.profile.user_id,
1470: last_update_login = arp_standard.profile.last_update_login,
1471: request_id = req_id,
1472: program_application_id =arp_standard.profile.program_application_id,
1473: program_id = arp_standard.profile.program_id,
1474: program_update_date = sysdate
1475: where ship_to_org_id in (select m.duplicate_site_id
1476: from ra_customer_merges m

Line 1473: program_id = arp_standard.profile.program_id,

1469: last_updated_by = arp_standard.profile.user_id,
1470: last_update_login = arp_standard.profile.last_update_login,
1471: request_id = req_id,
1472: program_application_id =arp_standard.profile.program_application_id,
1473: program_id = arp_standard.profile.program_id,
1474: program_update_date = sysdate
1475: where ship_to_org_id in (select m.duplicate_site_id
1476: from ra_customer_merges m
1477: where m.process_flag = 'N'

Line 1495: last_updated_by = arp_standard.profile.user_id,

1491: and m.request_id = req_id
1492: and m.process_flag = 'N'
1493: and m.set_number = set_num),
1494: last_update_date = sysdate,
1495: last_updated_by = arp_standard.profile.user_id,
1496: last_update_login = arp_standard.profile.last_update_login,
1497: request_id = req_id,
1498: program_application_id =arp_standard.profile.program_application_id,
1499: program_id = arp_standard.profile.program_id,

Line 1496: last_update_login = arp_standard.profile.last_update_login,

1492: and m.process_flag = 'N'
1493: and m.set_number = set_num),
1494: last_update_date = sysdate,
1495: last_updated_by = arp_standard.profile.user_id,
1496: last_update_login = arp_standard.profile.last_update_login,
1497: request_id = req_id,
1498: program_application_id =arp_standard.profile.program_application_id,
1499: program_id = arp_standard.profile.program_id,
1500: program_update_date = sysdate

Line 1498: program_application_id =arp_standard.profile.program_application_id,

1494: last_update_date = sysdate,
1495: last_updated_by = arp_standard.profile.user_id,
1496: last_update_login = arp_standard.profile.last_update_login,
1497: request_id = req_id,
1498: program_application_id =arp_standard.profile.program_application_id,
1499: program_id = arp_standard.profile.program_id,
1500: program_update_date = sysdate
1501: where invoice_to_org_id in (select m.duplicate_site_id
1502: from ra_customer_merges m

Line 1499: program_id = arp_standard.profile.program_id,

1495: last_updated_by = arp_standard.profile.user_id,
1496: last_update_login = arp_standard.profile.last_update_login,
1497: request_id = req_id,
1498: program_application_id =arp_standard.profile.program_application_id,
1499: program_id = arp_standard.profile.program_id,
1500: program_update_date = sysdate
1501: where invoice_to_org_id in (select m.duplicate_site_id
1502: from ra_customer_merges m
1503: where m.process_flag = 'N'

Line 1521: last_updated_by = arp_standard.profile.user_id,

1517: and m.request_id = req_id
1518: and m.process_flag = 'N'
1519: and m.set_number = set_num),
1520: last_update_date = sysdate,
1521: last_updated_by = arp_standard.profile.user_id,
1522: last_update_login = arp_standard.profile.last_update_login,
1523: request_id = req_id,
1524: program_application_id =arp_standard.profile.program_application_id,
1525: program_id = arp_standard.profile.program_id,

Line 1522: last_update_login = arp_standard.profile.last_update_login,

1518: and m.process_flag = 'N'
1519: and m.set_number = set_num),
1520: last_update_date = sysdate,
1521: last_updated_by = arp_standard.profile.user_id,
1522: last_update_login = arp_standard.profile.last_update_login,
1523: request_id = req_id,
1524: program_application_id =arp_standard.profile.program_application_id,
1525: program_id = arp_standard.profile.program_id,
1526: program_update_date = sysdate

Line 1524: program_application_id =arp_standard.profile.program_application_id,

1520: last_update_date = sysdate,
1521: last_updated_by = arp_standard.profile.user_id,
1522: last_update_login = arp_standard.profile.last_update_login,
1523: request_id = req_id,
1524: program_application_id =arp_standard.profile.program_application_id,
1525: program_id = arp_standard.profile.program_id,
1526: program_update_date = sysdate
1527: where deliver_to_org_id in (select m.duplicate_site_id
1528: from ra_customer_merges m

Line 1525: program_id = arp_standard.profile.program_id,

1521: last_updated_by = arp_standard.profile.user_id,
1522: last_update_login = arp_standard.profile.last_update_login,
1523: request_id = req_id,
1524: program_application_id =arp_standard.profile.program_application_id,
1525: program_id = arp_standard.profile.program_id,
1526: program_update_date = sysdate
1527: where deliver_to_org_id in (select m.duplicate_site_id
1528: from ra_customer_merges m
1529: where m.process_flag = 'N'

Line 1552: last_updated_by = arp_standard.profile.user_id,

1548: and m.process_flag = 'N'
1549: and m.request_id = req_id
1550: and m.set_number = set_num),
1551: last_update_date = sysdate,
1552: last_updated_by = arp_standard.profile.user_id,
1553: last_update_login = arp_standard.profile.last_update_login,
1554: request_id = req_id,
1555: program_application_id =arp_standard.profile.program_application_id,
1556: program_id = arp_standard.profile.program_id,

Line 1553: last_update_login = arp_standard.profile.last_update_login,

1549: and m.request_id = req_id
1550: and m.set_number = set_num),
1551: last_update_date = sysdate,
1552: last_updated_by = arp_standard.profile.user_id,
1553: last_update_login = arp_standard.profile.last_update_login,
1554: request_id = req_id,
1555: program_application_id =arp_standard.profile.program_application_id,
1556: program_id = arp_standard.profile.program_id,
1557: program_update_date = sysdate

Line 1555: program_application_id =arp_standard.profile.program_application_id,

1551: last_update_date = sysdate,
1552: last_updated_by = arp_standard.profile.user_id,
1553: last_update_login = arp_standard.profile.last_update_login,
1554: request_id = req_id,
1555: program_application_id =arp_standard.profile.program_application_id,
1556: program_id = arp_standard.profile.program_id,
1557: program_update_date = sysdate
1558: where sold_to_org_id in (select m.duplicate_id
1559: from ra_customer_merges m

Line 1556: program_id = arp_standard.profile.program_id,

1552: last_updated_by = arp_standard.profile.user_id,
1553: last_update_login = arp_standard.profile.last_update_login,
1554: request_id = req_id,
1555: program_application_id =arp_standard.profile.program_application_id,
1556: program_id = arp_standard.profile.program_id,
1557: program_update_date = sysdate
1558: where sold_to_org_id in (select m.duplicate_id
1559: from ra_customer_merges m
1560: where m.process_flag = 'N'

Line 1772: last_updated_by = arp_standard.profile.user_id,

1768: and m.request_id = req_id
1769: and m.process_flag = 'N'
1770: and m.set_number = set_num),
1771: last_update_date = sysdate,
1772: last_updated_by = arp_standard.profile.user_id,
1773: last_update_login = arp_standard.profile.last_update_login,
1774: request_id = req_id,
1775: program_application_id =arp_standard.profile.program_application_id,
1776: program_id = arp_standard.profile.program_id,

Line 1773: last_update_login = arp_standard.profile.last_update_login,

1769: and m.process_flag = 'N'
1770: and m.set_number = set_num),
1771: last_update_date = sysdate,
1772: last_updated_by = arp_standard.profile.user_id,
1773: last_update_login = arp_standard.profile.last_update_login,
1774: request_id = req_id,
1775: program_application_id =arp_standard.profile.program_application_id,
1776: program_id = arp_standard.profile.program_id,
1777: program_update_date = sysdate

Line 1775: program_application_id =arp_standard.profile.program_application_id,

1771: last_update_date = sysdate,
1772: last_updated_by = arp_standard.profile.user_id,
1773: last_update_login = arp_standard.profile.last_update_login,
1774: request_id = req_id,
1775: program_application_id =arp_standard.profile.program_application_id,
1776: program_id = arp_standard.profile.program_id,
1777: program_update_date = sysdate
1778: where ship_to_org_id in (select m.duplicate_site_id
1779: from ra_customer_merges m

Line 1776: program_id = arp_standard.profile.program_id,

1772: last_updated_by = arp_standard.profile.user_id,
1773: last_update_login = arp_standard.profile.last_update_login,
1774: request_id = req_id,
1775: program_application_id =arp_standard.profile.program_application_id,
1776: program_id = arp_standard.profile.program_id,
1777: program_update_date = sysdate
1778: where ship_to_org_id in (select m.duplicate_site_id
1779: from ra_customer_merges m
1780: where m.process_flag = 'N'

Line 1838: last_updated_by = arp_standard.profile.user_id,

1834: and m.request_id = req_id
1835: and m.process_flag = 'N'
1836: and m.set_number = set_num),
1837: last_update_date = sysdate,
1838: last_updated_by = arp_standard.profile.user_id,
1839: last_update_login = arp_standard.profile.last_update_login,
1840: request_id = req_id,
1841: program_application_id =arp_standard.profile.program_application_id,
1842: program_id = arp_standard.profile.program_id,

Line 1839: last_update_login = arp_standard.profile.last_update_login,

1835: and m.process_flag = 'N'
1836: and m.set_number = set_num),
1837: last_update_date = sysdate,
1838: last_updated_by = arp_standard.profile.user_id,
1839: last_update_login = arp_standard.profile.last_update_login,
1840: request_id = req_id,
1841: program_application_id =arp_standard.profile.program_application_id,
1842: program_id = arp_standard.profile.program_id,
1843: program_update_date = sysdate

Line 1841: program_application_id =arp_standard.profile.program_application_id,

1837: last_update_date = sysdate,
1838: last_updated_by = arp_standard.profile.user_id,
1839: last_update_login = arp_standard.profile.last_update_login,
1840: request_id = req_id,
1841: program_application_id =arp_standard.profile.program_application_id,
1842: program_id = arp_standard.profile.program_id,
1843: program_update_date = sysdate
1844: where invoice_to_org_id in (select m.duplicate_site_id
1845: from ra_customer_merges m

Line 1842: program_id = arp_standard.profile.program_id,

1838: last_updated_by = arp_standard.profile.user_id,
1839: last_update_login = arp_standard.profile.last_update_login,
1840: request_id = req_id,
1841: program_application_id =arp_standard.profile.program_application_id,
1842: program_id = arp_standard.profile.program_id,
1843: program_update_date = sysdate
1844: where invoice_to_org_id in (select m.duplicate_site_id
1845: from ra_customer_merges m
1846: where m.process_flag = 'N'

Line 1904: last_updated_by = arp_standard.profile.user_id,

1900: and m.request_id = req_id
1901: and m.process_flag = 'N'
1902: and m.set_number = set_num),
1903: last_update_date = sysdate,
1904: last_updated_by = arp_standard.profile.user_id,
1905: last_update_login = arp_standard.profile.last_update_login,
1906: request_id = req_id,
1907: program_application_id =arp_standard.profile.program_application_id,
1908: program_id = arp_standard.profile.program_id,

Line 1905: last_update_login = arp_standard.profile.last_update_login,

1901: and m.process_flag = 'N'
1902: and m.set_number = set_num),
1903: last_update_date = sysdate,
1904: last_updated_by = arp_standard.profile.user_id,
1905: last_update_login = arp_standard.profile.last_update_login,
1906: request_id = req_id,
1907: program_application_id =arp_standard.profile.program_application_id,
1908: program_id = arp_standard.profile.program_id,
1909: program_update_date = sysdate

Line 1907: program_application_id =arp_standard.profile.program_application_id,

1903: last_update_date = sysdate,
1904: last_updated_by = arp_standard.profile.user_id,
1905: last_update_login = arp_standard.profile.last_update_login,
1906: request_id = req_id,
1907: program_application_id =arp_standard.profile.program_application_id,
1908: program_id = arp_standard.profile.program_id,
1909: program_update_date = sysdate
1910: where deliver_to_org_id in (select m.duplicate_site_id
1911: from ra_customer_merges m

Line 1908: program_id = arp_standard.profile.program_id,

1904: last_updated_by = arp_standard.profile.user_id,
1905: last_update_login = arp_standard.profile.last_update_login,
1906: request_id = req_id,
1907: program_application_id =arp_standard.profile.program_application_id,
1908: program_id = arp_standard.profile.program_id,
1909: program_update_date = sysdate
1910: where deliver_to_org_id in (select m.duplicate_site_id
1911: from ra_customer_merges m
1912: where m.process_flag = 'N'

Line 1975: last_updated_by = arp_standard.profile.user_id,

1971: and m.process_flag = 'N'
1972: and m.request_id = req_id
1973: and m.set_number = set_num),
1974: last_update_date = sysdate,
1975: last_updated_by = arp_standard.profile.user_id,
1976: last_update_login = arp_standard.profile.last_update_login,
1977: request_id = req_id,
1978: program_application_id =arp_standard.profile.program_application_id,
1979: program_id = arp_standard.profile.program_id,

Line 1976: last_update_login = arp_standard.profile.last_update_login,

1972: and m.request_id = req_id
1973: and m.set_number = set_num),
1974: last_update_date = sysdate,
1975: last_updated_by = arp_standard.profile.user_id,
1976: last_update_login = arp_standard.profile.last_update_login,
1977: request_id = req_id,
1978: program_application_id =arp_standard.profile.program_application_id,
1979: program_id = arp_standard.profile.program_id,
1980: program_update_date = sysdate

Line 1978: program_application_id =arp_standard.profile.program_application_id,

1974: last_update_date = sysdate,
1975: last_updated_by = arp_standard.profile.user_id,
1976: last_update_login = arp_standard.profile.last_update_login,
1977: request_id = req_id,
1978: program_application_id =arp_standard.profile.program_application_id,
1979: program_id = arp_standard.profile.program_id,
1980: program_update_date = sysdate
1981: where sold_to_org_id in (select m.duplicate_id
1982: from ra_customer_merges m

Line 1979: program_id = arp_standard.profile.program_id,

1975: last_updated_by = arp_standard.profile.user_id,
1976: last_update_login = arp_standard.profile.last_update_login,
1977: request_id = req_id,
1978: program_application_id =arp_standard.profile.program_application_id,
1979: program_id = arp_standard.profile.program_id,
1980: program_update_date = sysdate
1981: where sold_to_org_id in (select m.duplicate_id
1982: from ra_customer_merges m
1983: where m.process_flag = 'N'

Line 2049: last_updated_by = arp_standard.profile.user_id,

2045: and m.process_flag = 'N'
2046: and m.request_id = req_id
2047: and m.set_number = set_num),
2048: last_update_date = sysdate,
2049: last_updated_by = arp_standard.profile.user_id,
2050: last_update_login = arp_standard.profile.last_update_login,
2051: request_id = req_id,
2052: program_application_id =arp_standard.profile.program_application_id,
2053: program_id = arp_standard.profile.program_id,

Line 2050: last_update_login = arp_standard.profile.last_update_login,

2046: and m.request_id = req_id
2047: and m.set_number = set_num),
2048: last_update_date = sysdate,
2049: last_updated_by = arp_standard.profile.user_id,
2050: last_update_login = arp_standard.profile.last_update_login,
2051: request_id = req_id,
2052: program_application_id =arp_standard.profile.program_application_id,
2053: program_id = arp_standard.profile.program_id,
2054: program_update_date = sysdate

Line 2052: program_application_id =arp_standard.profile.program_application_id,

2048: last_update_date = sysdate,
2049: last_updated_by = arp_standard.profile.user_id,
2050: last_update_login = arp_standard.profile.last_update_login,
2051: request_id = req_id,
2052: program_application_id =arp_standard.profile.program_application_id,
2053: program_id = arp_standard.profile.program_id,
2054: program_update_date = sysdate
2055: where sold_to_site_use_id in (select m.duplicate_id
2056: from ra_customer_merges m

Line 2053: program_id = arp_standard.profile.program_id,

2049: last_updated_by = arp_standard.profile.user_id,
2050: last_update_login = arp_standard.profile.last_update_login,
2051: request_id = req_id,
2052: program_application_id =arp_standard.profile.program_application_id,
2053: program_id = arp_standard.profile.program_id,
2054: program_update_date = sysdate
2055: where sold_to_site_use_id in (select m.duplicate_id
2056: from ra_customer_merges m
2057: where m.process_flag = 'N'

Line 2122: last_updated_by = arp_standard.profile.user_id,

2118: and m.process_flag = 'N'
2119: and m.request_id = req_id
2120: and m.set_number = set_num),
2121: last_update_date = sysdate,
2122: last_updated_by = arp_standard.profile.user_id,
2123: last_update_login = arp_standard.profile.last_update_login,
2124: request_id = req_id,
2125: program_application_id =arp_standard.profile.program_application_id,
2126: program_id = arp_standard.profile.program_id,

Line 2123: last_update_login = arp_standard.profile.last_update_login,

2119: and m.request_id = req_id
2120: and m.set_number = set_num),
2121: last_update_date = sysdate,
2122: last_updated_by = arp_standard.profile.user_id,
2123: last_update_login = arp_standard.profile.last_update_login,
2124: request_id = req_id,
2125: program_application_id =arp_standard.profile.program_application_id,
2126: program_id = arp_standard.profile.program_id,
2127: program_update_date = sysdate

Line 2125: program_application_id =arp_standard.profile.program_application_id,

2121: last_update_date = sysdate,
2122: last_updated_by = arp_standard.profile.user_id,
2123: last_update_login = arp_standard.profile.last_update_login,
2124: request_id = req_id,
2125: program_application_id =arp_standard.profile.program_application_id,
2126: program_id = arp_standard.profile.program_id,
2127: program_update_date = sysdate
2128: where
2129: end_customer_site_use_id in (select m.duplicate_id

Line 2126: program_id = arp_standard.profile.program_id,

2122: last_updated_by = arp_standard.profile.user_id,
2123: last_update_login = arp_standard.profile.last_update_login,
2124: request_id = req_id,
2125: program_application_id =arp_standard.profile.program_application_id,
2126: program_id = arp_standard.profile.program_id,
2127: program_update_date = sysdate
2128: where
2129: end_customer_site_use_id in (select m.duplicate_id
2130: from ra_customer_merges m

Line 2196: last_updated_by = arp_standard.profile.user_id,

2192: and m.process_flag = 'N'
2193: and m.request_id = req_id
2194: and m.set_number = set_num),
2195: last_update_date = sysdate,
2196: last_updated_by = arp_standard.profile.user_id,
2197: last_update_login = arp_standard.profile.last_update_login,
2198: request_id = req_id,
2199: program_application_id =arp_standard.profile.program_application_id,
2200: program_id = arp_standard.profile.program_id,

Line 2197: last_update_login = arp_standard.profile.last_update_login,

2193: and m.request_id = req_id
2194: and m.set_number = set_num),
2195: last_update_date = sysdate,
2196: last_updated_by = arp_standard.profile.user_id,
2197: last_update_login = arp_standard.profile.last_update_login,
2198: request_id = req_id,
2199: program_application_id =arp_standard.profile.program_application_id,
2200: program_id = arp_standard.profile.program_id,
2201: program_update_date = sysdate

Line 2199: program_application_id =arp_standard.profile.program_application_id,

2195: last_update_date = sysdate,
2196: last_updated_by = arp_standard.profile.user_id,
2197: last_update_login = arp_standard.profile.last_update_login,
2198: request_id = req_id,
2199: program_application_id =arp_standard.profile.program_application_id,
2200: program_id = arp_standard.profile.program_id,
2201: program_update_date = sysdate
2202: where end_customer_id in (select m.duplicate_id
2203: from ra_customer_merges m

Line 2200: program_id = arp_standard.profile.program_id,

2196: last_updated_by = arp_standard.profile.user_id,
2197: last_update_login = arp_standard.profile.last_update_login,
2198: request_id = req_id,
2199: program_application_id =arp_standard.profile.program_application_id,
2200: program_id = arp_standard.profile.program_id,
2201: program_update_date = sysdate
2202: where end_customer_id in (select m.duplicate_id
2203: from ra_customer_merges m
2204: where m.process_flag = 'N'

Line 2765: last_updated_by = arp_standard.profile.user_id,

2761: deliver_to_org_id = decode(line_deliver_to_org_id_tab(i),null,deliver_to_org_id,line_deliver_to_org_id_tab(i)),
2762: 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)),
2763: end_customer_id = decode(line_end_cust_id_tab(i),null,end_customer_id,line_end_cust_id_tab(i)),
2764: last_update_date = sysdate,
2765: last_updated_by = arp_standard.profile.user_id,
2766: last_update_login = arp_standard.profile.last_update_login,
2767: request_id = req_id,
2768: program_application_id = arp_standard.profile.program_application_id ,
2769: program_id = arp_standard.profile.program_id,

Line 2766: last_update_login = arp_standard.profile.last_update_login,

2762: 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)),
2763: end_customer_id = decode(line_end_cust_id_tab(i),null,end_customer_id,line_end_cust_id_tab(i)),
2764: last_update_date = sysdate,
2765: last_updated_by = arp_standard.profile.user_id,
2766: last_update_login = arp_standard.profile.last_update_login,
2767: request_id = req_id,
2768: program_application_id = arp_standard.profile.program_application_id ,
2769: program_id = arp_standard.profile.program_id,
2770: program_update_date = SYSDATE,

Line 2768: program_application_id = arp_standard.profile.program_application_id ,

2764: last_update_date = sysdate,
2765: last_updated_by = arp_standard.profile.user_id,
2766: last_update_login = arp_standard.profile.last_update_login,
2767: request_id = req_id,
2768: program_application_id = arp_standard.profile.program_application_id ,
2769: program_id = arp_standard.profile.program_id,
2770: program_update_date = SYSDATE,
2771: lock_control = lock_control+1
2772: WHERE line_id = line_line_id_tab(i)

Line 2769: program_id = arp_standard.profile.program_id,

2765: last_updated_by = arp_standard.profile.user_id,
2766: last_update_login = arp_standard.profile.last_update_login,
2767: request_id = req_id,
2768: program_application_id = arp_standard.profile.program_application_id ,
2769: program_id = arp_standard.profile.program_id,
2770: program_update_date = SYSDATE,
2771: lock_control = lock_control+1
2772: WHERE line_id = line_line_id_tab(i)
2773: AND line_duplicate_flag_tab(i) = 'N'; --Added for Duplicate Check

Line 3195: last_updated_by = arp_standard.profile.user_id,

3191: deliver_to_org_id = decode(lhst_deliver_to_org_id_tab(i),null,deliver_to_org_id,lhst_deliver_to_org_id_tab(i)),
3192: 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)),
3193: end_customer_id = decode(lhst_end_cust_id_tab(i),null,end_customer_id,lhst_end_cust_id_tab(i)),
3194: last_update_date = sysdate,
3195: last_updated_by = arp_standard.profile.user_id,
3196: last_update_login = arp_standard.profile.last_update_login,
3197: request_id = req_id,
3198: program_application_id = arp_standard.profile.program_application_id ,
3199: program_id = arp_standard.profile.program_id,

Line 3196: last_update_login = arp_standard.profile.last_update_login,

3192: 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)),
3193: end_customer_id = decode(lhst_end_cust_id_tab(i),null,end_customer_id,lhst_end_cust_id_tab(i)),
3194: last_update_date = sysdate,
3195: last_updated_by = arp_standard.profile.user_id,
3196: last_update_login = arp_standard.profile.last_update_login,
3197: request_id = req_id,
3198: program_application_id = arp_standard.profile.program_application_id ,
3199: program_id = arp_standard.profile.program_id,
3200: program_update_date = SYSDATE

Line 3198: program_application_id = arp_standard.profile.program_application_id ,

3194: last_update_date = sysdate,
3195: last_updated_by = arp_standard.profile.user_id,
3196: last_update_login = arp_standard.profile.last_update_login,
3197: request_id = req_id,
3198: program_application_id = arp_standard.profile.program_application_id ,
3199: program_id = arp_standard.profile.program_id,
3200: program_update_date = SYSDATE
3201: WHERE line_id = lhst_line_id_tab(i);
3202:

Line 3199: program_id = arp_standard.profile.program_id,

3195: last_updated_by = arp_standard.profile.user_id,
3196: last_update_login = arp_standard.profile.last_update_login,
3197: request_id = req_id,
3198: program_application_id = arp_standard.profile.program_application_id ,
3199: program_id = arp_standard.profile.program_id,
3200: program_update_date = SYSDATE
3201: WHERE line_id = lhst_line_id_tab(i);
3202:
3203: g_count := sql%rowcount;

Line 3340: last_updated_by = arp_standard.profile.user_id,

3336: and m.request_id = req_id
3337: and m.process_flag = 'N'
3338: and m.set_number = set_num),
3339: last_update_date = sysdate,
3340: last_updated_by = arp_standard.profile.user_id,
3341: last_update_login = arp_standard.profile.last_update_login,
3342: request_id = req_id,
3343: program_application_id =arp_standard.profile.program_application_id,
3344: program_id = arp_standard.profile.program_id,

Line 3341: last_update_login = arp_standard.profile.last_update_login,

3337: and m.process_flag = 'N'
3338: and m.set_number = set_num),
3339: last_update_date = sysdate,
3340: last_updated_by = arp_standard.profile.user_id,
3341: last_update_login = arp_standard.profile.last_update_login,
3342: request_id = req_id,
3343: program_application_id =arp_standard.profile.program_application_id,
3344: program_id = arp_standard.profile.program_id,
3345: program_update_date = sysdate

Line 3343: program_application_id =arp_standard.profile.program_application_id,

3339: last_update_date = sysdate,
3340: last_updated_by = arp_standard.profile.user_id,
3341: last_update_login = arp_standard.profile.last_update_login,
3342: request_id = req_id,
3343: program_application_id =arp_standard.profile.program_application_id,
3344: program_id = arp_standard.profile.program_id,
3345: program_update_date = sysdate
3346: where ship_to_org_id in (select m.duplicate_site_id
3347: from ra_customer_merges m

Line 3344: program_id = arp_standard.profile.program_id,

3340: last_updated_by = arp_standard.profile.user_id,
3341: last_update_login = arp_standard.profile.last_update_login,
3342: request_id = req_id,
3343: program_application_id =arp_standard.profile.program_application_id,
3344: program_id = arp_standard.profile.program_id,
3345: program_update_date = sysdate
3346: where ship_to_org_id in (select m.duplicate_site_id
3347: from ra_customer_merges m
3348: where m.process_flag = 'N'

Line 3366: last_updated_by = arp_standard.profile.user_id,

3362: and m.request_id = req_id
3363: and m.process_flag = 'N'
3364: and m.set_number = set_num),
3365: last_update_date = sysdate,
3366: last_updated_by = arp_standard.profile.user_id,
3367: last_update_login = arp_standard.profile.last_update_login,
3368: request_id = req_id,
3369: program_application_id =arp_standard.profile.program_application_id,
3370: program_id = arp_standard.profile.program_id,

Line 3367: last_update_login = arp_standard.profile.last_update_login,

3363: and m.process_flag = 'N'
3364: and m.set_number = set_num),
3365: last_update_date = sysdate,
3366: last_updated_by = arp_standard.profile.user_id,
3367: last_update_login = arp_standard.profile.last_update_login,
3368: request_id = req_id,
3369: program_application_id =arp_standard.profile.program_application_id,
3370: program_id = arp_standard.profile.program_id,
3371: program_update_date = sysdate

Line 3369: program_application_id =arp_standard.profile.program_application_id,

3365: last_update_date = sysdate,
3366: last_updated_by = arp_standard.profile.user_id,
3367: last_update_login = arp_standard.profile.last_update_login,
3368: request_id = req_id,
3369: program_application_id =arp_standard.profile.program_application_id,
3370: program_id = arp_standard.profile.program_id,
3371: program_update_date = sysdate
3372: where invoice_to_org_id in (select m.duplicate_site_id
3373: from ra_customer_merges m

Line 3370: program_id = arp_standard.profile.program_id,

3366: last_updated_by = arp_standard.profile.user_id,
3367: last_update_login = arp_standard.profile.last_update_login,
3368: request_id = req_id,
3369: program_application_id =arp_standard.profile.program_application_id,
3370: program_id = arp_standard.profile.program_id,
3371: program_update_date = sysdate
3372: where invoice_to_org_id in (select m.duplicate_site_id
3373: from ra_customer_merges m
3374: where m.process_flag = 'N'

Line 3392: last_updated_by = arp_standard.profile.user_id,

3388: and m.request_id = req_id
3389: and m.process_flag = 'N'
3390: and m.set_number = set_num),
3391: last_update_date = sysdate,
3392: last_updated_by = arp_standard.profile.user_id,
3393: last_update_login = arp_standard.profile.last_update_login,
3394: request_id = req_id,
3395: program_application_id =arp_standard.profile.program_application_id,
3396: program_id = arp_standard.profile.program_id,

Line 3393: last_update_login = arp_standard.profile.last_update_login,

3389: and m.process_flag = 'N'
3390: and m.set_number = set_num),
3391: last_update_date = sysdate,
3392: last_updated_by = arp_standard.profile.user_id,
3393: last_update_login = arp_standard.profile.last_update_login,
3394: request_id = req_id,
3395: program_application_id =arp_standard.profile.program_application_id,
3396: program_id = arp_standard.profile.program_id,
3397: program_update_date = sysdate

Line 3395: program_application_id =arp_standard.profile.program_application_id,

3391: last_update_date = sysdate,
3392: last_updated_by = arp_standard.profile.user_id,
3393: last_update_login = arp_standard.profile.last_update_login,
3394: request_id = req_id,
3395: program_application_id =arp_standard.profile.program_application_id,
3396: program_id = arp_standard.profile.program_id,
3397: program_update_date = sysdate
3398: where deliver_to_org_id in (select m.duplicate_site_id
3399: from ra_customer_merges m

Line 3396: program_id = arp_standard.profile.program_id,

3392: last_updated_by = arp_standard.profile.user_id,
3393: last_update_login = arp_standard.profile.last_update_login,
3394: request_id = req_id,
3395: program_application_id =arp_standard.profile.program_application_id,
3396: program_id = arp_standard.profile.program_id,
3397: program_update_date = sysdate
3398: where deliver_to_org_id in (select m.duplicate_site_id
3399: from ra_customer_merges m
3400: where m.process_flag = 'N'

Line 3422: last_updated_by = arp_standard.profile.user_id,

3418: and m.process_flag = 'N'
3419: and m.request_id = req_id
3420: and m.set_number = set_num),
3421: last_update_date = sysdate,
3422: last_updated_by = arp_standard.profile.user_id,
3423: last_update_login = arp_standard.profile.last_update_login,
3424: request_id = req_id,
3425: program_application_id =arp_standard.profile.program_application_id,
3426: program_id = arp_standard.profile.program_id,

Line 3423: last_update_login = arp_standard.profile.last_update_login,

3419: and m.request_id = req_id
3420: and m.set_number = set_num),
3421: last_update_date = sysdate,
3422: last_updated_by = arp_standard.profile.user_id,
3423: last_update_login = arp_standard.profile.last_update_login,
3424: request_id = req_id,
3425: program_application_id =arp_standard.profile.program_application_id,
3426: program_id = arp_standard.profile.program_id,
3427: program_update_date = sysdate

Line 3425: program_application_id =arp_standard.profile.program_application_id,

3421: last_update_date = sysdate,
3422: last_updated_by = arp_standard.profile.user_id,
3423: last_update_login = arp_standard.profile.last_update_login,
3424: request_id = req_id,
3425: program_application_id =arp_standard.profile.program_application_id,
3426: program_id = arp_standard.profile.program_id,
3427: program_update_date = sysdate
3428: where sold_to_org_id in (select m.duplicate_id
3429: from ra_customer_merges m

Line 3426: program_id = arp_standard.profile.program_id,

3422: last_updated_by = arp_standard.profile.user_id,
3423: last_update_login = arp_standard.profile.last_update_login,
3424: request_id = req_id,
3425: program_application_id =arp_standard.profile.program_application_id,
3426: program_id = arp_standard.profile.program_id,
3427: program_update_date = sysdate
3428: where sold_to_org_id in (select m.duplicate_id
3429: from ra_customer_merges m
3430: where m.process_flag = 'N'

Line 3643: last_updated_by = arp_standard.profile.user_id,

3639: and m.request_id = req_id
3640: and m.process_flag = 'N'
3641: and m.set_number = set_num),
3642: last_update_date = sysdate,
3643: last_updated_by = arp_standard.profile.user_id,
3644: last_update_login = arp_standard.profile.last_update_login,
3645: request_id = req_id,
3646: program_application_id =arp_standard.profile.program_application_id,
3647: program_id = arp_standard.profile.program_id,

Line 3644: last_update_login = arp_standard.profile.last_update_login,

3640: and m.process_flag = 'N'
3641: and m.set_number = set_num),
3642: last_update_date = sysdate,
3643: last_updated_by = arp_standard.profile.user_id,
3644: last_update_login = arp_standard.profile.last_update_login,
3645: request_id = req_id,
3646: program_application_id =arp_standard.profile.program_application_id,
3647: program_id = arp_standard.profile.program_id,
3648: program_update_date = sysdate

Line 3646: program_application_id =arp_standard.profile.program_application_id,

3642: last_update_date = sysdate,
3643: last_updated_by = arp_standard.profile.user_id,
3644: last_update_login = arp_standard.profile.last_update_login,
3645: request_id = req_id,
3646: program_application_id =arp_standard.profile.program_application_id,
3647: program_id = arp_standard.profile.program_id,
3648: program_update_date = sysdate
3649: where ship_to_org_id in (select m.duplicate_site_id
3650: from ra_customer_merges m

Line 3647: program_id = arp_standard.profile.program_id,

3643: last_updated_by = arp_standard.profile.user_id,
3644: last_update_login = arp_standard.profile.last_update_login,
3645: request_id = req_id,
3646: program_application_id =arp_standard.profile.program_application_id,
3647: program_id = arp_standard.profile.program_id,
3648: program_update_date = sysdate
3649: where ship_to_org_id in (select m.duplicate_site_id
3650: from ra_customer_merges m
3651: where m.process_flag = 'N'

Line 3711: last_updated_by = arp_standard.profile.user_id,

3707: and m.request_id = req_id
3708: and m.process_flag = 'N'
3709: and m.set_number = set_num),
3710: last_update_date = sysdate,
3711: last_updated_by = arp_standard.profile.user_id,
3712: last_update_login = arp_standard.profile.last_update_login,
3713: request_id = req_id,
3714: program_application_id =arp_standard.profile.program_application_id,
3715: program_id = arp_standard.profile.program_id,

Line 3712: last_update_login = arp_standard.profile.last_update_login,

3708: and m.process_flag = 'N'
3709: and m.set_number = set_num),
3710: last_update_date = sysdate,
3711: last_updated_by = arp_standard.profile.user_id,
3712: last_update_login = arp_standard.profile.last_update_login,
3713: request_id = req_id,
3714: program_application_id =arp_standard.profile.program_application_id,
3715: program_id = arp_standard.profile.program_id,
3716: program_update_date = sysdate

Line 3714: program_application_id =arp_standard.profile.program_application_id,

3710: last_update_date = sysdate,
3711: last_updated_by = arp_standard.profile.user_id,
3712: last_update_login = arp_standard.profile.last_update_login,
3713: request_id = req_id,
3714: program_application_id =arp_standard.profile.program_application_id,
3715: program_id = arp_standard.profile.program_id,
3716: program_update_date = sysdate
3717: where invoice_to_org_id in (select m.duplicate_site_id
3718: from ra_customer_merges m

Line 3715: program_id = arp_standard.profile.program_id,

3711: last_updated_by = arp_standard.profile.user_id,
3712: last_update_login = arp_standard.profile.last_update_login,
3713: request_id = req_id,
3714: program_application_id =arp_standard.profile.program_application_id,
3715: program_id = arp_standard.profile.program_id,
3716: program_update_date = sysdate
3717: where invoice_to_org_id in (select m.duplicate_site_id
3718: from ra_customer_merges m
3719: where m.process_flag = 'N'

Line 3779: last_updated_by = arp_standard.profile.user_id,

3775: and m.request_id = req_id
3776: and m.process_flag = 'N'
3777: and m.set_number = set_num),
3778: last_update_date = sysdate,
3779: last_updated_by = arp_standard.profile.user_id,
3780: last_update_login = arp_standard.profile.last_update_login,
3781: request_id = req_id,
3782: program_application_id =arp_standard.profile.program_application_id,
3783: program_id = arp_standard.profile.program_id,

Line 3780: last_update_login = arp_standard.profile.last_update_login,

3776: and m.process_flag = 'N'
3777: and m.set_number = set_num),
3778: last_update_date = sysdate,
3779: last_updated_by = arp_standard.profile.user_id,
3780: last_update_login = arp_standard.profile.last_update_login,
3781: request_id = req_id,
3782: program_application_id =arp_standard.profile.program_application_id,
3783: program_id = arp_standard.profile.program_id,
3784: program_update_date = sysdate

Line 3782: program_application_id =arp_standard.profile.program_application_id,

3778: last_update_date = sysdate,
3779: last_updated_by = arp_standard.profile.user_id,
3780: last_update_login = arp_standard.profile.last_update_login,
3781: request_id = req_id,
3782: program_application_id =arp_standard.profile.program_application_id,
3783: program_id = arp_standard.profile.program_id,
3784: program_update_date = sysdate
3785: where deliver_to_org_id in (select m.duplicate_site_id
3786: from ra_customer_merges m

Line 3783: program_id = arp_standard.profile.program_id,

3779: last_updated_by = arp_standard.profile.user_id,
3780: last_update_login = arp_standard.profile.last_update_login,
3781: request_id = req_id,
3782: program_application_id =arp_standard.profile.program_application_id,
3783: program_id = arp_standard.profile.program_id,
3784: program_update_date = sysdate
3785: where deliver_to_org_id in (select m.duplicate_site_id
3786: from ra_customer_merges m
3787: where m.process_flag = 'N'

Line 3848: last_updated_by = arp_standard.profile.user_id,

3844: and m.request_id = req_id
3845: and m.process_flag = 'N'
3846: and m.set_number = set_num),
3847: last_update_date = sysdate,
3848: last_updated_by = arp_standard.profile.user_id,
3849: last_update_login = arp_standard.profile.last_update_login,
3850: request_id = req_id,
3851: program_application_id =arp_standard.profile.program_application_id,
3852: program_id = arp_standard.profile.program_id,

Line 3849: last_update_login = arp_standard.profile.last_update_login,

3845: and m.process_flag = 'N'
3846: and m.set_number = set_num),
3847: last_update_date = sysdate,
3848: last_updated_by = arp_standard.profile.user_id,
3849: last_update_login = arp_standard.profile.last_update_login,
3850: request_id = req_id,
3851: program_application_id =arp_standard.profile.program_application_id,
3852: program_id = arp_standard.profile.program_id,
3853: program_update_date = sysdate

Line 3851: program_application_id =arp_standard.profile.program_application_id,

3847: last_update_date = sysdate,
3848: last_updated_by = arp_standard.profile.user_id,
3849: last_update_login = arp_standard.profile.last_update_login,
3850: request_id = req_id,
3851: program_application_id =arp_standard.profile.program_application_id,
3852: program_id = arp_standard.profile.program_id,
3853: program_update_date = sysdate
3854: where intmed_ship_to_org_id in (select m.duplicate_site_id
3855: from ra_customer_merges m

Line 3852: program_id = arp_standard.profile.program_id,

3848: last_updated_by = arp_standard.profile.user_id,
3849: last_update_login = arp_standard.profile.last_update_login,
3850: request_id = req_id,
3851: program_application_id =arp_standard.profile.program_application_id,
3852: program_id = arp_standard.profile.program_id,
3853: program_update_date = sysdate
3854: where intmed_ship_to_org_id in (select m.duplicate_site_id
3855: from ra_customer_merges m
3856: where m.process_flag = 'N'

Line 3922: last_updated_by = arp_standard.profile.user_id,

3918: and m.process_flag = 'N'
3919: and m.request_id = req_id
3920: and m.set_number = set_num),
3921: last_update_date = sysdate,
3922: last_updated_by = arp_standard.profile.user_id,
3923: last_update_login = arp_standard.profile.last_update_login,
3924: request_id = req_id,
3925: program_application_id =arp_standard.profile.program_application_id,
3926: program_id = arp_standard.profile.program_id,

Line 3923: last_update_login = arp_standard.profile.last_update_login,

3919: and m.request_id = req_id
3920: and m.set_number = set_num),
3921: last_update_date = sysdate,
3922: last_updated_by = arp_standard.profile.user_id,
3923: last_update_login = arp_standard.profile.last_update_login,
3924: request_id = req_id,
3925: program_application_id =arp_standard.profile.program_application_id,
3926: program_id = arp_standard.profile.program_id,
3927: program_update_date = sysdate

Line 3925: program_application_id =arp_standard.profile.program_application_id,

3921: last_update_date = sysdate,
3922: last_updated_by = arp_standard.profile.user_id,
3923: last_update_login = arp_standard.profile.last_update_login,
3924: request_id = req_id,
3925: program_application_id =arp_standard.profile.program_application_id,
3926: program_id = arp_standard.profile.program_id,
3927: program_update_date = sysdate
3928: where sold_to_org_id in (select m.duplicate_id
3929: from ra_customer_merges m

Line 3926: program_id = arp_standard.profile.program_id,

3922: last_updated_by = arp_standard.profile.user_id,
3923: last_update_login = arp_standard.profile.last_update_login,
3924: request_id = req_id,
3925: program_application_id =arp_standard.profile.program_application_id,
3926: program_id = arp_standard.profile.program_id,
3927: program_update_date = sysdate
3928: where sold_to_org_id in (select m.duplicate_id
3929: from ra_customer_merges m
3930: where m.process_flag = 'N'

Line 3999: last_updated_by = arp_standard.profile.user_id,

3995: and m.process_flag = 'N'
3996: and m.request_id = req_id
3997: and m.set_number = set_num),
3998: last_update_date = sysdate,
3999: last_updated_by = arp_standard.profile.user_id,
4000: last_update_login = arp_standard.profile.last_update_login,
4001: request_id = req_id,
4002: program_application_id =arp_standard.profile.program_application_id,
4003: program_id = arp_standard.profile.program_id,

Line 4000: last_update_login = arp_standard.profile.last_update_login,

3996: and m.request_id = req_id
3997: and m.set_number = set_num),
3998: last_update_date = sysdate,
3999: last_updated_by = arp_standard.profile.user_id,
4000: last_update_login = arp_standard.profile.last_update_login,
4001: request_id = req_id,
4002: program_application_id =arp_standard.profile.program_application_id,
4003: program_id = arp_standard.profile.program_id,
4004: program_update_date = sysdate

Line 4002: program_application_id =arp_standard.profile.program_application_id,

3998: last_update_date = sysdate,
3999: last_updated_by = arp_standard.profile.user_id,
4000: last_update_login = arp_standard.profile.last_update_login,
4001: request_id = req_id,
4002: program_application_id =arp_standard.profile.program_application_id,
4003: program_id = arp_standard.profile.program_id,
4004: program_update_date = sysdate
4005: where end_customer_site_use_id in (select m.duplicate_id
4006: from ra_customer_merges m

Line 4003: program_id = arp_standard.profile.program_id,

3999: last_updated_by = arp_standard.profile.user_id,
4000: last_update_login = arp_standard.profile.last_update_login,
4001: request_id = req_id,
4002: program_application_id =arp_standard.profile.program_application_id,
4003: program_id = arp_standard.profile.program_id,
4004: program_update_date = sysdate
4005: where end_customer_site_use_id in (select m.duplicate_id
4006: from ra_customer_merges m
4007: where m.process_flag = 'N'

Line 4074: last_updated_by = arp_standard.profile.user_id,

4070: and m.process_flag = 'N'
4071: and m.request_id = req_id
4072: and m.set_number = set_num),
4073: last_update_date = sysdate,
4074: last_updated_by = arp_standard.profile.user_id,
4075: last_update_login = arp_standard.profile.last_update_login,
4076: request_id = req_id,
4077: program_application_id =arp_standard.profile.program_application_id,
4078: program_id = arp_standard.profile.program_id,

Line 4075: last_update_login = arp_standard.profile.last_update_login,

4071: and m.request_id = req_id
4072: and m.set_number = set_num),
4073: last_update_date = sysdate,
4074: last_updated_by = arp_standard.profile.user_id,
4075: last_update_login = arp_standard.profile.last_update_login,
4076: request_id = req_id,
4077: program_application_id =arp_standard.profile.program_application_id,
4078: program_id = arp_standard.profile.program_id,
4079: program_update_date = sysdate

Line 4077: program_application_id =arp_standard.profile.program_application_id,

4073: last_update_date = sysdate,
4074: last_updated_by = arp_standard.profile.user_id,
4075: last_update_login = arp_standard.profile.last_update_login,
4076: request_id = req_id,
4077: program_application_id =arp_standard.profile.program_application_id,
4078: program_id = arp_standard.profile.program_id,
4079: program_update_date = sysdate
4080: where end_customer_id in (select m.duplicate_id
4081: from ra_customer_merges m

Line 4078: program_id = arp_standard.profile.program_id,

4074: last_updated_by = arp_standard.profile.user_id,
4075: last_update_login = arp_standard.profile.last_update_login,
4076: request_id = req_id,
4077: program_application_id =arp_standard.profile.program_application_id,
4078: program_id = arp_standard.profile.program_id,
4079: program_update_date = sysdate
4080: where end_customer_id in (select m.duplicate_id
4081: from ra_customer_merges m
4082: where m.process_flag = 'N'

Line 4278: last_updated_by = arp_standard.profile.user_id,

4274: and m.request_id = req_id
4275: and m.process_flag = 'N'
4276: and m.set_number = set_num),
4277: last_update_date = sysdate,
4278: last_updated_by = arp_standard.profile.user_id,
4279: last_update_login = arp_standard.profile.last_update_login
4280: where attribute_value in (select to_char(m.duplicate_site_id)
4281: from ra_customer_merges m
4282: where m.process_flag = 'N'

Line 4279: last_update_login = arp_standard.profile.last_update_login

4275: and m.process_flag = 'N'
4276: and m.set_number = set_num),
4277: last_update_date = sysdate,
4278: last_updated_by = arp_standard.profile.user_id,
4279: last_update_login = arp_standard.profile.last_update_login
4280: where attribute_value in (select to_char(m.duplicate_site_id)
4281: from ra_customer_merges m
4282: where m.process_flag = 'N'
4283: and m.request_id = req_id

Line 4346: last_updated_by = arp_standard.profile.user_id,

4342: and m.request_id = req_id
4343: and m.process_flag = 'N'
4344: and m.set_number = set_num),
4345: last_update_date = sysdate,
4346: last_updated_by = arp_standard.profile.user_id,
4347: last_update_login = arp_standard.profile.last_update_login
4348: where attribute_value in (select to_char(m.duplicate_site_id)
4349: from ra_customer_merges m
4350: where m.process_flag = 'N'

Line 4347: last_update_login = arp_standard.profile.last_update_login

4343: and m.process_flag = 'N'
4344: and m.set_number = set_num),
4345: last_update_date = sysdate,
4346: last_updated_by = arp_standard.profile.user_id,
4347: last_update_login = arp_standard.profile.last_update_login
4348: where attribute_value in (select to_char(m.duplicate_site_id)
4349: from ra_customer_merges m
4350: where m.process_flag = 'N'
4351: and m.request_id = req_id

Line 4415: last_updated_by = arp_standard.profile.user_id,

4411: and m.request_id = req_id
4412: and m.process_flag = 'N'
4413: and m.set_number = set_num),
4414: last_update_date = sysdate,
4415: last_updated_by = arp_standard.profile.user_id,
4416: last_update_login = arp_standard.profile.last_update_login
4417: where attribute_value in (select to_char(m.duplicate_id)
4418: from ra_customer_merges m
4419: where m.process_flag = 'N'

Line 4416: last_update_login = arp_standard.profile.last_update_login

4412: and m.process_flag = 'N'
4413: and m.set_number = set_num),
4414: last_update_date = sysdate,
4415: last_updated_by = arp_standard.profile.user_id,
4416: last_update_login = arp_standard.profile.last_update_login
4417: where attribute_value in (select to_char(m.duplicate_id)
4418: from ra_customer_merges m
4419: where m.process_flag = 'N'
4420: and m.request_id = req_id

Line 4636: last_updated_by = arp_standard.profile.user_id,

4632: and m.request_id = req_id
4633: and m.process_flag = 'N'
4634: and m.set_number = set_num),
4635: last_update_date = sysdate,
4636: last_updated_by = arp_standard.profile.user_id,
4637: last_update_login = arp_standard.profile.last_update_login
4638: where value_string in (select to_char(m.duplicate_site_id)
4639: from ra_customer_merges m
4640: where m.process_flag = 'N'

Line 4637: last_update_login = arp_standard.profile.last_update_login

4633: and m.process_flag = 'N'
4634: and m.set_number = set_num),
4635: last_update_date = sysdate,
4636: last_updated_by = arp_standard.profile.user_id,
4637: last_update_login = arp_standard.profile.last_update_login
4638: where value_string in (select to_char(m.duplicate_site_id)
4639: from ra_customer_merges m
4640: where m.process_flag = 'N'
4641: and m.request_id = req_id

Line 4704: last_updated_by = arp_standard.profile.user_id,

4700: and m.request_id = req_id
4701: and m.process_flag = 'N'
4702: and m.set_number = set_num),
4703: last_update_date = sysdate,
4704: last_updated_by = arp_standard.profile.user_id,
4705: last_update_login = arp_standard.profile.last_update_login
4706: where value_string in (select to_char(m.duplicate_site_id)
4707: from ra_customer_merges m
4708: where m.process_flag = 'N'

Line 4705: last_update_login = arp_standard.profile.last_update_login

4701: and m.process_flag = 'N'
4702: and m.set_number = set_num),
4703: last_update_date = sysdate,
4704: last_updated_by = arp_standard.profile.user_id,
4705: last_update_login = arp_standard.profile.last_update_login
4706: where value_string in (select to_char(m.duplicate_site_id)
4707: from ra_customer_merges m
4708: where m.process_flag = 'N'
4709: and m.request_id = req_id

Line 4772: last_updated_by = arp_standard.profile.user_id,

4768: and m.request_id = req_id
4769: and m.process_flag = 'N'
4770: and m.set_number = set_num),
4771: last_update_date = sysdate,
4772: last_updated_by = arp_standard.profile.user_id,
4773: last_update_login = arp_standard.profile.last_update_login
4774: where value_string in (select to_char(m.duplicate_site_id)
4775: from ra_customer_merges m
4776: where m.process_flag = 'N'

Line 4773: last_update_login = arp_standard.profile.last_update_login

4769: and m.process_flag = 'N'
4770: and m.set_number = set_num),
4771: last_update_date = sysdate,
4772: last_updated_by = arp_standard.profile.user_id,
4773: last_update_login = arp_standard.profile.last_update_login
4774: where value_string in (select to_char(m.duplicate_site_id)
4775: from ra_customer_merges m
4776: where m.process_flag = 'N'
4777: and m.request_id = req_id

Line 4840: last_updated_by = arp_standard.profile.user_id,

4836: and m.request_id = req_id
4837: and m.process_flag = 'N'
4838: and m.set_number = set_num),
4839: last_update_date = sysdate,
4840: last_updated_by = arp_standard.profile.user_id,
4841: last_update_login = arp_standard.profile.last_update_login
4842: where value_string in (select to_char(m.duplicate_id)
4843: from ra_customer_merges m
4844: where m.process_flag = 'N'

Line 4841: last_update_login = arp_standard.profile.last_update_login

4837: and m.process_flag = 'N'
4838: and m.set_number = set_num),
4839: last_update_date = sysdate,
4840: last_updated_by = arp_standard.profile.user_id,
4841: last_update_login = arp_standard.profile.last_update_login
4842: where value_string in (select to_char(m.duplicate_id)
4843: from ra_customer_merges m
4844: where m.process_flag = 'N'
4845: and m.request_id = req_id

Line 4912: last_updated_by = arp_standard.profile.user_id,

4908: and m.request_id = req_id
4909: and m.process_flag = 'N'
4910: and m.set_number = set_num),
4911: last_update_date = sysdate,
4912: last_updated_by = arp_standard.profile.user_id,
4913: last_update_login = arp_standard.profile.last_update_login
4914: where src_constant_value in (select to_char(m.duplicate_site_id)
4915: from ra_customer_merges m
4916: where m.process_flag = 'N'

Line 4913: last_update_login = arp_standard.profile.last_update_login

4909: and m.process_flag = 'N'
4910: and m.set_number = set_num),
4911: last_update_date = sysdate,
4912: last_updated_by = arp_standard.profile.user_id,
4913: last_update_login = arp_standard.profile.last_update_login
4914: where src_constant_value in (select to_char(m.duplicate_site_id)
4915: from ra_customer_merges m
4916: where m.process_flag = 'N'
4917: and m.request_id = req_id

Line 4980: last_updated_by = arp_standard.profile.user_id,

4976: and m.request_id = req_id
4977: and m.process_flag = 'N'
4978: and m.set_number = set_num),
4979: last_update_date = sysdate,
4980: last_updated_by = arp_standard.profile.user_id,
4981: last_update_login = arp_standard.profile.last_update_login
4982: where src_constant_value in (select to_char(m.duplicate_site_id)
4983: from ra_customer_merges m
4984: where m.process_flag = 'N'

Line 4981: last_update_login = arp_standard.profile.last_update_login

4977: and m.process_flag = 'N'
4978: and m.set_number = set_num),
4979: last_update_date = sysdate,
4980: last_updated_by = arp_standard.profile.user_id,
4981: last_update_login = arp_standard.profile.last_update_login
4982: where src_constant_value in (select to_char(m.duplicate_site_id)
4983: from ra_customer_merges m
4984: where m.process_flag = 'N'
4985: and m.request_id = req_id

Line 5048: last_updated_by = arp_standard.profile.user_id,

5044: and m.request_id = req_id
5045: and m.process_flag = 'N'
5046: and m.set_number = set_num),
5047: last_update_date = sysdate,
5048: last_updated_by = arp_standard.profile.user_id,
5049: last_update_login = arp_standard.profile.last_update_login
5050: where src_constant_value in (select to_char(m.duplicate_site_id)
5051: from ra_customer_merges m
5052: where m.process_flag = 'N'

Line 5049: last_update_login = arp_standard.profile.last_update_login

5045: and m.process_flag = 'N'
5046: and m.set_number = set_num),
5047: last_update_date = sysdate,
5048: last_updated_by = arp_standard.profile.user_id,
5049: last_update_login = arp_standard.profile.last_update_login
5050: where src_constant_value in (select to_char(m.duplicate_site_id)
5051: from ra_customer_merges m
5052: where m.process_flag = 'N'
5053: and m.request_id = req_id

Line 5117: last_updated_by = arp_standard.profile.user_id,

5113: and m.request_id = req_id
5114: and m.process_flag = 'N'
5115: and m.set_number = set_num),
5116: last_update_date = sysdate,
5117: last_updated_by = arp_standard.profile.user_id,
5118: last_update_login = arp_standard.profile.last_update_login
5119: where src_constant_value in (select to_char(m.duplicate_id)
5120: from ra_customer_merges m
5121: where m.process_flag = 'N'

Line 5118: last_update_login = arp_standard.profile.last_update_login

5114: and m.process_flag = 'N'
5115: and m.set_number = set_num),
5116: last_update_date = sysdate,
5117: last_updated_by = arp_standard.profile.user_id,
5118: last_update_login = arp_standard.profile.last_update_login
5119: where src_constant_value in (select to_char(m.duplicate_id)
5120: from ra_customer_merges m
5121: where m.process_flag = 'N'
5122: and m.request_id = req_id

Line 5285: last_updated_by = arp_standard.profile.user_id,

5281: and m.request_id = req_id
5282: and m.process_flag = 'N'
5283: and m.set_number = set_num),
5284: last_update_date = sysdate,
5285: last_updated_by = arp_standard.profile.user_id,
5286: last_update_login = arp_standard.profile.last_update_login
5287: where value_string in (select to_char(m.duplicate_site_id)
5288: from ra_customer_merges m
5289: where m.process_flag = 'N'

Line 5286: last_update_login = arp_standard.profile.last_update_login

5282: and m.process_flag = 'N'
5283: and m.set_number = set_num),
5284: last_update_date = sysdate,
5285: last_updated_by = arp_standard.profile.user_id,
5286: last_update_login = arp_standard.profile.last_update_login
5287: where value_string in (select to_char(m.duplicate_site_id)
5288: from ra_customer_merges m
5289: where m.process_flag = 'N'
5290: and m.request_id = req_id

Line 5353: last_updated_by = arp_standard.profile.user_id,

5349: and m.request_id = req_id
5350: and m.process_flag = 'N'
5351: and m.set_number = set_num),
5352: last_update_date = sysdate,
5353: last_updated_by = arp_standard.profile.user_id,
5354: last_update_login = arp_standard.profile.last_update_login
5355: where value_string in (select to_char(m.duplicate_site_id)
5356: from ra_customer_merges m
5357: where m.process_flag = 'N'

Line 5354: last_update_login = arp_standard.profile.last_update_login

5350: and m.process_flag = 'N'
5351: and m.set_number = set_num),
5352: last_update_date = sysdate,
5353: last_updated_by = arp_standard.profile.user_id,
5354: last_update_login = arp_standard.profile.last_update_login
5355: where value_string in (select to_char(m.duplicate_site_id)
5356: from ra_customer_merges m
5357: where m.process_flag = 'N'
5358: and m.request_id = req_id

Line 5421: last_updated_by = arp_standard.profile.user_id,

5417: and m.request_id = req_id
5418: and m.process_flag = 'N'
5419: and m.set_number = set_num),
5420: last_update_date = sysdate,
5421: last_updated_by = arp_standard.profile.user_id,
5422: last_update_login = arp_standard.profile.last_update_login
5423: where value_string in (select to_char(m.duplicate_site_id)
5424: from ra_customer_merges m
5425: where m.process_flag = 'N'

Line 5422: last_update_login = arp_standard.profile.last_update_login

5418: and m.process_flag = 'N'
5419: and m.set_number = set_num),
5420: last_update_date = sysdate,
5421: last_updated_by = arp_standard.profile.user_id,
5422: last_update_login = arp_standard.profile.last_update_login
5423: where value_string in (select to_char(m.duplicate_site_id)
5424: from ra_customer_merges m
5425: where m.process_flag = 'N'
5426: and m.request_id = req_id

Line 5490: last_updated_by = arp_standard.profile.user_id,

5486: and m.request_id = req_id
5487: and m.process_flag = 'N'
5488: and m.set_number = set_num),
5489: last_update_date = sysdate,
5490: last_updated_by = arp_standard.profile.user_id,
5491: last_update_login = arp_standard.profile.last_update_login
5492: where value_string in (select to_char(m.duplicate_id)
5493: from ra_customer_merges m
5494: where m.process_flag = 'N'

Line 5491: last_update_login = arp_standard.profile.last_update_login

5487: and m.process_flag = 'N'
5488: and m.set_number = set_num),
5489: last_update_date = sysdate,
5490: last_updated_by = arp_standard.profile.user_id,
5491: last_update_login = arp_standard.profile.last_update_login
5492: where value_string in (select to_char(m.duplicate_id)
5493: from ra_customer_merges m
5494: where m.process_flag = 'N'
5495: and m.request_id = req_id

Line 5642: last_updated_by = arp_standard.profile.user_id,

5638: and m.process_flag = 'N'
5639: and m.set_number = set_num),
5640: last_update_date = sysdate,
5641:
5642: last_updated_by = arp_standard.profile.user_id,
5643: last_update_login = arp_standard.profile.last_update_login
5644: where hold_entity_id in (select to_char(m.duplicate_site_id) --Bug 8866783
5645: from ra_customer_merges m
5646: where m.process_flag = 'N'

Line 5643: last_update_login = arp_standard.profile.last_update_login

5639: and m.set_number = set_num),
5640: last_update_date = sysdate,
5641:
5642: last_updated_by = arp_standard.profile.user_id,
5643: last_update_login = arp_standard.profile.last_update_login
5644: where hold_entity_id in (select to_char(m.duplicate_site_id) --Bug 8866783
5645: from ra_customer_merges m
5646: where m.process_flag = 'N'
5647: and m.request_id = req_id

Line 5711: last_updated_by = arp_standard.profile.user_id,

5707: and m.request_id = req_id
5708: and m.process_flag = 'N'
5709: and m.set_number = set_num),
5710: last_update_date = sysdate,
5711: last_updated_by = arp_standard.profile.user_id,
5712: last_update_login = arp_standard.profile.last_update_login
5713: where hold_entity_id in (select to_char(m.duplicate_site_id) --Bug 8866783
5714: from ra_customer_merges m
5715: where m.process_flag = 'N'

Line 5712: last_update_login = arp_standard.profile.last_update_login

5708: and m.process_flag = 'N'
5709: and m.set_number = set_num),
5710: last_update_date = sysdate,
5711: last_updated_by = arp_standard.profile.user_id,
5712: last_update_login = arp_standard.profile.last_update_login
5713: where hold_entity_id in (select to_char(m.duplicate_site_id) --Bug 8866783
5714: from ra_customer_merges m
5715: where m.process_flag = 'N'
5716: and m.request_id = req_id

Line 5781: last_updated_by = arp_standard.profile.user_id,

5777: and m.process_flag = 'N'
5778: and m.request_id = req_id
5779: and m.set_number = set_num),
5780: last_update_date = sysdate,
5781: last_updated_by = arp_standard.profile.user_id,
5782: last_update_login = arp_standard.profile.last_update_login
5783: where hold_entity_id in (select to_char(m.duplicate_id) --Bug 8866783
5784: from ra_customer_merges m
5785: where m.process_flag = 'N'

Line 5782: last_update_login = arp_standard.profile.last_update_login

5778: and m.request_id = req_id
5779: and m.set_number = set_num),
5780: last_update_date = sysdate,
5781: last_updated_by = arp_standard.profile.user_id,
5782: last_update_login = arp_standard.profile.last_update_login
5783: where hold_entity_id in (select to_char(m.duplicate_id) --Bug 8866783
5784: from ra_customer_merges m
5785: where m.process_flag = 'N'
5786: and m.request_id = req_id

Line 5895: last_updated_by = arp_standard.profile.user_id,

5891: and m.request_id = req_id
5892: and m.process_flag = 'N'
5893: and m.set_number = set_num),
5894: last_update_date = sysdate,
5895: last_updated_by = arp_standard.profile.user_id,
5896: last_update_login = arp_standard.profile.last_update_login
5897: where line_location_id in (select m.duplicate_site_id
5898: from ra_customer_merges m
5899: where m.process_flag = 'N'

Line 5896: last_update_login = arp_standard.profile.last_update_login

5892: and m.process_flag = 'N'
5893: and m.set_number = set_num),
5894: last_update_date = sysdate,
5895: last_updated_by = arp_standard.profile.user_id,
5896: last_update_login = arp_standard.profile.last_update_login
5897: where line_location_id in (select m.duplicate_site_id
5898: from ra_customer_merges m
5899: where m.process_flag = 'N'
5900: and m.request_id = req_id

Line 6019: last_updated_by = arp_standard.profile.user_id,

6015: and m.request_id = req_id
6016: and m.process_flag = 'N'
6017: and m.set_number = set_num),
6018: last_update_date = sysdate,
6019: last_updated_by = arp_standard.profile.user_id,
6020: last_update_login = arp_standard.profile.last_update_login
6021: where site_use_id in (select m.duplicate_site_id
6022: from ra_customer_merges m
6023: where m.process_flag = 'N'

Line 6020: last_update_login = arp_standard.profile.last_update_login

6016: and m.process_flag = 'N'
6017: and m.set_number = set_num),
6018: last_update_date = sysdate,
6019: last_updated_by = arp_standard.profile.user_id,
6020: last_update_login = arp_standard.profile.last_update_login
6021: where site_use_id in (select m.duplicate_site_id
6022: from ra_customer_merges m
6023: where m.process_flag = 'N'
6024: and m.request_id = req_id

Line 6081: last_updated_by = arp_standard.profile.user_id,

6077: and m.request_id = req_id
6078: and m.process_flag = 'N'
6079: and m.set_number = set_num),
6080: last_update_date = sysdate,
6081: last_updated_by = arp_standard.profile.user_id,
6082: last_update_login = arp_standard.profile.last_update_login
6083: where customer_id in (select m.duplicate_id
6084: from ra_customer_merges m
6085: where m.process_flag = 'N'

Line 6082: last_update_login = arp_standard.profile.last_update_login

6078: and m.process_flag = 'N'
6079: and m.set_number = set_num),
6080: last_update_date = sysdate,
6081: last_updated_by = arp_standard.profile.user_id,
6082: last_update_login = arp_standard.profile.last_update_login
6083: where customer_id in (select m.duplicate_id
6084: from ra_customer_merges m
6085: where m.process_flag = 'N'
6086: and m.request_id = req_id

Line 6237: updated_by = arp_standard.profile.user_id,

6233: FORALL i in sets_set_id_tab.FIRST..sets_set_id_tab.LAST
6234: UPDATE OE_SETS S
6235: SET ship_to_org_id = sets_ship_to_org_id_tab(i),
6236: update_date = sysdate,
6237: updated_by = arp_standard.profile.user_id,
6238: update_login = arp_standard.profile.last_update_login
6239: WHERE set_id = sets_set_id_tab(i);
6240:
6241: g_count := sql%rowcount;

Line 6238: update_login = arp_standard.profile.last_update_login

6234: UPDATE OE_SETS S
6235: SET ship_to_org_id = sets_ship_to_org_id_tab(i),
6236: update_date = sysdate,
6237: updated_by = arp_standard.profile.user_id,
6238: update_login = arp_standard.profile.last_update_login
6239: WHERE set_id = sets_set_id_tab(i);
6240:
6241: g_count := sql%rowcount;
6242:

Line 6413: last_updated_by = arp_standard.profile.user_id,

6409: FORALL i in attrib_id_tab.FIRST..attrib_id_tab.LAST
6410: UPDATE OE_PRICE_ADJ_ATTRIBS S
6411: SET pricing_attr_value_from = to_char(attrib_value_from_tab(i)),
6412: last_update_date = sysdate,
6413: last_updated_by = arp_standard.profile.user_id,
6414: last_update_login = arp_standard.profile.last_update_login
6415: WHERE price_adj_attrib_id = attrib_id_tab(i);
6416:
6417: g_count := sql%rowcount;

Line 6414: last_update_login = arp_standard.profile.last_update_login

6410: UPDATE OE_PRICE_ADJ_ATTRIBS S
6411: SET pricing_attr_value_from = to_char(attrib_value_from_tab(i)),
6412: last_update_date = sysdate,
6413: last_updated_by = arp_standard.profile.user_id,
6414: last_update_login = arp_standard.profile.last_update_login
6415: WHERE price_adj_attrib_id = attrib_id_tab(i);
6416:
6417: g_count := sql%rowcount;
6418:

Line 6806: last_updated_by = arp_standard.profile.user_id,

6802: ship_to_org_id = decode(hdr_ship_to_org_id_tab(i),null,ship_to_org_id,hdr_ship_to_org_id_tab(i)),
6803: deliver_to_org_id = decode(hdr_deliver_to_org_id_tab(i),null,deliver_to_org_id,hdr_deliver_to_org_id_tab(i)),
6804: 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)),
6805: last_update_date = sysdate,
6806: last_updated_by = arp_standard.profile.user_id,
6807: last_update_login = arp_standard.profile.last_update_login,
6808: request_id = req_id,
6809: program_application_id = arp_standard.profile.program_application_id ,
6810: program_id = arp_standard.profile.program_id,

Line 6807: last_update_login = arp_standard.profile.last_update_login,

6803: deliver_to_org_id = decode(hdr_deliver_to_org_id_tab(i),null,deliver_to_org_id,hdr_deliver_to_org_id_tab(i)),
6804: 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)),
6805: last_update_date = sysdate,
6806: last_updated_by = arp_standard.profile.user_id,
6807: last_update_login = arp_standard.profile.last_update_login,
6808: request_id = req_id,
6809: program_application_id = arp_standard.profile.program_application_id ,
6810: program_id = arp_standard.profile.program_id,
6811: program_update_date = SYSDATE,

Line 6809: program_application_id = arp_standard.profile.program_application_id ,

6805: last_update_date = sysdate,
6806: last_updated_by = arp_standard.profile.user_id,
6807: last_update_login = arp_standard.profile.last_update_login,
6808: request_id = req_id,
6809: program_application_id = arp_standard.profile.program_application_id ,
6810: program_id = arp_standard.profile.program_id,
6811: program_update_date = SYSDATE,
6812: lock_control = lock_control+1
6813: WHERE header_id = hdr_header_id_tab(i);

Line 6810: program_id = arp_standard.profile.program_id,

6806: last_updated_by = arp_standard.profile.user_id,
6807: last_update_login = arp_standard.profile.last_update_login,
6808: request_id = req_id,
6809: program_application_id = arp_standard.profile.program_application_id ,
6810: program_id = arp_standard.profile.program_id,
6811: program_update_date = SYSDATE,
6812: lock_control = lock_control+1
6813: WHERE header_id = hdr_header_id_tab(i);
6814:

Line 7031: last_updated_by = arp_standard.profile.user_id,

7027: and m.request_id = req_id
7028: and m.process_flag = 'N'
7029: and m.set_number = set_num),
7030: last_update_date = sysdate,
7031: last_updated_by = arp_standard.profile.user_id,
7032: last_update_login = arp_standard.profile.last_update_login,
7033: request_id = req_id,
7034: program_application_id =arp_standard.profile.program_application_id,
7035: program_id = arp_standard.profile.program_id,

Line 7032: last_update_login = arp_standard.profile.last_update_login,

7028: and m.process_flag = 'N'
7029: and m.set_number = set_num),
7030: last_update_date = sysdate,
7031: last_updated_by = arp_standard.profile.user_id,
7032: last_update_login = arp_standard.profile.last_update_login,
7033: request_id = req_id,
7034: program_application_id =arp_standard.profile.program_application_id,
7035: program_id = arp_standard.profile.program_id,
7036: program_update_date = sysdate

Line 7034: program_application_id =arp_standard.profile.program_application_id,

7030: last_update_date = sysdate,
7031: last_updated_by = arp_standard.profile.user_id,
7032: last_update_login = arp_standard.profile.last_update_login,
7033: request_id = req_id,
7034: program_application_id =arp_standard.profile.program_application_id,
7035: program_id = arp_standard.profile.program_id,
7036: program_update_date = sysdate
7037: where ship_to_org_id in (select m.duplicate_site_id
7038: from ra_customer_merges m

Line 7035: program_id = arp_standard.profile.program_id,

7031: last_updated_by = arp_standard.profile.user_id,
7032: last_update_login = arp_standard.profile.last_update_login,
7033: request_id = req_id,
7034: program_application_id =arp_standard.profile.program_application_id,
7035: program_id = arp_standard.profile.program_id,
7036: program_update_date = sysdate
7037: where ship_to_org_id in (select m.duplicate_site_id
7038: from ra_customer_merges m
7039: where m.process_flag = 'N'

Line 7097: last_updated_by = arp_standard.profile.user_id,

7093: and m.request_id = req_id
7094: and m.process_flag = 'N'
7095: and m.set_number = set_num),
7096: last_update_date = sysdate,
7097: last_updated_by = arp_standard.profile.user_id,
7098: last_update_login = arp_standard.profile.last_update_login,
7099: request_id = req_id,
7100: program_application_id =arp_standard.profile.program_application_id,
7101: program_id = arp_standard.profile.program_id,

Line 7098: last_update_login = arp_standard.profile.last_update_login,

7094: and m.process_flag = 'N'
7095: and m.set_number = set_num),
7096: last_update_date = sysdate,
7097: last_updated_by = arp_standard.profile.user_id,
7098: last_update_login = arp_standard.profile.last_update_login,
7099: request_id = req_id,
7100: program_application_id =arp_standard.profile.program_application_id,
7101: program_id = arp_standard.profile.program_id,
7102: program_update_date = sysdate

Line 7100: program_application_id =arp_standard.profile.program_application_id,

7096: last_update_date = sysdate,
7097: last_updated_by = arp_standard.profile.user_id,
7098: last_update_login = arp_standard.profile.last_update_login,
7099: request_id = req_id,
7100: program_application_id =arp_standard.profile.program_application_id,
7101: program_id = arp_standard.profile.program_id,
7102: program_update_date = sysdate
7103: where invoice_to_org_id in (select m.duplicate_site_id
7104: from ra_customer_merges m

Line 7101: program_id = arp_standard.profile.program_id,

7097: last_updated_by = arp_standard.profile.user_id,
7098: last_update_login = arp_standard.profile.last_update_login,
7099: request_id = req_id,
7100: program_application_id =arp_standard.profile.program_application_id,
7101: program_id = arp_standard.profile.program_id,
7102: program_update_date = sysdate
7103: where invoice_to_org_id in (select m.duplicate_site_id
7104: from ra_customer_merges m
7105: where m.process_flag = 'N'

Line 7163: last_updated_by = arp_standard.profile.user_id,

7159: and m.request_id = req_id
7160: and m.process_flag = 'N'
7161: and m.set_number = set_num),
7162: last_update_date = sysdate,
7163: last_updated_by = arp_standard.profile.user_id,
7164: last_update_login = arp_standard.profile.last_update_login,
7165: request_id = req_id,
7166: program_application_id =arp_standard.profile.program_application_id,
7167: program_id = arp_standard.profile.program_id,

Line 7164: last_update_login = arp_standard.profile.last_update_login,

7160: and m.process_flag = 'N'
7161: and m.set_number = set_num),
7162: last_update_date = sysdate,
7163: last_updated_by = arp_standard.profile.user_id,
7164: last_update_login = arp_standard.profile.last_update_login,
7165: request_id = req_id,
7166: program_application_id =arp_standard.profile.program_application_id,
7167: program_id = arp_standard.profile.program_id,
7168: program_update_date = sysdate

Line 7166: program_application_id =arp_standard.profile.program_application_id,

7162: last_update_date = sysdate,
7163: last_updated_by = arp_standard.profile.user_id,
7164: last_update_login = arp_standard.profile.last_update_login,
7165: request_id = req_id,
7166: program_application_id =arp_standard.profile.program_application_id,
7167: program_id = arp_standard.profile.program_id,
7168: program_update_date = sysdate
7169: where deliver_to_org_id in (select m.duplicate_site_id
7170: from ra_customer_merges m

Line 7167: program_id = arp_standard.profile.program_id,

7163: last_updated_by = arp_standard.profile.user_id,
7164: last_update_login = arp_standard.profile.last_update_login,
7165: request_id = req_id,
7166: program_application_id =arp_standard.profile.program_application_id,
7167: program_id = arp_standard.profile.program_id,
7168: program_update_date = sysdate
7169: where deliver_to_org_id in (select m.duplicate_site_id
7170: from ra_customer_merges m
7171: where m.process_flag = 'N'

Line 7234: last_updated_by = arp_standard.profile.user_id,

7230: and m.process_flag = 'N'
7231: and m.request_id = req_id
7232: and m.set_number = set_num),
7233: last_update_date = sysdate,
7234: last_updated_by = arp_standard.profile.user_id,
7235: last_update_login = arp_standard.profile.last_update_login,
7236: request_id = req_id,
7237: program_application_id =arp_standard.profile.program_application_id,
7238: program_id = arp_standard.profile.program_id,

Line 7235: last_update_login = arp_standard.profile.last_update_login,

7231: and m.request_id = req_id
7232: and m.set_number = set_num),
7233: last_update_date = sysdate,
7234: last_updated_by = arp_standard.profile.user_id,
7235: last_update_login = arp_standard.profile.last_update_login,
7236: request_id = req_id,
7237: program_application_id =arp_standard.profile.program_application_id,
7238: program_id = arp_standard.profile.program_id,
7239: program_update_date = sysdate

Line 7237: program_application_id =arp_standard.profile.program_application_id,

7233: last_update_date = sysdate,
7234: last_updated_by = arp_standard.profile.user_id,
7235: last_update_login = arp_standard.profile.last_update_login,
7236: request_id = req_id,
7237: program_application_id =arp_standard.profile.program_application_id,
7238: program_id = arp_standard.profile.program_id,
7239: program_update_date = sysdate
7240: where sold_to_org_id in (select m.duplicate_id
7241: from ra_customer_merges m

Line 7238: program_id = arp_standard.profile.program_id,

7234: last_updated_by = arp_standard.profile.user_id,
7235: last_update_login = arp_standard.profile.last_update_login,
7236: request_id = req_id,
7237: program_application_id =arp_standard.profile.program_application_id,
7238: program_id = arp_standard.profile.program_id,
7239: program_update_date = sysdate
7240: where sold_to_org_id in (select m.duplicate_id
7241: from ra_customer_merges m
7242: where m.process_flag = 'N'

Line 7307: last_updated_by = arp_standard.profile.user_id,

7303: and m.process_flag = 'N'
7304: and m.request_id = req_id
7305: and m.set_number = set_num),
7306: last_update_date = sysdate,
7307: last_updated_by = arp_standard.profile.user_id,
7308: last_update_login = arp_standard.profile.last_update_login,
7309: request_id = req_id,
7310: program_application_id =arp_standard.profile.program_application_id,
7311: program_id = arp_standard.profile.program_id,

Line 7308: last_update_login = arp_standard.profile.last_update_login,

7304: and m.request_id = req_id
7305: and m.set_number = set_num),
7306: last_update_date = sysdate,
7307: last_updated_by = arp_standard.profile.user_id,
7308: last_update_login = arp_standard.profile.last_update_login,
7309: request_id = req_id,
7310: program_application_id =arp_standard.profile.program_application_id,
7311: program_id = arp_standard.profile.program_id,
7312: program_update_date = sysdate

Line 7310: program_application_id =arp_standard.profile.program_application_id,

7306: last_update_date = sysdate,
7307: last_updated_by = arp_standard.profile.user_id,
7308: last_update_login = arp_standard.profile.last_update_login,
7309: request_id = req_id,
7310: program_application_id =arp_standard.profile.program_application_id,
7311: program_id = arp_standard.profile.program_id,
7312: program_update_date = sysdate
7313: where sold_to_site_use_id in (select m.duplicate_id
7314: from ra_customer_merges m

Line 7311: program_id = arp_standard.profile.program_id,

7307: last_updated_by = arp_standard.profile.user_id,
7308: last_update_login = arp_standard.profile.last_update_login,
7309: request_id = req_id,
7310: program_application_id =arp_standard.profile.program_application_id,
7311: program_id = arp_standard.profile.program_id,
7312: program_update_date = sysdate
7313: where sold_to_site_use_id in (select m.duplicate_id
7314: from ra_customer_merges m
7315: where m.process_flag = 'N'

Line 7699: last_updated_by = arp_standard.profile.user_id,

7695: ship_to_org_id = decode(line_ship_to_org_id_tab(i),null,ship_to_org_id,line_ship_to_org_id_tab(i)),
7696: 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)),
7697: deliver_to_org_id = decode(line_deliver_to_org_id_tab(i),null,deliver_to_org_id,line_deliver_to_org_id_tab(i)),
7698: last_update_date = sysdate,
7699: last_updated_by = arp_standard.profile.user_id,
7700: last_update_login = arp_standard.profile.last_update_login,
7701: request_id = req_id,
7702: program_application_id = arp_standard.profile.program_application_id ,
7703: program_id = arp_standard.profile.program_id,

Line 7700: last_update_login = arp_standard.profile.last_update_login,

7696: 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)),
7697: deliver_to_org_id = decode(line_deliver_to_org_id_tab(i),null,deliver_to_org_id,line_deliver_to_org_id_tab(i)),
7698: last_update_date = sysdate,
7699: last_updated_by = arp_standard.profile.user_id,
7700: last_update_login = arp_standard.profile.last_update_login,
7701: request_id = req_id,
7702: program_application_id = arp_standard.profile.program_application_id ,
7703: program_id = arp_standard.profile.program_id,
7704: program_update_date = SYSDATE,

Line 7702: program_application_id = arp_standard.profile.program_application_id ,

7698: last_update_date = sysdate,
7699: last_updated_by = arp_standard.profile.user_id,
7700: last_update_login = arp_standard.profile.last_update_login,
7701: request_id = req_id,
7702: program_application_id = arp_standard.profile.program_application_id ,
7703: program_id = arp_standard.profile.program_id,
7704: program_update_date = SYSDATE,
7705: lock_control = lock_control+1
7706: WHERE line_id = line_line_id_tab(i);

Line 7703: program_id = arp_standard.profile.program_id,

7699: last_updated_by = arp_standard.profile.user_id,
7700: last_update_login = arp_standard.profile.last_update_login,
7701: request_id = req_id,
7702: program_application_id = arp_standard.profile.program_application_id ,
7703: program_id = arp_standard.profile.program_id,
7704: program_update_date = SYSDATE,
7705: lock_control = lock_control+1
7706: WHERE line_id = line_line_id_tab(i);
7707:

Line 8129: last_updated_by = arp_standard.profile.user_id,

8125: ship_to_org_id = decode(lhst_ship_to_org_id_tab(i),null,ship_to_org_id,lhst_ship_to_org_id_tab(i)),
8126: 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)),
8127: deliver_to_org_id = decode(lhst_deliver_to_org_id_tab(i),null,deliver_to_org_id,lhst_deliver_to_org_id_tab(i)),
8128: last_update_date = sysdate,
8129: last_updated_by = arp_standard.profile.user_id,
8130: last_update_login = arp_standard.profile.last_update_login,
8131: request_id = req_id,
8132: program_application_id = arp_standard.profile.program_application_id ,
8133: program_id = arp_standard.profile.program_id,

Line 8130: last_update_login = arp_standard.profile.last_update_login,

8126: 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)),
8127: deliver_to_org_id = decode(lhst_deliver_to_org_id_tab(i),null,deliver_to_org_id,lhst_deliver_to_org_id_tab(i)),
8128: last_update_date = sysdate,
8129: last_updated_by = arp_standard.profile.user_id,
8130: last_update_login = arp_standard.profile.last_update_login,
8131: request_id = req_id,
8132: program_application_id = arp_standard.profile.program_application_id ,
8133: program_id = arp_standard.profile.program_id,
8134: program_update_date = SYSDATE

Line 8132: program_application_id = arp_standard.profile.program_application_id ,

8128: last_update_date = sysdate,
8129: last_updated_by = arp_standard.profile.user_id,
8130: last_update_login = arp_standard.profile.last_update_login,
8131: request_id = req_id,
8132: program_application_id = arp_standard.profile.program_application_id ,
8133: program_id = arp_standard.profile.program_id,
8134: program_update_date = SYSDATE
8135: WHERE line_id = lhst_line_id_tab(i);
8136:

Line 8133: program_id = arp_standard.profile.program_id,

8129: last_updated_by = arp_standard.profile.user_id,
8130: last_update_login = arp_standard.profile.last_update_login,
8131: request_id = req_id,
8132: program_application_id = arp_standard.profile.program_application_id ,
8133: program_id = arp_standard.profile.program_id,
8134: program_update_date = SYSDATE
8135: WHERE line_id = lhst_line_id_tab(i);
8136:
8137: g_count := sql%rowcount;

Line 8292: last_updated_by = arp_standard.profile.user_id,

8288: and m.process_flag = 'N'
8289: and m.request_id = req_id
8290: and m.set_number = set_num),
8291: last_update_date = sysdate,
8292: last_updated_by = arp_standard.profile.user_id,
8293: last_update_login = arp_standard.profile.last_update_login,
8294: request_id = req_id,
8295: program_application_id =arp_standard.profile.program_application_id,
8296: program_id = arp_standard.profile.program_id,

Line 8293: last_update_login = arp_standard.profile.last_update_login,

8289: and m.request_id = req_id
8290: and m.set_number = set_num),
8291: last_update_date = sysdate,
8292: last_updated_by = arp_standard.profile.user_id,
8293: last_update_login = arp_standard.profile.last_update_login,
8294: request_id = req_id,
8295: program_application_id =arp_standard.profile.program_application_id,
8296: program_id = arp_standard.profile.program_id,
8297: program_update_date = sysdate

Line 8295: program_application_id =arp_standard.profile.program_application_id,

8291: last_update_date = sysdate,
8292: last_updated_by = arp_standard.profile.user_id,
8293: last_update_login = arp_standard.profile.last_update_login,
8294: request_id = req_id,
8295: program_application_id =arp_standard.profile.program_application_id,
8296: program_id = arp_standard.profile.program_id,
8297: program_update_date = sysdate
8298: where sold_to_org_id in (select m.duplicate_id
8299: from ra_customer_merges m

Line 8296: program_id = arp_standard.profile.program_id,

8292: last_updated_by = arp_standard.profile.user_id,
8293: last_update_login = arp_standard.profile.last_update_login,
8294: request_id = req_id,
8295: program_application_id =arp_standard.profile.program_application_id,
8296: program_id = arp_standard.profile.program_id,
8297: program_update_date = sysdate
8298: where sold_to_org_id in (select m.duplicate_id
8299: from ra_customer_merges m
8300: where m.process_flag = 'N'