28: IS
29: l_api_version CONSTANT NUMBER := 1.0;
30: l_api_name CONSTANT VARCHAR2(30):= 'Add_Attachment';
31:
32: l_user_id number:=fnd_global.USER_ID;
33: l_login_id number:=fnd_global.LOGIN_ID;
34: l_program_id number:=fnd_global.CONC_PROGRAM_ID;
35: l_program_application_id number:=fnd_global.PROG_APPL_ID;
36: l_request_id number:=fnd_global.CONC_REQUEST_ID;
29: l_api_version CONSTANT NUMBER := 1.0;
30: l_api_name CONSTANT VARCHAR2(30):= 'Add_Attachment';
31:
32: l_user_id number:=fnd_global.USER_ID;
33: l_login_id number:=fnd_global.LOGIN_ID;
34: l_program_id number:=fnd_global.CONC_PROGRAM_ID;
35: l_program_application_id number:=fnd_global.PROG_APPL_ID;
36: l_request_id number:=fnd_global.CONC_REQUEST_ID;
37: l_curr_date date :=sysdate;
30: l_api_name CONSTANT VARCHAR2(30):= 'Add_Attachment';
31:
32: l_user_id number:=fnd_global.USER_ID;
33: l_login_id number:=fnd_global.LOGIN_ID;
34: l_program_id number:=fnd_global.CONC_PROGRAM_ID;
35: l_program_application_id number:=fnd_global.PROG_APPL_ID;
36: l_request_id number:=fnd_global.CONC_REQUEST_ID;
37: l_curr_date date :=sysdate;
38: l_program_update_date date :=null;
31:
32: l_user_id number:=fnd_global.USER_ID;
33: l_login_id number:=fnd_global.LOGIN_ID;
34: l_program_id number:=fnd_global.CONC_PROGRAM_ID;
35: l_program_application_id number:=fnd_global.PROG_APPL_ID;
36: l_request_id number:=fnd_global.CONC_REQUEST_ID;
37: l_curr_date date :=sysdate;
38: l_program_update_date date :=null;
39: l_dummy varchar(1);
32: l_user_id number:=fnd_global.USER_ID;
33: l_login_id number:=fnd_global.LOGIN_ID;
34: l_program_id number:=fnd_global.CONC_PROGRAM_ID;
35: l_program_application_id number:=fnd_global.PROG_APPL_ID;
36: l_request_id number:=fnd_global.CONC_REQUEST_ID;
37: l_curr_date date :=sysdate;
38: l_program_update_date date :=null;
39: l_dummy varchar(1);
40: l_attachment_id number;
398: l_language varchar2(30);
399: l_dummy varchar2(5);
400: l_document_id number;
401:
402: l_user_id number:=fnd_global.USER_ID;
403: l_login_id number:=fnd_global.LOGIN_ID;
404: l_program_id number:=fnd_global.CONC_PROGRAM_ID;
405: l_program_application_id number:=fnd_global.PROG_APPL_ID;
406: l_request_id number:=fnd_global.CONC_REQUEST_ID;
399: l_dummy varchar2(5);
400: l_document_id number;
401:
402: l_user_id number:=fnd_global.USER_ID;
403: l_login_id number:=fnd_global.LOGIN_ID;
404: l_program_id number:=fnd_global.CONC_PROGRAM_ID;
405: l_program_application_id number:=fnd_global.PROG_APPL_ID;
406: l_request_id number:=fnd_global.CONC_REQUEST_ID;
407: l_curr_date date :=sysdate;
400: l_document_id number;
401:
402: l_user_id number:=fnd_global.USER_ID;
403: l_login_id number:=fnd_global.LOGIN_ID;
404: l_program_id number:=fnd_global.CONC_PROGRAM_ID;
405: l_program_application_id number:=fnd_global.PROG_APPL_ID;
406: l_request_id number:=fnd_global.CONC_REQUEST_ID;
407: l_curr_date date :=sysdate;
408: l_program_update_date date :=null;
401:
402: l_user_id number:=fnd_global.USER_ID;
403: l_login_id number:=fnd_global.LOGIN_ID;
404: l_program_id number:=fnd_global.CONC_PROGRAM_ID;
405: l_program_application_id number:=fnd_global.PROG_APPL_ID;
406: l_request_id number:=fnd_global.CONC_REQUEST_ID;
407: l_curr_date date :=sysdate;
408: l_program_update_date date :=null;
409:
402: l_user_id number:=fnd_global.USER_ID;
403: l_login_id number:=fnd_global.LOGIN_ID;
404: l_program_id number:=fnd_global.CONC_PROGRAM_ID;
405: l_program_application_id number:=fnd_global.PROG_APPL_ID;
406: l_request_id number:=fnd_global.CONC_REQUEST_ID;
407: l_curr_date date :=sysdate;
408: l_program_update_date date :=null;
409:
410: CURSOR C_CATEGORY
585: p_api_version in number,
586: p_copy_attachments_tbl in Copy_Attachments_Tbl_Type
587: )
588: IS
589: l_user_id number:=fnd_global.USER_ID;
590: l_login_id number:=fnd_global.LOGIN_ID;
591: l_program_id number:=fnd_global.CONC_PROGRAM_ID;
592: l_program_application_id number:=fnd_global.PROG_APPL_ID;
593: l_request_id number:=fnd_global.CONC_REQUEST_ID;
586: p_copy_attachments_tbl in Copy_Attachments_Tbl_Type
587: )
588: IS
589: l_user_id number:=fnd_global.USER_ID;
590: l_login_id number:=fnd_global.LOGIN_ID;
591: l_program_id number:=fnd_global.CONC_PROGRAM_ID;
592: l_program_application_id number:=fnd_global.PROG_APPL_ID;
593: l_request_id number:=fnd_global.CONC_REQUEST_ID;
594:
587: )
588: IS
589: l_user_id number:=fnd_global.USER_ID;
590: l_login_id number:=fnd_global.LOGIN_ID;
591: l_program_id number:=fnd_global.CONC_PROGRAM_ID;
592: l_program_application_id number:=fnd_global.PROG_APPL_ID;
593: l_request_id number:=fnd_global.CONC_REQUEST_ID;
594:
595: --
588: IS
589: l_user_id number:=fnd_global.USER_ID;
590: l_login_id number:=fnd_global.LOGIN_ID;
591: l_program_id number:=fnd_global.CONC_PROGRAM_ID;
592: l_program_application_id number:=fnd_global.PROG_APPL_ID;
593: l_request_id number:=fnd_global.CONC_REQUEST_ID;
594:
595: --
596: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
589: l_user_id number:=fnd_global.USER_ID;
590: l_login_id number:=fnd_global.LOGIN_ID;
591: l_program_id number:=fnd_global.CONC_PROGRAM_ID;
592: l_program_application_id number:=fnd_global.PROG_APPL_ID;
593: l_request_id number:=fnd_global.CONC_REQUEST_ID;
594:
595: --
596: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
597: --