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.

[Home] [Help]

APPS.EGO_IMPORT_PVT dependencies on EGO_ITM_USR_ATTR_INTRFC

Line 20: SUBTYPE EIUAI_ROW IS EGO_ITM_USR_ATTR_INTRFC%ROWTYPE;

16: G_NEED_TO_LOG_ERROR CONSTANT NUMBER := -3;
17:
18: SUBTYPE MSII_ROW IS MTL_SYSTEM_ITEMS_INTERFACE%ROWTYPE;
19: TYPE COLUMN_NAMES IS TABLE OF ALL_TAB_COLUMNS.COLUMN_NAME%TYPE;
20: SUBTYPE EIUAI_ROW IS EGO_ITM_USR_ATTR_INTRFC%ROWTYPE;
21: TYPE EIUAI_ROWS IS TABLE OF EIUAI_ROW INDEX BY BINARY_INTEGER;
22: SUBTYPE IAssocs_Row IS EGO_ITEM_ASSOCIATIONS_INTF%ROWTYPE;
23: TYPE IAssocs_Rows IS TABLE OF IAssocs_Row INDEX BY BINARY_INTEGER;
24:

Line 131: FROM EGO_ITM_USR_ATTR_INTRFC

127: SELECT
128: ORGANIZATION_ID,
129: TRANSACTION_ID,
130: PROCESS_STATUS
131: FROM EGO_ITM_USR_ATTR_INTRFC
132: WHERE DATA_SET_ID = p_data_set_id
133: AND PROCESS_STATUS IN (33379, 33389);
134:
135: CURSOR c_ssxref_null_eipi IS

Line 216: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI

212: )
213: );
214:
215: -- EIUAI
216: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI
217: SET PROCESS_STATUS = (CASE WHEN EIUAI.SOURCE_SYSTEM_REFERENCE IS NULL THEN 33379 ELSE 33389 END),
218: TRANSACTION_ID = NVL(TRANSACTION_ID, MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL),
219: PROGRAM_APPLICATION_ID = l_prog_appid,
220: PROGRAM_ID = l_prog_id,

Line 412: ,'EGO_ITM_USR_ATTR_INTRFC'

408: ,l_request_id
409: ,i.TRANSACTION_ID
410: ,l_msg_text
411: ,'SOURCE_SYSTEM_REFERENCE'
412: ,'EGO_ITM_USR_ATTR_INTRFC'
413: ,'INV_IOI_ERR'
414: ,l_err_text);
415: ELSIF i.PROCESS_STATUS = 33389 THEN
416: FND_MESSAGE.SET_NAME('EGO', 'EGO_SSXID_INVALID');

Line 428: ,'EGO_ITM_USR_ATTR_INTRFC'

424: ,l_request_id
425: ,i.TRANSACTION_ID
426: ,l_msg_text
427: ,'SOURCE_SYSTEM_ID'
428: ,'EGO_ITM_USR_ATTR_INTRFC'
429: ,'INV_IOI_ERR'
430: ,l_err_text);
431: END IF;
432: END LOOP;

Line 563: UPDATE EGO_ITM_USR_ATTR_INTRFC

559: SET PROCESS_FLAG =3
560: WHERE PROCESS_FLAG IN (33379, 33389)
561: AND SET_PROCESS_ID = p_data_set_id;
562:
563: UPDATE EGO_ITM_USR_ATTR_INTRFC
564: SET PROCESS_STATUS =3
565: WHERE PROCESS_STATUS IN (33379, 33389)
566: AND DATA_SET_ID = p_data_set_id;
567:

Line 691: -- checking whether stats needs to be collected on EGO_ITM_USR_ATTR_INTRFC

687: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_AML_INTF');
688: Debug_Conc_Log('Collected Statistics on EGO_AML_INTF');
689: END IF;
690:
691: -- checking whether stats needs to be collected on EGO_ITM_USR_ATTR_INTRFC
692: SELECT COUNT(1) INTO l_records
693: FROM EGO_ITM_USR_ATTR_INTRFC
694: WHERE DATA_SET_ID = p_data_set_id;
695:

Line 693: FROM EGO_ITM_USR_ATTR_INTRFC

689: END IF;
690:
691: -- checking whether stats needs to be collected on EGO_ITM_USR_ATTR_INTRFC
692: SELECT COUNT(1) INTO l_records
693: FROM EGO_ITM_USR_ATTR_INTRFC
694: WHERE DATA_SET_ID = p_data_set_id;
695:
696: IF (l_records > (l_stats_profile*25)) AND l_ego_installed AND l_schema IS NOT NULL THEN
697: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITM_USR_ATTR_INTRFC');

Line 697: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITM_USR_ATTR_INTRFC');

693: FROM EGO_ITM_USR_ATTR_INTRFC
694: WHERE DATA_SET_ID = p_data_set_id;
695:
696: IF (l_records > (l_stats_profile*25)) AND l_ego_installed AND l_schema IS NOT NULL THEN
697: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITM_USR_ATTR_INTRFC');
698: Debug_Conc_Log('Collected Statistics on EGO_ITM_USR_ATTR_INTRFC');
699: END IF;
700:
701: -- R12C: BEGIN

Line 698: Debug_Conc_Log('Collected Statistics on EGO_ITM_USR_ATTR_INTRFC');

694: WHERE DATA_SET_ID = p_data_set_id;
695:
696: IF (l_records > (l_stats_profile*25)) AND l_ego_installed AND l_schema IS NOT NULL THEN
697: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITM_USR_ATTR_INTRFC');
698: Debug_Conc_Log('Collected Statistics on EGO_ITM_USR_ATTR_INTRFC');
699: END IF;
700:
701: -- R12C: BEGIN
702: -- checking whether stats needs to be collected on EGO_ITEM_ASSOCIATIONS_INTF

Line 795: CURSOR c_pdh_target_rev_attrs( cp_master_org_id EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE, cp_rev_dl_id NUMBER ) IS

791: , p_commit IN FLAG DEFAULT FND_API.G_FALSE
792: )
793: IS
794: --6468564:Perf issue replacing EGO_ATTRS_V
795: CURSOR c_pdh_target_rev_attrs( cp_master_org_id EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE, cp_rev_dl_id NUMBER ) IS
796: SELECT sub.*
797: ,EXT.DATA_TYPE DATA_TYPE_CODE
798: FROM
799: ( SELECT

Line 850: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

846: , NVL( eiuai.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
847: )
848: rnk
849: , eiuai.*
850: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
851: WHERE DATA_SET_ID = p_batch_id
852: AND PROCESS_STATUS = 1
853: AND ITEM_NUMBER IS NOT NULL
854: AND FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )

Line 878: CURSOR c_ss_target_rev_attrs( cp_master_org_id EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE, cp_rev_dl_id NUMBER ) IS

874: AND EXT.APPLICATION_COLUMN_NAME = FL_COL.APPLICATION_COLUMN_NAME
875: ORDER BY rnk, sub.last_update_date DESC, interface_table_unique_id DESC ;
876:
877: --6468564:Perf issue replacing EGO_ATTRS_V
878: CURSOR c_ss_target_rev_attrs( cp_master_org_id EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE, cp_rev_dl_id NUMBER ) IS
879: SELECT sub.*
880: ,EXT.DATA_TYPE DATA_TYPE_CODE
881: FROM
882: ( SELECT

Line 935: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

931: , NVL( eiuai.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
932: )
933: rnk
934: , eiuai.*
935: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
936: WHERE DATA_SET_ID = p_batch_id
937: AND PROCESS_STATUS = 0
938: AND FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
939: AND FL_CTX_EXT.APPLICATION_ID = 431

Line 968: l_ss_id EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE := p_ss_id;

964: l_merge_base EIUAI_ROW;
965: l_old_rows TARGET_ROWS;
966: l_old_rowids UROWID_TABLE;
967:
968: l_ss_id EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE := p_ss_id;
969: l_ssr EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE;
970: l_candidate_trans EGO_ITM_USR_ATTR_INTRFC.TRANSACTION_TYPE%TYPE;
971:
972: l_cur_rank PLS_INTEGER := 0; -- because rank() starts at 1

Line 969: l_ssr EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE;

965: l_old_rows TARGET_ROWS;
966: l_old_rowids UROWID_TABLE;
967:
968: l_ss_id EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE := p_ss_id;
969: l_ssr EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE;
970: l_candidate_trans EGO_ITM_USR_ATTR_INTRFC.TRANSACTION_TYPE%TYPE;
971:
972: l_cur_rank PLS_INTEGER := 0; -- because rank() starts at 1
973: l_mrow_ix PLS_INTEGER := 0;

Line 970: l_candidate_trans EGO_ITM_USR_ATTR_INTRFC.TRANSACTION_TYPE%TYPE;

966: l_old_rowids UROWID_TABLE;
967:
968: l_ss_id EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE := p_ss_id;
969: l_ssr EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE;
970: l_candidate_trans EGO_ITM_USR_ATTR_INTRFC.TRANSACTION_TYPE%TYPE;
971:
972: l_cur_rank PLS_INTEGER := 0; -- because rank() starts at 1
973: l_mrow_ix PLS_INTEGER := 0;
974: l_is_pdh_batch BOOLEAN;

Line 978: l_org_id EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE := p_master_org_id;

974: l_is_pdh_batch BOOLEAN;
975:
976: l_data_type_code EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;
977:
978: l_org_id EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE := p_master_org_id;
979: l_pdh_batch_flag FLAG := p_is_pdh_batch;
980: l_rev_dl_id NUMBER;
981:
982: l_proc_log_prefix CONSTANT VARCHAR2(30) := ' merge_rev_attrs - ';

Line 1141: WHERE TABLE_NAME = 'EGO_ITM_USR_ATTR_INTRFC'

1137: /* Generated using:
1138: SET LINESIZE 200
1139: SELECT 'if l_merged_rows( l_mrow_ix ).' ||column_name || ' is null then l_merged_rows( l_mrow_ix ).' || column_name || ' := l_old_rows( orow_ix ).' || column_name || '; end if; '
1140: FROM ALL_TAB_COLUMNS
1141: WHERE TABLE_NAME = 'EGO_ITM_USR_ATTR_INTRFC'
1142: AND COLUMN_NAME NOT IN
1143: ( -- special cases (for merge)
1144: 'INVENTORY_ITEM_ID'
1145: , 'ITEM_NUMBER'

Line 1199: DELETE FROM EGO_ITM_USR_ATTR_INTRFC

1195: IF l_merged_rows IS NOT NULL THEN
1196: -- delete
1197: Debug_Conc_Log( l_proc_log_prefix || 'Deleting ' || l_old_rowids.COUNT || ' old rows ...' );
1198: FORALL rid_ix IN INDICES OF l_old_rowids
1199: DELETE FROM EGO_ITM_USR_ATTR_INTRFC
1200: WHERE ROWID = l_old_rowids( rid_ix );
1201: -- insert
1202: Debug_Conc_Log( l_proc_log_prefix || 'Inserting ' || l_merged_rows.COUNT || ' merged rows ...' );
1203: FORALL row_index IN INDICES OF l_merged_rows

Line 1204: INSERT INTO EGO_ITM_USR_ATTR_INTRFC

1200: WHERE ROWID = l_old_rowids( rid_ix );
1201: -- insert
1202: Debug_Conc_Log( l_proc_log_prefix || 'Inserting ' || l_merged_rows.COUNT || ' merged rows ...' );
1203: FORALL row_index IN INDICES OF l_merged_rows
1204: INSERT INTO EGO_ITM_USR_ATTR_INTRFC
1205: VALUES l_merged_rows( row_index );
1206: END IF;
1207: END IF; -- ENDS IF l_old_rows.count <> 0
1208:

Line 1225: CURSOR c_pdh_target_item_attrs( cp_master_org_id EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE ) IS

1221: )
1222: IS
1223:
1224: --6468564:Perf issue replacing EGO_ATTRS_V
1225: CURSOR c_pdh_target_item_attrs( cp_master_org_id EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE ) IS
1226: SELECT sub.*
1227: ,EXT.DATA_TYPE DATA_TYPE_CODE
1228: FROM
1229: ( SELECT

Line 1272: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

1268: , NVL( ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
1269: )
1270: rnk
1271: , eiuai.*
1272: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
1273: WHERE DATA_SET_ID = p_batch_id
1274: AND PROCESS_STATUS = 1
1275: AND FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
1276: AND FL_CTX_EXT.APPLICATION_ID = 431

Line 1302: CURSOR c_ss_target_item_attrs( cp_master_org_id EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE ) IS

1298: AND EXT.APPLICATION_COLUMN_NAME = FL_COL.APPLICATION_COLUMN_NAME
1299: ORDER BY rnk, sub.last_update_date DESC, interface_table_unique_id DESC ;
1300:
1301: --6468564 : Perf issue replacing EGO_ATTRS_V
1302: CURSOR c_ss_target_item_attrs( cp_master_org_id EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE ) IS
1303: SELECT sub.*
1304: ,EXT.DATA_TYPE DATA_TYPE_CODE
1305: FROM
1306: ( SELECT

Line 1351: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

1347: , NVL( ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
1348: )
1349: rnk
1350: , eiuai.*
1351: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
1352: WHERE DATA_SET_ID = p_batch_id
1353: AND PROCESS_STATUS = 0
1354: AND FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
1355: AND FL_CTX_EXT.APPLICATION_ID = 431

Line 1387: l_ss_id EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE := p_ss_id;

1383: l_merge_base EIUAI_ROW;
1384: l_old_rows TARGET_ROWS;
1385: l_old_rowids UROWID_TABLE;
1386:
1387: l_ss_id EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE := p_ss_id;
1388: l_ssr EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE;
1389: l_candidate_trans EGO_ITM_USR_ATTR_INTRFC.TRANSACTION_TYPE%TYPE;
1390:
1391: l_cur_rank PLS_INTEGER := 0; -- because rank() starts at 1

Line 1388: l_ssr EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE;

1384: l_old_rows TARGET_ROWS;
1385: l_old_rowids UROWID_TABLE;
1386:
1387: l_ss_id EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE := p_ss_id;
1388: l_ssr EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE;
1389: l_candidate_trans EGO_ITM_USR_ATTR_INTRFC.TRANSACTION_TYPE%TYPE;
1390:
1391: l_cur_rank PLS_INTEGER := 0; -- because rank() starts at 1
1392: l_mrow_ix PLS_INTEGER := 0;

Line 1389: l_candidate_trans EGO_ITM_USR_ATTR_INTRFC.TRANSACTION_TYPE%TYPE;

1385: l_old_rowids UROWID_TABLE;
1386:
1387: l_ss_id EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE := p_ss_id;
1388: l_ssr EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE;
1389: l_candidate_trans EGO_ITM_USR_ATTR_INTRFC.TRANSACTION_TYPE%TYPE;
1390:
1391: l_cur_rank PLS_INTEGER := 0; -- because rank() starts at 1
1392: l_mrow_ix PLS_INTEGER := 0;
1393: l_is_pdh_batch BOOLEAN;

Line 1396: l_org_id EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE := p_master_org_id;

1392: l_mrow_ix PLS_INTEGER := 0;
1393: l_is_pdh_batch BOOLEAN;
1394:
1395: l_data_type_code EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;
1396: l_org_id EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE := p_master_org_id;
1397: l_pdh_batch_flag FLAG := p_is_pdh_batch;
1398:
1399: l_proc_log_prefix CONSTANT VARCHAR2(30) := ' merge_item_attrs - ';
1400: BEGIN

Line 1552: WHERE TABLE_NAME = 'EGO_ITM_USR_ATTR_INTRFC'

1548: /* Generated using:
1549: SET LINESIZE 200
1550: SELECT 'if l_merged_rows( l_mrow_ix ).' ||column_name || ' is null then l_merged_rows( l_mrow_ix ).' || column_name || ' := l_old_rows( orow_ix ).' || column_name || '; end if; '
1551: FROM ALL_TAB_COLUMNS
1552: WHERE TABLE_NAME = 'EGO_ITM_USR_ATTR_INTRFC'
1553: AND COLUMN_NAME NOT IN
1554: ( -- special cases (for merge)
1555: 'INVENTORY_ITEM_ID'
1556: , 'ITEM_NUMBER'

Line 1610: DELETE FROM EGO_ITM_USR_ATTR_INTRFC

1606: IF l_merged_rows IS NOT NULL THEN
1607: -- delete
1608: Debug_Conc_Log( l_proc_log_prefix || l_old_rowids.COUNT || ' old rows ...' );
1609: FORALL rid_ix IN INDICES OF l_old_rowids
1610: DELETE FROM EGO_ITM_USR_ATTR_INTRFC
1611: WHERE ROWID = l_old_rowids( rid_ix );
1612: -- insert
1613: Debug_Conc_Log( l_proc_log_prefix || l_merged_rows.COUNT || ' merged rows ...' );
1614: FORALL row_index IN INDICES OF l_merged_rows

Line 1615: INSERT INTO EGO_ITM_USR_ATTR_INTRFC

1611: WHERE ROWID = l_old_rowids( rid_ix );
1612: -- insert
1613: Debug_Conc_Log( l_proc_log_prefix || l_merged_rows.COUNT || ' merged rows ...' );
1614: FORALL row_index IN INDICES OF l_merged_rows
1615: INSERT INTO EGO_ITM_USR_ATTR_INTRFC
1616: VALUES l_merged_rows( row_index );
1617: END IF;
1618: END IF; -- ENDS IF l_old_rows.count <> 0
1619:

Line 4305: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

4301: , NVL( ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
4302: )
4303: rnk
4304: , eiuai.*
4305: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
4306: WHERE DATA_SET_ID = p_batch_id
4307: AND PROCESS_STATUS = 1
4308: AND ITEM_NUMBER IS NOT NULL
4309: AND ORGANIZATION_ID IS NOT NULL

Line 4339: l_candidate_trans EGO_ITM_USR_ATTR_INTRFC.TRANSACTION_TYPE%TYPE;

4335: l_merged_row EIUAI_ROW;
4336: l_old_rows TARGET_ROWS;
4337: l_old_rowids UROWID_TABLE;
4338:
4339: l_candidate_trans EGO_ITM_USR_ATTR_INTRFC.TRANSACTION_TYPE%TYPE;
4340:
4341: l_cur_rank PLS_INTEGER := 0; -- because rank() starts at 1
4342: l_mrow_ix PLS_INTEGER := 0;
4343: l_new_row_idx PLS_INTEGER := 0;

Line 4352: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai

4348: BEGIN
4349: Debug_Conc_Log( l_proc_log_prefix || 'Entering' );
4350: Debug_Conc_Log( l_proc_log_prefix || 'Batch ID: ' || p_batch_id );
4351:
4352: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai
4353: SET ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
4354: FROM MTL_SYSTEM_ITEMS_KFV
4355: WHERE INVENTORY_ITEM_ID = eiuai.INVENTORY_ITEM_ID
4356: AND ORGANIZATION_ID = eiuai.ORGANIZATION_ID)

Line 4571: DELETE FROM EGO_ITM_USR_ATTR_INTRFC

4567: IF l_merged_rows IS NOT NULL THEN
4568: -- delete
4569: Debug_Conc_Log( l_proc_log_prefix || l_old_rowids.COUNT || ' old rows ...' );
4570: FORALL rid_ix IN INDICES OF l_old_rowids
4571: DELETE FROM EGO_ITM_USR_ATTR_INTRFC
4572: WHERE ROWID = l_old_rowids( rid_ix );
4573: -- insert
4574: Debug_Conc_Log( l_proc_log_prefix || l_merged_rows.COUNT || ' merged rows ...' );
4575: FORALL row_index IN INDICES OF l_merged_rows

Line 4576: INSERT INTO EGO_ITM_USR_ATTR_INTRFC

4572: WHERE ROWID = l_old_rowids( rid_ix );
4573: -- insert
4574: Debug_Conc_Log( l_proc_log_prefix || l_merged_rows.COUNT || ' merged rows ...' );
4575: FORALL row_index IN INDICES OF l_merged_rows
4576: INSERT INTO EGO_ITM_USR_ATTR_INTRFC
4577: VALUES l_merged_rows( row_index );
4578: END IF;
4579: END IF; -- ENDS IF l_old_rows.count <> 0
4580:

Line 4620: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

4616: , NVL( ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
4617: )
4618: rnk
4619: , eiuai.*
4620: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
4621: WHERE DATA_SET_ID = p_batch_id
4622: AND PROCESS_STATUS = 1
4623: AND ITEM_NUMBER IS NOT NULL
4624: AND ORGANIZATION_ID IS NOT NULL

Line 4651: l_candidate_trans EGO_ITM_USR_ATTR_INTRFC.TRANSACTION_TYPE%TYPE;

4647: l_merged_row EIUAI_ROW;
4648: l_old_rows TARGET_ROWS;
4649: l_old_rowids UROWID_TABLE;
4650:
4651: l_candidate_trans EGO_ITM_USR_ATTR_INTRFC.TRANSACTION_TYPE%TYPE;
4652:
4653: l_cur_rank PLS_INTEGER := 0; -- because rank() starts at 1
4654: l_mrow_ix PLS_INTEGER := 0;
4655: l_new_row_idx PLS_INTEGER := 0;

Line 4675: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai

4671: RETURN;
4672: END;
4673: Debug_Conc_Log( l_proc_log_prefix || 'l_rev_dl_id: ' || l_rev_dl_id );
4674:
4675: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai
4676: SET ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
4677: FROM MTL_SYSTEM_ITEMS_KFV
4678: WHERE INVENTORY_ITEM_ID = eiuai.INVENTORY_ITEM_ID
4679: AND ORGANIZATION_ID = eiuai.ORGANIZATION_ID)

Line 4881: DELETE FROM EGO_ITM_USR_ATTR_INTRFC

4877: IF l_merged_rows IS NOT NULL THEN
4878: -- delete
4879: Debug_Conc_Log( l_proc_log_prefix || l_old_rowids.COUNT || ' old rows ...' );
4880: FORALL rid_ix IN INDICES OF l_old_rowids
4881: DELETE FROM EGO_ITM_USR_ATTR_INTRFC
4882: WHERE ROWID = l_old_rowids( rid_ix );
4883: -- insert
4884: Debug_Conc_Log( l_proc_log_prefix || l_merged_rows.COUNT || ' merged rows ...' );
4885: FORALL row_index IN INDICES OF l_merged_rows

Line 4886: INSERT INTO EGO_ITM_USR_ATTR_INTRFC

4882: WHERE ROWID = l_old_rowids( rid_ix );
4883: -- insert
4884: Debug_Conc_Log( l_proc_log_prefix || l_merged_rows.COUNT || ' merged rows ...' );
4885: FORALL row_index IN INDICES OF l_merged_rows
4886: INSERT INTO EGO_ITM_USR_ATTR_INTRFC
4887: VALUES l_merged_rows( row_index );
4888: END IF;
4889: END IF; -- ENDS IF l_old_rows.count <> 0
4890: Debug_Conc_Log( l_proc_log_prefix || 'Exiting' );

Line 4975: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai

4971: AND PROCESS_FLAG = 111;
4972:
4973: Debug_Conc_Log( l_proc_log_prefix || 'Processed ' || SQL%ROWCOUNT || ' Category Assignments.' );
4974: -- processing revision attributes
4975: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai
4976: SET (PROCESS_STATUS, INVENTORY_ITEM_ID) =
4977: (SELECT PROCESS_STATUS, INVENTORY_ITEM_ID
4978: FROM EGO_ITM_USR_ATTR_INTRFC eiuai_merged
4979: WHERE eiuai_merged.ITEM_NUMBER = eiuai.ITEM_NUMBER

Line 4978: FROM EGO_ITM_USR_ATTR_INTRFC eiuai_merged

4974: -- processing revision attributes
4975: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai
4976: SET (PROCESS_STATUS, INVENTORY_ITEM_ID) =
4977: (SELECT PROCESS_STATUS, INVENTORY_ITEM_ID
4978: FROM EGO_ITM_USR_ATTR_INTRFC eiuai_merged
4979: WHERE eiuai_merged.ITEM_NUMBER = eiuai.ITEM_NUMBER
4980: AND eiuai_merged.ORGANIZATION_ID = eiuai.ORGANIZATION_ID
4981: AND eiuai_merged.ATTR_GROUP_INT_NAME = eiuai.ATTR_GROUP_INT_NAME
4982: AND eiuai_merged.ATTR_INT_NAME = eiuai.ATTR_INT_NAME

Line 4994: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai

4990: AND REVISION IS NOT NULL;
4991:
4992: Debug_Conc_Log( l_proc_log_prefix || 'Processed ' || SQL%ROWCOUNT || ' Revision attributes.' );
4993: -- processing item attributes
4994: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai
4995: SET (PROCESS_STATUS, INVENTORY_ITEM_ID) =
4996: (SELECT PROCESS_STATUS, INVENTORY_ITEM_ID
4997: FROM EGO_ITM_USR_ATTR_INTRFC eiuai_merged
4998: WHERE eiuai_merged.ITEM_NUMBER = eiuai.ITEM_NUMBER

Line 4997: FROM EGO_ITM_USR_ATTR_INTRFC eiuai_merged

4993: -- processing item attributes
4994: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai
4995: SET (PROCESS_STATUS, INVENTORY_ITEM_ID) =
4996: (SELECT PROCESS_STATUS, INVENTORY_ITEM_ID
4997: FROM EGO_ITM_USR_ATTR_INTRFC eiuai_merged
4998: WHERE eiuai_merged.ITEM_NUMBER = eiuai.ITEM_NUMBER
4999: AND eiuai_merged.ORGANIZATION_ID = eiuai.ORGANIZATION_ID
5000: AND eiuai_merged.ATTR_GROUP_INT_NAME = eiuai.ATTR_GROUP_INT_NAME
5001: AND eiuai_merged.ATTR_INT_NAME = eiuai.ATTR_INT_NAME

Line 5739: UPDATE EGO_ITM_USR_ATTR_INTRFC

5735: REQUEST_ID = l_request_id,
5736: PROGRAM_UPDATE_DATE = SYSDATE
5737: WHERE ROWID = i.ROW_ID;
5738:
5739: UPDATE EGO_ITM_USR_ATTR_INTRFC
5740: SET PROCESS_STATUS = 4,
5741: PROGRAM_APPLICATION_ID = l_prog_appid,
5742: PROGRAM_ID = l_prog_id,
5743: REQUEST_ID = l_request_id,

Line 5803: UPDATE EGO_ITM_USR_ATTR_INTRFC

5799: REQUEST_ID = l_request_id,
5800: PROGRAM_UPDATE_DATE = SYSDATE
5801: WHERE ROWID = i.ROW_ID;
5802:
5803: UPDATE EGO_ITM_USR_ATTR_INTRFC
5804: SET PROCESS_STATUS = 4,
5805: PROGRAM_APPLICATION_ID = l_prog_appid,
5806: PROGRAM_ID = l_prog_id,
5807: REQUEST_ID = l_request_id,

Line 6006: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

6002: * based on the data and revision import policy
6003: */
6004: FUNCTION IS_NEW_REVISION_INFO_NEEDED
6005: (
6006: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
6007: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
6008: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
6009: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
6010: , p_organization_code IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_CODE%TYPE

Line 6007: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE

6003: */
6004: FUNCTION IS_NEW_REVISION_INFO_NEEDED
6005: (
6006: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
6007: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
6008: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
6009: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
6010: , p_organization_code IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_CODE%TYPE
6011: , p_instance_rev_policy IN EGO_IMPORT_OPTION_SETS.REVISION_IMPORT_POLICY%TYPE

Line 6008: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE

6004: FUNCTION IS_NEW_REVISION_INFO_NEEDED
6005: (
6006: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
6007: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
6008: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
6009: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
6010: , p_organization_code IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_CODE%TYPE
6011: , p_instance_rev_policy IN EGO_IMPORT_OPTION_SETS.REVISION_IMPORT_POLICY%TYPE
6012: )

Line 6009: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

6005: (
6006: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
6007: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
6008: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
6009: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
6010: , p_organization_code IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_CODE%TYPE
6011: , p_instance_rev_policy IN EGO_IMPORT_OPTION_SETS.REVISION_IMPORT_POLICY%TYPE
6012: )
6013: RETURN BOOLEAN IS

Line 6010: , p_organization_code IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_CODE%TYPE

6006: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
6007: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
6008: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
6009: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
6010: , p_organization_code IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_CODE%TYPE
6011: , p_instance_rev_policy IN EGO_IMPORT_OPTION_SETS.REVISION_IMPORT_POLICY%TYPE
6012: )
6013: RETURN BOOLEAN IS
6014: l_temp VARCHAR2(1);

Line 6502: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI

6498: WHERE SET_PROCESS_ID = p_data_set_id AND
6499: (PROCESS_FLAG IS NULL OR PROCESS_FLAG IN (0, 1)) AND
6500: ORGANIZATION_ID IS NULL;
6501:
6502: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI
6503: SET ORGANIZATION_ID =
6504: CASE
6505: WHEN ORGANIZATION_CODE IS NOT NULL
6506: THEN (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE = EIUAI.ORGANIZATION_CODE)

Line 6563: UPDATE EGO_ITM_USR_ATTR_INTRFC uai

6559: AND DATA_LEVEL_ID IS NULL
6560: AND DATA_LEVEL_NAME IS NOT NULL;
6561:
6562:
6563: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
6564: SET uai.DATA_LEVEL_ID = (SELECT edlb.DATA_LEVEL_ID
6565: FROM EGO_DATA_LEVEL_B edlb
6566: WHERE edlb.DATA_LEVEL_NAME = uai.DATA_LEVEL_NAME
6567: AND edlb.APPLICATION_ID = 431

Line 6575: UPDATE EGO_ITM_USR_ATTR_INTRFC uai

6571: AND (uai.PROCESS_STATUS IS NULL OR uai.PROCESS_STATUS IN (0, 1))
6572: AND uai.DATA_LEVEL_NAME IS NOT NULL
6573: AND uai.DATA_LEVEL_ID IS NULL;
6574:
6575: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
6576: SET uai.DATA_LEVEL_ID = (SELECT edlv.DATA_LEVEL_ID
6577: FROM EGO_DATA_LEVEL_VL edlv
6578: WHERE edlv.USER_DATA_LEVEL_NAME = uai.USER_DATA_LEVEL_NAME
6579: AND edlv.APPLICATION_ID = 431

Line 6593: UPDATE EGO_ITM_USR_ATTR_INTRFC uai

6589: -- If all data level columns are null, then check if the --
6590: -- attribute group is associated at only one level, then --
6591: -- put that data level id here. --
6592: -----------------------------------------------------------
6593: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
6594: SET DATA_LEVEL_ID = (SELECT DATA_LEVEL_ID
6595: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext
6596: WHERE eagd.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID
6597: AND ag_ext.APPLICATION_ID = 431

Line 6701: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI

6697: AND PROCESS_FLAG = 1
6698: AND ITEM_NUMBER IS NULL
6699: AND INVENTORY_ITEM_ID IS NOT NULL;
6700:
6701: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI
6702: SET item_number = (SELECT CONCATENATED_SEGMENTS
6703: FROM MTL_SYSTEM_ITEMS_KFV
6704: WHERE INVENTORY_ITEM_ID = EIUAI.INVENTORY_ITEM_ID
6705: AND ORGANIZATION_ID = EIUAI.ORGANIZATION_ID)

Line 6767: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

6763: , MAX( EIUAI.created_by ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) CREATED_BY
6764: , MAX( EIUAI.last_updated_by ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) UPDATED_BY
6765: , MAX( EIUAI.last_update_login ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) LAST_UPDATE_LOGIN
6766: , MAX( EIUAI.item_catalog_group_id ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) ITEM_CATALOG_GROUP_ID
6767: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
6768: -- , MTL_PARAMETERS MP
6769: WHERE
6770: data_set_id = p_data_set_id
6771: AND process_status = 1

Line 6941: UPDATE EGO_ITM_USR_ATTR_INTRFC

6937: SET PROCESS_FLAG = 0
6938: WHERE SET_PROCESS_ID = p_data_set_id AND
6939: PROCESS_FLAG IS NULL;
6940:
6941: UPDATE EGO_ITM_USR_ATTR_INTRFC
6942: SET PROCESS_STATUS = 0
6943: WHERE DATA_SET_ID = p_data_set_id AND
6944: PROCESS_STATUS IS NULL;
6945:

Line 6984: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

6980: , MAX( EIUAI.created_by ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, ITEM_NUMBER NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) CREATED_BY
6981: , MAX( EIUAI.last_updated_by ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, ITEM_NUMBER NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) UPDATED_BY
6982: , MAX( EIUAI.last_update_login ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, ITEM_NUMBER NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) LAST_UPDATE_LOGIN
6983: , MAX( EIUAI.item_catalog_group_id ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, ITEM_NUMBER NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) ITEM_CATALOG_GROUP_ID
6984: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
6985: -- , MTL_PARAMETERS MP
6986: WHERE
6987: data_set_id = p_data_set_id
6988: AND process_status = 0

Line 7268: -- rev code or id in either EGO_ITM_USR_ATTR_INTRFC or MTL_ITEM_REVISIONS_INTERFACE: We set it to 'S' meaning specific.

7264: execute immediate l_sql using p_data_set_id, l_org_id;
7265: Debug_Conc_Log( 'Resolve_SSXref_on_Data_load - Source System batch, resolved xrefs. Rows touched: ' || SQL%ROWCOUNT );
7266: -- determine if import policy applies to a source system item:
7267: -- the revision import policy should not apply if the user has given us a
7268: -- rev code or id in either EGO_ITM_USR_ATTR_INTRFC or MTL_ITEM_REVISIONS_INTERFACE: We set it to 'S' meaning specific.
7269: -- however, if the rev import policy is set to Specific already, we need to verify that
7270: -- the user has given us a rev code or id in either EGO_ITM_USR_ATTR_INTRFC or MTL_ITEM_REVISIONS_INTERFACE.
7271: UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII
7272: SET REVISION_IMPORT_POLICY =

Line 7270: -- the user has given us a rev code or id in either EGO_ITM_USR_ATTR_INTRFC or MTL_ITEM_REVISIONS_INTERFACE.

7266: -- determine if import policy applies to a source system item:
7267: -- the revision import policy should not apply if the user has given us a
7268: -- rev code or id in either EGO_ITM_USR_ATTR_INTRFC or MTL_ITEM_REVISIONS_INTERFACE: We set it to 'S' meaning specific.
7269: -- however, if the rev import policy is set to Specific already, we need to verify that
7270: -- the user has given us a rev code or id in either EGO_ITM_USR_ATTR_INTRFC or MTL_ITEM_REVISIONS_INTERFACE.
7271: UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII
7272: SET REVISION_IMPORT_POLICY =
7273: CASE
7274: WHEN EXISTS -- check the revision interface table

Line 7293: FROM EGO_ITM_USR_ATTR_INTRFC USR_ATTR

7289: THEN 'S'
7290: WHEN EXISTS -- check the user attrs interface table
7291: (
7292: SELECT NULL
7293: FROM EGO_ITM_USR_ATTR_INTRFC USR_ATTR
7294: WHERE DATA_SET_ID = MSII.SET_PROCESS_ID
7295: AND SOURCE_SYSTEM_ID = MSII.SOURCE_SYSTEM_ID
7296: AND SOURCE_SYSTEM_REFERENCE = MSII.SOURCE_SYSTEM_REFERENCE
7297: AND ORGANIZATION_ID = MSII.ORGANIZATION_ID

Line 7432: FROM EGO_ITM_USR_ATTR_INTRFC eiuai

7428: PK5_VALUE,
7429: ORGANIZATION_ID,
7430: NVL( ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
7431: ) cnt
7432: FROM EGO_ITM_USR_ATTR_INTRFC eiuai
7433: WHERE DATA_SET_ID = p_batch_id
7434: AND PROCESS_STATUS = p_process_status
7435: AND (ITEM_NUMBER IS NOT NULL OR SOURCE_SYSTEM_REFERENCE IS NOT NULL)
7436: AND DATA_LEVEL_ID IS NOT NULL

Line 7479: FROM EGO_ITM_USR_ATTR_INTRFC eiuai

7475: PK5_VALUE,
7476: ORGANIZATION_ID,
7477: NVL( ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
7478: ) MAX_ROW_IDENTIFIER
7479: FROM EGO_ITM_USR_ATTR_INTRFC eiuai
7480: WHERE DATA_SET_ID = p_batch_id
7481: AND PROCESS_STATUS = p_process_status
7482: AND (ITEM_NUMBER IS NOT NULL OR SOURCE_SYSTEM_REFERENCE IS NOT NULL)
7483: AND DATA_LEVEL_ID IS NOT NULL

Line 7502: FROM EGO_ITM_USR_ATTR_INTRFC

7498: SOURCE_SYSTEM_REFERENCE,
7499: INVENTORY_ITEM_ID,
7500: ATTR_GROUP_INT_NAME,
7501: TRANSACTION_ID
7502: FROM EGO_ITM_USR_ATTR_INTRFC
7503: WHERE DATA_SET_ID = p_batch_id
7504: AND PROCESS_STATUS = 3.475;
7505:
7506: l_msg_text VARCHAR2(4000);

Line 7533: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai

7529: l_ss_id := GET_PDH_SOURCE_SYSTEM_ID();
7530: END;
7531:
7532: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Pre - Updating item_number and revision, l_ss_id='||l_ss_id);
7533: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai
7534: SET ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
7535: FROM MTL_SYSTEM_ITEMS_KFV
7536: WHERE INVENTORY_ITEM_ID = eiuai.INVENTORY_ITEM_ID
7537: AND ORGANIZATION_ID = eiuai.ORGANIZATION_ID)

Line 7543: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai

7539: AND PROCESS_STATUS = p_process_status
7540: AND INVENTORY_ITEM_ID IS NOT NULL
7541: AND ITEM_NUMBER IS NULL;
7542:
7543: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai
7544: SET REVISION = ( SELECT R.REVISION
7545: FROM MTL_ITEM_REVISIONS_B R
7546: WHERE R.REVISION_ID = eiuai.REVISION_ID
7547: )

Line 7560: UPDATE EGO_ITM_USR_ATTR_INTRFC

7556: FETCH c_unmerged_rows BULK COLLECT INTO l_unmerged_row_idents LIMIT 1000;
7557: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Pre - fetched '||l_unmerged_row_idents.Count||' rows, ');
7558:
7559: FORALL idx IN l_unmerged_row_idents.FIRST..l_unmerged_row_idents.LAST
7560: UPDATE EGO_ITM_USR_ATTR_INTRFC
7561: SET process_status = 3.475
7562: WHERE DATA_SET_ID = p_batch_id
7563: AND PROCESS_STATUS = p_process_status
7564: AND ROW_IDENTIFIER = l_unmerged_row_idents(idx);

Line 7586: ,'EGO_ITM_USR_ATTR_INTRFC'

7582: ,l_request_id
7583: ,i.TRANSACTION_ID
7584: ,l_msg_text
7585: ,'ATTR_GROUP_INT_NAME'
7586: ,'EGO_ITM_USR_ATTR_INTRFC'
7587: ,'INV_IOI_ERR'
7588: ,l_err_text);
7589: END LOOP;
7590: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Pre - Done Logging errors for Errored out unmerged rows');

Line 7592: UPDATE EGO_ITM_USR_ATTR_INTRFC

7588: ,l_err_text);
7589: END LOOP;
7590: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Pre - Done Logging errors for Errored out unmerged rows');
7591:
7592: UPDATE EGO_ITM_USR_ATTR_INTRFC
7593: SET
7594: PROCESS_STATUS = 3,
7595: REQUEST_ID = l_request_id
7596: WHERE DATA_SET_ID = p_batch_id

Line 7613: UPDATE EGO_ITM_USR_ATTR_INTRFC

7609: FETCH c_intf_recs BULK COLLECT INTO l_row_ids, l_row_idents LIMIT 1000;
7610: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Pre - fetched '||l_unmerged_row_idents.Count||' rows, ');
7611:
7612: FORALL idx IN l_row_ids.FIRST..l_row_ids.LAST
7613: UPDATE EGO_ITM_USR_ATTR_INTRFC
7614: SET ROW_IDENTIFIER = l_row_idents(idx)
7615: WHERE ROWID = l_row_ids(idx);
7616: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Pre - Updated - '||SQL%ROWCOUNT||' rows');
7617: EXIT WHEN c_intf_recs%NOTFOUND;

Line 7662: FROM EGO_ITM_USR_ATTR_INTRFC eiuai

7658: PK5_VALUE,
7659: ORGANIZATION_ID,
7660: NVL( ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
7661: ) cnt
7662: FROM EGO_ITM_USR_ATTR_INTRFC eiuai
7663: WHERE DATA_SET_ID = p_batch_id
7664: AND PROCESS_STATUS = p_process_status
7665: AND INVENTORY_ITEM_ID IS NOT NULL
7666: AND DATA_LEVEL_ID IS NOT NULL

Line 7707: FROM EGO_ITM_USR_ATTR_INTRFC eiuai

7703: PK5_VALUE,
7704: ORGANIZATION_ID,
7705: NVL( ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
7706: ) MAX_ROW_IDENTIFIER
7707: FROM EGO_ITM_USR_ATTR_INTRFC eiuai
7708: WHERE DATA_SET_ID = p_batch_id
7709: AND PROCESS_STATUS = p_process_status
7710: AND INVENTORY_ITEM_ID IS NOT NULL
7711: AND DATA_LEVEL_ID IS NOT NULL

Line 7730: FROM EGO_ITM_USR_ATTR_INTRFC

7726: SOURCE_SYSTEM_REFERENCE,
7727: INVENTORY_ITEM_ID,
7728: ATTR_GROUP_INT_NAME,
7729: TRANSACTION_ID
7730: FROM EGO_ITM_USR_ATTR_INTRFC
7731: WHERE DATA_SET_ID = p_batch_id
7732: AND PROCESS_STATUS = 3.475;
7733:
7734: l_msg_text VARCHAR2(4000);

Line 7758: UPDATE EGO_ITM_USR_ATTR_INTRFC

7754: FETCH c_unmerged_rows BULK COLLECT INTO l_unmerged_row_idents LIMIT 1000;
7755: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Post - fetched '||l_unmerged_row_idents.Count||' rows, ');
7756:
7757: FORALL idx IN l_unmerged_row_idents.FIRST..l_unmerged_row_idents.LAST
7758: UPDATE EGO_ITM_USR_ATTR_INTRFC
7759: SET process_status = 3.475
7760: WHERE DATA_SET_ID = p_batch_id
7761: AND PROCESS_STATUS = p_process_status
7762: AND ROW_IDENTIFIER = l_unmerged_row_idents(idx);

Line 7784: ,'EGO_ITM_USR_ATTR_INTRFC'

7780: ,l_request_id
7781: ,i.TRANSACTION_ID
7782: ,l_msg_text
7783: ,'ATTR_GROUP_INT_NAME'
7784: ,'EGO_ITM_USR_ATTR_INTRFC'
7785: ,'INV_IOI_ERR'
7786: ,l_err_text);
7787: END LOOP;
7788: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Post - Done Logging errors for Errored out unmerged rows');

Line 7790: UPDATE EGO_ITM_USR_ATTR_INTRFC

7786: ,l_err_text);
7787: END LOOP;
7788: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Post - Done Logging errors for Errored out unmerged rows');
7789:
7790: UPDATE EGO_ITM_USR_ATTR_INTRFC
7791: SET
7792: PROCESS_STATUS = 3,
7793: REQUEST_ID = l_request_id
7794: WHERE DATA_SET_ID = p_batch_id

Line 7811: UPDATE EGO_ITM_USR_ATTR_INTRFC

7807: FETCH c_intf_recs BULK COLLECT INTO l_row_ids, l_row_idents LIMIT 1000;
7808: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Post - fetched '||l_unmerged_row_idents.Count||' rows, ');
7809:
7810: FORALL idx IN l_row_ids.FIRST..l_row_ids.LAST
7811: UPDATE EGO_ITM_USR_ATTR_INTRFC
7812: SET ROW_IDENTIFIER = l_row_idents(idx)
7813: WHERE ROWID = l_row_ids(idx);
7814: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Post - Updated - '||SQL%ROWCOUNT||' rows');
7815: EXIT WHEN c_intf_recs%NOTFOUND;

Line 7837: * are represented by only one row identifier in EGO_ITM_USR_ATTR_INTRFC

7833: END CLEAN_UP_UDA_ROW_IDENTS_POST;
7834:
7835: /*
7836: * This method cleans up UDA row identifiers, ensuring that all single attr groups
7837: * are represented by only one row identifier in EGO_ITM_USR_ATTR_INTRFC
7838: *
7839: * Helper procedure for resolve_child_entities
7840: */
7841: PROCEDURE CLEAN_UP_UDA_ROW_IDENTS( p_batch_id IN NUMBER,

Line 7867: * EGO_ITEM_PEOPLE_INTF, MTL_ITEM_CATEGORIES_INTERFACE, EGO_ITM_USR_ATTR_INTRFC etc.

7863:
7864: /*
7865: * This method populates the child entities with PK values.
7866: * This method populates the other interface tables like MTL_ITEM_REVISION_INTERFACE,
7867: * EGO_ITEM_PEOPLE_INTF, MTL_ITEM_CATEGORIES_INTERFACE, EGO_ITM_USR_ATTR_INTRFC etc.
7868: * with the inventory item id/number and organization id/code.
7869: */
7870: PROCEDURE Resolve_Child_Entities( p_data_set_id IN NUMBER
7871: , p_commit IN FLAG DEFAULT FND_API.G_TRUE

Line 8645: UPDATE EGO_ITM_USR_ATTR_INTRFC ATTRS

8641: AND MSII.ORGANIZATION_ID = l_org_id);
8642:
8643: Debug_Conc_Log('Resolve_Child_Entities - After resolving categories rows' );
8644: -- updating item_number, item_id from MSII table
8645: UPDATE EGO_ITM_USR_ATTR_INTRFC ATTRS
8646: SET (PROCESS_STATUS, TRANSACTION_TYPE, INVENTORY_ITEM_ID, ITEM_NUMBER, ITEM_CATALOG_GROUP_ID) =
8647: (SELECT
8648: 1,
8649: (CASE

Line 8679: UPDATE EGO_ITM_USR_ATTR_INTRFC ATTRS

8675: AND MSII.ORGANIZATION_ID = l_org_id);
8676:
8677: Debug_Conc_Log('Resolve_Child_Entities - After resolving user defined attrs rows' );
8678:
8679: UPDATE EGO_ITM_USR_ATTR_INTRFC ATTRS
8680: SET REVISION = (
8681: CASE (SELECT
8682: CASE
8683: WHEN MSII.CONFIRM_STATUS IN ('CMR', 'CCR', G_FAKE_CONF_STATUS_FLAG )

Line 9123: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI

9119: Debug_Conc_Log('Resolve_Child_Entities - After updating item people intf table for items that has XXref');
9120:
9121: -- updating the item user defined attributes interface
9122: l_sql := q'#
9123: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI
9124: SET (PROCESS_STATUS, TRANSACTION_TYPE, INVENTORY_ITEM_ID) =
9125: (SELECT
9126: 1,
9127: NVL(EIUAI.TRANSACTION_TYPE, 'SYNC'),

Line 9563: UPDATE EGO_ITM_USR_ATTR_INTRFC

9559: );
9560: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9561:
9562: -- updating item user defined attributes
9563: UPDATE EGO_ITM_USR_ATTR_INTRFC
9564: SET PROCESS_STATUS = 1
9565: WHERE ( INVENTORY_ITEM_ID = l_item_id
9566: OR ( ITEM_NUMBER = l_item_number
9567: AND INVENTORY_ITEM_ID IS NULL

Line 9670: UPDATE EGO_ITM_USR_ATTR_INTRFC

9666: );
9667: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9668:
9669: -- updating item user defined attributes
9670: UPDATE EGO_ITM_USR_ATTR_INTRFC
9671: SET PROCESS_STATUS = 1
9672: WHERE ITEM_NUMBER = l_item_number
9673: AND PROCESS_STATUS = 3
9674: AND DATA_SET_ID = p_batch_id

Line 9931: UPDATE EGO_ITM_USR_ATTR_INTRFC

9927: );
9928: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9929:
9930: -- updating item user defined attributes
9931: UPDATE EGO_ITM_USR_ATTR_INTRFC
9932: SET PROCESS_STATUS = 1
9933: WHERE SOURCE_SYSTEM_ID = l_ss_id
9934: AND SOURCE_SYSTEM_REFERENCE = l_ssr
9935: AND PROCESS_STATUS = 3

Line 10043: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

10039: -- their possible presence in other logical rows of the interface table --
10040: ------------------------------------------------------------------------------------------------
10041: FUNCTION GET_LATEST_EIUAI_REV_SS
10042: (
10043: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10044: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10045: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10046: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10047: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 10044: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE

10040: ------------------------------------------------------------------------------------------------
10041: FUNCTION GET_LATEST_EIUAI_REV_SS
10042: (
10043: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10044: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10045: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10046: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10047: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10048: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 10045: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE

10041: FUNCTION GET_LATEST_EIUAI_REV_SS
10042: (
10043: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10044: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10045: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10046: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10047: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10048: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10049: )

Line 10046: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

10042: (
10043: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10044: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10045: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10046: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10047: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10048: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10049: )
10050: RETURN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 10048: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

10044: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10045: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10046: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10047: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10048: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10049: )
10050: RETURN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10051: IS
10052: l_rev_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;

Line 10050: RETURN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

10046: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10047: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10048: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10049: )
10050: RETURN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10051: IS
10052: l_rev_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
10053: BEGIN
10054: IF p_do_processed_rows_flag = FND_API.G_TRUE THEN

Line 10052: l_rev_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;

10048: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10049: )
10050: RETURN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10051: IS
10052: l_rev_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
10053: BEGIN
10054: IF p_do_processed_rows_flag = FND_API.G_TRUE THEN
10055: SELECT MAX( EIUAI.REVISION ) INTO l_rev_code
10056: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

Line 10056: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

10052: l_rev_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
10053: BEGIN
10054: IF p_do_processed_rows_flag = FND_API.G_TRUE THEN
10055: SELECT MAX( EIUAI.REVISION ) INTO l_rev_code
10056: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
10057: WHERE EIUAI.SOURCE_SYSTEM_REFERENCE = p_source_system_reference
10058: AND EIUAI.SOURCE_SYSTEM_ID = p_source_system_id
10059: AND EIUAI.ORGANIZATION_ID = p_organization_id
10060: AND EIUAI.DATA_SET_ID = p_batch_id

Line 10083: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

10079: -- the aggregate function MAX always returns one (possibly null) row, so
10080: -- no need to check for the NO_DATA_FOUND exception, or initialize l_rev_code
10081: ELSE
10082: SELECT MAX( EIUAI.REVISION ) INTO l_rev_code
10083: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
10084: WHERE EIUAI.SOURCE_SYSTEM_REFERENCE = p_source_system_reference
10085: AND EIUAI.SOURCE_SYSTEM_ID = p_source_system_id
10086: AND EIUAI.ORGANIZATION_ID = p_organization_id
10087: AND EIUAI.DATA_SET_ID = p_batch_id

Line 10113: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

10109: END GET_LATEST_EIUAI_REV_SS;
10110:
10111: FUNCTION GET_LATEST_EIUAI_REV_PDH
10112: (
10113: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10114: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
10115: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
10116: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10117: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 10114: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE

10110:
10111: FUNCTION GET_LATEST_EIUAI_REV_PDH
10112: (
10113: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10114: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
10115: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
10116: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10117: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10118: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 10115: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE

10111: FUNCTION GET_LATEST_EIUAI_REV_PDH
10112: (
10113: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10114: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
10115: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
10116: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10117: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10118: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10119: )

Line 10116: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

10112: (
10113: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10114: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
10115: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
10116: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10117: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10118: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10119: )
10120: RETURN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 10118: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

10114: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
10115: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
10116: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10117: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10118: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10119: )
10120: RETURN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10121: IS
10122: l_rev_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;

Line 10120: RETURN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

10116: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10117: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10118: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10119: )
10120: RETURN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10121: IS
10122: l_rev_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
10123: l_sql_stmt VARCHAR2( 32000 );
10124: BEGIN

Line 10122: l_rev_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;

10118: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10119: )
10120: RETURN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10121: IS
10122: l_rev_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
10123: l_sql_stmt VARCHAR2( 32000 );
10124: BEGIN
10125: -- the aggregate function MAX always returns one (possibly null) row, so
10126: -- no need to check for the NO_DATA_FOUND exception, or initialize l_rev_code

Line 10133: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

10129: THEN
10130: IF p_do_processed_rows_flag = FND_API.G_TRUE THEN
10131: SELECT MAX( EIUAI.REVISION )
10132: INTO l_rev_code
10133: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
10134: WHERE EIUAI.ITEM_NUMBER = p_item_number
10135: AND EIUAI.ORGANIZATION_ID = p_organization_id
10136: AND EIUAI.DATA_SET_ID = p_batch_id
10137: AND EIUAI.REVISION IS NOT NULL

Line 10160: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

10156: -- no need to check for the NO_DATA_FOUND exception, or initialize l_rev_code
10157: ELSE
10158: SELECT MAX( EIUAI.REVISION )
10159: INTO l_rev_code
10160: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
10161: WHERE EIUAI.ITEM_NUMBER = p_item_number
10162: AND EIUAI.ORGANIZATION_ID = p_organization_id
10163: AND EIUAI.DATA_SET_ID = p_batch_id
10164: AND EIUAI.REVISION IS NOT NULL

Line 10188: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

10184: ELSE
10185: IF p_do_processed_rows_flag = FND_API.G_TRUE THEN
10186: SELECT MAX( EIUAI.REVISION )
10187: INTO l_rev_code
10188: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
10189: WHERE
10190: ( ( EIUAI.INVENTORY_ITEM_ID IS NULL
10191: AND EIUAI.ITEM_NUMBER = p_item_number
10192: )

Line 10220: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

10216: -- no need to check for the NO_DATA_FOUND exception, or initialize l_rev_code
10217: ELSE
10218: SELECT MAX( EIUAI.REVISION )
10219: INTO l_rev_code
10220: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
10221: WHERE
10222: ( ( EIUAI.INVENTORY_ITEM_ID IS NULL
10223: AND EIUAI.ITEM_NUMBER = p_item_number
10224: )

Line 10403: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

10399: -- display value, it returns the appropriate value column, based on the --
10400: -- p_attr_value_type parameter --
10401: --------------------------------------------------------------------------------------------
10402: FUNCTION GET_REV_USR_ATTR
10403: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10404: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10405: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10406: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10407: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 10404: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE

10400: -- p_attr_value_type parameter --
10401: --------------------------------------------------------------------------------------------
10402: FUNCTION GET_REV_USR_ATTR
10403: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10404: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10405: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10406: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10407: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10408: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 10405: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE

10401: --------------------------------------------------------------------------------------------
10402: FUNCTION GET_REV_USR_ATTR
10403: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10404: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10405: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10406: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10407: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10408: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10409: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 10406: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

10402: FUNCTION GET_REV_USR_ATTR
10403: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10404: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10405: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10406: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10407: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10408: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10409: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10410: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 10407: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

10403: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10404: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10405: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10406: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10407: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10408: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10409: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10410: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10411: , p_attr_value_type IN FLAG

Line 10408: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

10404: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10405: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10406: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10407: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10408: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10409: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10410: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10411: , p_attr_value_type IN FLAG
10412: )

Line 10409: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

10405: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10406: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10407: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10408: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10409: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10410: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10411: , p_attr_value_type IN FLAG
10412: )
10413: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE

Line 10410: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

10406: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10407: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10408: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10409: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10410: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10411: , p_attr_value_type IN FLAG
10412: )
10413: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE
10414: IS

Line 10413: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE

10409: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10410: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10411: , p_attr_value_type IN FLAG
10412: )
10413: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE
10414: IS
10415: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE;
10416: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
10417: BEGIN

Line 10415: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE;

10411: , p_attr_value_type IN FLAG
10412: )
10413: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE
10414: IS
10415: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE;
10416: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
10417: BEGIN
10418: l_return_value := null;
10419: l_revision_code := p_revision_code;

Line 10416: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;

10412: )
10413: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE
10414: IS
10415: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE;
10416: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
10417: BEGIN
10418: l_return_value := null;
10419: l_revision_code := p_revision_code;
10420:

Line 10440: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

10436: CASE p_attr_value_type
10437: -- text attr-type case
10438: WHEN G_TEXT_DATA_TYPE THEN
10439: SELECT NVL( EIUAI.ATTR_DISP_VALUE, EIUAI.ATTR_VALUE_STR ) INTO l_return_value
10440: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
10441: WHERE
10442: NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE ) = p_attr_group_type
10443: AND EIUAI.ATTR_GROUP_INT_NAME = p_attr_group_name
10444: AND EIUAI.ATTR_INT_NAME = p_attr_name

Line 10456: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

10452: -- end text attr-type case
10453: -- number attr-type case
10454: WHEN G_NUMBER_DATA_TYPE THEN
10455: SELECT NVL( EIUAI.ATTR_DISP_VALUE, TO_CHAR( EIUAI.ATTR_VALUE_NUM ) ) INTO l_return_value
10456: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
10457: WHERE
10458: NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE ) = p_attr_group_type
10459: AND EIUAI.ATTR_GROUP_INT_NAME = p_attr_group_name
10460: AND EIUAI.ATTR_INT_NAME = p_attr_name

Line 10473: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

10469: -- date attr-type case
10470: WHEN G_DATE_DATA_TYPE THEN
10471: -- XXX: which date format to use? what about date-time type vs date-type?
10472: SELECT NVL( EIUAI.ATTR_DISP_VALUE, TO_CHAR( EIUAI.ATTR_VALUE_DATE ) ) INTO l_return_value
10473: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
10474: WHERE
10475: NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE ) = p_attr_group_type
10476: AND EIUAI.ATTR_GROUP_INT_NAME = p_attr_group_name
10477: AND EIUAI.ATTR_INT_NAME = p_attr_name

Line 10499: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

10495: CASE p_attr_value_type
10496: -- text attr-type case
10497: WHEN G_TEXT_DATA_TYPE THEN
10498: SELECT NVL( EIUAI.ATTR_DISP_VALUE, EIUAI.ATTR_VALUE_STR ) INTO l_return_value
10499: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
10500: WHERE
10501: NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE ) = p_attr_group_type
10502: AND EIUAI.ATTR_GROUP_INT_NAME = p_attr_group_name
10503: AND EIUAI.ATTR_INT_NAME = p_attr_name

Line 10515: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

10511: -- end text attr-type case
10512: -- number attr-type case
10513: WHEN G_NUMBER_DATA_TYPE THEN
10514: SELECT NVL( EIUAI.ATTR_DISP_VALUE, TO_CHAR( EIUAI.ATTR_VALUE_NUM ) ) INTO l_return_value
10515: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
10516: WHERE
10517: NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE ) = p_attr_group_type
10518: AND EIUAI.ATTR_GROUP_INT_NAME = p_attr_group_name
10519: AND EIUAI.ATTR_INT_NAME = p_attr_name

Line 10532: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

10528: -- date attr-type case
10529: WHEN G_DATE_DATA_TYPE THEN
10530: -- XXX: which date format to use? what about date-time type vs date-type?
10531: SELECT NVL( EIUAI.ATTR_DISP_VALUE, TO_CHAR( EIUAI.ATTR_VALUE_DATE ) ) INTO l_return_value
10532: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
10533: WHERE
10534: NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE ) = p_attr_group_type
10535: AND EIUAI.ATTR_GROUP_INT_NAME = p_attr_group_name
10536: AND EIUAI.ATTR_INT_NAME = p_attr_name

Line 10565: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

10561: -- The assumption is that this will be called from a value set context ...
10562: ----------------------------------------------------------------------------------------------
10563: FUNCTION GET_REV_USR_ATTR_TO_CHAR
10564: (
10565: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10566: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
10567: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
10568: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10569: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 10566: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL

10562: ----------------------------------------------------------------------------------------------
10563: FUNCTION GET_REV_USR_ATTR_TO_CHAR
10564: (
10565: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10566: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
10567: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
10568: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10569: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10570: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 10567: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL

10563: FUNCTION GET_REV_USR_ATTR_TO_CHAR
10564: (
10565: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10566: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
10567: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
10568: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10569: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10570: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10571: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 10568: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

10564: (
10565: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10566: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
10567: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
10568: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10569: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10570: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10571: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10572: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 10569: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

10565: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10566: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
10567: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
10568: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10569: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10570: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10571: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10572: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10573: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 10570: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

10566: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
10567: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
10568: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10569: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10570: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10571: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10572: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10573: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10574: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 10571: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

10567: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
10568: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10569: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10570: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10571: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10572: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10573: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10574: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10575: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL

Line 10572: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

10568: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10569: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10570: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10571: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10572: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10573: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10574: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10575: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
10576: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL

Line 10574: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

10570: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10571: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10572: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10573: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10574: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10575: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
10576: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
10577: , p_use_pdh_keys_to_join IN BOOLEAN
10578: , p_get_value_col IN BOOLEAN

Line 10575: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL

10571: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10572: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10573: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10574: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10575: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
10576: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
10577: , p_use_pdh_keys_to_join IN BOOLEAN
10578: , p_get_value_col IN BOOLEAN
10579: , p_attr_type IN FLAG

Line 10576: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL

10572: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10573: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10574: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10575: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
10576: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
10577: , p_use_pdh_keys_to_join IN BOOLEAN
10578: , p_get_value_col IN BOOLEAN
10579: , p_attr_type IN FLAG
10580: , p_attr_miss_value IN BOOLEAN DEFAULT TRUE

Line 10582: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE

10578: , p_get_value_col IN BOOLEAN
10579: , p_attr_type IN FLAG
10580: , p_attr_miss_value IN BOOLEAN DEFAULT TRUE
10581: )
10582: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE
10583: IS
10584: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE;
10585: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
10586: l_sql_stmt VARCHAR2( 32000 );

Line 10584: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE;

10580: , p_attr_miss_value IN BOOLEAN DEFAULT TRUE
10581: )
10582: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE
10583: IS
10584: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE;
10585: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
10586: l_sql_stmt VARCHAR2( 32000 );
10587: l_do_procd_rows_sql VARCHAR2( 200 );
10588: l_join_sql VARCHAR2( 200 );

Line 10585: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;

10581: )
10582: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE
10583: IS
10584: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE;
10585: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
10586: l_sql_stmt VARCHAR2( 32000 );
10587: l_do_procd_rows_sql VARCHAR2( 200 );
10588: l_join_sql VARCHAR2( 200 );
10589: l_select_sql VARCHAR2( 200 );

Line 10692: ||' FROM EGO_ITM_USR_ATTR_INTRFC EIUAI '

10688: END;
10689:
10690: l_sql_stmt := '
10691: SELECT ' || l_select_sql
10692: ||' FROM EGO_ITM_USR_ATTR_INTRFC EIUAI '
10693: ||' WHERE '
10694: ||' NVL( EIUAI.ATTR_GROUP_TYPE, :default_attr_grp ) = :attr_grp_type'
10695: ||' AND EIUAI.ATTR_GROUP_INT_NAME = :attr_grp'
10696: ||' AND EIUAI.ATTR_INT_NAME = :attr '

Line 10760: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

10756: END GET_REV_USR_ATTR_TO_CHAR;
10757:
10758: FUNCTION GET_REV_USR_ATTR_SS_DISP
10759: (
10760: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10761: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10762: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10763: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10764: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 10761: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE

10757:
10758: FUNCTION GET_REV_USR_ATTR_SS_DISP
10759: (
10760: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10761: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10762: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10763: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10764: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10765: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 10762: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE

10758: FUNCTION GET_REV_USR_ATTR_SS_DISP
10759: (
10760: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10761: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10762: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10763: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10764: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10765: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10766: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 10763: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

10759: (
10760: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10761: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10762: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10763: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10764: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10765: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10766: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10767: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 10764: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

10760: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10761: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10762: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10763: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10764: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10765: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10766: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10767: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10768: , p_attr_type IN FLAG

Line 10765: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

10761: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10762: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10763: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10764: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10765: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10766: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10767: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10768: , p_attr_type IN FLAG
10769: , p_from_internal_column IN FLAG

Line 10766: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

10762: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10763: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10764: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10765: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10766: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10767: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10768: , p_attr_type IN FLAG
10769: , p_from_internal_column IN FLAG
10770: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 10767: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

10763: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10764: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10765: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10766: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10767: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10768: , p_attr_type IN FLAG
10769: , p_from_internal_column IN FLAG
10770: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10771: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 10771: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

10767: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10768: , p_attr_type IN FLAG
10769: , p_from_internal_column IN FLAG
10770: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10771: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10772: )
10773: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE
10774: IS
10775: l_get_value_col BOOLEAN := ( FND_API.G_TRUE = p_from_internal_column );

Line 10773: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE

10769: , p_from_internal_column IN FLAG
10770: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10771: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10772: )
10773: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE
10774: IS
10775: l_get_value_col BOOLEAN := ( FND_API.G_TRUE = p_from_internal_column );
10776: BEGIN
10777: RETURN GET_REV_USR_ATTR_TO_CHAR

Line 10798: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

10794: END;
10795:
10796: FUNCTION GET_REV_USR_ATTR_PDH_DISP
10797: (
10798: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10799: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
10800: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
10801: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10802: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 10799: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE

10795:
10796: FUNCTION GET_REV_USR_ATTR_PDH_DISP
10797: (
10798: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10799: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
10800: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
10801: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10802: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10803: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 10800: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE

10796: FUNCTION GET_REV_USR_ATTR_PDH_DISP
10797: (
10798: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10799: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
10800: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
10801: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10802: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10803: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10804: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 10801: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

10797: (
10798: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10799: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
10800: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
10801: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10802: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10803: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10804: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10805: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 10802: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

10798: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10799: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
10800: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
10801: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10802: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10803: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10804: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10805: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10806: , p_attr_type IN FLAG

Line 10803: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

10799: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
10800: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
10801: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10802: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10803: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10804: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10805: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10806: , p_attr_type IN FLAG
10807: , p_from_internal_column IN FLAG

Line 10804: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

10800: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
10801: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10802: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10803: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10804: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10805: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10806: , p_attr_type IN FLAG
10807: , p_from_internal_column IN FLAG
10808: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 10805: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

10801: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10802: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10803: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10804: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10805: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10806: , p_attr_type IN FLAG
10807: , p_from_internal_column IN FLAG
10808: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10809: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 10809: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

10805: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10806: , p_attr_type IN FLAG
10807: , p_from_internal_column IN FLAG
10808: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10809: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10810: )
10811: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE
10812: IS
10813: l_get_value_col BOOLEAN := ( FND_API.G_TRUE = p_from_internal_column );

Line 10811: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE

10807: , p_from_internal_column IN FLAG
10808: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10809: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10810: )
10811: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE
10812: IS
10813: l_get_value_col BOOLEAN := ( FND_API.G_TRUE = p_from_internal_column );
10814: BEGIN
10815: RETURN GET_REV_USR_ATTR_TO_CHAR

Line 10842: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

10838: -- in the interface table, merging in an attempted conversion of the display column content.
10839: ----------------------------------------------------------------------------------------------
10840: FUNCTION GET_REV_USR_ATTR_DATE
10841: (
10842: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10843: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
10844: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
10845: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10846: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 10843: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL

10839: ----------------------------------------------------------------------------------------------
10840: FUNCTION GET_REV_USR_ATTR_DATE
10841: (
10842: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10843: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
10844: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
10845: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10846: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10847: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 10844: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL

10840: FUNCTION GET_REV_USR_ATTR_DATE
10841: (
10842: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10843: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
10844: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
10845: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10846: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10847: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10848: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 10845: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

10841: (
10842: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10843: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
10844: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
10845: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10846: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10847: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10848: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10849: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 10846: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

10842: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10843: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
10844: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
10845: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10846: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10847: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10848: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10849: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10850: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 10847: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

10843: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
10844: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
10845: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10846: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10847: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10848: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10849: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10850: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10851: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 10848: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

10844: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
10845: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10846: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10847: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10848: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10849: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10850: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10851: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10852: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL

Line 10849: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

10845: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10846: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10847: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10848: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10849: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10850: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10851: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10852: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
10853: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL

Line 10851: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

10847: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10848: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10849: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10850: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10851: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10852: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
10853: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
10854: , p_use_pdh_keys_to_join IN BOOLEAN
10855: , p_get_value_column IN BOOLEAN

Line 10852: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL

10848: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10849: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10850: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10851: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10852: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
10853: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
10854: , p_use_pdh_keys_to_join IN BOOLEAN
10855: , p_get_value_column IN BOOLEAN
10856: )

Line 10853: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL

10849: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10850: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10851: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10852: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
10853: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
10854: , p_use_pdh_keys_to_join IN BOOLEAN
10855: , p_get_value_column IN BOOLEAN
10856: )
10857: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE

Line 10857: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE

10853: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
10854: , p_use_pdh_keys_to_join IN BOOLEAN
10855: , p_get_value_column IN BOOLEAN
10856: )
10857: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE
10858: IS
10859: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE;
10860: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
10861: l_sql_stmt VARCHAR2( 32000 );

Line 10859: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE;

10855: , p_get_value_column IN BOOLEAN
10856: )
10857: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE
10858: IS
10859: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE;
10860: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
10861: l_sql_stmt VARCHAR2( 32000 );
10862: l_do_procd_rows_sql VARCHAR2( 200 );
10863: l_join_sql VARCHAR2( 200 );

Line 10860: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;

10856: )
10857: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE
10858: IS
10859: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE;
10860: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
10861: l_sql_stmt VARCHAR2( 32000 );
10862: l_do_procd_rows_sql VARCHAR2( 200 );
10863: l_join_sql VARCHAR2( 200 );
10864: l_select_sql VARCHAR2( 300 );

Line 10941: ||' FROM EGO_ITM_USR_ATTR_INTRFC EIUAI '

10937: END;
10938:
10939: l_sql_stmt := '
10940: SELECT ' || l_select_sql
10941: ||' FROM EGO_ITM_USR_ATTR_INTRFC EIUAI '
10942: ||' WHERE '
10943: ||' NVL( EIUAI.ATTR_GROUP_TYPE, :default_attr_grp ) = :attr_grp_type'
10944: ||' AND EIUAI.ATTR_GROUP_INT_NAME = :attr_grp'
10945: ||' AND EIUAI.ATTR_INT_NAME = :attr '

Line 11011: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

11007: END GET_REV_USR_ATTR_DATE;
11008:
11009: FUNCTION GET_REV_USR_ATTR_SS_DDATE
11010: (
11011: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11012: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11013: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11014: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11015: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 11012: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE

11008:
11009: FUNCTION GET_REV_USR_ATTR_SS_DDATE
11010: (
11011: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11012: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11013: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11014: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11015: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11016: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 11013: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE

11009: FUNCTION GET_REV_USR_ATTR_SS_DDATE
11010: (
11011: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11012: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11013: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11014: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11015: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11016: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11017: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 11014: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

11010: (
11011: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11012: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11013: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11014: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11015: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11016: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11017: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11018: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 11015: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

11011: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11012: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11013: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11014: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11015: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11016: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11017: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11018: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11019: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 11016: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

11012: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11013: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11014: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11015: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11016: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11017: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11018: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11019: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11020: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 11017: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

11013: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11014: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11015: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11016: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11017: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11018: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11019: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11020: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11021: )

Line 11018: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

11014: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11015: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11016: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11017: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11018: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11019: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11020: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11021: )
11022: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS

Line 11020: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

11016: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11017: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11018: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11019: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11020: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11021: )
11022: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS
11023: BEGIN
11024: RETURN GET_REV_USR_ATTR_DATE

Line 11022: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS

11018: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11019: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11020: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11021: )
11022: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS
11023: BEGIN
11024: RETURN GET_REV_USR_ATTR_DATE
11025: (
11026: p_batch_id => p_batch_id

Line 11042: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

11038: );
11039: END GET_REV_USR_ATTR_SS_DDATE;
11040:
11041: FUNCTION GET_REV_USR_ATTR_PDH_DDATE
11042: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11043: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11044: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11045: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11046: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 11043: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE

11039: END GET_REV_USR_ATTR_SS_DDATE;
11040:
11041: FUNCTION GET_REV_USR_ATTR_PDH_DDATE
11042: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11043: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11044: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11045: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11046: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11047: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 11044: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE

11040:
11041: FUNCTION GET_REV_USR_ATTR_PDH_DDATE
11042: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11043: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11044: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11045: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11046: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11047: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11048: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 11045: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

11041: FUNCTION GET_REV_USR_ATTR_PDH_DDATE
11042: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11043: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11044: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11045: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11046: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11047: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11048: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11049: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 11046: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

11042: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11043: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11044: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11045: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11046: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11047: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11048: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11049: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11050: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 11047: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

11043: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11044: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11045: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11046: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11047: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11048: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11049: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11050: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11051: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 11048: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

11044: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11045: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11046: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11047: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11048: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11049: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11050: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11051: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11052: )

Line 11049: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

11045: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11046: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11047: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11048: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11049: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11050: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11051: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11052: )
11053: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS

Line 11051: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

11047: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11048: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11049: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11050: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11051: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11052: )
11053: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS
11054: BEGIN
11055: RETURN GET_REV_USR_ATTR_DATE

Line 11053: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS

11049: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11050: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11051: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11052: )
11053: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS
11054: BEGIN
11055: RETURN GET_REV_USR_ATTR_DATE
11056: (
11057: p_batch_id => p_batch_id

Line 11078: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

11074: -- Returns the string value of the specified revision attribute, if the attribute is present
11075: -- in the interface table, merging in an attempted conversion of the display column content.
11076: ----------------------------------------------------------------------------------------------
11077: FUNCTION GET_REV_USR_ATTR_STR
11078: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11079: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
11080: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
11081: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11082: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 11079: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL

11075: -- in the interface table, merging in an attempted conversion of the display column content.
11076: ----------------------------------------------------------------------------------------------
11077: FUNCTION GET_REV_USR_ATTR_STR
11078: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11079: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
11080: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
11081: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11082: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11083: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 11080: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL

11076: ----------------------------------------------------------------------------------------------
11077: FUNCTION GET_REV_USR_ATTR_STR
11078: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11079: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
11080: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
11081: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11082: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11083: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11084: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 11081: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

11077: FUNCTION GET_REV_USR_ATTR_STR
11078: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11079: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
11080: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
11081: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11082: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11083: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11084: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11085: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 11082: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

11078: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11079: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
11080: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
11081: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11082: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11083: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11084: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11085: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11086: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 11083: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

11079: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
11080: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
11081: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11082: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11083: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11084: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11085: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11086: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11087: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 11084: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

11080: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
11081: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11082: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11083: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11084: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11085: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11086: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11087: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11088: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL

Line 11085: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

11081: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11082: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11083: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11084: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11085: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11086: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11087: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11088: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
11089: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL

Line 11087: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

11083: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11084: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11085: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11086: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11087: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11088: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
11089: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
11090: , p_use_pdh_keys_to_join IN BOOLEAN
11091: , p_get_value_column IN BOOLEAN

Line 11088: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL

11084: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11085: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11086: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11087: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11088: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
11089: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
11090: , p_use_pdh_keys_to_join IN BOOLEAN
11091: , p_get_value_column IN BOOLEAN
11092: )

Line 11089: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL

11085: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11086: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11087: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11088: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
11089: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
11090: , p_use_pdh_keys_to_join IN BOOLEAN
11091: , p_get_value_column IN BOOLEAN
11092: )
11093: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE

Line 11093: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE

11089: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
11090: , p_use_pdh_keys_to_join IN BOOLEAN
11091: , p_get_value_column IN BOOLEAN
11092: )
11093: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE
11094: IS
11095: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE;
11096: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
11097: l_sql_stmt VARCHAR2( 32000 );

Line 11095: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE;

11091: , p_get_value_column IN BOOLEAN
11092: )
11093: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE
11094: IS
11095: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE;
11096: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
11097: l_sql_stmt VARCHAR2( 32000 );
11098: l_do_procd_rows_sql VARCHAR2( 200 );
11099: l_join_sql VARCHAR2( 200 );

Line 11096: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;

11092: )
11093: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE
11094: IS
11095: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE;
11096: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
11097: l_sql_stmt VARCHAR2( 32000 );
11098: l_do_procd_rows_sql VARCHAR2( 200 );
11099: l_join_sql VARCHAR2( 200 );
11100: l_select_sql VARCHAR2( 200 );

Line 11173: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

11169:
11170: l_sql_stmt := '
11171: SELECT ' || l_select_sql
11172: || '
11173: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
11174: WHERE
11175: NVL( EIUAI.ATTR_GROUP_TYPE, :default_attr_grp ) = :attr_grp_type
11176: AND EIUAI.ATTR_GROUP_INT_NAME = :attr_grp
11177: AND EIUAI.ATTR_INT_NAME = :attr '

Line 11244: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

11240: END GET_REV_USR_ATTR_STR;
11241:
11242: FUNCTION GET_REV_USR_ATTR_SS_DSTR
11243: (
11244: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11245: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11246: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11247: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11248: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 11245: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE

11241:
11242: FUNCTION GET_REV_USR_ATTR_SS_DSTR
11243: (
11244: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11245: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11246: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11247: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11248: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11249: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 11246: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE

11242: FUNCTION GET_REV_USR_ATTR_SS_DSTR
11243: (
11244: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11245: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11246: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11247: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11248: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11249: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11250: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 11247: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

11243: (
11244: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11245: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11246: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11247: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11248: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11249: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11250: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11251: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 11248: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

11244: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11245: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11246: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11247: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11248: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11249: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11250: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11251: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11252: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 11249: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

11245: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11246: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11247: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11248: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11249: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11250: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11251: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11252: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11253: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 11250: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

11246: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11247: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11248: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11249: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11250: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11251: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11252: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11253: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11254: )

Line 11251: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

11247: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11248: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11249: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11250: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11251: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11252: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11253: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11254: )
11255: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS

Line 11253: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

11249: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11250: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11251: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11252: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11253: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11254: )
11255: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS
11256: BEGIN
11257: RETURN GET_REV_USR_ATTR_STR

Line 11255: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS

11251: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11252: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11253: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11254: )
11255: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS
11256: BEGIN
11257: RETURN GET_REV_USR_ATTR_STR
11258: (
11259: p_batch_id => p_batch_id

Line 11276: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

11272: END GET_REV_USR_ATTR_SS_DSTR;
11273:
11274: FUNCTION GET_REV_USR_ATTR_PDH_DSTR
11275: (
11276: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11277: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11278: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11279: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11280: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 11277: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE

11273:
11274: FUNCTION GET_REV_USR_ATTR_PDH_DSTR
11275: (
11276: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11277: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11278: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11279: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11280: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11281: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 11278: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE

11274: FUNCTION GET_REV_USR_ATTR_PDH_DSTR
11275: (
11276: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11277: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11278: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11279: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11280: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11281: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11282: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 11279: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

11275: (
11276: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11277: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11278: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11279: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11280: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11281: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11282: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11283: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 11280: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

11276: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11277: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11278: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11279: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11280: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11281: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11282: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11283: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11284: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 11281: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

11277: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11278: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11279: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11280: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11281: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11282: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11283: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11284: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11285: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 11282: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

11278: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11279: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11280: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11281: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11282: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11283: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11284: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11285: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11286: )

Line 11283: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

11279: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11280: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11281: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11282: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11283: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11284: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11285: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11286: )
11287: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS

Line 11285: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

11281: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11282: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11283: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11284: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11285: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11286: )
11287: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS
11288: BEGIN
11289: RETURN GET_REV_USR_ATTR_STR

Line 11287: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS

11283: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11284: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11285: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11286: )
11287: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS
11288: BEGIN
11289: RETURN GET_REV_USR_ATTR_STR
11290: (
11291: p_batch_id => p_batch_id

Line 11313: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

11309: -- in the interface table, merging in an attempted conversion of the display column content.
11310: --------------------------------------------------------------------------------------------
11311: FUNCTION GET_REV_USR_ATTR_NUM
11312: (
11313: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11314: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
11315: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
11316: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11317: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 11314: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL

11310: --------------------------------------------------------------------------------------------
11311: FUNCTION GET_REV_USR_ATTR_NUM
11312: (
11313: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11314: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
11315: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
11316: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11317: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11318: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 11315: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL

11311: FUNCTION GET_REV_USR_ATTR_NUM
11312: (
11313: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11314: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
11315: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
11316: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11317: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11318: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11319: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 11316: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

11312: (
11313: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11314: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
11315: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
11316: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11317: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11318: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11319: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11320: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 11317: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

11313: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11314: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
11315: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
11316: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11317: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11318: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11319: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11320: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11321: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE DEFAULT NULL

Line 11318: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

11314: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
11315: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
11316: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11317: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11318: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11319: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11320: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11321: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE DEFAULT NULL
11322: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 11319: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

11315: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
11316: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11317: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11318: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11319: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11320: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11321: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE DEFAULT NULL
11322: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11323: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 11320: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

11316: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11317: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11318: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11319: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11320: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11321: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE DEFAULT NULL
11322: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11323: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11324: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL

Line 11321: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE DEFAULT NULL

11317: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11318: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11319: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11320: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11321: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE DEFAULT NULL
11322: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11323: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11324: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
11325: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL

Line 11323: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

11319: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11320: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11321: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE DEFAULT NULL
11322: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11323: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11324: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
11325: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
11326: , p_use_pdh_keys_to_join IN BOOLEAN
11327: , p_get_value_column IN BOOLEAN

Line 11324: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL

11320: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11321: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE DEFAULT NULL
11322: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11323: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11324: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
11325: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
11326: , p_use_pdh_keys_to_join IN BOOLEAN
11327: , p_get_value_column IN BOOLEAN
11328: )

Line 11325: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL

11321: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE DEFAULT NULL
11322: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11323: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11324: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
11325: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
11326: , p_use_pdh_keys_to_join IN BOOLEAN
11327: , p_get_value_column IN BOOLEAN
11328: )
11329: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE

Line 11329: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE

11325: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
11326: , p_use_pdh_keys_to_join IN BOOLEAN
11327: , p_get_value_column IN BOOLEAN
11328: )
11329: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE
11330: IS
11331: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE;
11332: l_num_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE;
11333: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;

Line 11331: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE;

11327: , p_get_value_column IN BOOLEAN
11328: )
11329: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE
11330: IS
11331: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE;
11332: l_num_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE;
11333: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
11334: l_sql_stmt VARCHAR2( 32000 );
11335: l_do_procd_rows_sql VARCHAR2( 200 );

Line 11332: l_num_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE;

11328: )
11329: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE
11330: IS
11331: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE;
11332: l_num_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE;
11333: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
11334: l_sql_stmt VARCHAR2( 32000 );
11335: l_do_procd_rows_sql VARCHAR2( 200 );
11336: l_join_sql VARCHAR2( 200 );

Line 11333: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;

11329: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE
11330: IS
11331: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE;
11332: l_num_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE;
11333: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
11334: l_sql_stmt VARCHAR2( 32000 );
11335: l_do_procd_rows_sql VARCHAR2( 200 );
11336: l_join_sql VARCHAR2( 200 );
11337: l_select_sql VARCHAR2( 200 );

Line 11340: l_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE;

11336: l_join_sql VARCHAR2( 200 );
11337: l_select_sql VARCHAR2( 200 );
11338: l_do_processed_rows BOOLEAN;
11339:
11340: l_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE;
11341: l_uom_disp_value EGO_ITM_USR_ATTR_INTRFC.ATTR_UOM_DISP_VALUE%TYPE;
11342: l_uom_rate NUMBER := 1;
11343: BEGIN
11344: l_return_value := null; -- 'default';

Line 11341: l_uom_disp_value EGO_ITM_USR_ATTR_INTRFC.ATTR_UOM_DISP_VALUE%TYPE;

11337: l_select_sql VARCHAR2( 200 );
11338: l_do_processed_rows BOOLEAN;
11339:
11340: l_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE;
11341: l_uom_disp_value EGO_ITM_USR_ATTR_INTRFC.ATTR_UOM_DISP_VALUE%TYPE;
11342: l_uom_rate NUMBER := 1;
11343: BEGIN
11344: l_return_value := null; -- 'default';
11345:

Line 11418: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

11414: l_sql_stmt := '
11415: SELECT ' || l_select_sql
11416: || ', ATTR_VALUE_UOM
11417: , ATTR_UOM_DISP_VALUE
11418: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
11419: WHERE
11420: NVL( EIUAI.ATTR_GROUP_TYPE, :default_attr_grp ) = :attr_grp_type
11421: AND EIUAI.ATTR_GROUP_INT_NAME = :attr_grp
11422: AND EIUAI.ATTR_INT_NAME = :attr '

Line 11496: , p_to_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE

11492: -- If both of the from_uom params are null, no attempt to make the conversion is --
11493: -- performed. --
11494: --------------------------------------------------------------------------------------------
11495: FUNCTION WRAPPED_TO_UOM( p_val NUMBER
11496: , p_to_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11497: , p_from_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11498: , p_from_uom_value EGO_ITM_USR_ATTR_INTRFC.ATTR_UOM_DISP_VALUE%TYPE
11499: , p_inventory_item_id EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
11500: )

Line 11497: , p_from_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE

11493: -- performed. --
11494: --------------------------------------------------------------------------------------------
11495: FUNCTION WRAPPED_TO_UOM( p_val NUMBER
11496: , p_to_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11497: , p_from_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11498: , p_from_uom_value EGO_ITM_USR_ATTR_INTRFC.ATTR_UOM_DISP_VALUE%TYPE
11499: , p_inventory_item_id EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
11500: )
11501: RETURN NUMBER IS

Line 11498: , p_from_uom_value EGO_ITM_USR_ATTR_INTRFC.ATTR_UOM_DISP_VALUE%TYPE

11494: --------------------------------------------------------------------------------------------
11495: FUNCTION WRAPPED_TO_UOM( p_val NUMBER
11496: , p_to_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11497: , p_from_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11498: , p_from_uom_value EGO_ITM_USR_ATTR_INTRFC.ATTR_UOM_DISP_VALUE%TYPE
11499: , p_inventory_item_id EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
11500: )
11501: RETURN NUMBER IS
11502: l_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE := p_from_uom_code;

Line 11499: , p_inventory_item_id EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL

11495: FUNCTION WRAPPED_TO_UOM( p_val NUMBER
11496: , p_to_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11497: , p_from_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11498: , p_from_uom_value EGO_ITM_USR_ATTR_INTRFC.ATTR_UOM_DISP_VALUE%TYPE
11499: , p_inventory_item_id EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
11500: )
11501: RETURN NUMBER IS
11502: l_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE := p_from_uom_code;
11503: l_uom_rate NUMBER;

Line 11502: l_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE := p_from_uom_code;

11498: , p_from_uom_value EGO_ITM_USR_ATTR_INTRFC.ATTR_UOM_DISP_VALUE%TYPE
11499: , p_inventory_item_id EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
11500: )
11501: RETURN NUMBER IS
11502: l_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE := p_from_uom_code;
11503: l_uom_rate NUMBER;
11504: BEGIN
11505: IF p_val IS NULL
11506: OR p_val = 0

Line 11540: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

11536: END WRAPPED_TO_UOM;
11537:
11538: FUNCTION GET_REV_USR_ATTR_SS_DNUM
11539: (
11540: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11541: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11542: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11543: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11544: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 11541: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE

11537:
11538: FUNCTION GET_REV_USR_ATTR_SS_DNUM
11539: (
11540: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11541: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11542: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11543: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11544: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11545: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 11542: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE

11538: FUNCTION GET_REV_USR_ATTR_SS_DNUM
11539: (
11540: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11541: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11542: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11543: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11544: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11545: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11546: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 11543: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

11539: (
11540: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11541: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11542: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11543: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11544: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11545: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11546: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11547: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 11544: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

11540: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11541: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11542: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11543: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11544: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11545: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11546: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11547: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11548: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE

Line 11545: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

11541: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11542: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11543: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11544: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11545: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11546: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11547: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11548: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11549: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 11546: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

11542: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11543: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11544: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11545: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11546: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11547: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11548: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11549: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11550: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 11547: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

11543: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11544: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11545: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11546: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11547: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11548: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11549: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11550: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11551: )

Line 11548: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE

11544: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11545: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11546: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11547: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11548: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11549: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11550: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11551: )
11552: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS

Line 11550: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

11546: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11547: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11548: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11549: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11550: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11551: )
11552: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS
11553: BEGIN
11554: RETURN GET_REV_USR_ATTR_NUM

Line 11552: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS

11548: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11549: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11550: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11551: )
11552: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS
11553: BEGIN
11554: RETURN GET_REV_USR_ATTR_NUM
11555: (
11556: p_batch_id => p_batch_id

Line 11574: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

11570: END GET_REV_USR_ATTR_SS_DNUM;
11571:
11572: FUNCTION GET_REV_USR_ATTR_PDH_DNUM
11573: (
11574: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11575: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11576: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11577: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11578: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 11575: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE

11571:
11572: FUNCTION GET_REV_USR_ATTR_PDH_DNUM
11573: (
11574: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11575: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11576: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11577: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11578: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11579: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 11576: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE

11572: FUNCTION GET_REV_USR_ATTR_PDH_DNUM
11573: (
11574: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11575: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11576: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11577: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11578: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11579: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11580: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 11577: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

11573: (
11574: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11575: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11576: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11577: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11578: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11579: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11580: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11581: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 11578: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

11574: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11575: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11576: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11577: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11578: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11579: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11580: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11581: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11582: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE

Line 11579: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

11575: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11576: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11577: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11578: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11579: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11580: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11581: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11582: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11583: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 11580: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

11576: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11577: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11578: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11579: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11580: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11581: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11582: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11583: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11584: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 11581: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

11577: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11578: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11579: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11580: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11581: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11582: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11583: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11584: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11585: )

Line 11582: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE

11578: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11579: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11580: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11581: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11582: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11583: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11584: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11585: )
11586: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS

Line 11584: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

11580: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11581: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11582: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11583: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11584: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11585: )
11586: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS
11587: BEGIN
11588: RETURN GET_REV_USR_ATTR_NUM

Line 11586: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS

11582: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11583: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11584: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11585: )
11586: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS
11587: BEGIN
11588: RETURN GET_REV_USR_ATTR_NUM
11589: (
11590: p_batch_id => p_batch_id

Line 11613: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

11609: -- in the interface table.
11610: --------------------------------------------------------------------------------------------
11611: FUNCTION GET_REV_USR_ATTR_SS_VSTR
11612: (
11613: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11614: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11615: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11616: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11617: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 11614: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE

11610: --------------------------------------------------------------------------------------------
11611: FUNCTION GET_REV_USR_ATTR_SS_VSTR
11612: (
11613: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11614: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11615: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11616: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11617: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11618: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 11615: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE

11611: FUNCTION GET_REV_USR_ATTR_SS_VSTR
11612: (
11613: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11614: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11615: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11616: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11617: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11618: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11619: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 11616: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

11612: (
11613: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11614: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11615: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11616: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11617: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11618: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11619: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11620: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 11617: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

11613: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11614: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11615: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11616: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11617: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11618: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11619: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11620: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11621: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 11618: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

11614: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11615: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11616: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11617: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11618: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11619: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11620: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11621: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11622: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 11619: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

11615: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11616: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11617: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11618: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11619: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11620: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11621: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11622: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11623: )

Line 11620: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

11616: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11617: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11618: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11619: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11620: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11621: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11622: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11623: )
11624: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS

Line 11622: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

11618: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11619: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11620: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11621: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11622: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11623: )
11624: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS
11625: BEGIN
11626: RETURN GET_REV_USR_ATTR_STR

Line 11624: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS

11620: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11621: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11622: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11623: )
11624: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS
11625: BEGIN
11626: RETURN GET_REV_USR_ATTR_STR
11627: (
11628: p_batch_id => p_batch_id

Line 11645: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

11641: END GET_REV_USR_ATTR_SS_VSTR;
11642:
11643: FUNCTION GET_REV_USR_ATTR_PDH_VSTR
11644: (
11645: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11646: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11647: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11648: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11649: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 11646: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE

11642:
11643: FUNCTION GET_REV_USR_ATTR_PDH_VSTR
11644: (
11645: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11646: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11647: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11648: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11649: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11650: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 11647: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE

11643: FUNCTION GET_REV_USR_ATTR_PDH_VSTR
11644: (
11645: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11646: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11647: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11648: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11649: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11650: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11651: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 11648: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

11644: (
11645: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11646: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11647: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11648: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11649: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11650: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11651: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11652: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 11649: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

11645: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11646: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11647: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11648: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11649: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11650: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11651: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11652: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11653: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 11650: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

11646: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11647: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11648: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11649: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11650: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11651: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11652: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11653: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11654: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 11651: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

11647: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11648: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11649: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11650: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11651: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11652: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11653: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11654: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11655: )

Line 11652: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

11648: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11649: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11650: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11651: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11652: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11653: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11654: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11655: )
11656: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS

Line 11654: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

11650: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11651: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11652: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11653: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11654: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11655: )
11656: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS
11657: BEGIN
11658: RETURN GET_REV_USR_ATTR_STR

Line 11656: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS

11652: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11653: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11654: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11655: )
11656: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS
11657: BEGIN
11658: RETURN GET_REV_USR_ATTR_STR
11659: (
11660: p_batch_id => p_batch_id

Line 11682: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

11678: -- in the interface table.
11679: --------------------------------------------------------------------------------------------
11680: FUNCTION GET_REV_USR_ATTR_SS_VDATE
11681: (
11682: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11683: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11684: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11685: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11686: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 11683: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE

11679: --------------------------------------------------------------------------------------------
11680: FUNCTION GET_REV_USR_ATTR_SS_VDATE
11681: (
11682: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11683: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11684: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11685: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11686: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11687: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 11684: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE

11680: FUNCTION GET_REV_USR_ATTR_SS_VDATE
11681: (
11682: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11683: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11684: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11685: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11686: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11687: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11688: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 11685: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

11681: (
11682: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11683: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11684: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11685: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11686: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11687: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11688: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11689: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 11686: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

11682: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11683: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11684: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11685: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11686: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11687: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11688: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11689: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11690: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 11687: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

11683: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11684: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11685: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11686: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11687: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11688: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11689: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11690: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11691: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 11688: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

11684: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11685: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11686: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11687: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11688: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11689: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11690: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11691: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11692: )

Line 11689: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

11685: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11686: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11687: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11688: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11689: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11690: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11691: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11692: )
11693: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS

Line 11691: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

11687: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11688: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11689: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11690: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11691: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11692: )
11693: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS
11694: BEGIN
11695: RETURN GET_REV_USR_ATTR_DATE

Line 11693: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS

11689: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11690: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11691: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11692: )
11693: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS
11694: BEGIN
11695: RETURN GET_REV_USR_ATTR_DATE
11696: (
11697: p_batch_id => p_batch_id

Line 11714: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

11710: END GET_REV_USR_ATTR_SS_VDATE;
11711:
11712: FUNCTION GET_REV_USR_ATTR_PDH_VDATE
11713: (
11714: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11715: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11716: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11717: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11718: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 11715: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE

11711:
11712: FUNCTION GET_REV_USR_ATTR_PDH_VDATE
11713: (
11714: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11715: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11716: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11717: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11718: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11719: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 11716: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE

11712: FUNCTION GET_REV_USR_ATTR_PDH_VDATE
11713: (
11714: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11715: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11716: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11717: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11718: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11719: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11720: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 11717: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

11713: (
11714: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11715: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11716: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11717: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11718: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11719: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11720: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11721: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 11718: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

11714: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11715: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11716: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11717: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11718: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11719: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11720: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11721: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11722: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 11719: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

11715: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11716: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11717: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11718: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11719: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11720: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11721: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11722: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11723: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 11720: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

11716: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11717: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11718: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11719: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11720: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11721: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11722: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11723: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11724: )

Line 11721: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

11717: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11718: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11719: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11720: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11721: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11722: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11723: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11724: )
11725: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS

Line 11723: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

11719: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11720: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11721: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11722: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11723: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11724: )
11725: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS
11726: BEGIN
11727: RETURN GET_REV_USR_ATTR_DATE

Line 11725: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS

11721: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11722: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11723: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11724: )
11725: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS
11726: BEGIN
11727: RETURN GET_REV_USR_ATTR_DATE
11728: (
11729: p_batch_id => p_batch_id

Line 11752: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

11748: -- p_output_uom_code parameter is ignored (no uom conversions performed)
11749: --------------------------------------------------------------------------------------------
11750: FUNCTION GET_REV_USR_ATTR_SS_VNUM
11751: (
11752: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11753: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11754: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11755: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11756: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 11753: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE

11749: --------------------------------------------------------------------------------------------
11750: FUNCTION GET_REV_USR_ATTR_SS_VNUM
11751: (
11752: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11753: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11754: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11755: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11756: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11757: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 11754: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE

11750: FUNCTION GET_REV_USR_ATTR_SS_VNUM
11751: (
11752: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11753: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11754: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11755: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11756: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11757: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11758: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 11755: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

11751: (
11752: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11753: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11754: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11755: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11756: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11757: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11758: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11759: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 11756: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

11752: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11753: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11754: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11755: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11756: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11757: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11758: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11759: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11760: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE

Line 11757: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

11753: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11754: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11755: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11756: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11757: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11758: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11759: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11760: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11761: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 11758: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

11754: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11755: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11756: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11757: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11758: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11759: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11760: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11761: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11762: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 11759: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

11755: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11756: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11757: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11758: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11759: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11760: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11761: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11762: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11763: )

Line 11760: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE

11756: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11757: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11758: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11759: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11760: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11761: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11762: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11763: )
11764: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS

Line 11762: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

11758: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11759: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11760: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11761: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11762: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11763: )
11764: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS
11765: BEGIN
11766: RETURN GET_REV_USR_ATTR_NUM

Line 11764: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS

11760: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11761: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11762: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11763: )
11764: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS
11765: BEGIN
11766: RETURN GET_REV_USR_ATTR_NUM
11767: (
11768: p_batch_id => p_batch_id

Line 11786: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

11782: END GET_REV_USR_ATTR_SS_VNUM;
11783:
11784: FUNCTION GET_REV_USR_ATTR_PDH_VNUM
11785: (
11786: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11787: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11788: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11789: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11790: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 11787: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE

11783:
11784: FUNCTION GET_REV_USR_ATTR_PDH_VNUM
11785: (
11786: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11787: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11788: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11789: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11790: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11791: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 11788: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE

11784: FUNCTION GET_REV_USR_ATTR_PDH_VNUM
11785: (
11786: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11787: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11788: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11789: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11790: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11791: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11792: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 11789: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

11785: (
11786: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11787: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11788: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11789: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11790: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11791: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11792: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11793: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 11790: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

11786: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11787: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11788: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11789: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11790: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11791: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11792: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11793: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11794: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE

Line 11791: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

11787: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11788: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11789: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11790: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11791: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11792: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11793: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11794: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11795: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 11792: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

11788: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11789: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11790: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11791: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11792: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11793: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11794: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11795: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11796: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 11793: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

11789: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11790: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11791: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11792: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11793: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11794: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11795: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11796: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11797: )

Line 11794: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE

11790: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11791: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11792: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11793: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11794: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11795: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11796: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11797: )
11798: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS

Line 11796: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

11792: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11793: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11794: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11795: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11796: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11797: )
11798: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS
11799: BEGIN
11800: RETURN GET_REV_USR_ATTR_NUM

Line 11798: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS

11794: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11795: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11796: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11797: )
11798: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS
11799: BEGIN
11800: RETURN GET_REV_USR_ATTR_NUM
11801: (
11802: p_batch_id => p_batch_id

Line 11926: -- EGO_ITM_USR_ATTR_INTRFC --

11922: AND SOURCE_SYSTEM_REFERENCE = p_src_system_ref
11923: AND PROCESS_FLAG = 0;
11924:
11925: -----------------------------
11926: -- EGO_ITM_USR_ATTR_INTRFC --
11927: -----------------------------
11928: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI
11929: SET ORGANIZATION_ID =
11930: NVL(ORGANIZATION_ID,

Line 11928: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI

11924:
11925: -----------------------------
11926: -- EGO_ITM_USR_ATTR_INTRFC --
11927: -----------------------------
11928: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI
11929: SET ORGANIZATION_ID =
11930: NVL(ORGANIZATION_ID,
11931: (SELECT MP.ORGANIZATION_ID
11932: FROM MTL_PARAMETERS MP

Line 12052: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

12048: -- MSI interface, and finally, the user-defined attributes interface table. --
12049: ------------------------------------------------------------------------------------------
12050: FUNCTION GET_LATEST_REVISION_FUNC
12051: (
12052: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
12053: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
12054: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
12055: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
12056: )

Line 12053: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE

12049: ------------------------------------------------------------------------------------------
12050: FUNCTION GET_LATEST_REVISION_FUNC
12051: (
12052: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
12053: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
12054: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
12055: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
12056: )
12057: RETURN VARCHAR2

Line 12054: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE

12050: FUNCTION GET_LATEST_REVISION_FUNC
12051: (
12052: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
12053: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
12054: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
12055: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
12056: )
12057: RETURN VARCHAR2
12058: IS

Line 12055: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

12051: (
12052: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
12053: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
12054: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
12055: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
12056: )
12057: RETURN VARCHAR2
12058: IS
12059: