eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_DOCUMENT_EXTRA_INFO_API dependencies on HR_DOCUMENT_EXTRA_INFO

Line 1: Package Body hr_document_extra_info_api as

1: Package Body hr_document_extra_info_api as
2: /* $Header: hrdeiapi.pkb 120.2.12010000.4 2010/06/07 11:01:19 tkghosh ship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' hr_document_extra_info_api.';

2: /* $Header: hrdeiapi.pkb 120.2.12010000.4 2010/06/07 11:01:19 tkghosh ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hr_document_extra_info_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |-------------------------< create_doc_extra_info >---------------------|
10: -- ----------------------------------------------------------------------------

Line 102: l_object_version_number hr_document_extra_info.object_version_number%type;

98: -- Declare cursors and local variables
99: --
100:
101: l_proc varchar2(72) := g_package||'create_doc_extra_info';
102: l_object_version_number hr_document_extra_info.object_version_number%type;
103: l_document_extra_info_id hr_document_extra_info.document_extra_info_id%type;
104: l_person_id hr_document_extra_info.person_id%type;
105: l_document_type varchar2(50);
106: l_document_type_id hr_document_extra_info.document_type_id%type;

Line 103: l_document_extra_info_id hr_document_extra_info.document_extra_info_id%type;

99: --
100:
101: l_proc varchar2(72) := g_package||'create_doc_extra_info';
102: l_object_version_number hr_document_extra_info.object_version_number%type;
103: l_document_extra_info_id hr_document_extra_info.document_extra_info_id%type;
104: l_person_id hr_document_extra_info.person_id%type;
105: l_document_type varchar2(50);
106: l_document_type_id hr_document_extra_info.document_type_id%type;
107: l_date_from hr_document_extra_info.date_from%type;

Line 104: l_person_id hr_document_extra_info.person_id%type;

100:
101: l_proc varchar2(72) := g_package||'create_doc_extra_info';
102: l_object_version_number hr_document_extra_info.object_version_number%type;
103: l_document_extra_info_id hr_document_extra_info.document_extra_info_id%type;
104: l_person_id hr_document_extra_info.person_id%type;
105: l_document_type varchar2(50);
106: l_document_type_id hr_document_extra_info.document_type_id%type;
107: l_date_from hr_document_extra_info.date_from%type;
108: l_date_to hr_document_extra_info.date_to%type;

Line 106: l_document_type_id hr_document_extra_info.document_type_id%type;

102: l_object_version_number hr_document_extra_info.object_version_number%type;
103: l_document_extra_info_id hr_document_extra_info.document_extra_info_id%type;
104: l_person_id hr_document_extra_info.person_id%type;
105: l_document_type varchar2(50);
106: l_document_type_id hr_document_extra_info.document_type_id%type;
107: l_date_from hr_document_extra_info.date_from%type;
108: l_date_to hr_document_extra_info.date_to%type;
109: l_mul_flag hr_document_types_v.multiple_occurences_flag%type;
110: l_num number;

Line 107: l_date_from hr_document_extra_info.date_from%type;

103: l_document_extra_info_id hr_document_extra_info.document_extra_info_id%type;
104: l_person_id hr_document_extra_info.person_id%type;
105: l_document_type varchar2(50);
106: l_document_type_id hr_document_extra_info.document_type_id%type;
107: l_date_from hr_document_extra_info.date_from%type;
108: l_date_to hr_document_extra_info.date_to%type;
109: l_mul_flag hr_document_types_v.multiple_occurences_flag%type;
110: l_num number;
111: l_authorization_required varchar2(10);

Line 108: l_date_to hr_document_extra_info.date_to%type;

104: l_person_id hr_document_extra_info.person_id%type;
105: l_document_type varchar2(50);
106: l_document_type_id hr_document_extra_info.document_type_id%type;
107: l_date_from hr_document_extra_info.date_from%type;
108: l_date_to hr_document_extra_info.date_to%type;
109: l_mul_flag hr_document_types_v.multiple_occurences_flag%type;
110: l_num number;
111: l_authorization_required varchar2(10);
112: l_verified_by number := p_verified_by;

Line 125: from hr_document_extra_info

121:
122: cursor csr_chk_combination(p_document_type_id number,p_person_id number,
123: p_date_from DATE,p_date_to DATE) is
124: select 'X'
125: from hr_document_extra_info
126: where document_type_id = p_document_type_id
127: and person_id = p_person_id
128: and date_from = p_date_from
129: and date_to = p_date_to;

Line 138: select count(*) from hr_document_extra_info

134: from HR_DOCUMENT_TYPES_V
135: where DOCUMENT_TYPE_ID = p_document_type_id;
136:
137: cursor csr_chk_doc_allowed(p_document_type_id number,p_person_id number) is
138: select count(*) from hr_document_extra_info
139: where document_type_id = p_document_type_id
140: and person_id = p_person_id;
141: --
142: begin

Line 153: hr_document_extra_info_bk1.create_doc_extra_info_b

149: -- Call Before Process User Hook
150: --
151: begin
152:
153: hr_document_extra_info_bk1.create_doc_extra_info_b
154: (p_person_id => p_person_id,
155: p_document_type_id => p_document_type_id,
156: p_date_from => p_date_from,
157: p_date_to => p_date_to,

Line 397: hr_document_extra_info_bk1.create_doc_extra_info_a

393: --
394: -- Call After Process User Hook
395: --
396: begin
397: hr_document_extra_info_bk1.create_doc_extra_info_a
398: (
399: p_document_extra_info_id => l_document_extra_info_id,
400: p_person_id => p_person_id,
401: p_document_type_id => p_document_type_id,

Line 626: l_object_version_number hr_document_extra_info.object_version_number%TYPE;

622: --
623: -- Declare cursors and local variables
624: --
625: l_proc varchar2(72) := g_package||'update_doc_extra_info';
626: l_object_version_number hr_document_extra_info.object_version_number%TYPE;
627: l_ovn hr_document_extra_info.object_version_number%TYPE := p_object_version_number;
628: l_authorization_required varchar2(10);
629: l_verified_by number := p_verified_by;
630: l_verified_date date := p_verified_date;

Line 627: l_ovn hr_document_extra_info.object_version_number%TYPE := p_object_version_number;

623: -- Declare cursors and local variables
624: --
625: l_proc varchar2(72) := g_package||'update_doc_extra_info';
626: l_object_version_number hr_document_extra_info.object_version_number%TYPE;
627: l_ovn hr_document_extra_info.object_version_number%TYPE := p_object_version_number;
628: l_authorization_required varchar2(10);
629: l_verified_by number := p_verified_by;
630: l_verified_date date := p_verified_date;
631: l_document_type varchar2(50);

Line 645: from hr_document_extra_info

641:
642: cursor csr_chk_combination(p_document_type_id number,p_person_id number,p_date_from DATE,
643: p_date_to DATE,p_document_extra_info_id number) is
644: select 'X'
645: from hr_document_extra_info
646: where document_type_id = p_document_type_id
647: and person_id = p_person_id
648: and date_from = p_date_from
649: and date_to = p_date_to

Line 660: select count(*) from hr_document_extra_info

656: where DOCUMENT_TYPE_ID = p_document_type_id;
657:
658: cursor csr_chk_doc_allowed(p_document_type_id number,p_person_id number,
659: p_document_extra_info_id number) is
660: select count(*) from hr_document_extra_info
661: where document_type_id = p_document_type_id
662: and person_id = p_person_id
663: and document_extra_info_id <> p_document_extra_info_id;
664: --

Line 675: hr_document_extra_info_bk2.update_doc_extra_info_b

671: --
672: -- Call Before Process User Hook
673: --
674: begin
675: hr_document_extra_info_bk2.update_doc_extra_info_b
676: (
677: p_document_extra_info_id => p_document_extra_info_id,
678: p_person_id => p_person_id,
679: p_document_type_id => p_document_type_id,

Line 924: hr_document_extra_info_bk2.update_doc_extra_info_a

920: --
921: -- Call After Process User Hook
922: --
923: begin
924: hr_document_extra_info_bk2.update_doc_extra_info_a
925: (
926: p_document_extra_info_id => p_document_extra_info_id,
927: p_person_id => p_person_id,
928: p_document_type_id => p_document_type_id,

Line 1082: hr_document_extra_info_bk3.delete_doc_extra_info_b

1078: --
1079: -- Call Before Process User Hook
1080: --
1081: begin
1082: hr_document_extra_info_bk3.delete_doc_extra_info_b
1083: (p_document_extra_info_id => p_document_extra_info_id,
1084: p_object_version_number => p_object_version_number
1085: );
1086: exception

Line 1110: hr_document_extra_info_bk3.delete_doc_extra_info_a

1106: --
1107: -- Call Before Process User Hook
1108: --
1109: begin
1110: hr_document_extra_info_bk3.delete_doc_extra_info_a
1111: (p_document_extra_info_id => p_document_extra_info_id,
1112: p_object_version_number => p_object_version_number
1113: );
1114: exception

Line 1213: WF_CORE.CONTEXT('HR_DOCUMENT_EXTRA_INFO_API'

1209: end if;
1210: --
1211: exception
1212: when others then
1213: WF_CORE.CONTEXT('HR_DOCUMENT_EXTRA_INFO_API'
1214: ,'SET_REVIEWER'
1215: ,itemtype
1216: ,itemkey
1217: ,to_char(actid)

Line 1256: WF_CORE.CONTEXT('HR_DOCUMENT_EXTRA_INFO_API'

1252: end if;
1253: --
1254: exception
1255: when others then
1256: WF_CORE.CONTEXT('HR_DOCUMENT_EXTRA_INFO_API'
1257: ,'SET_REVIEWEE'
1258: ,itemtype
1259: ,itemkey
1260: ,to_char(actid)

Line 1305: end hr_document_extra_info_api;

1301: END LOOP;
1302: --
1303: end get_view_pg_wf_notif_params;
1304:
1305: end hr_document_extra_info_api;