188: ),
189: inactive_flag = 'Y',
190: cum_note_text = l_cumNotesTab(i),
191: last_update_date = SYSDATE,
192: last_updated_by = arp_standard.profile.user_id,
193: last_update_login = arp_standard.profile.last_update_login,
194: request_id = req_id,
195: program_application_id = arp_standard.profile.program_application_id,
196: program_id = arp_standard.profile.program_id,
189: inactive_flag = 'Y',
190: cum_note_text = l_cumNotesTab(i),
191: last_update_date = SYSDATE,
192: last_updated_by = arp_standard.profile.user_id,
193: last_update_login = arp_standard.profile.last_update_login,
194: request_id = req_id,
195: program_application_id = arp_standard.profile.program_application_id,
196: program_id = arp_standard.profile.program_id,
197: program_update_date = SYSDATE
191: last_update_date = SYSDATE,
192: last_updated_by = arp_standard.profile.user_id,
193: last_update_login = arp_standard.profile.last_update_login,
194: request_id = req_id,
195: program_application_id = arp_standard.profile.program_application_id,
196: program_id = arp_standard.profile.program_id,
197: program_update_date = SYSDATE
198: WHERE cum_key_id = l_cumKeyIdTab(i);
199: --
192: last_updated_by = arp_standard.profile.user_id,
193: last_update_login = arp_standard.profile.last_update_login,
194: request_id = req_id,
195: program_application_id = arp_standard.profile.program_application_id,
196: program_id = arp_standard.profile.program_id,
197: program_update_date = SYSDATE
198: WHERE cum_key_id = l_cumKeyIdTab(i);
199: --
200: setARMessageRowCount( SQL%ROWCOUNT );
332: ece_primary_address_id
333: ),
334: header_note_text = l_headerNotesTab(i),
335: last_update_date = SYSDATE,
336: last_updated_by = arp_standard.profile.user_id,
337: last_update_login = arp_standard.profile.last_update_login,
338: request_id = req_id,
339: program_application_id = arp_standard.profile.program_application_id,
340: program_id = arp_standard.profile.program_id,
333: ),
334: header_note_text = l_headerNotesTab(i),
335: last_update_date = SYSDATE,
336: last_updated_by = arp_standard.profile.user_id,
337: last_update_login = arp_standard.profile.last_update_login,
338: request_id = req_id,
339: program_application_id = arp_standard.profile.program_application_id,
340: program_id = arp_standard.profile.program_id,
341: program_update_date = SYSDATE
335: last_update_date = SYSDATE,
336: last_updated_by = arp_standard.profile.user_id,
337: last_update_login = arp_standard.profile.last_update_login,
338: request_id = req_id,
339: program_application_id = arp_standard.profile.program_application_id,
340: program_id = arp_standard.profile.program_id,
341: program_update_date = SYSDATE
342: WHERE header_id = l_headerIdTab(i);
343: --
336: last_updated_by = arp_standard.profile.user_id,
337: last_update_login = arp_standard.profile.last_update_login,
338: request_id = req_id,
339: program_application_id = arp_standard.profile.program_application_id,
340: program_id = arp_standard.profile.program_id,
341: program_update_date = SYSDATE
342: WHERE header_id = l_headerIdTab(i);
343: --
344: setARMessageRowCount( SQL%ROWCOUNT );
500: ship_to_org_id
501: ),
502: item_note_text = l_lineNotesTab(i),
503: last_update_date = SYSDATE,
504: last_updated_by = arp_standard.profile.user_id,
505: last_update_login = arp_standard.profile.last_update_login,
506: request_id = req_id,
507: program_application_id= arp_standard.profile.program_application_id,
508: program_id = arp_standard.profile.program_id,
501: ),
502: item_note_text = l_lineNotesTab(i),
503: last_update_date = SYSDATE,
504: last_updated_by = arp_standard.profile.user_id,
505: last_update_login = arp_standard.profile.last_update_login,
506: request_id = req_id,
507: program_application_id= arp_standard.profile.program_application_id,
508: program_id = arp_standard.profile.program_id,
509: program_update_date = SYSDATE
503: last_update_date = SYSDATE,
504: last_updated_by = arp_standard.profile.user_id,
505: last_update_login = arp_standard.profile.last_update_login,
506: request_id = req_id,
507: program_application_id= arp_standard.profile.program_application_id,
508: program_id = arp_standard.profile.program_id,
509: program_update_date = SYSDATE
510: WHERE line_id = l_lineIdTab(i);
511: --
504: last_updated_by = arp_standard.profile.user_id,
505: last_update_login = arp_standard.profile.last_update_login,
506: request_id = req_id,
507: program_application_id= arp_standard.profile.program_application_id,
508: program_id = arp_standard.profile.program_id,
509: program_update_date = SYSDATE
510: WHERE line_id = l_lineIdTab(i);
511: --
512: setARMessageRowCount( SQL%ROWCOUNT );
639: ece_primary_address_id
640: ),
641: header_note_text = l_headerNotesTab(i),
642: last_update_date = SYSDATE,
643: last_updated_by = arp_standard.profile.user_id,
644: last_update_login = arp_standard.profile.last_update_login,
645: request_id = req_id,
646: program_application_id= arp_standard.profile.program_application_id,
647: program_id = arp_standard.profile.program_id,
640: ),
641: header_note_text = l_headerNotesTab(i),
642: last_update_date = SYSDATE,
643: last_updated_by = arp_standard.profile.user_id,
644: last_update_login = arp_standard.profile.last_update_login,
645: request_id = req_id,
646: program_application_id= arp_standard.profile.program_application_id,
647: program_id = arp_standard.profile.program_id,
648: program_update_date = SYSDATE
642: last_update_date = SYSDATE,
643: last_updated_by = arp_standard.profile.user_id,
644: last_update_login = arp_standard.profile.last_update_login,
645: request_id = req_id,
646: program_application_id= arp_standard.profile.program_application_id,
647: program_id = arp_standard.profile.program_id,
648: program_update_date = SYSDATE
649: WHERE header_id = l_headerIdTab(i);
650: --
643: last_updated_by = arp_standard.profile.user_id,
644: last_update_login = arp_standard.profile.last_update_login,
645: request_id = req_id,
646: program_application_id= arp_standard.profile.program_application_id,
647: program_id = arp_standard.profile.program_id,
648: program_update_date = SYSDATE
649: WHERE header_id = l_headerIdTab(i);
650: --
651: setARMessageRowCount( SQL%ROWCOUNT );
807: ship_to_org_id
808: ),
809: item_note_text = l_lineNotesTab(i),
810: last_update_date = SYSDATE,
811: last_updated_by = arp_standard.profile.user_id,
812: last_update_login = arp_standard.profile.last_update_login,
813: request_id = req_id,
814: program_application_id= arp_standard.profile.program_application_id,
815: program_id = arp_standard.profile.program_id,
808: ),
809: item_note_text = l_lineNotesTab(i),
810: last_update_date = SYSDATE,
811: last_updated_by = arp_standard.profile.user_id,
812: last_update_login = arp_standard.profile.last_update_login,
813: request_id = req_id,
814: program_application_id= arp_standard.profile.program_application_id,
815: program_id = arp_standard.profile.program_id,
816: program_update_date = SYSDATE
810: last_update_date = SYSDATE,
811: last_updated_by = arp_standard.profile.user_id,
812: last_update_login = arp_standard.profile.last_update_login,
813: request_id = req_id,
814: program_application_id= arp_standard.profile.program_application_id,
815: program_id = arp_standard.profile.program_id,
816: program_update_date = SYSDATE
817: WHERE line_id = l_lineIdTab(i);
818: --
811: last_updated_by = arp_standard.profile.user_id,
812: last_update_login = arp_standard.profile.last_update_login,
813: request_id = req_id,
814: program_application_id= arp_standard.profile.program_application_id,
815: program_id = arp_standard.profile.program_id,
816: program_update_date = SYSDATE
817: WHERE line_id = l_lineIdTab(i);
818: --
819: setARMessageRowCount( SQL%ROWCOUNT );