DBA Data[Home] [Help]

APPS.OE_FND_ATTACHMENTS_PUB dependencies on FND_GLOBAL

Line 32: l_user_id number:=fnd_global.USER_ID;

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;

Line 33: l_login_id number:=fnd_global.LOGIN_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;

Line 34: l_program_id number:=fnd_global.CONC_PROGRAM_ID;

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;

Line 35: l_program_application_id number:=fnd_global.PROG_APPL_ID;

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);

Line 36: l_request_id number:=fnd_global.CONC_REQUEST_ID;

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;

Line 402: l_user_id number:=fnd_global.USER_ID;

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;

Line 403: l_login_id number:=fnd_global.LOGIN_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;

Line 404: l_program_id number:=fnd_global.CONC_PROGRAM_ID;

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;

Line 405: l_program_application_id number:=fnd_global.PROG_APPL_ID;

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:

Line 406: l_request_id number:=fnd_global.CONC_REQUEST_ID;

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

Line 589: l_user_id number:=fnd_global.USER_ID;

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;

Line 590: l_login_id number:=fnd_global.LOGIN_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:

Line 591: l_program_id number:=fnd_global.CONC_PROGRAM_ID;

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: --

Line 592: l_program_application_id number:=fnd_global.PROG_APPL_ID;

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;

Line 593: l_request_id number:=fnd_global.CONC_REQUEST_ID;

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: --