169: fnd_attached_documents_pkg.insert_row(X_Rowid => x_row_id,
170: X_attached_document_id => x_attached_document_id,
171: X_document_id => X_document_id,
172: X_creation_date => SYSDATE,
173: X_created_by => Fnd_Global.User_Id,
174: X_last_update_date => SYSDATE,
175: X_last_updated_by => Fnd_Global.User_Id,
176: X_last_update_login => Fnd_Global.Login_Id,
177: X_seq_num => l_seq_num,
171: X_document_id => X_document_id,
172: X_creation_date => SYSDATE,
173: X_created_by => Fnd_Global.User_Id,
174: X_last_update_date => SYSDATE,
175: X_last_updated_by => Fnd_Global.User_Id,
176: X_last_update_login => Fnd_Global.Login_Id,
177: X_seq_num => l_seq_num,
178: X_entity_name => l_entity_name,
179: X_column1 => NULL,
172: X_creation_date => SYSDATE,
173: X_created_by => Fnd_Global.User_Id,
174: X_last_update_date => SYSDATE,
175: X_last_updated_by => Fnd_Global.User_Id,
176: X_last_update_login => Fnd_Global.Login_Id,
177: X_seq_num => l_seq_num,
178: X_entity_name => l_entity_name,
179: X_column1 => NULL,
180: X_pk1_value => l_attachment_pk1,
226: SYSDATE,
227: l_lookup_code,
228: NULL,
229: SYSDATE,
230: Fnd_Global.User_Id,
231: SYSDATE,
232: Fnd_Global.User_Id,
233: Fnd_Global.Login_Id
234: );
228: NULL,
229: SYSDATE,
230: Fnd_Global.User_Id,
231: SYSDATE,
232: Fnd_Global.User_Id,
233: Fnd_Global.Login_Id
234: );
235:
236:
229: SYSDATE,
230: Fnd_Global.User_Id,
231: SYSDATE,
232: Fnd_Global.User_Id,
233: Fnd_Global.Login_Id
234: );
235:
236:
237:
265: SYSDATE,
266: l_lookup_code,
267: 'URL Not Found',
268: SYSDATE,
269: Fnd_Global.User_Id,
270: SYSDATE,
271: Fnd_Global.User_Id,
272: Fnd_Global.Login_Id
273: );
267: 'URL Not Found',
268: SYSDATE,
269: Fnd_Global.User_Id,
270: SYSDATE,
271: Fnd_Global.User_Id,
272: Fnd_Global.Login_Id
273: );
274:
275:
268: SYSDATE,
269: Fnd_Global.User_Id,
270: SYSDATE,
271: Fnd_Global.User_Id,
272: Fnd_Global.Login_Id
273: );
274:
275:
276:
373: fnd_attached_documents_pkg.insert_row(X_Rowid => x_row_id,
374: X_attached_document_id => x_attached_document_id,
375: X_document_id => X_document_id,
376: X_creation_date => SYSDATE,
377: X_created_by => Fnd_Global.User_Id,
378: X_last_update_date => SYSDATE,
379: X_last_updated_by => Fnd_Global.User_Id,
380: X_last_update_login => Fnd_Global.Login_Id,
381: X_seq_num => l_seq_num,
375: X_document_id => X_document_id,
376: X_creation_date => SYSDATE,
377: X_created_by => Fnd_Global.User_Id,
378: X_last_update_date => SYSDATE,
379: X_last_updated_by => Fnd_Global.User_Id,
380: X_last_update_login => Fnd_Global.Login_Id,
381: X_seq_num => l_seq_num,
382: X_entity_name => l_entity_name,
383: X_column1 => NULL,
376: X_creation_date => SYSDATE,
377: X_created_by => Fnd_Global.User_Id,
378: X_last_update_date => SYSDATE,
379: X_last_updated_by => Fnd_Global.User_Id,
380: X_last_update_login => Fnd_Global.Login_Id,
381: X_seq_num => l_seq_num,
382: X_entity_name => l_entity_name,
383: X_column1 => NULL,
384: X_pk1_value => l_attachment_pk1,
418: X_to_pk2_value => c.pk2_value,
419: X_to_pk3_value => c.pk3_value,
420: X_to_pk4_value => c.pk4_value,
421: X_to_pk5_value => c.pk5_value,
422: X_created_by => Fnd_Global.User_Id,
423: X_last_update_login => Fnd_Global.Login_Id,
424: X_program_application_id => c.PROGRAM_APPLICATION_ID,
425: X_program_id => c.PROGRAM_ID,
426: X_request_id => c.REQUEST_ID,
419: X_to_pk3_value => c.pk3_value,
420: X_to_pk4_value => c.pk4_value,
421: X_to_pk5_value => c.pk5_value,
422: X_created_by => Fnd_Global.User_Id,
423: X_last_update_login => Fnd_Global.Login_Id,
424: X_program_application_id => c.PROGRAM_APPLICATION_ID,
425: X_program_id => c.PROGRAM_ID,
426: X_request_id => c.REQUEST_ID,
427: X_automatically_added_flag => c.AUTOMATICALLY_ADDED_FLAG,
474: SYSDATE,
475: l_lookup_code,
476: NULL,
477: SYSDATE,
478: Fnd_Global.User_Id,
479: SYSDATE,
480: Fnd_Global.User_Id,
481: Fnd_Global.Login_Id
482: );
476: NULL,
477: SYSDATE,
478: Fnd_Global.User_Id,
479: SYSDATE,
480: Fnd_Global.User_Id,
481: Fnd_Global.Login_Id
482: );
483:
484: ELSE
477: SYSDATE,
478: Fnd_Global.User_Id,
479: SYSDATE,
480: Fnd_Global.User_Id,
481: Fnd_Global.Login_Id
482: );
483:
484: ELSE
485:
511: SYSDATE,
512: l_lookup_code,
513: 'URL Not Found',
514: SYSDATE,
515: Fnd_Global.User_Id,
516: SYSDATE,
517: Fnd_Global.User_Id,
518: Fnd_Global.Login_Id
519: );
513: 'URL Not Found',
514: SYSDATE,
515: Fnd_Global.User_Id,
516: SYSDATE,
517: Fnd_Global.User_Id,
518: Fnd_Global.Login_Id
519: );
520:
521:
514: SYSDATE,
515: Fnd_Global.User_Id,
516: SYSDATE,
517: Fnd_Global.User_Id,
518: Fnd_Global.Login_Id
519: );
520:
521:
522: END IF;
662: null,
663: null,
664: NULL,
665: SYSDATE,
666: Fnd_Global.User_Id,
667: SYSDATE,
668: Fnd_Global.User_Id,
669: Fnd_Global.Login_Id
670: );
664: NULL,
665: SYSDATE,
666: Fnd_Global.User_Id,
667: SYSDATE,
668: Fnd_Global.User_Id,
669: Fnd_Global.Login_Id
670: );
671:
672:
665: SYSDATE,
666: Fnd_Global.User_Id,
667: SYSDATE,
668: Fnd_Global.User_Id,
669: Fnd_Global.Login_Id
670: );
671:
672:
673: