201: p_lci_table(i).taxation_country, /* 18 */
202: p_lci_table(i).document_sub_type, /* 19 */
203: p_lci_table(i).ship_header_id, /* 20 */
204: p_lci_table(i).last_task_code, /* 21 */
205: fnd_global.user_id, /* 22 */
206: SYSDATE, /* 23 */
207: fnd_global.user_id, /* 24 */
208: SYSDATE, /* 25 */
209: fnd_global.login_id, /* 26 */
203: p_lci_table(i).ship_header_id, /* 20 */
204: p_lci_table(i).last_task_code, /* 21 */
205: fnd_global.user_id, /* 22 */
206: SYSDATE, /* 23 */
207: fnd_global.user_id, /* 24 */
208: SYSDATE, /* 25 */
209: fnd_global.login_id, /* 26 */
210: fnd_global.conc_request_id, /* 27 */
211: fnd_global.conc_program_id, /* 28 */
205: fnd_global.user_id, /* 22 */
206: SYSDATE, /* 23 */
207: fnd_global.user_id, /* 24 */
208: SYSDATE, /* 25 */
209: fnd_global.login_id, /* 26 */
210: fnd_global.conc_request_id, /* 27 */
211: fnd_global.conc_program_id, /* 28 */
212: fnd_global.prog_appl_id, /* 29 */
213: decode(fnd_global.conc_request_id, -1, NULL, SYSDATE) /* 30 */
206: SYSDATE, /* 23 */
207: fnd_global.user_id, /* 24 */
208: SYSDATE, /* 25 */
209: fnd_global.login_id, /* 26 */
210: fnd_global.conc_request_id, /* 27 */
211: fnd_global.conc_program_id, /* 28 */
212: fnd_global.prog_appl_id, /* 29 */
213: decode(fnd_global.conc_request_id, -1, NULL, SYSDATE) /* 30 */
214: );
207: fnd_global.user_id, /* 24 */
208: SYSDATE, /* 25 */
209: fnd_global.login_id, /* 26 */
210: fnd_global.conc_request_id, /* 27 */
211: fnd_global.conc_program_id, /* 28 */
212: fnd_global.prog_appl_id, /* 29 */
213: decode(fnd_global.conc_request_id, -1, NULL, SYSDATE) /* 30 */
214: );
215:
208: SYSDATE, /* 25 */
209: fnd_global.login_id, /* 26 */
210: fnd_global.conc_request_id, /* 27 */
211: fnd_global.conc_program_id, /* 28 */
212: fnd_global.prog_appl_id, /* 29 */
213: decode(fnd_global.conc_request_id, -1, NULL, SYSDATE) /* 30 */
214: );
215:
216: l_current_shipment_header_id := p_lci_table(i).hdr_interface_source_line_id; -- Bug #9232742
209: fnd_global.login_id, /* 26 */
210: fnd_global.conc_request_id, /* 27 */
211: fnd_global.conc_program_id, /* 28 */
212: fnd_global.prog_appl_id, /* 29 */
213: decode(fnd_global.conc_request_id, -1, NULL, SYSDATE) /* 30 */
214: );
215:
216: l_current_shipment_header_id := p_lci_table(i).hdr_interface_source_line_id; -- Bug #9232742
217: l_current_organization_id:= p_lci_table(i).organization_id;
372: p_lci_table(i).ship_header_id, /* 64 */
373: p_lci_table(i).ship_line_id, /* 65 */
374: p_lci_table(i).line_interface_source_table, /* 66 */
375: p_lci_table(i).line_interface_source_line_id, /* 67 */
376: fnd_global.user_id, /* 68 */
377: SYSDATE, /* 69 */
378: fnd_global.user_id, /* 70 */
379: SYSDATE, /* 71 */
380: fnd_global.login_id, /* 72 */
374: p_lci_table(i).line_interface_source_table, /* 66 */
375: p_lci_table(i).line_interface_source_line_id, /* 67 */
376: fnd_global.user_id, /* 68 */
377: SYSDATE, /* 69 */
378: fnd_global.user_id, /* 70 */
379: SYSDATE, /* 71 */
380: fnd_global.login_id, /* 72 */
381: fnd_global.conc_request_id, /* 73 */
382: fnd_global.conc_program_id, /* 74 */
376: fnd_global.user_id, /* 68 */
377: SYSDATE, /* 69 */
378: fnd_global.user_id, /* 70 */
379: SYSDATE, /* 71 */
380: fnd_global.login_id, /* 72 */
381: fnd_global.conc_request_id, /* 73 */
382: fnd_global.conc_program_id, /* 74 */
383: fnd_global.prog_appl_id, /* 75 */
384: decode(fnd_global.conc_request_id, -1, NULL, SYSDATE) /* 76 */
377: SYSDATE, /* 69 */
378: fnd_global.user_id, /* 70 */
379: SYSDATE, /* 71 */
380: fnd_global.login_id, /* 72 */
381: fnd_global.conc_request_id, /* 73 */
382: fnd_global.conc_program_id, /* 74 */
383: fnd_global.prog_appl_id, /* 75 */
384: decode(fnd_global.conc_request_id, -1, NULL, SYSDATE) /* 76 */
385: );
378: fnd_global.user_id, /* 70 */
379: SYSDATE, /* 71 */
380: fnd_global.login_id, /* 72 */
381: fnd_global.conc_request_id, /* 73 */
382: fnd_global.conc_program_id, /* 74 */
383: fnd_global.prog_appl_id, /* 75 */
384: decode(fnd_global.conc_request_id, -1, NULL, SYSDATE) /* 76 */
385: );
386: END IF;
379: SYSDATE, /* 71 */
380: fnd_global.login_id, /* 72 */
381: fnd_global.conc_request_id, /* 73 */
382: fnd_global.conc_program_id, /* 74 */
383: fnd_global.prog_appl_id, /* 75 */
384: decode(fnd_global.conc_request_id, -1, NULL, SYSDATE) /* 76 */
385: );
386: END IF;
387: END LOOP;
380: fnd_global.login_id, /* 72 */
381: fnd_global.conc_request_id, /* 73 */
382: fnd_global.conc_program_id, /* 74 */
383: fnd_global.prog_appl_id, /* 75 */
384: decode(fnd_global.conc_request_id, -1, NULL, SYSDATE) /* 76 */
385: );
386: END IF;
387: END LOOP;
388: END; -- End of API Body
2554: 1, --process_status (1 = Pending) /* 08 */
2555: 1, --process_phase (1 = Pending) /* 09 */
2556: NULL, -- group_id /* 10 */
2557: l_current_date, -- creation_date /* 11 */
2558: FND_GLOBAL.user_id, -- created_by /* 12 */
2559: l_current_date, -- last_update_date /* 13 */
2560: FND_GLOBAL.user_id, --last_updated_by /* 14 */
2561: FND_GLOBAL.login_id, --last_update_login /* 15 */
2562: NULL, --request_id, /* 16 */
2556: NULL, -- group_id /* 10 */
2557: l_current_date, -- creation_date /* 11 */
2558: FND_GLOBAL.user_id, -- created_by /* 12 */
2559: l_current_date, -- last_update_date /* 13 */
2560: FND_GLOBAL.user_id, --last_updated_by /* 14 */
2561: FND_GLOBAL.login_id, --last_update_login /* 15 */
2562: NULL, --request_id, /* 16 */
2563: NULL, --program_application_id, /* 17 */
2564: NULL, --program_id, /* 18 */
2557: l_current_date, -- creation_date /* 11 */
2558: FND_GLOBAL.user_id, -- created_by /* 12 */
2559: l_current_date, -- last_update_date /* 13 */
2560: FND_GLOBAL.user_id, --last_updated_by /* 14 */
2561: FND_GLOBAL.login_id, --last_update_login /* 15 */
2562: NULL, --request_id, /* 16 */
2563: NULL, --program_application_id, /* 17 */
2564: NULL, --program_id, /* 18 */
2565: NULL --program_update_date /* 19 */