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.EGO_IMPORT_PVT dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 16: G_CONF_XREF CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CC';

12: G_IMPORTED_PROC_STATUS CONSTANT FLAG := 'I';
13:
14: G_PDH_SOURCE_SYSTEM_ID CONSTANT NUMBER := 7;
15:
16: G_CONF_XREF CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CC';
17: G_CONF_XREF_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CCR';
18: G_CONF_XREF_NOT_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CCN';
19: G_CONF_XREF_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CFC';
20:

Line 17: G_CONF_XREF_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CCR';

13:
14: G_PDH_SOURCE_SYSTEM_ID CONSTANT NUMBER := 7;
15:
16: G_CONF_XREF CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CC';
17: G_CONF_XREF_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CCR';
18: G_CONF_XREF_NOT_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CCN';
19: G_CONF_XREF_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CFC';
20:
21: G_CONF_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CM';

Line 18: G_CONF_XREF_NOT_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CCN';

14: G_PDH_SOURCE_SYSTEM_ID CONSTANT NUMBER := 7;
15:
16: G_CONF_XREF CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CC';
17: G_CONF_XREF_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CCR';
18: G_CONF_XREF_NOT_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CCN';
19: G_CONF_XREF_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CFC';
20:
21: G_CONF_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CM';
22: G_CONF_MATCH_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CMR';

Line 19: G_CONF_XREF_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CFC';

15:
16: G_CONF_XREF CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CC';
17: G_CONF_XREF_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CCR';
18: G_CONF_XREF_NOT_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CCN';
19: G_CONF_XREF_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CFC';
20:
21: G_CONF_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CM';
22: G_CONF_MATCH_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CMR';
23: G_CONF_MATCH_NOT_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CMN';

Line 21: G_CONF_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CM';

17: G_CONF_XREF_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CCR';
18: G_CONF_XREF_NOT_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CCN';
19: G_CONF_XREF_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CFC';
20:
21: G_CONF_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CM';
22: G_CONF_MATCH_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CMR';
23: G_CONF_MATCH_NOT_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CMN';
24: G_CONF_MATCH_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CFM';
25: G_FAKE_MATCH_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'FMR';

Line 22: G_CONF_MATCH_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CMR';

18: G_CONF_XREF_NOT_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CCN';
19: G_CONF_XREF_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CFC';
20:
21: G_CONF_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CM';
22: G_CONF_MATCH_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CMR';
23: G_CONF_MATCH_NOT_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CMN';
24: G_CONF_MATCH_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CFM';
25: G_FAKE_MATCH_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'FMR';
26:

Line 23: G_CONF_MATCH_NOT_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CMN';

19: G_CONF_XREF_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CFC';
20:
21: G_CONF_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CM';
22: G_CONF_MATCH_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CMR';
23: G_CONF_MATCH_NOT_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CMN';
24: G_CONF_MATCH_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CFM';
25: G_FAKE_MATCH_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'FMR';
26:
27: G_CONF_NEW CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CN';

Line 24: G_CONF_MATCH_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CFM';

20:
21: G_CONF_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CM';
22: G_CONF_MATCH_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CMR';
23: G_CONF_MATCH_NOT_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CMN';
24: G_CONF_MATCH_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CFM';
25: G_FAKE_MATCH_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'FMR';
26:
27: G_CONF_NEW CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CN';
28: G_CONF_NEW_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CNR';

Line 25: G_FAKE_MATCH_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'FMR';

21: G_CONF_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CM';
22: G_CONF_MATCH_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CMR';
23: G_CONF_MATCH_NOT_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CMN';
24: G_CONF_MATCH_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CFM';
25: G_FAKE_MATCH_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'FMR';
26:
27: G_CONF_NEW CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CN';
28: G_CONF_NEW_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CNR';
29: G_CONF_NEW_NOT_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CNN';

Line 27: G_CONF_NEW CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CN';

23: G_CONF_MATCH_NOT_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CMN';
24: G_CONF_MATCH_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CFM';
25: G_FAKE_MATCH_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'FMR';
26:
27: G_CONF_NEW CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CN';
28: G_CONF_NEW_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CNR';
29: G_CONF_NEW_NOT_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CNN';
30:
31: G_UNCONF_NONE_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UN';

Line 28: G_CONF_NEW_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CNR';

24: G_CONF_MATCH_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CFM';
25: G_FAKE_MATCH_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'FMR';
26:
27: G_CONF_NEW CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CN';
28: G_CONF_NEW_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CNR';
29: G_CONF_NEW_NOT_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CNN';
30:
31: G_UNCONF_NONE_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UN';
32: G_UNCONF_SIGL_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'US';

Line 29: G_CONF_NEW_NOT_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CNN';

25: G_FAKE_MATCH_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'FMR';
26:
27: G_CONF_NEW CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CN';
28: G_CONF_NEW_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CNR';
29: G_CONF_NEW_NOT_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CNN';
30:
31: G_UNCONF_NONE_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UN';
32: G_UNCONF_SIGL_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'US';
33: G_UNCONF_MULT_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UM';

Line 31: G_UNCONF_NONE_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UN';

27: G_CONF_NEW CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CN';
28: G_CONF_NEW_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CNR';
29: G_CONF_NEW_NOT_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CNN';
30:
31: G_UNCONF_NONE_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UN';
32: G_UNCONF_SIGL_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'US';
33: G_UNCONF_MULT_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UM';
34:
35: G_UNCONF_NO_MATCH_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UFN';

Line 32: G_UNCONF_SIGL_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'US';

28: G_CONF_NEW_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CNR';
29: G_CONF_NEW_NOT_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CNN';
30:
31: G_UNCONF_NONE_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UN';
32: G_UNCONF_SIGL_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'US';
33: G_UNCONF_MULT_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UM';
34:
35: G_UNCONF_NO_MATCH_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UFN';
36: G_UNCONF_SINGLE_MATCH_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UFS';

Line 33: G_UNCONF_MULT_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UM';

29: G_CONF_NEW_NOT_READY CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'CNN';
30:
31: G_UNCONF_NONE_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UN';
32: G_UNCONF_SIGL_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'US';
33: G_UNCONF_MULT_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UM';
34:
35: G_UNCONF_NO_MATCH_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UFN';
36: G_UNCONF_SINGLE_MATCH_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UFS';
37: G_UNCONF_MULTI_MATCH_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UFM';

Line 35: G_UNCONF_NO_MATCH_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UFN';

31: G_UNCONF_NONE_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UN';
32: G_UNCONF_SIGL_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'US';
33: G_UNCONF_MULT_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UM';
34:
35: G_UNCONF_NO_MATCH_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UFN';
36: G_UNCONF_SINGLE_MATCH_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UFS';
37: G_UNCONF_MULTI_MATCH_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UFM';
38: G_FAKE_CONF_STATUS_FLAG CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'FK';
39:

Line 36: G_UNCONF_SINGLE_MATCH_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UFS';

32: G_UNCONF_SIGL_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'US';
33: G_UNCONF_MULT_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UM';
34:
35: G_UNCONF_NO_MATCH_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UFN';
36: G_UNCONF_SINGLE_MATCH_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UFS';
37: G_UNCONF_MULTI_MATCH_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UFM';
38: G_FAKE_CONF_STATUS_FLAG CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'FK';
39:
40: G_EXCLUDED CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'EX';

Line 37: G_UNCONF_MULTI_MATCH_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UFM';

33: G_UNCONF_MULT_MATCH CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UM';
34:
35: G_UNCONF_NO_MATCH_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UFN';
36: G_UNCONF_SINGLE_MATCH_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UFS';
37: G_UNCONF_MULTI_MATCH_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UFM';
38: G_FAKE_CONF_STATUS_FLAG CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'FK';
39:
40: G_EXCLUDED CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'EX';
41: G_FAKE_EXCLUDED CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'FEX';

Line 38: G_FAKE_CONF_STATUS_FLAG CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'FK';

34:
35: G_UNCONF_NO_MATCH_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UFN';
36: G_UNCONF_SINGLE_MATCH_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UFS';
37: G_UNCONF_MULTI_MATCH_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UFM';
38: G_FAKE_CONF_STATUS_FLAG CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'FK';
39:
40: G_EXCLUDED CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'EX';
41: G_FAKE_EXCLUDED CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'FEX';
42:

Line 40: G_EXCLUDED CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'EX';

36: G_UNCONF_SINGLE_MATCH_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UFS';
37: G_UNCONF_MULTI_MATCH_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UFM';
38: G_FAKE_CONF_STATUS_FLAG CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'FK';
39:
40: G_EXCLUDED CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'EX';
41: G_FAKE_EXCLUDED CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'FEX';
42:
43: G_UNCONF_ACTION CONSTANT VARCHAR2(2) := 'UA';
44: G_UNEXCLUDE_ACTION CONSTANT VARCHAR2(2) := 'UX';

Line 41: G_FAKE_EXCLUDED CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'FEX';

37: G_UNCONF_MULTI_MATCH_FAKE CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'UFM';
38: G_FAKE_CONF_STATUS_FLAG CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'FK';
39:
40: G_EXCLUDED CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'EX';
41: G_FAKE_EXCLUDED CONSTANT MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE := 'FEX';
42:
43: G_UNCONF_ACTION CONSTANT VARCHAR2(2) := 'UA';
44: G_UNEXCLUDE_ACTION CONSTANT VARCHAR2(2) := 'UX';
45:

Line 68: * immediately after MTL_SYSTEM_ITEMS_INTERFACE is populated and

64: p_data_set_id IN NUMBER);
65: /*
66: * "Phase 2 API
67: * This method resolves source system item cross references
68: * immediately after MTL_SYSTEM_ITEMS_INTERFACE is populated and
69: * tries to detect discrepencies between user entered CONFIRM_STATUS
70: * (if any) and other data.
71: */
72: PROCEDURE Resolve_SSXref_On_Data_load( p_data_set_id IN NUMBER

Line 140: PROCEDURE Stamp_RequestId_For_ReImport( p_request_id IN MTL_SYSTEM_ITEMS_INTERFACE.REQUEST_ID%TYPE );

136: PROCEDURE Resolve_Child_Entities( p_data_set_id IN NUMBER
137: , p_commit IN FLAG DEFAULT FND_API.G_TRUE
138: );
139:
140: PROCEDURE Stamp_RequestId_For_ReImport( p_request_id IN MTL_SYSTEM_ITEMS_INTERFACE.REQUEST_ID%TYPE );
141:
142: PROCEDURE Stamp_Row_RequestId( p_request_id IN MTL_SYSTEM_ITEMS_INTERFACE.REQUEST_ID%TYPE
143: , p_target_rowid IN UROWID
144: );

Line 142: PROCEDURE Stamp_Row_RequestId( p_request_id IN MTL_SYSTEM_ITEMS_INTERFACE.REQUEST_ID%TYPE

138: );
139:
140: PROCEDURE Stamp_RequestId_For_ReImport( p_request_id IN MTL_SYSTEM_ITEMS_INTERFACE.REQUEST_ID%TYPE );
141:
142: PROCEDURE Stamp_Row_RequestId( p_request_id IN MTL_SYSTEM_ITEMS_INTERFACE.REQUEST_ID%TYPE
143: , p_target_rowid IN UROWID
144: );
145:
146: PROCEDURE Log_Error_For_ReImport(p_request_id IN MTL_SYSTEM_ITEMS_INTERFACE.REQUEST_ID%TYPE

Line 146: PROCEDURE Log_Error_For_ReImport(p_request_id IN MTL_SYSTEM_ITEMS_INTERFACE.REQUEST_ID%TYPE

142: PROCEDURE Stamp_Row_RequestId( p_request_id IN MTL_SYSTEM_ITEMS_INTERFACE.REQUEST_ID%TYPE
143: , p_target_rowid IN UROWID
144: );
145:
146: PROCEDURE Log_Error_For_ReImport(p_request_id IN MTL_SYSTEM_ITEMS_INTERFACE.REQUEST_ID%TYPE
147: , p_target_rowid IN UROWID
148: , p_err_msg IN VARCHAR2
149: );
150:

Line 152: ( p_batch_id IN MTL_SYSTEM_ITEMS_INTERFACE.SET_PROCESS_ID%TYPE

148: , p_err_msg IN VARCHAR2
149: );
150:
151: PROCEDURE Prepare_Row_For_ReImport
152: ( p_batch_id IN MTL_SYSTEM_ITEMS_INTERFACE.SET_PROCESS_ID%TYPE
153: , p_organization_id IN MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE
154: , p_target_rowid IN UROWID
155: , x_return_code OUT NOCOPY NUMBER
156: , x_err_msg OUT NOCOPY VARCHAR2

Line 153: , p_organization_id IN MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE

149: );
150:
151: PROCEDURE Prepare_Row_For_ReImport
152: ( p_batch_id IN MTL_SYSTEM_ITEMS_INTERFACE.SET_PROCESS_ID%TYPE
153: , p_organization_id IN MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE
154: , p_target_rowid IN UROWID
155: , x_return_code OUT NOCOPY NUMBER
156: , x_err_msg OUT NOCOPY VARCHAR2
157: );

Line 213: -- (MTL_SYSTEM_ITEMS_INTERFACE)

209:
210: --------------------------------------------------------------------------------------------
211: -- Procedure MERGE_ITEMS
212: -- Merges unprocessed items found in the items interface table
213: -- (MTL_SYSTEM_ITEMS_INTERFACE)
214: --------------------------------------------------------------------------------------------
215: PROCEDURE merge_items ( p_batch_id IN NUMBER
216: , p_is_pdh_batch IN FLAG DEFAULT NULL
217: , p_ss_id IN NUMBER DEFAULT NULL

Line 699: (p_batch_id IN MTL_SYSTEM_ITEMS_INTERFACE.SET_PROCESS_ID%TYPE

695: );
696:
697:
698: PROCEDURE SET_CONFIRM_STATUS
699: (p_batch_id IN MTL_SYSTEM_ITEMS_INTERFACE.SET_PROCESS_ID%TYPE
700: ,p_source_system_id IN MTL_SYSTEM_ITEMS_INTERFACE.SOURCE_SYSTEM_ID%TYPE
701: ,p_source_system_reference IN MTL_SYSTEM_ITEMS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE
702: ,p_new_status IN MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE
703: ,p_inventory_item_id IN MTL_SYSTEM_ITEMS_INTERFACE.INVENTORY_ITEM_ID%TYPE DEFAULT NULL

Line 700: ,p_source_system_id IN MTL_SYSTEM_ITEMS_INTERFACE.SOURCE_SYSTEM_ID%TYPE

696:
697:
698: PROCEDURE SET_CONFIRM_STATUS
699: (p_batch_id IN MTL_SYSTEM_ITEMS_INTERFACE.SET_PROCESS_ID%TYPE
700: ,p_source_system_id IN MTL_SYSTEM_ITEMS_INTERFACE.SOURCE_SYSTEM_ID%TYPE
701: ,p_source_system_reference IN MTL_SYSTEM_ITEMS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE
702: ,p_new_status IN MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE
703: ,p_inventory_item_id IN MTL_SYSTEM_ITEMS_INTERFACE.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
704: ,p_organization_id IN MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE DEFAULT NULL

Line 701: ,p_source_system_reference IN MTL_SYSTEM_ITEMS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE

697:
698: PROCEDURE SET_CONFIRM_STATUS
699: (p_batch_id IN MTL_SYSTEM_ITEMS_INTERFACE.SET_PROCESS_ID%TYPE
700: ,p_source_system_id IN MTL_SYSTEM_ITEMS_INTERFACE.SOURCE_SYSTEM_ID%TYPE
701: ,p_source_system_reference IN MTL_SYSTEM_ITEMS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE
702: ,p_new_status IN MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE
703: ,p_inventory_item_id IN MTL_SYSTEM_ITEMS_INTERFACE.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
704: ,p_organization_id IN MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE DEFAULT NULL
705: ,p_check_matching_table IN FLAG DEFAULT FND_API.G_FALSE

Line 702: ,p_new_status IN MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE

698: PROCEDURE SET_CONFIRM_STATUS
699: (p_batch_id IN MTL_SYSTEM_ITEMS_INTERFACE.SET_PROCESS_ID%TYPE
700: ,p_source_system_id IN MTL_SYSTEM_ITEMS_INTERFACE.SOURCE_SYSTEM_ID%TYPE
701: ,p_source_system_reference IN MTL_SYSTEM_ITEMS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE
702: ,p_new_status IN MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE
703: ,p_inventory_item_id IN MTL_SYSTEM_ITEMS_INTERFACE.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
704: ,p_organization_id IN MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE DEFAULT NULL
705: ,p_check_matching_table IN FLAG DEFAULT FND_API.G_FALSE
706: ,errmsg OUT NOCOPY VARCHAR2

Line 703: ,p_inventory_item_id IN MTL_SYSTEM_ITEMS_INTERFACE.INVENTORY_ITEM_ID%TYPE DEFAULT NULL

699: (p_batch_id IN MTL_SYSTEM_ITEMS_INTERFACE.SET_PROCESS_ID%TYPE
700: ,p_source_system_id IN MTL_SYSTEM_ITEMS_INTERFACE.SOURCE_SYSTEM_ID%TYPE
701: ,p_source_system_reference IN MTL_SYSTEM_ITEMS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE
702: ,p_new_status IN MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE
703: ,p_inventory_item_id IN MTL_SYSTEM_ITEMS_INTERFACE.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
704: ,p_organization_id IN MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE DEFAULT NULL
705: ,p_check_matching_table IN FLAG DEFAULT FND_API.G_FALSE
706: ,errmsg OUT NOCOPY VARCHAR2
707: ,retcode OUT NOCOPY VARCHAR2

Line 704: ,p_organization_id IN MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE DEFAULT NULL

700: ,p_source_system_id IN MTL_SYSTEM_ITEMS_INTERFACE.SOURCE_SYSTEM_ID%TYPE
701: ,p_source_system_reference IN MTL_SYSTEM_ITEMS_INTERFACE.SOURCE_SYSTEM_REFERENCE%TYPE
702: ,p_new_status IN MTL_SYSTEM_ITEMS_INTERFACE.CONFIRM_STATUS%TYPE
703: ,p_inventory_item_id IN MTL_SYSTEM_ITEMS_INTERFACE.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
704: ,p_organization_id IN MTL_SYSTEM_ITEMS_INTERFACE.ORGANIZATION_ID%TYPE DEFAULT NULL
705: ,p_check_matching_table IN FLAG DEFAULT FND_API.G_FALSE
706: ,errmsg OUT NOCOPY VARCHAR2
707: ,retcode OUT NOCOPY VARCHAR2
708: );