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

APPS.EGO_IMPORT_PVT dependencies on 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_SSXREF_IS_NULL_04'--bug 11894684, replace 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_SSXID_INVALID_04'--bug 11894684, replace 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 705: -- checking whether stats needs to be collected on EGO_ITM_USR_ATTR_INTRFC

701: As mentioned in the note 1208945.1 and suggested by performance team,
702: for any performance issues we need to gather stats manualy so no need to gather stats in the code.
703: */
704: /*
705: -- checking whether stats needs to be collected on EGO_ITM_USR_ATTR_INTRFC
706: SELECT COUNT(1) INTO l_records
707: FROM EGO_ITM_USR_ATTR_INTRFC
708: WHERE DATA_SET_ID = p_data_set_id;
709:

Line 707: FROM EGO_ITM_USR_ATTR_INTRFC

703: */
704: /*
705: -- checking whether stats needs to be collected on EGO_ITM_USR_ATTR_INTRFC
706: SELECT COUNT(1) INTO l_records
707: FROM EGO_ITM_USR_ATTR_INTRFC
708: WHERE DATA_SET_ID = p_data_set_id;
709:
710: IF (l_records > (l_stats_profile*25)) AND l_ego_installed AND l_schema IS NOT NULL THEN
711: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITM_USR_ATTR_INTRFC');

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

707: FROM EGO_ITM_USR_ATTR_INTRFC
708: WHERE DATA_SET_ID = p_data_set_id;
709:
710: IF (l_records > (l_stats_profile*25)) AND l_ego_installed AND l_schema IS NOT NULL THEN
711: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITM_USR_ATTR_INTRFC');
712: Debug_Conc_Log('Collected Statistics on EGO_ITM_USR_ATTR_INTRFC');
713: END IF;
714: */
715: -- Bug 12669090 : End

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

708: WHERE DATA_SET_ID = p_data_set_id;
709:
710: IF (l_records > (l_stats_profile*25)) AND l_ego_installed AND l_schema IS NOT NULL THEN
711: FND_STATS.GATHER_TABLE_STATS(l_schema, 'EGO_ITM_USR_ATTR_INTRFC');
712: Debug_Conc_Log('Collected Statistics on EGO_ITM_USR_ATTR_INTRFC');
713: END IF;
714: */
715: -- Bug 12669090 : End
716: -- R12C: BEGIN

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

806: , p_commit IN FLAG DEFAULT FND_API.G_FALSE
807: )
808: IS
809: --6468564:Perf issue replacing EGO_ATTRS_V
810: CURSOR c_pdh_target_rev_attrs( cp_master_org_id EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE, cp_rev_dl_id NUMBER ) IS
811: SELECT sub.*
812: ,EXT.DATA_TYPE DATA_TYPE_CODE
813: FROM
814: ( SELECT

Line 865: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

861: , NVL( eiuai.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
862: )
863: rnk
864: , eiuai.*
865: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
866: WHERE DATA_SET_ID = p_batch_id
867: AND PROCESS_STATUS = 1
868: AND ITEM_NUMBER IS NOT NULL
869: AND FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )

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

889: AND EXT.APPLICATION_COLUMN_NAME = FL_COL.APPLICATION_COLUMN_NAME
890: ORDER BY rnk, sub.last_update_date DESC, interface_table_unique_id DESC ;
891:
892: --6468564:Perf issue replacing EGO_ATTRS_V
893: CURSOR c_ss_target_rev_attrs( cp_master_org_id EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE, cp_rev_dl_id NUMBER ) IS
894: SELECT sub.*
895: ,EXT.DATA_TYPE DATA_TYPE_CODE
896: FROM
897: ( SELECT

Line 950: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

946: , NVL( eiuai.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
947: )
948: rnk
949: , eiuai.*
950: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
951: WHERE DATA_SET_ID = p_batch_id
952: AND PROCESS_STATUS = 0
953: AND FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
954: AND FL_CTX_EXT.APPLICATION_ID = 431

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

979: l_merge_base EIUAI_ROW;
980: l_old_rows TARGET_ROWS;
981: l_old_rowids UROWID_TABLE;
982:
983: l_ss_id EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE := p_ss_id;
984: l_ssr EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE;
985: l_candidate_trans EGO_ITM_USR_ATTR_INTRFC.TRANSACTION_TYPE%TYPE;
986:
987: l_cur_rank PLS_INTEGER := 0; -- because rank() starts at 1

Line 984: l_ssr EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE;

980: l_old_rows TARGET_ROWS;
981: l_old_rowids UROWID_TABLE;
982:
983: l_ss_id EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE := p_ss_id;
984: l_ssr EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE;
985: l_candidate_trans EGO_ITM_USR_ATTR_INTRFC.TRANSACTION_TYPE%TYPE;
986:
987: l_cur_rank PLS_INTEGER := 0; -- because rank() starts at 1
988: l_mrow_ix PLS_INTEGER := 0;

Line 985: l_candidate_trans EGO_ITM_USR_ATTR_INTRFC.TRANSACTION_TYPE%TYPE;

981: l_old_rowids UROWID_TABLE;
982:
983: l_ss_id EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE := p_ss_id;
984: l_ssr EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE;
985: l_candidate_trans EGO_ITM_USR_ATTR_INTRFC.TRANSACTION_TYPE%TYPE;
986:
987: l_cur_rank PLS_INTEGER := 0; -- because rank() starts at 1
988: l_mrow_ix PLS_INTEGER := 0;
989: l_is_pdh_batch BOOLEAN;

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

989: l_is_pdh_batch BOOLEAN;
990:
991: l_data_type_code EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;
992:
993: l_org_id EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE := p_master_org_id;
994: l_pdh_batch_flag FLAG := p_is_pdh_batch;
995: l_rev_dl_id NUMBER;
996:
997: l_proc_log_prefix CONSTANT VARCHAR2(30) := ' merge_rev_attrs - ';

Line 1156: WHERE TABLE_NAME = 'EGO_ITM_USR_ATTR_INTRFC'

1152: /* Generated using:
1153: SET LINESIZE 200
1154: 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; '
1155: FROM ALL_TAB_COLUMNS
1156: WHERE TABLE_NAME = 'EGO_ITM_USR_ATTR_INTRFC'
1157: AND COLUMN_NAME NOT IN
1158: ( -- special cases (for merge)
1159: 'INVENTORY_ITEM_ID'
1160: , 'ITEM_NUMBER'

Line 1214: DELETE FROM EGO_ITM_USR_ATTR_INTRFC

1210: IF l_merged_rows IS NOT NULL THEN
1211: -- delete
1212: Debug_Conc_Log( l_proc_log_prefix || 'Deleting ' || l_old_rowids.COUNT || ' old rows ...' );
1213: FORALL rid_ix IN INDICES OF l_old_rowids
1214: DELETE FROM EGO_ITM_USR_ATTR_INTRFC
1215: WHERE ROWID = l_old_rowids( rid_ix );
1216: -- insert
1217: Debug_Conc_Log( l_proc_log_prefix || 'Inserting ' || l_merged_rows.COUNT || ' merged rows ...' );
1218: FORALL row_index IN INDICES OF l_merged_rows

Line 1219: INSERT INTO EGO_ITM_USR_ATTR_INTRFC

1215: WHERE ROWID = l_old_rowids( rid_ix );
1216: -- insert
1217: Debug_Conc_Log( l_proc_log_prefix || 'Inserting ' || l_merged_rows.COUNT || ' merged rows ...' );
1218: FORALL row_index IN INDICES OF l_merged_rows
1219: INSERT INTO EGO_ITM_USR_ATTR_INTRFC
1220: VALUES l_merged_rows( row_index );
1221: END IF;
1222: END IF; -- ENDS IF l_old_rows.count <> 0
1223:

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

1236: )
1237: IS
1238:
1239: --6468564:Perf issue replacing EGO_ATTRS_V
1240: CURSOR c_pdh_target_item_attrs( cp_master_org_id EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE ) IS
1241: SELECT sub.*
1242: ,EXT.DATA_TYPE DATA_TYPE_CODE
1243: FROM
1244: ( SELECT

Line 1287: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

1283: , NVL( ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
1284: )
1285: rnk
1286: , eiuai.*
1287: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
1288: WHERE DATA_SET_ID = p_batch_id
1289: AND PROCESS_STATUS = 1
1290: AND FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
1291: AND FL_CTX_EXT.APPLICATION_ID = 431

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

1316: AND EXT.APPLICATION_COLUMN_NAME = FL_COL.APPLICATION_COLUMN_NAME
1317: ORDER BY rnk, sub.last_update_date DESC, interface_table_unique_id DESC ;
1318:
1319: --6468564 : Perf issue replacing EGO_ATTRS_V
1320: CURSOR c_ss_target_item_attrs( cp_master_org_id EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE ) IS
1321: SELECT sub.*
1322: ,EXT.DATA_TYPE DATA_TYPE_CODE
1323: FROM
1324: ( SELECT

Line 1369: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

1365: , NVL( ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
1366: )
1367: rnk
1368: , eiuai.*
1369: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
1370: WHERE DATA_SET_ID = p_batch_id
1371: AND PROCESS_STATUS = 0
1372: AND FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
1373: AND FL_CTX_EXT.APPLICATION_ID = 431

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

1404: l_merge_base EIUAI_ROW;
1405: l_old_rows TARGET_ROWS;
1406: l_old_rowids UROWID_TABLE;
1407:
1408: l_ss_id EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE := p_ss_id;
1409: l_ssr EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE;
1410: l_candidate_trans EGO_ITM_USR_ATTR_INTRFC.TRANSACTION_TYPE%TYPE;
1411:
1412: l_cur_rank PLS_INTEGER := 0; -- because rank() starts at 1

Line 1409: l_ssr EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE;

1405: l_old_rows TARGET_ROWS;
1406: l_old_rowids UROWID_TABLE;
1407:
1408: l_ss_id EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE := p_ss_id;
1409: l_ssr EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE;
1410: l_candidate_trans EGO_ITM_USR_ATTR_INTRFC.TRANSACTION_TYPE%TYPE;
1411:
1412: l_cur_rank PLS_INTEGER := 0; -- because rank() starts at 1
1413: l_mrow_ix PLS_INTEGER := 0;

Line 1410: l_candidate_trans EGO_ITM_USR_ATTR_INTRFC.TRANSACTION_TYPE%TYPE;

1406: l_old_rowids UROWID_TABLE;
1407:
1408: l_ss_id EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE := p_ss_id;
1409: l_ssr EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE;
1410: l_candidate_trans EGO_ITM_USR_ATTR_INTRFC.TRANSACTION_TYPE%TYPE;
1411:
1412: l_cur_rank PLS_INTEGER := 0; -- because rank() starts at 1
1413: l_mrow_ix PLS_INTEGER := 0;
1414: l_is_pdh_batch BOOLEAN;

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

1413: l_mrow_ix PLS_INTEGER := 0;
1414: l_is_pdh_batch BOOLEAN;
1415:
1416: l_data_type_code EGO_ATTRS_V.DATA_TYPE_CODE%TYPE;
1417: l_org_id EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE := p_master_org_id;
1418: l_pdh_batch_flag FLAG := p_is_pdh_batch;
1419:
1420: l_proc_log_prefix CONSTANT VARCHAR2(30) := ' merge_item_attrs - ';
1421: BEGIN

Line 1573: WHERE TABLE_NAME = 'EGO_ITM_USR_ATTR_INTRFC'

1569: /* Generated using:
1570: SET LINESIZE 200
1571: 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; '
1572: FROM ALL_TAB_COLUMNS
1573: WHERE TABLE_NAME = 'EGO_ITM_USR_ATTR_INTRFC'
1574: AND COLUMN_NAME NOT IN
1575: ( -- special cases (for merge)
1576: 'INVENTORY_ITEM_ID'
1577: , 'ITEM_NUMBER'

Line 1631: DELETE FROM EGO_ITM_USR_ATTR_INTRFC

1627: IF l_merged_rows IS NOT NULL THEN
1628: -- delete
1629: Debug_Conc_Log( l_proc_log_prefix || l_old_rowids.COUNT || ' old rows ...' );
1630: FORALL rid_ix IN INDICES OF l_old_rowids
1631: DELETE FROM EGO_ITM_USR_ATTR_INTRFC
1632: WHERE ROWID = l_old_rowids( rid_ix );
1633: -- insert
1634: Debug_Conc_Log( l_proc_log_prefix || l_merged_rows.COUNT || ' merged rows ...' );
1635: FORALL row_index IN INDICES OF l_merged_rows

Line 1636: INSERT INTO EGO_ITM_USR_ATTR_INTRFC

1632: WHERE ROWID = l_old_rowids( rid_ix );
1633: -- insert
1634: Debug_Conc_Log( l_proc_log_prefix || l_merged_rows.COUNT || ' merged rows ...' );
1635: FORALL row_index IN INDICES OF l_merged_rows
1636: INSERT INTO EGO_ITM_USR_ATTR_INTRFC
1637: VALUES l_merged_rows( row_index );
1638: END IF;
1639: END IF; -- ENDS IF l_old_rows.count <> 0
1640:

Line 4367: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

4363: , NVL( ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
4364: )
4365: rnk
4366: , eiuai.*
4367: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
4368: WHERE DATA_SET_ID = p_batch_id
4369: AND PROCESS_STATUS = 1
4370: AND ITEM_NUMBER IS NOT NULL
4371: AND ORGANIZATION_ID IS NOT NULL

Line 4404: l_candidate_trans EGO_ITM_USR_ATTR_INTRFC.TRANSACTION_TYPE%TYPE;

4400: l_merged_row EIUAI_ROW;
4401: l_old_rows TARGET_ROWS;
4402: l_old_rowids UROWID_TABLE;
4403:
4404: l_candidate_trans EGO_ITM_USR_ATTR_INTRFC.TRANSACTION_TYPE%TYPE;
4405:
4406: l_cur_rank PLS_INTEGER := 0; -- because rank() starts at 1
4407: l_mrow_ix PLS_INTEGER := 0;
4408: l_new_row_idx PLS_INTEGER := 0;

Line 4417: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai

4413: BEGIN
4414: Debug_Conc_Log( l_proc_log_prefix || 'Entering' );
4415: Debug_Conc_Log( l_proc_log_prefix || 'Batch ID: ' || p_batch_id );
4416:
4417: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai
4418: SET ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
4419: FROM MTL_SYSTEM_ITEMS_KFV
4420: WHERE INVENTORY_ITEM_ID = eiuai.INVENTORY_ITEM_ID
4421: AND ORGANIZATION_ID = eiuai.ORGANIZATION_ID)

Line 4636: DELETE FROM EGO_ITM_USR_ATTR_INTRFC

4632: IF l_merged_rows IS NOT NULL THEN
4633: -- delete
4634: Debug_Conc_Log( l_proc_log_prefix || l_old_rowids.COUNT || ' old rows ...' );
4635: FORALL rid_ix IN INDICES OF l_old_rowids
4636: DELETE FROM EGO_ITM_USR_ATTR_INTRFC
4637: WHERE ROWID = l_old_rowids( rid_ix );
4638: -- insert
4639: Debug_Conc_Log( l_proc_log_prefix || l_merged_rows.COUNT || ' merged rows ...' );
4640: FORALL row_index IN INDICES OF l_merged_rows

Line 4641: INSERT INTO EGO_ITM_USR_ATTR_INTRFC

4637: WHERE ROWID = l_old_rowids( rid_ix );
4638: -- insert
4639: Debug_Conc_Log( l_proc_log_prefix || l_merged_rows.COUNT || ' merged rows ...' );
4640: FORALL row_index IN INDICES OF l_merged_rows
4641: INSERT INTO EGO_ITM_USR_ATTR_INTRFC
4642: VALUES l_merged_rows( row_index );
4643: END IF;
4644: END IF; -- ENDS IF l_old_rows.count <> 0
4645:

Line 4685: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

4681: , NVL( ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
4682: )
4683: rnk
4684: , eiuai.*
4685: FROM EGO_ITM_USR_ATTR_INTRFC eiuai, EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
4686: WHERE DATA_SET_ID = p_batch_id
4687: AND PROCESS_STATUS = 1
4688: AND ITEM_NUMBER IS NOT NULL
4689: AND ORGANIZATION_ID IS NOT NULL

Line 4716: l_candidate_trans EGO_ITM_USR_ATTR_INTRFC.TRANSACTION_TYPE%TYPE;

4712: l_merged_row EIUAI_ROW;
4713: l_old_rows TARGET_ROWS;
4714: l_old_rowids UROWID_TABLE;
4715:
4716: l_candidate_trans EGO_ITM_USR_ATTR_INTRFC.TRANSACTION_TYPE%TYPE;
4717:
4718: l_cur_rank PLS_INTEGER := 0; -- because rank() starts at 1
4719: l_mrow_ix PLS_INTEGER := 0;
4720: l_new_row_idx PLS_INTEGER := 0;

Line 4740: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai

4736: RETURN;
4737: END;
4738: Debug_Conc_Log( l_proc_log_prefix || 'l_rev_dl_id: ' || l_rev_dl_id );
4739:
4740: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai
4741: SET ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
4742: FROM MTL_SYSTEM_ITEMS_KFV
4743: WHERE INVENTORY_ITEM_ID = eiuai.INVENTORY_ITEM_ID
4744: AND ORGANIZATION_ID = eiuai.ORGANIZATION_ID)

Line 4946: DELETE FROM EGO_ITM_USR_ATTR_INTRFC

4942: IF l_merged_rows IS NOT NULL THEN
4943: -- delete
4944: Debug_Conc_Log( l_proc_log_prefix || l_old_rowids.COUNT || ' old rows ...' );
4945: FORALL rid_ix IN INDICES OF l_old_rowids
4946: DELETE FROM EGO_ITM_USR_ATTR_INTRFC
4947: WHERE ROWID = l_old_rowids( rid_ix );
4948: -- insert
4949: Debug_Conc_Log( l_proc_log_prefix || l_merged_rows.COUNT || ' merged rows ...' );
4950: FORALL row_index IN INDICES OF l_merged_rows

Line 4951: INSERT INTO EGO_ITM_USR_ATTR_INTRFC

4947: WHERE ROWID = l_old_rowids( rid_ix );
4948: -- insert
4949: Debug_Conc_Log( l_proc_log_prefix || l_merged_rows.COUNT || ' merged rows ...' );
4950: FORALL row_index IN INDICES OF l_merged_rows
4951: INSERT INTO EGO_ITM_USR_ATTR_INTRFC
4952: VALUES l_merged_rows( row_index );
4953: END IF;
4954: END IF; -- ENDS IF l_old_rows.count <> 0
4955: Debug_Conc_Log( l_proc_log_prefix || 'Exiting' );

Line 5040: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai

5036: AND PROCESS_FLAG = 111;
5037:
5038: Debug_Conc_Log( l_proc_log_prefix || 'Processed ' || SQL%ROWCOUNT || ' Category Assignments.' );
5039: -- processing revision attributes
5040: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai
5041: SET (PROCESS_STATUS, INVENTORY_ITEM_ID) =
5042: (SELECT PROCESS_STATUS, INVENTORY_ITEM_ID
5043: FROM EGO_ITM_USR_ATTR_INTRFC eiuai_merged
5044: WHERE eiuai_merged.ITEM_NUMBER = eiuai.ITEM_NUMBER

Line 5043: FROM EGO_ITM_USR_ATTR_INTRFC eiuai_merged

5039: -- processing revision attributes
5040: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai
5041: SET (PROCESS_STATUS, INVENTORY_ITEM_ID) =
5042: (SELECT PROCESS_STATUS, INVENTORY_ITEM_ID
5043: FROM EGO_ITM_USR_ATTR_INTRFC eiuai_merged
5044: WHERE eiuai_merged.ITEM_NUMBER = eiuai.ITEM_NUMBER
5045: AND eiuai_merged.ORGANIZATION_ID = eiuai.ORGANIZATION_ID
5046: AND eiuai_merged.ATTR_GROUP_INT_NAME = eiuai.ATTR_GROUP_INT_NAME
5047: AND eiuai_merged.ATTR_INT_NAME = eiuai.ATTR_INT_NAME

Line 5059: UPDATE /+ INDEX(eiuai,EGO_ITM_USR_ATTR_INTRFC_N3) / /* Bug 9678667 */

5055: AND REVISION IS NOT NULL;
5056:
5057: Debug_Conc_Log( l_proc_log_prefix || 'Processed ' || SQL%ROWCOUNT || ' Revision attributes.' );
5058: -- processing item attributes
5059: UPDATE /*+ INDEX(eiuai,EGO_ITM_USR_ATTR_INTRFC_N3) */ /* Bug 9678667 */
5060: EGO_ITM_USR_ATTR_INTRFC eiuai
5061: SET (PROCESS_STATUS, INVENTORY_ITEM_ID) =
5062: (SELECT PROCESS_STATUS, INVENTORY_ITEM_ID
5063: FROM EGO_ITM_USR_ATTR_INTRFC eiuai_merged

Line 5060: EGO_ITM_USR_ATTR_INTRFC eiuai

5056:
5057: Debug_Conc_Log( l_proc_log_prefix || 'Processed ' || SQL%ROWCOUNT || ' Revision attributes.' );
5058: -- processing item attributes
5059: UPDATE /*+ INDEX(eiuai,EGO_ITM_USR_ATTR_INTRFC_N3) */ /* Bug 9678667 */
5060: EGO_ITM_USR_ATTR_INTRFC eiuai
5061: SET (PROCESS_STATUS, INVENTORY_ITEM_ID) =
5062: (SELECT PROCESS_STATUS, INVENTORY_ITEM_ID
5063: FROM EGO_ITM_USR_ATTR_INTRFC eiuai_merged
5064: WHERE eiuai_merged.ITEM_NUMBER = eiuai.ITEM_NUMBER

Line 5063: FROM EGO_ITM_USR_ATTR_INTRFC eiuai_merged

5059: UPDATE /*+ INDEX(eiuai,EGO_ITM_USR_ATTR_INTRFC_N3) */ /* Bug 9678667 */
5060: EGO_ITM_USR_ATTR_INTRFC eiuai
5061: SET (PROCESS_STATUS, INVENTORY_ITEM_ID) =
5062: (SELECT PROCESS_STATUS, INVENTORY_ITEM_ID
5063: FROM EGO_ITM_USR_ATTR_INTRFC eiuai_merged
5064: WHERE eiuai_merged.ITEM_NUMBER = eiuai.ITEM_NUMBER
5065: AND eiuai_merged.ORGANIZATION_ID = eiuai.ORGANIZATION_ID
5066: AND eiuai_merged.ATTR_GROUP_INT_NAME = eiuai.ATTR_GROUP_INT_NAME
5067: AND eiuai_merged.ATTR_INT_NAME = eiuai.ATTR_INT_NAME

Line 5805: UPDATE EGO_ITM_USR_ATTR_INTRFC

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

Line 5869: UPDATE EGO_ITM_USR_ATTR_INTRFC

5865: REQUEST_ID = l_request_id,
5866: PROGRAM_UPDATE_DATE = SYSDATE
5867: WHERE ROWID = i.ROW_ID;
5868:
5869: UPDATE EGO_ITM_USR_ATTR_INTRFC
5870: SET PROCESS_STATUS = 4,
5871: PROGRAM_APPLICATION_ID = l_prog_appid,
5872: PROGRAM_ID = l_prog_id,
5873: REQUEST_ID = l_request_id,

Line 6088: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

6084: * based on the data and revision import policy
6085: */
6086: FUNCTION IS_NEW_REVISION_INFO_NEEDED
6087: (
6088: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
6089: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
6090: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
6091: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
6092: , p_organization_code IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_CODE%TYPE

Line 6089: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE

6085: */
6086: FUNCTION IS_NEW_REVISION_INFO_NEEDED
6087: (
6088: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
6089: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
6090: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
6091: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
6092: , p_organization_code IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_CODE%TYPE
6093: , p_instance_rev_policy IN EGO_IMPORT_OPTION_SETS.REVISION_IMPORT_POLICY%TYPE

Line 6090: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE

6086: FUNCTION IS_NEW_REVISION_INFO_NEEDED
6087: (
6088: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
6089: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
6090: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
6091: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
6092: , p_organization_code IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_CODE%TYPE
6093: , p_instance_rev_policy IN EGO_IMPORT_OPTION_SETS.REVISION_IMPORT_POLICY%TYPE
6094: )

Line 6091: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

6087: (
6088: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
6089: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
6090: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
6091: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
6092: , p_organization_code IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_CODE%TYPE
6093: , p_instance_rev_policy IN EGO_IMPORT_OPTION_SETS.REVISION_IMPORT_POLICY%TYPE
6094: )
6095: RETURN BOOLEAN IS

Line 6092: , p_organization_code IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_CODE%TYPE

6088: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
6089: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
6090: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
6091: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
6092: , p_organization_code IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_CODE%TYPE
6093: , p_instance_rev_policy IN EGO_IMPORT_OPTION_SETS.REVISION_IMPORT_POLICY%TYPE
6094: )
6095: RETURN BOOLEAN IS
6096: l_temp VARCHAR2(1);

Line 6584: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI

6580: WHERE SET_PROCESS_ID = p_data_set_id AND
6581: (PROCESS_FLAG IS NULL OR PROCESS_FLAG IN (0, 1)) AND
6582: ORGANIZATION_ID IS NULL;
6583:
6584: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI
6585: SET ORGANIZATION_ID =
6586: CASE
6587: WHEN ORGANIZATION_CODE IS NOT NULL
6588: THEN (SELECT ORGANIZATION_ID FROM MTL_PARAMETERS WHERE ORGANIZATION_CODE = EIUAI.ORGANIZATION_CODE)

Line 6645: UPDATE EGO_ITM_USR_ATTR_INTRFC uai

6641: AND DATA_LEVEL_ID IS NULL
6642: AND DATA_LEVEL_NAME IS NOT NULL;
6643:
6644:
6645: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
6646: SET uai.DATA_LEVEL_ID = (SELECT edlb.DATA_LEVEL_ID
6647: FROM EGO_DATA_LEVEL_B edlb
6648: WHERE edlb.DATA_LEVEL_NAME = uai.DATA_LEVEL_NAME
6649: AND edlb.APPLICATION_ID = 431

Line 6657: UPDATE EGO_ITM_USR_ATTR_INTRFC uai

6653: AND (uai.PROCESS_STATUS IS NULL OR uai.PROCESS_STATUS IN (0, 1))
6654: AND uai.DATA_LEVEL_NAME IS NOT NULL
6655: AND uai.DATA_LEVEL_ID IS NULL;
6656:
6657: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
6658: SET uai.DATA_LEVEL_ID = (SELECT edlv.DATA_LEVEL_ID
6659: FROM EGO_DATA_LEVEL_VL edlv
6660: WHERE edlv.USER_DATA_LEVEL_NAME = uai.USER_DATA_LEVEL_NAME
6661: AND edlv.APPLICATION_ID = 431

Line 6675: UPDATE EGO_ITM_USR_ATTR_INTRFC uai

6671: -- If all data level columns are null, then check if the --
6672: -- attribute group is associated at only one level, then --
6673: -- put that data level id here. --
6674: -----------------------------------------------------------
6675: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
6676: SET DATA_LEVEL_ID = (SELECT DATA_LEVEL_ID
6677: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext
6678: WHERE eagd.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID
6679: AND ag_ext.APPLICATION_ID = 431

Line 6786: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI

6782: AND PROCESS_FLAG = 1
6783: AND ITEM_NUMBER IS NULL
6784: AND INVENTORY_ITEM_ID IS NOT NULL;
6785:
6786: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI
6787: SET item_number = (SELECT CONCATENATED_SEGMENTS
6788: FROM MTL_SYSTEM_ITEMS_KFV
6789: WHERE INVENTORY_ITEM_ID = EIUAI.INVENTORY_ITEM_ID
6790: AND ORGANIZATION_ID = EIUAI.ORGANIZATION_ID)

Line 6852: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

6848: , MAX( EIUAI.created_by ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) CREATED_BY
6849: , MAX( EIUAI.last_updated_by ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) UPDATED_BY
6850: , MAX( EIUAI.last_update_login ) KEEP ( DENSE_RANK FIRST ORDER BY INVENTORY_ITEM_ID NULLS LAST, LAST_UPDATE_DATE NULLS LAST ) LAST_UPDATE_LOGIN
6851: , 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
6852: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
6853: -- , MTL_PARAMETERS MP
6854: WHERE
6855: data_set_id = p_data_set_id
6856: AND process_status = 1

Line 7026: UPDATE EGO_ITM_USR_ATTR_INTRFC

7022: SET PROCESS_FLAG = 0
7023: WHERE SET_PROCESS_ID = p_data_set_id AND
7024: PROCESS_FLAG IS NULL;
7025:
7026: UPDATE EGO_ITM_USR_ATTR_INTRFC
7027: SET PROCESS_STATUS = 0
7028: WHERE DATA_SET_ID = p_data_set_id AND
7029: PROCESS_STATUS IS NULL;
7030:

Line 7078: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

7074: , 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
7075: , 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
7076: , 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
7077: , 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
7078: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
7079: -- , MTL_PARAMETERS MP
7080: WHERE
7081: data_set_id = p_data_set_id
7082: AND process_status = 0

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

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

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

7360: -- determine if import policy applies to a source system item:
7361: -- the revision import policy should not apply if the user has given us a
7362: -- rev code or id in either EGO_ITM_USR_ATTR_INTRFC or MTL_ITEM_REVISIONS_INTERFACE: We set it to 'S' meaning specific.
7363: -- however, if the rev import policy is set to Specific already, we need to verify that
7364: -- the user has given us a rev code or id in either EGO_ITM_USR_ATTR_INTRFC or MTL_ITEM_REVISIONS_INTERFACE.
7365: UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII
7366: SET REVISION_IMPORT_POLICY =
7367: CASE
7368: WHEN EXISTS -- check the revision interface table

Line 7387: FROM EGO_ITM_USR_ATTR_INTRFC USR_ATTR

7383: THEN 'S'
7384: WHEN EXISTS -- check the user attrs interface table
7385: (
7386: SELECT NULL
7387: FROM EGO_ITM_USR_ATTR_INTRFC USR_ATTR
7388: WHERE DATA_SET_ID = MSII.SET_PROCESS_ID
7389: AND SOURCE_SYSTEM_ID = MSII.SOURCE_SYSTEM_ID
7390: AND SOURCE_SYSTEM_REFERENCE = MSII.SOURCE_SYSTEM_REFERENCE
7391: AND ORGANIZATION_ID = MSII.ORGANIZATION_ID

Line 7527: FROM EGO_ITM_USR_ATTR_INTRFC eiuai

7523: PK5_VALUE,
7524: ORGANIZATION_ID,
7525: NVL( ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
7526: ) cnt
7527: FROM EGO_ITM_USR_ATTR_INTRFC eiuai
7528: WHERE DATA_SET_ID = p_batch_id
7529: AND PROCESS_STATUS = p_process_status
7530: AND (ITEM_NUMBER IS NOT NULL OR SOURCE_SYSTEM_REFERENCE IS NOT NULL)
7531: AND DATA_LEVEL_ID IS NOT NULL

Line 7575: FROM EGO_ITM_USR_ATTR_INTRFC eiuai

7571: PK5_VALUE,
7572: ORGANIZATION_ID,
7573: NVL( ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
7574: ) MAX_ROW_IDENTIFIER
7575: FROM EGO_ITM_USR_ATTR_INTRFC eiuai
7576: WHERE DATA_SET_ID = p_batch_id
7577: AND PROCESS_STATUS = p_process_status
7578: AND (ITEM_NUMBER IS NOT NULL OR SOURCE_SYSTEM_REFERENCE IS NOT NULL)
7579: AND DATA_LEVEL_ID IS NOT NULL

Line 7591: SELECT /+ INDEX(EGO_ITM_USR_ATTR_INTRFC, EGO_ITM_USR_ATTR_INTRFC_N3) / /* Bug 9678667 */

7587: )
7588: WHERE CNT > 1;
7589:
7590: CURSOR c_error_case_cursor IS
7591: SELECT /*+ INDEX(EGO_ITM_USR_ATTR_INTRFC, EGO_ITM_USR_ATTR_INTRFC_N3) */ /* Bug 9678667 */
7592: DISTINCT
7593: ORGANIZATION_ID,
7594: ITEM_NUMBER,
7595: SOURCE_SYSTEM_REFERENCE,

Line 7599: FROM EGO_ITM_USR_ATTR_INTRFC

7595: SOURCE_SYSTEM_REFERENCE,
7596: INVENTORY_ITEM_ID,
7597: ATTR_GROUP_INT_NAME,
7598: TRANSACTION_ID
7599: FROM EGO_ITM_USR_ATTR_INTRFC
7600: WHERE DATA_SET_ID = p_batch_id
7601: AND PROCESS_STATUS = 3.475;
7602:
7603: l_msg_text VARCHAR2(4000);

Line 7630: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai

7626: l_ss_id := GET_PDH_SOURCE_SYSTEM_ID();
7627: END;
7628:
7629: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Pre - Updating item_number and revision, l_ss_id='||l_ss_id);
7630: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai
7631: SET ITEM_NUMBER = (SELECT CONCATENATED_SEGMENTS
7632: FROM MTL_SYSTEM_ITEMS_KFV
7633: WHERE INVENTORY_ITEM_ID = eiuai.INVENTORY_ITEM_ID
7634: AND ORGANIZATION_ID = eiuai.ORGANIZATION_ID)

Line 7640: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai

7636: AND PROCESS_STATUS = p_process_status
7637: AND INVENTORY_ITEM_ID IS NOT NULL
7638: AND ITEM_NUMBER IS NULL;
7639:
7640: UPDATE EGO_ITM_USR_ATTR_INTRFC eiuai
7641: SET REVISION = ( SELECT R.REVISION
7642: FROM MTL_ITEM_REVISIONS_B R
7643: WHERE R.REVISION_ID = eiuai.REVISION_ID
7644: )

Line 7657: UPDATE EGO_ITM_USR_ATTR_INTRFC

7653: FETCH c_unmerged_rows BULK COLLECT INTO l_unmerged_row_idents LIMIT 1000;
7654: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Pre - fetched '||l_unmerged_row_idents.Count||' rows, ');
7655:
7656: FORALL idx IN l_unmerged_row_idents.FIRST..l_unmerged_row_idents.LAST
7657: UPDATE EGO_ITM_USR_ATTR_INTRFC
7658: SET process_status = 3.475
7659: WHERE DATA_SET_ID = p_batch_id
7660: AND PROCESS_STATUS = p_process_status
7661: AND ROW_IDENTIFIER = l_unmerged_row_idents(idx);

Line 7683: ,'EGO_ITM_USR_ATTR_INTRFC'

7679: ,l_request_id
7680: ,i.TRANSACTION_ID
7681: ,l_msg_text
7682: ,'ATTR_GROUP_INT_NAME'
7683: ,'EGO_ITM_USR_ATTR_INTRFC'
7684: ,'INV_IOI_ERR_EF_IDENTICAL_RS01'--bug 11894684, replace INV_IOI_ERR
7685: ,l_err_text);
7686: END LOOP;
7687: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Pre - Done Logging errors for Errored out unmerged rows');

Line 7689: UPDATE /+ INDEX(EGO_ITM_USR_ATTR_INTRFC, EGO_ITM_USR_ATTR_INTRFC_N3) / /* Bug 9678667 */

7685: ,l_err_text);
7686: END LOOP;
7687: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Pre - Done Logging errors for Errored out unmerged rows');
7688:
7689: UPDATE /*+ INDEX(EGO_ITM_USR_ATTR_INTRFC, EGO_ITM_USR_ATTR_INTRFC_N3) */ /* Bug 9678667 */
7690: EGO_ITM_USR_ATTR_INTRFC
7691: SET
7692: PROCESS_STATUS = 3,
7693: REQUEST_ID = l_request_id

Line 7690: EGO_ITM_USR_ATTR_INTRFC

7686: END LOOP;
7687: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Pre - Done Logging errors for Errored out unmerged rows');
7688:
7689: UPDATE /*+ INDEX(EGO_ITM_USR_ATTR_INTRFC, EGO_ITM_USR_ATTR_INTRFC_N3) */ /* Bug 9678667 */
7690: EGO_ITM_USR_ATTR_INTRFC
7691: SET
7692: PROCESS_STATUS = 3,
7693: REQUEST_ID = l_request_id
7694: WHERE DATA_SET_ID = p_batch_id

Line 7711: UPDATE EGO_ITM_USR_ATTR_INTRFC

7707: FETCH c_intf_recs BULK COLLECT INTO l_row_ids, l_row_idents LIMIT 1000;
7708: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Pre - fetched '||l_unmerged_row_idents.Count||' rows, ');
7709:
7710: FORALL idx IN l_row_ids.FIRST..l_row_ids.LAST
7711: UPDATE EGO_ITM_USR_ATTR_INTRFC
7712: SET ROW_IDENTIFIER = l_row_idents(idx)
7713: WHERE ROWID = l_row_ids(idx);
7714: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Pre - Updated - '||SQL%ROWCOUNT||' rows');
7715: EXIT WHEN c_intf_recs%NOTFOUND;

Line 7761: FROM EGO_ITM_USR_ATTR_INTRFC eiuai

7757: PK5_VALUE,
7758: ORGANIZATION_ID,
7759: NVL( ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
7760: ) cnt
7761: FROM EGO_ITM_USR_ATTR_INTRFC eiuai
7762: WHERE DATA_SET_ID = p_batch_id
7763: AND PROCESS_STATUS = p_process_status
7764: AND INVENTORY_ITEM_ID IS NOT NULL
7765: AND DATA_LEVEL_ID IS NOT NULL

Line 7807: FROM EGO_ITM_USR_ATTR_INTRFC eiuai

7803: PK5_VALUE,
7804: ORGANIZATION_ID,
7805: NVL( ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE )
7806: ) MAX_ROW_IDENTIFIER
7807: FROM EGO_ITM_USR_ATTR_INTRFC eiuai
7808: WHERE DATA_SET_ID = p_batch_id
7809: AND PROCESS_STATUS = p_process_status
7810: AND INVENTORY_ITEM_ID IS NOT NULL
7811: AND DATA_LEVEL_ID IS NOT NULL

Line 7823: SELECT /+ INDEX(EGO_ITM_USR_ATTR_INTRFC, EGO_ITM_USR_ATTR_INTRFC_N3) / /* Bug 9678667 */

7819: )
7820: WHERE CNT > 1;
7821:
7822: CURSOR c_error_case_cursor IS
7823: SELECT /*+ INDEX(EGO_ITM_USR_ATTR_INTRFC, EGO_ITM_USR_ATTR_INTRFC_N3) */ /* Bug 9678667 */
7824: DISTINCT
7825: ORGANIZATION_ID,
7826: ITEM_NUMBER,
7827: SOURCE_SYSTEM_REFERENCE,

Line 7831: FROM EGO_ITM_USR_ATTR_INTRFC

7827: SOURCE_SYSTEM_REFERENCE,
7828: INVENTORY_ITEM_ID,
7829: ATTR_GROUP_INT_NAME,
7830: TRANSACTION_ID
7831: FROM EGO_ITM_USR_ATTR_INTRFC
7832: WHERE DATA_SET_ID = p_batch_id
7833: AND PROCESS_STATUS = 3.475;
7834:
7835: l_msg_text VARCHAR2(4000);

Line 7859: UPDATE EGO_ITM_USR_ATTR_INTRFC

7855: FETCH c_unmerged_rows BULK COLLECT INTO l_unmerged_row_idents LIMIT 1000;
7856: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Post - fetched '||l_unmerged_row_idents.Count||' rows, ');
7857:
7858: FORALL idx IN l_unmerged_row_idents.FIRST..l_unmerged_row_idents.LAST
7859: UPDATE EGO_ITM_USR_ATTR_INTRFC
7860: SET process_status = 3.475
7861: WHERE DATA_SET_ID = p_batch_id
7862: AND PROCESS_STATUS = p_process_status
7863: AND ROW_IDENTIFIER = l_unmerged_row_idents(idx);

Line 7885: ,'EGO_ITM_USR_ATTR_INTRFC'

7881: ,l_request_id
7882: ,i.TRANSACTION_ID
7883: ,l_msg_text
7884: ,'ATTR_GROUP_INT_NAME'
7885: ,'EGO_ITM_USR_ATTR_INTRFC'
7886: ,'INV_IOI_ERR_EF_IDENTICAL_RS02'--bug 11894684, replace INV_IOI_ERR
7887: ,l_err_text);
7888: END LOOP;
7889: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Post - Done Logging errors for Errored out unmerged rows');

Line 7891: UPDATE /+ INDEX(EGO_ITM_USR_ATTR_INTRFC, EGO_ITM_USR_ATTR_INTRFC_N3) / /* Bug 9678667 */

7887: ,l_err_text);
7888: END LOOP;
7889: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Post - Done Logging errors for Errored out unmerged rows');
7890:
7891: UPDATE /*+ INDEX(EGO_ITM_USR_ATTR_INTRFC, EGO_ITM_USR_ATTR_INTRFC_N3) */ /* Bug 9678667 */
7892: EGO_ITM_USR_ATTR_INTRFC
7893: SET
7894: PROCESS_STATUS = 3,
7895: REQUEST_ID = l_request_id

Line 7892: EGO_ITM_USR_ATTR_INTRFC

7888: END LOOP;
7889: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Post - Done Logging errors for Errored out unmerged rows');
7890:
7891: UPDATE /*+ INDEX(EGO_ITM_USR_ATTR_INTRFC, EGO_ITM_USR_ATTR_INTRFC_N3) */ /* Bug 9678667 */
7892: EGO_ITM_USR_ATTR_INTRFC
7893: SET
7894: PROCESS_STATUS = 3,
7895: REQUEST_ID = l_request_id
7896: WHERE DATA_SET_ID = p_batch_id

Line 7913: UPDATE EGO_ITM_USR_ATTR_INTRFC

7909: FETCH c_intf_recs BULK COLLECT INTO l_row_ids, l_row_idents LIMIT 1000;
7910: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Post - fetched '||l_unmerged_row_idents.Count||' rows, ');
7911:
7912: FORALL idx IN l_row_ids.FIRST..l_row_ids.LAST
7913: UPDATE EGO_ITM_USR_ATTR_INTRFC
7914: SET ROW_IDENTIFIER = l_row_idents(idx)
7915: WHERE ROWID = l_row_ids(idx);
7916: Debug_Conc_Log('Clean_Up_UDA_Row_Idents_Post - Updated - '||SQL%ROWCOUNT||' rows');
7917: EXIT WHEN c_intf_recs%NOTFOUND;

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

7935: END CLEAN_UP_UDA_ROW_IDENTS_POST;
7936:
7937: /*
7938: * This method cleans up UDA row identifiers, ensuring that all single attr groups
7939: * are represented by only one row identifier in EGO_ITM_USR_ATTR_INTRFC
7940: *
7941: * Helper procedure for resolve_child_entities
7942: */
7943: PROCEDURE CLEAN_UP_UDA_ROW_IDENTS( p_batch_id IN NUMBER,

Line 7969: * EGO_ITEM_PEOPLE_INTF, MTL_ITEM_CATEGORIES_INTERFACE, EGO_ITM_USR_ATTR_INTRFC etc.

7965:
7966: /*
7967: * This method populates the child entities with PK values.
7968: * This method populates the other interface tables like MTL_ITEM_REVISION_INTERFACE,
7969: * EGO_ITEM_PEOPLE_INTF, MTL_ITEM_CATEGORIES_INTERFACE, EGO_ITM_USR_ATTR_INTRFC etc.
7970: * with the inventory item id/number and organization id/code.
7971: */
7972: PROCEDURE Resolve_Child_Entities( p_data_set_id IN NUMBER
7973: , p_commit IN FLAG DEFAULT FND_API.G_TRUE

Line 8748: UPDATE EGO_ITM_USR_ATTR_INTRFC ATTRS

8744: AND MSII.ORGANIZATION_ID = l_org_id);
8745:
8746: Debug_Conc_Log('Resolve_Child_Entities - After resolving categories rows' );
8747: -- updating item_number, item_id from MSII table
8748: UPDATE EGO_ITM_USR_ATTR_INTRFC ATTRS
8749: SET (PROCESS_STATUS, TRANSACTION_TYPE, INVENTORY_ITEM_ID, ITEM_NUMBER, ITEM_CATALOG_GROUP_ID) =
8750: (SELECT
8751: 1,
8752: (CASE

Line 8782: UPDATE EGO_ITM_USR_ATTR_INTRFC ATTRS

8778: AND MSII.ORGANIZATION_ID = l_org_id);
8779:
8780: Debug_Conc_Log('Resolve_Child_Entities - After resolving user defined attrs rows' );
8781:
8782: UPDATE EGO_ITM_USR_ATTR_INTRFC ATTRS
8783: SET REVISION = (
8784: CASE (SELECT
8785: CASE
8786: WHEN MSII.CONFIRM_STATUS IN ('CMR', 'CCR', G_FAKE_CONF_STATUS_FLAG )

Line 9226: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI

9222: Debug_Conc_Log('Resolve_Child_Entities - After updating item people intf table for items that has XXref');
9223:
9224: -- updating the item user defined attributes interface
9225: l_sql := q'#
9226: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI
9227: SET (PROCESS_STATUS, TRANSACTION_TYPE, INVENTORY_ITEM_ID) =
9228: (SELECT
9229: 1,
9230: NVL(EIUAI.TRANSACTION_TYPE, 'SYNC'),

Line 9666: UPDATE EGO_ITM_USR_ATTR_INTRFC

9662: );
9663: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9664:
9665: -- updating item user defined attributes
9666: UPDATE EGO_ITM_USR_ATTR_INTRFC
9667: SET PROCESS_STATUS = 1
9668: WHERE ( INVENTORY_ITEM_ID = l_item_id
9669: OR ( ITEM_NUMBER = l_item_number
9670: AND INVENTORY_ITEM_ID IS NULL

Line 9773: UPDATE EGO_ITM_USR_ATTR_INTRFC

9769: );
9770: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
9771:
9772: -- updating item user defined attributes
9773: UPDATE EGO_ITM_USR_ATTR_INTRFC
9774: SET PROCESS_STATUS = 1
9775: WHERE ITEM_NUMBER = l_item_number
9776: AND PROCESS_STATUS = 3
9777: AND DATA_SET_ID = p_batch_id

Line 10034: UPDATE EGO_ITM_USR_ATTR_INTRFC

10030: );
10031: l_is_reimport := l_is_reimport OR ( 0 <> SQL%ROWCOUNT );
10032:
10033: -- updating item user defined attributes
10034: UPDATE EGO_ITM_USR_ATTR_INTRFC
10035: SET PROCESS_STATUS = 1
10036: WHERE SOURCE_SYSTEM_ID = l_ss_id
10037: AND SOURCE_SYSTEM_REFERENCE = l_ssr
10038: AND PROCESS_STATUS = 3

Line 10146: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

10142: -- their possible presence in other logical rows of the interface table --
10143: ------------------------------------------------------------------------------------------------
10144: FUNCTION GET_LATEST_EIUAI_REV_SS
10145: (
10146: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10147: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10148: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10149: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10150: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 10147: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE

10143: ------------------------------------------------------------------------------------------------
10144: FUNCTION GET_LATEST_EIUAI_REV_SS
10145: (
10146: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10147: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10148: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10149: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10150: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10151: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 10148: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE

10144: FUNCTION GET_LATEST_EIUAI_REV_SS
10145: (
10146: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10147: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10148: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10149: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10150: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10151: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10152: )

Line 10149: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

10145: (
10146: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10147: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10148: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10149: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10150: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10151: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10152: )
10153: RETURN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

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

10147: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10148: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10149: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10150: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10151: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10152: )
10153: RETURN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10154: IS
10155: l_rev_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;

Line 10153: RETURN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

10149: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10150: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10151: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10152: )
10153: RETURN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10154: IS
10155: l_rev_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
10156: BEGIN
10157: IF p_do_processed_rows_flag = FND_API.G_TRUE THEN

Line 10155: l_rev_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;

10151: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10152: )
10153: RETURN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10154: IS
10155: l_rev_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
10156: BEGIN
10157: IF p_do_processed_rows_flag = FND_API.G_TRUE THEN
10158: SELECT MAX( EIUAI.REVISION ) INTO l_rev_code
10159: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

Line 10159: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

10155: l_rev_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
10156: BEGIN
10157: IF p_do_processed_rows_flag = FND_API.G_TRUE THEN
10158: SELECT MAX( EIUAI.REVISION ) INTO l_rev_code
10159: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
10160: WHERE EIUAI.SOURCE_SYSTEM_REFERENCE = p_source_system_reference
10161: AND EIUAI.SOURCE_SYSTEM_ID = p_source_system_id
10162: AND EIUAI.ORGANIZATION_ID = p_organization_id
10163: AND EIUAI.DATA_SET_ID = p_batch_id

Line 10186: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

10182: -- the aggregate function MAX always returns one (possibly null) row, so
10183: -- no need to check for the NO_DATA_FOUND exception, or initialize l_rev_code
10184: ELSE
10185: SELECT MAX( EIUAI.REVISION ) INTO l_rev_code
10186: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
10187: WHERE EIUAI.SOURCE_SYSTEM_REFERENCE = p_source_system_reference
10188: AND EIUAI.SOURCE_SYSTEM_ID = p_source_system_id
10189: AND EIUAI.ORGANIZATION_ID = p_organization_id
10190: AND EIUAI.DATA_SET_ID = p_batch_id

Line 10216: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

10212: END GET_LATEST_EIUAI_REV_SS;
10213:
10214: FUNCTION GET_LATEST_EIUAI_REV_PDH
10215: (
10216: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10217: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
10218: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
10219: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10220: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 10217: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE

10213:
10214: FUNCTION GET_LATEST_EIUAI_REV_PDH
10215: (
10216: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10217: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
10218: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
10219: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10220: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10221: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 10218: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE

10214: FUNCTION GET_LATEST_EIUAI_REV_PDH
10215: (
10216: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10217: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
10218: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
10219: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10220: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10221: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10222: )

Line 10219: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

10215: (
10216: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10217: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
10218: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
10219: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10220: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10221: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10222: )
10223: RETURN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

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

10217: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
10218: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
10219: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10220: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10221: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10222: )
10223: RETURN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10224: IS
10225: l_rev_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;

Line 10223: RETURN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

10219: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10220: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10221: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10222: )
10223: RETURN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10224: IS
10225: l_rev_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
10226: l_sql_stmt VARCHAR2( 32000 );
10227: BEGIN

Line 10225: l_rev_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;

10221: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10222: )
10223: RETURN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10224: IS
10225: l_rev_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
10226: l_sql_stmt VARCHAR2( 32000 );
10227: BEGIN
10228: -- the aggregate function MAX always returns one (possibly null) row, so
10229: -- no need to check for the NO_DATA_FOUND exception, or initialize l_rev_code

Line 10236: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

10232: THEN
10233: IF p_do_processed_rows_flag = FND_API.G_TRUE THEN
10234: SELECT MAX( EIUAI.REVISION )
10235: INTO l_rev_code
10236: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
10237: WHERE EIUAI.ITEM_NUMBER = p_item_number
10238: AND EIUAI.ORGANIZATION_ID = p_organization_id
10239: AND EIUAI.DATA_SET_ID = p_batch_id
10240: AND EIUAI.REVISION IS NOT NULL

Line 10263: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

10259: -- no need to check for the NO_DATA_FOUND exception, or initialize l_rev_code
10260: ELSE
10261: SELECT MAX( EIUAI.REVISION )
10262: INTO l_rev_code
10263: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
10264: WHERE EIUAI.ITEM_NUMBER = p_item_number
10265: AND EIUAI.ORGANIZATION_ID = p_organization_id
10266: AND EIUAI.DATA_SET_ID = p_batch_id
10267: AND EIUAI.REVISION IS NOT NULL

Line 10291: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

10287: ELSE
10288: IF p_do_processed_rows_flag = FND_API.G_TRUE THEN
10289: SELECT MAX( EIUAI.REVISION )
10290: INTO l_rev_code
10291: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
10292: WHERE
10293: ( ( EIUAI.INVENTORY_ITEM_ID IS NULL
10294: AND EIUAI.ITEM_NUMBER = p_item_number
10295: )

Line 10323: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

10319: -- no need to check for the NO_DATA_FOUND exception, or initialize l_rev_code
10320: ELSE
10321: SELECT MAX( EIUAI.REVISION )
10322: INTO l_rev_code
10323: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
10324: WHERE
10325: ( ( EIUAI.INVENTORY_ITEM_ID IS NULL
10326: AND EIUAI.ITEM_NUMBER = p_item_number
10327: )

Line 10506: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

10502: -- display value, it returns the appropriate value column, based on the --
10503: -- p_attr_value_type parameter --
10504: --------------------------------------------------------------------------------------------
10505: FUNCTION GET_REV_USR_ATTR
10506: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10507: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10508: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10509: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10510: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 10507: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE

10503: -- p_attr_value_type parameter --
10504: --------------------------------------------------------------------------------------------
10505: FUNCTION GET_REV_USR_ATTR
10506: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10507: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10508: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10509: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10510: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10511: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 10508: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE

10504: --------------------------------------------------------------------------------------------
10505: FUNCTION GET_REV_USR_ATTR
10506: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10507: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10508: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10509: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10510: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10511: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10512: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 10509: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

10505: FUNCTION GET_REV_USR_ATTR
10506: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10507: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10508: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10509: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10510: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10511: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10512: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10513: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 10510: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

10506: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10507: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10508: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10509: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10510: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10511: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10512: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10513: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10514: , p_attr_value_type IN FLAG

Line 10511: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

10507: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10508: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10509: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10510: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10511: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10512: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10513: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10514: , p_attr_value_type IN FLAG
10515: )

Line 10512: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

10508: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10509: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10510: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10511: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10512: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10513: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10514: , p_attr_value_type IN FLAG
10515: )
10516: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE

Line 10513: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

10509: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10510: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10511: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10512: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10513: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10514: , p_attr_value_type IN FLAG
10515: )
10516: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE
10517: IS

Line 10516: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE

10512: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10513: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10514: , p_attr_value_type IN FLAG
10515: )
10516: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE
10517: IS
10518: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE;
10519: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
10520: BEGIN

Line 10518: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE;

10514: , p_attr_value_type IN FLAG
10515: )
10516: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE
10517: IS
10518: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE;
10519: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
10520: BEGIN
10521: l_return_value := null;
10522: l_revision_code := p_revision_code;

Line 10519: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;

10515: )
10516: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE
10517: IS
10518: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE;
10519: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
10520: BEGIN
10521: l_return_value := null;
10522: l_revision_code := p_revision_code;
10523:

Line 10543: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

10539: CASE p_attr_value_type
10540: -- text attr-type case
10541: WHEN G_TEXT_DATA_TYPE THEN
10542: SELECT NVL( EIUAI.ATTR_DISP_VALUE, EIUAI.ATTR_VALUE_STR ) INTO l_return_value
10543: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
10544: WHERE
10545: NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE ) = p_attr_group_type
10546: AND EIUAI.ATTR_GROUP_INT_NAME = p_attr_group_name
10547: AND EIUAI.ATTR_INT_NAME = p_attr_name

Line 10559: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

10555: -- end text attr-type case
10556: -- number attr-type case
10557: WHEN G_NUMBER_DATA_TYPE THEN
10558: SELECT NVL( EIUAI.ATTR_DISP_VALUE, TO_CHAR( EIUAI.ATTR_VALUE_NUM ) ) INTO l_return_value
10559: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
10560: WHERE
10561: NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE ) = p_attr_group_type
10562: AND EIUAI.ATTR_GROUP_INT_NAME = p_attr_group_name
10563: AND EIUAI.ATTR_INT_NAME = p_attr_name

Line 10576: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

10572: -- date attr-type case
10573: WHEN G_DATE_DATA_TYPE THEN
10574: -- XXX: which date format to use? what about date-time type vs date-type?
10575: SELECT NVL( EIUAI.ATTR_DISP_VALUE, TO_CHAR( EIUAI.ATTR_VALUE_DATE ) ) INTO l_return_value
10576: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
10577: WHERE
10578: NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE ) = p_attr_group_type
10579: AND EIUAI.ATTR_GROUP_INT_NAME = p_attr_group_name
10580: AND EIUAI.ATTR_INT_NAME = p_attr_name

Line 10602: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

10598: CASE p_attr_value_type
10599: -- text attr-type case
10600: WHEN G_TEXT_DATA_TYPE THEN
10601: SELECT NVL( EIUAI.ATTR_DISP_VALUE, EIUAI.ATTR_VALUE_STR ) INTO l_return_value
10602: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
10603: WHERE
10604: NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE ) = p_attr_group_type
10605: AND EIUAI.ATTR_GROUP_INT_NAME = p_attr_group_name
10606: AND EIUAI.ATTR_INT_NAME = p_attr_name

Line 10618: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

10614: -- end text attr-type case
10615: -- number attr-type case
10616: WHEN G_NUMBER_DATA_TYPE THEN
10617: SELECT NVL( EIUAI.ATTR_DISP_VALUE, TO_CHAR( EIUAI.ATTR_VALUE_NUM ) ) INTO l_return_value
10618: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
10619: WHERE
10620: NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE ) = p_attr_group_type
10621: AND EIUAI.ATTR_GROUP_INT_NAME = p_attr_group_name
10622: AND EIUAI.ATTR_INT_NAME = p_attr_name

Line 10635: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

10631: -- date attr-type case
10632: WHEN G_DATE_DATA_TYPE THEN
10633: -- XXX: which date format to use? what about date-time type vs date-type?
10634: SELECT NVL( EIUAI.ATTR_DISP_VALUE, TO_CHAR( EIUAI.ATTR_VALUE_DATE ) ) INTO l_return_value
10635: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
10636: WHERE
10637: NVL( EIUAI.ATTR_GROUP_TYPE, G_DEFAULT_ATTR_GROUP_TYPE ) = p_attr_group_type
10638: AND EIUAI.ATTR_GROUP_INT_NAME = p_attr_group_name
10639: AND EIUAI.ATTR_INT_NAME = p_attr_name

Line 10668: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

10664: -- The assumption is that this will be called from a value set context ...
10665: ----------------------------------------------------------------------------------------------
10666: FUNCTION GET_REV_USR_ATTR_TO_CHAR
10667: (
10668: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10669: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
10670: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
10671: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10672: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

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

10665: ----------------------------------------------------------------------------------------------
10666: FUNCTION GET_REV_USR_ATTR_TO_CHAR
10667: (
10668: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10669: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
10670: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
10671: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10672: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10673: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

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

10666: FUNCTION GET_REV_USR_ATTR_TO_CHAR
10667: (
10668: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10669: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
10670: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
10671: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10672: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10673: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10674: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 10671: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

10667: (
10668: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10669: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
10670: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
10671: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10672: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10673: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10674: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10675: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 10672: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

10668: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10669: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
10670: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
10671: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10672: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10673: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10674: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10675: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10676: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 10673: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

10669: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
10670: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
10671: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10672: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10673: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10674: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10675: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10676: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10677: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 10674: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

10670: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
10671: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10672: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10673: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10674: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10675: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10676: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10677: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10678: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL

Line 10675: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

10671: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10672: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10673: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10674: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10675: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10676: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10677: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10678: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
10679: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL

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

10673: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10674: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10675: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10676: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10677: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10678: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
10679: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
10680: , p_use_pdh_keys_to_join IN BOOLEAN
10681: , p_get_value_col IN BOOLEAN

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

10674: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10675: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10676: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10677: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10678: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
10679: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
10680: , p_use_pdh_keys_to_join IN BOOLEAN
10681: , p_get_value_col IN BOOLEAN
10682: , p_attr_type IN FLAG

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

10675: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10676: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10677: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10678: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
10679: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
10680: , p_use_pdh_keys_to_join IN BOOLEAN
10681: , p_get_value_col IN BOOLEAN
10682: , p_attr_type IN FLAG
10683: , p_attr_miss_value IN BOOLEAN DEFAULT TRUE

Line 10685: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE

10681: , p_get_value_col IN BOOLEAN
10682: , p_attr_type IN FLAG
10683: , p_attr_miss_value IN BOOLEAN DEFAULT TRUE
10684: )
10685: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE
10686: IS
10687: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE;
10688: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
10689: l_sql_stmt VARCHAR2( 32000 );

Line 10687: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE;

10683: , p_attr_miss_value IN BOOLEAN DEFAULT TRUE
10684: )
10685: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE
10686: IS
10687: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE;
10688: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
10689: l_sql_stmt VARCHAR2( 32000 );
10690: l_do_procd_rows_sql VARCHAR2( 200 );
10691: l_join_sql VARCHAR2( 200 );

Line 10688: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;

10684: )
10685: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE
10686: IS
10687: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE;
10688: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
10689: l_sql_stmt VARCHAR2( 32000 );
10690: l_do_procd_rows_sql VARCHAR2( 200 );
10691: l_join_sql VARCHAR2( 200 );
10692: l_select_sql VARCHAR2( 200 );

Line 10795: ||' FROM EGO_ITM_USR_ATTR_INTRFC EIUAI '

10791: END;
10792:
10793: l_sql_stmt := '
10794: SELECT ' || l_select_sql
10795: ||' FROM EGO_ITM_USR_ATTR_INTRFC EIUAI '
10796: ||' WHERE '
10797: ||' NVL( EIUAI.ATTR_GROUP_TYPE, :default_attr_grp ) = :attr_grp_type'
10798: ||' AND EIUAI.ATTR_GROUP_INT_NAME = :attr_grp'
10799: ||' AND EIUAI.ATTR_INT_NAME = :attr '

Line 10863: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

10859: END GET_REV_USR_ATTR_TO_CHAR;
10860:
10861: FUNCTION GET_REV_USR_ATTR_SS_DISP
10862: (
10863: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10864: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10865: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10866: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10867: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 10864: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE

10860:
10861: FUNCTION GET_REV_USR_ATTR_SS_DISP
10862: (
10863: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10864: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10865: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10866: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10867: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10868: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 10865: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE

10861: FUNCTION GET_REV_USR_ATTR_SS_DISP
10862: (
10863: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10864: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10865: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10866: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10867: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10868: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10869: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 10866: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

10862: (
10863: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10864: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10865: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10866: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10867: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10868: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10869: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10870: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 10867: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

10863: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10864: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10865: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10866: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10867: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10868: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10869: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10870: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10871: , p_attr_type IN FLAG

Line 10868: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

10864: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
10865: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10866: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10867: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10868: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10869: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10870: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10871: , p_attr_type IN FLAG
10872: , p_from_internal_column IN FLAG

Line 10869: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

10865: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
10866: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10867: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10868: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10869: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10870: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10871: , p_attr_type IN FLAG
10872: , p_from_internal_column IN FLAG
10873: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 10870: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

10866: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10867: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10868: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10869: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10870: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10871: , p_attr_type IN FLAG
10872: , p_from_internal_column IN FLAG
10873: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10874: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

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

10870: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10871: , p_attr_type IN FLAG
10872: , p_from_internal_column IN FLAG
10873: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10874: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10875: )
10876: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE
10877: IS
10878: l_get_value_col BOOLEAN := ( FND_API.G_TRUE = p_from_internal_column );

Line 10876: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE

10872: , p_from_internal_column IN FLAG
10873: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10874: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10875: )
10876: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE
10877: IS
10878: l_get_value_col BOOLEAN := ( FND_API.G_TRUE = p_from_internal_column );
10879: BEGIN
10880: RETURN GET_REV_USR_ATTR_TO_CHAR

Line 10901: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

10897: END;
10898:
10899: FUNCTION GET_REV_USR_ATTR_PDH_DISP
10900: (
10901: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10902: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
10903: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
10904: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10905: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 10902: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE

10898:
10899: FUNCTION GET_REV_USR_ATTR_PDH_DISP
10900: (
10901: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10902: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
10903: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
10904: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10905: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10906: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 10903: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE

10899: FUNCTION GET_REV_USR_ATTR_PDH_DISP
10900: (
10901: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10902: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
10903: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
10904: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10905: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10906: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10907: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 10904: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

10900: (
10901: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10902: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
10903: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
10904: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10905: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10906: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10907: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10908: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 10905: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

10901: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10902: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
10903: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
10904: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10905: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10906: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10907: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10908: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10909: , p_attr_type IN FLAG

Line 10906: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

10902: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
10903: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
10904: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10905: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10906: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10907: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10908: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10909: , p_attr_type IN FLAG
10910: , p_from_internal_column IN FLAG

Line 10907: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

10903: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
10904: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10905: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10906: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10907: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10908: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10909: , p_attr_type IN FLAG
10910: , p_from_internal_column IN FLAG
10911: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 10908: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

10904: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10905: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10906: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10907: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10908: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10909: , p_attr_type IN FLAG
10910: , p_from_internal_column IN FLAG
10911: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10912: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

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

10908: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10909: , p_attr_type IN FLAG
10910: , p_from_internal_column IN FLAG
10911: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10912: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10913: )
10914: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE
10915: IS
10916: l_get_value_col BOOLEAN := ( FND_API.G_TRUE = p_from_internal_column );

Line 10914: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE

10910: , p_from_internal_column IN FLAG
10911: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10912: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10913: )
10914: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_DISP_VALUE%TYPE
10915: IS
10916: l_get_value_col BOOLEAN := ( FND_API.G_TRUE = p_from_internal_column );
10917: BEGIN
10918: RETURN GET_REV_USR_ATTR_TO_CHAR

Line 10945: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

10941: -- in the interface table, merging in an attempted conversion of the display column content.
10942: ----------------------------------------------------------------------------------------------
10943: FUNCTION GET_REV_USR_ATTR_DATE
10944: (
10945: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10946: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
10947: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
10948: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10949: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

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

10942: ----------------------------------------------------------------------------------------------
10943: FUNCTION GET_REV_USR_ATTR_DATE
10944: (
10945: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10946: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
10947: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
10948: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10949: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10950: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

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

10943: FUNCTION GET_REV_USR_ATTR_DATE
10944: (
10945: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10946: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
10947: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
10948: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10949: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10950: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10951: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 10948: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

10944: (
10945: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10946: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
10947: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
10948: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10949: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10950: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10951: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10952: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 10949: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

10945: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
10946: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
10947: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
10948: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10949: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10950: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10951: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10952: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10953: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 10950: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

10946: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
10947: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
10948: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10949: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10950: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10951: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10952: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10953: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10954: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 10951: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

10947: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
10948: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10949: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10950: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10951: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10952: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10953: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10954: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10955: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL

Line 10952: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

10948: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
10949: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
10950: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10951: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10952: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10953: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10954: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10955: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
10956: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL

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

10950: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
10951: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10952: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10953: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10954: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10955: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
10956: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
10957: , p_use_pdh_keys_to_join IN BOOLEAN
10958: , p_get_value_column IN BOOLEAN

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

10951: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
10952: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10953: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10954: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10955: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
10956: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
10957: , p_use_pdh_keys_to_join IN BOOLEAN
10958: , p_get_value_column IN BOOLEAN
10959: )

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

10952: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
10953: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
10954: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
10955: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
10956: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
10957: , p_use_pdh_keys_to_join IN BOOLEAN
10958: , p_get_value_column IN BOOLEAN
10959: )
10960: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE

Line 10960: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE

10956: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
10957: , p_use_pdh_keys_to_join IN BOOLEAN
10958: , p_get_value_column IN BOOLEAN
10959: )
10960: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE
10961: IS
10962: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE;
10963: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
10964: l_sql_stmt VARCHAR2( 32000 );

Line 10962: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE;

10958: , p_get_value_column IN BOOLEAN
10959: )
10960: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE
10961: IS
10962: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE;
10963: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
10964: l_sql_stmt VARCHAR2( 32000 );
10965: l_do_procd_rows_sql VARCHAR2( 200 );
10966: l_join_sql VARCHAR2( 200 );

Line 10963: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;

10959: )
10960: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE
10961: IS
10962: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE;
10963: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
10964: l_sql_stmt VARCHAR2( 32000 );
10965: l_do_procd_rows_sql VARCHAR2( 200 );
10966: l_join_sql VARCHAR2( 200 );
10967: l_select_sql VARCHAR2( 300 );

Line 11044: ||' FROM EGO_ITM_USR_ATTR_INTRFC EIUAI '

11040: END;
11041:
11042: l_sql_stmt := '
11043: SELECT ' || l_select_sql
11044: ||' FROM EGO_ITM_USR_ATTR_INTRFC EIUAI '
11045: ||' WHERE '
11046: ||' NVL( EIUAI.ATTR_GROUP_TYPE, :default_attr_grp ) = :attr_grp_type'
11047: ||' AND EIUAI.ATTR_GROUP_INT_NAME = :attr_grp'
11048: ||' AND EIUAI.ATTR_INT_NAME = :attr '

Line 11114: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

11110: END GET_REV_USR_ATTR_DATE;
11111:
11112: FUNCTION GET_REV_USR_ATTR_SS_DDATE
11113: (
11114: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11115: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11116: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11117: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11118: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 11115: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE

11111:
11112: FUNCTION GET_REV_USR_ATTR_SS_DDATE
11113: (
11114: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11115: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11116: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11117: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11118: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11119: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 11116: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE

11112: FUNCTION GET_REV_USR_ATTR_SS_DDATE
11113: (
11114: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11115: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11116: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11117: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11118: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11119: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11120: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 11117: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

11113: (
11114: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11115: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11116: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11117: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11118: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11119: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11120: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11121: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 11118: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

11114: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11115: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11116: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11117: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11118: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11119: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11120: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11121: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11122: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 11119: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

11115: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11116: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11117: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11118: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11119: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11120: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11121: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11122: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11123: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 11120: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

11116: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11117: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11118: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11119: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11120: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11121: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11122: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11123: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11124: )

Line 11121: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

11117: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11118: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11119: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11120: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11121: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11122: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11123: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11124: )
11125: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS

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

11119: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11120: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11121: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11122: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11123: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11124: )
11125: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS
11126: BEGIN
11127: RETURN GET_REV_USR_ATTR_DATE

Line 11125: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS

11121: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11122: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11123: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11124: )
11125: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS
11126: BEGIN
11127: RETURN GET_REV_USR_ATTR_DATE
11128: (
11129: p_batch_id => p_batch_id

Line 11145: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

11141: );
11142: END GET_REV_USR_ATTR_SS_DDATE;
11143:
11144: FUNCTION GET_REV_USR_ATTR_PDH_DDATE
11145: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11146: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11147: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11148: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11149: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 11146: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE

11142: END GET_REV_USR_ATTR_SS_DDATE;
11143:
11144: FUNCTION GET_REV_USR_ATTR_PDH_DDATE
11145: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11146: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11147: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11148: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11149: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11150: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 11147: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE

11143:
11144: FUNCTION GET_REV_USR_ATTR_PDH_DDATE
11145: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11146: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11147: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11148: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11149: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11150: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11151: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 11148: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

11144: FUNCTION GET_REV_USR_ATTR_PDH_DDATE
11145: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11146: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11147: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11148: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11149: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11150: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11151: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11152: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 11149: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

11145: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11146: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11147: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11148: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11149: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11150: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11151: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11152: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11153: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 11150: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

11146: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11147: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11148: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11149: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11150: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11151: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11152: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11153: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11154: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 11151: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

11147: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11148: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11149: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11150: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11151: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11152: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11153: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11154: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11155: )

Line 11152: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

11148: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11149: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11150: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11151: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11152: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11153: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11154: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11155: )
11156: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS

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

11150: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11151: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11152: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11153: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11154: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11155: )
11156: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS
11157: BEGIN
11158: RETURN GET_REV_USR_ATTR_DATE

Line 11156: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS

11152: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11153: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11154: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11155: )
11156: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS
11157: BEGIN
11158: RETURN GET_REV_USR_ATTR_DATE
11159: (
11160: p_batch_id => p_batch_id

Line 11181: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

11177: -- Returns the string value of the specified revision attribute, if the attribute is present
11178: -- in the interface table, merging in an attempted conversion of the display column content.
11179: ----------------------------------------------------------------------------------------------
11180: FUNCTION GET_REV_USR_ATTR_STR
11181: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11182: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
11183: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
11184: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11185: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

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

11178: -- in the interface table, merging in an attempted conversion of the display column content.
11179: ----------------------------------------------------------------------------------------------
11180: FUNCTION GET_REV_USR_ATTR_STR
11181: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11182: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
11183: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
11184: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11185: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11186: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

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

11179: ----------------------------------------------------------------------------------------------
11180: FUNCTION GET_REV_USR_ATTR_STR
11181: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11182: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
11183: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
11184: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11185: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11186: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11187: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 11184: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

11180: FUNCTION GET_REV_USR_ATTR_STR
11181: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11182: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
11183: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
11184: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11185: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11186: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11187: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11188: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 11185: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

11181: ( p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11182: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
11183: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
11184: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11185: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11186: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11187: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11188: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11189: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 11186: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

11182: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
11183: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
11184: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11185: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11186: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11187: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11188: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11189: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11190: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 11187: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

11183: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
11184: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11185: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11186: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11187: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11188: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11189: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11190: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11191: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL

Line 11188: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

11184: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11185: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11186: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11187: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11188: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11189: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11190: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11191: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
11192: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL

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

11186: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11187: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11188: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11189: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11190: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11191: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
11192: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
11193: , p_use_pdh_keys_to_join IN BOOLEAN
11194: , p_get_value_column IN BOOLEAN

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

11187: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11188: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11189: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11190: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11191: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
11192: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
11193: , p_use_pdh_keys_to_join IN BOOLEAN
11194: , p_get_value_column IN BOOLEAN
11195: )

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

11188: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11189: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11190: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11191: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
11192: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
11193: , p_use_pdh_keys_to_join IN BOOLEAN
11194: , p_get_value_column IN BOOLEAN
11195: )
11196: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE

Line 11196: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE

11192: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
11193: , p_use_pdh_keys_to_join IN BOOLEAN
11194: , p_get_value_column IN BOOLEAN
11195: )
11196: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE
11197: IS
11198: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE;
11199: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
11200: l_sql_stmt VARCHAR2( 32000 );

Line 11198: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE;

11194: , p_get_value_column IN BOOLEAN
11195: )
11196: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE
11197: IS
11198: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE;
11199: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
11200: l_sql_stmt VARCHAR2( 32000 );
11201: l_do_procd_rows_sql VARCHAR2( 200 );
11202: l_join_sql VARCHAR2( 200 );

Line 11199: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;

11195: )
11196: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE
11197: IS
11198: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE;
11199: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
11200: l_sql_stmt VARCHAR2( 32000 );
11201: l_do_procd_rows_sql VARCHAR2( 200 );
11202: l_join_sql VARCHAR2( 200 );
11203: l_select_sql VARCHAR2( 200 );

Line 11276: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

11272:
11273: l_sql_stmt := '
11274: SELECT ' || l_select_sql
11275: || '
11276: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
11277: WHERE
11278: NVL( EIUAI.ATTR_GROUP_TYPE, :default_attr_grp ) = :attr_grp_type
11279: AND EIUAI.ATTR_GROUP_INT_NAME = :attr_grp
11280: AND EIUAI.ATTR_INT_NAME = :attr '

Line 11347: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

11343: END GET_REV_USR_ATTR_STR;
11344:
11345: FUNCTION GET_REV_USR_ATTR_SS_DSTR
11346: (
11347: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11348: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11349: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11350: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11351: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 11348: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE

11344:
11345: FUNCTION GET_REV_USR_ATTR_SS_DSTR
11346: (
11347: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11348: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11349: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11350: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11351: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11352: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 11349: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE

11345: FUNCTION GET_REV_USR_ATTR_SS_DSTR
11346: (
11347: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11348: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11349: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11350: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11351: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11352: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11353: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 11350: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

11346: (
11347: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11348: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11349: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11350: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11351: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11352: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11353: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11354: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 11351: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

11347: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11348: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11349: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11350: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11351: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11352: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11353: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11354: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11355: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 11352: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

11348: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11349: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11350: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11351: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11352: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11353: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11354: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11355: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11356: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 11353: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

11349: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11350: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11351: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11352: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11353: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11354: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11355: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11356: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11357: )

Line 11354: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

11350: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11351: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11352: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11353: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11354: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11355: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11356: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11357: )
11358: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS

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

11352: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11353: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11354: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11355: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11356: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11357: )
11358: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS
11359: BEGIN
11360: RETURN GET_REV_USR_ATTR_STR

Line 11358: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS

11354: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11355: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11356: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11357: )
11358: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS
11359: BEGIN
11360: RETURN GET_REV_USR_ATTR_STR
11361: (
11362: p_batch_id => p_batch_id

Line 11379: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

11375: END GET_REV_USR_ATTR_SS_DSTR;
11376:
11377: FUNCTION GET_REV_USR_ATTR_PDH_DSTR
11378: (
11379: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11380: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11381: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11382: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11383: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 11380: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE

11376:
11377: FUNCTION GET_REV_USR_ATTR_PDH_DSTR
11378: (
11379: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11380: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11381: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11382: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11383: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11384: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 11381: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE

11377: FUNCTION GET_REV_USR_ATTR_PDH_DSTR
11378: (
11379: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11380: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11381: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11382: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11383: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11384: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11385: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 11382: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

11378: (
11379: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11380: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11381: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11382: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11383: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11384: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11385: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11386: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 11383: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

11379: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11380: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11381: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11382: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11383: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11384: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11385: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11386: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11387: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 11384: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

11380: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11381: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11382: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11383: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11384: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11385: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11386: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11387: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11388: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 11385: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

11381: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11382: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11383: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11384: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11385: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11386: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11387: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11388: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11389: )

Line 11386: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

11382: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11383: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11384: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11385: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11386: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11387: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11388: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11389: )
11390: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS

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

11384: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11385: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11386: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11387: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11388: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11389: )
11390: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS
11391: BEGIN
11392: RETURN GET_REV_USR_ATTR_STR

Line 11390: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS

11386: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11387: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11388: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11389: )
11390: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS
11391: BEGIN
11392: RETURN GET_REV_USR_ATTR_STR
11393: (
11394: p_batch_id => p_batch_id

Line 11416: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

11412: -- in the interface table, merging in an attempted conversion of the display column content.
11413: --------------------------------------------------------------------------------------------
11414: FUNCTION GET_REV_USR_ATTR_NUM
11415: (
11416: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11417: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
11418: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
11419: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11420: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

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

11413: --------------------------------------------------------------------------------------------
11414: FUNCTION GET_REV_USR_ATTR_NUM
11415: (
11416: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11417: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
11418: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
11419: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11420: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11421: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

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

11414: FUNCTION GET_REV_USR_ATTR_NUM
11415: (
11416: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11417: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
11418: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
11419: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11420: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11421: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11422: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 11419: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

11415: (
11416: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11417: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
11418: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
11419: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11420: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11421: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11422: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11423: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 11420: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

11416: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11417: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
11418: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
11419: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11420: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11421: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11422: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11423: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11424: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE DEFAULT NULL

Line 11421: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

11417: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE DEFAULT NULL
11418: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
11419: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11420: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11421: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11422: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11423: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11424: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE DEFAULT NULL
11425: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 11422: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

11418: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE DEFAULT NULL
11419: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11420: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11421: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11422: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11423: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11424: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE DEFAULT NULL
11425: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11426: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 11423: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

11419: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11420: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11421: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11422: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11423: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11424: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE DEFAULT NULL
11425: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11426: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11427: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL

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

11420: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11421: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11422: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11423: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11424: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE DEFAULT NULL
11425: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11426: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11427: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
11428: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL

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

11422: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11423: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11424: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE DEFAULT NULL
11425: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11426: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11427: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
11428: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
11429: , p_use_pdh_keys_to_join IN BOOLEAN
11430: , p_get_value_column IN BOOLEAN

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

11423: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11424: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE DEFAULT NULL
11425: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11426: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11427: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
11428: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
11429: , p_use_pdh_keys_to_join IN BOOLEAN
11430: , p_get_value_column IN BOOLEAN
11431: )

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

11424: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE DEFAULT NULL
11425: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11426: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11427: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
11428: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
11429: , p_use_pdh_keys_to_join IN BOOLEAN
11430: , p_get_value_column IN BOOLEAN
11431: )
11432: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE

Line 11432: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE

11428: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE DEFAULT NULL
11429: , p_use_pdh_keys_to_join IN BOOLEAN
11430: , p_get_value_column IN BOOLEAN
11431: )
11432: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE
11433: IS
11434: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE;
11435: l_num_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE;
11436: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;

Line 11434: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE;

11430: , p_get_value_column IN BOOLEAN
11431: )
11432: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE
11433: IS
11434: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE;
11435: l_num_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE;
11436: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
11437: l_sql_stmt VARCHAR2( 32000 );
11438: l_do_procd_rows_sql VARCHAR2( 200 );

Line 11435: l_num_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE;

11431: )
11432: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE
11433: IS
11434: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE;
11435: l_num_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE;
11436: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
11437: l_sql_stmt VARCHAR2( 32000 );
11438: l_do_procd_rows_sql VARCHAR2( 200 );
11439: l_join_sql VARCHAR2( 200 );

Line 11436: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;

11432: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE
11433: IS
11434: l_return_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE;
11435: l_num_value EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE;
11436: l_revision_code EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE;
11437: l_sql_stmt VARCHAR2( 32000 );
11438: l_do_procd_rows_sql VARCHAR2( 200 );
11439: l_join_sql VARCHAR2( 200 );
11440: l_select_sql VARCHAR2( 200 );

Line 11443: l_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE;

11439: l_join_sql VARCHAR2( 200 );
11440: l_select_sql VARCHAR2( 200 );
11441: l_do_processed_rows BOOLEAN;
11442:
11443: l_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE;
11444: l_uom_disp_value EGO_ITM_USR_ATTR_INTRFC.ATTR_UOM_DISP_VALUE%TYPE;
11445: l_uom_rate NUMBER := 1;
11446: BEGIN
11447: l_return_value := null; -- 'default';

Line 11444: l_uom_disp_value EGO_ITM_USR_ATTR_INTRFC.ATTR_UOM_DISP_VALUE%TYPE;

11440: l_select_sql VARCHAR2( 200 );
11441: l_do_processed_rows BOOLEAN;
11442:
11443: l_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE;
11444: l_uom_disp_value EGO_ITM_USR_ATTR_INTRFC.ATTR_UOM_DISP_VALUE%TYPE;
11445: l_uom_rate NUMBER := 1;
11446: BEGIN
11447: l_return_value := null; -- 'default';
11448:

Line 11521: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI

11517: l_sql_stmt := '
11518: SELECT ' || l_select_sql
11519: || ', ATTR_VALUE_UOM
11520: , ATTR_UOM_DISP_VALUE
11521: FROM EGO_ITM_USR_ATTR_INTRFC EIUAI
11522: WHERE
11523: NVL( EIUAI.ATTR_GROUP_TYPE, :default_attr_grp ) = :attr_grp_type
11524: AND EIUAI.ATTR_GROUP_INT_NAME = :attr_grp
11525: AND EIUAI.ATTR_INT_NAME = :attr '

Line 11599: , p_to_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE

11595: -- If both of the from_uom params are null, no attempt to make the conversion is --
11596: -- performed. --
11597: --------------------------------------------------------------------------------------------
11598: FUNCTION WRAPPED_TO_UOM( p_val NUMBER
11599: , p_to_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11600: , p_from_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11601: , p_from_uom_value EGO_ITM_USR_ATTR_INTRFC.ATTR_UOM_DISP_VALUE%TYPE
11602: , p_inventory_item_id EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
11603: )

Line 11600: , p_from_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE

11596: -- performed. --
11597: --------------------------------------------------------------------------------------------
11598: FUNCTION WRAPPED_TO_UOM( p_val NUMBER
11599: , p_to_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11600: , p_from_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11601: , p_from_uom_value EGO_ITM_USR_ATTR_INTRFC.ATTR_UOM_DISP_VALUE%TYPE
11602: , p_inventory_item_id EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
11603: )
11604: RETURN NUMBER IS

Line 11601: , p_from_uom_value EGO_ITM_USR_ATTR_INTRFC.ATTR_UOM_DISP_VALUE%TYPE

11597: --------------------------------------------------------------------------------------------
11598: FUNCTION WRAPPED_TO_UOM( p_val NUMBER
11599: , p_to_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11600: , p_from_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11601: , p_from_uom_value EGO_ITM_USR_ATTR_INTRFC.ATTR_UOM_DISP_VALUE%TYPE
11602: , p_inventory_item_id EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
11603: )
11604: RETURN NUMBER IS
11605: l_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE := p_from_uom_code;

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

11598: FUNCTION WRAPPED_TO_UOM( p_val NUMBER
11599: , p_to_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11600: , p_from_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11601: , p_from_uom_value EGO_ITM_USR_ATTR_INTRFC.ATTR_UOM_DISP_VALUE%TYPE
11602: , p_inventory_item_id EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
11603: )
11604: RETURN NUMBER IS
11605: l_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE := p_from_uom_code;
11606: l_uom_rate NUMBER;

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

11601: , p_from_uom_value EGO_ITM_USR_ATTR_INTRFC.ATTR_UOM_DISP_VALUE%TYPE
11602: , p_inventory_item_id EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
11603: )
11604: RETURN NUMBER IS
11605: l_uom_code EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE := p_from_uom_code;
11606: l_uom_rate NUMBER;
11607: BEGIN
11608: IF p_val IS NULL
11609: OR p_val = 0

Line 11643: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

11639: END WRAPPED_TO_UOM;
11640:
11641: FUNCTION GET_REV_USR_ATTR_SS_DNUM
11642: (
11643: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11644: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11645: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11646: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11647: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 11644: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE

11640:
11641: FUNCTION GET_REV_USR_ATTR_SS_DNUM
11642: (
11643: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11644: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11645: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11646: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11647: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11648: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 11645: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE

11641: FUNCTION GET_REV_USR_ATTR_SS_DNUM
11642: (
11643: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11644: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11645: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11646: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11647: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11648: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11649: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 11646: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

11642: (
11643: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11644: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11645: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11646: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11647: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11648: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11649: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11650: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 11647: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

11643: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11644: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11645: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11646: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11647: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11648: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11649: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11650: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11651: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE

Line 11648: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

11644: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11645: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11646: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11647: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11648: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11649: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11650: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11651: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11652: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 11649: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

11645: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11646: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11647: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11648: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11649: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11650: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11651: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11652: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11653: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 11650: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

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

Line 11651: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE

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

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

11649: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11650: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11651: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11652: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11653: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11654: )
11655: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS
11656: BEGIN
11657: RETURN GET_REV_USR_ATTR_NUM

Line 11655: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS

11651: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11652: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11653: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11654: )
11655: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS
11656: BEGIN
11657: RETURN GET_REV_USR_ATTR_NUM
11658: (
11659: p_batch_id => p_batch_id

Line 11677: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

11673: END GET_REV_USR_ATTR_SS_DNUM;
11674:
11675: FUNCTION GET_REV_USR_ATTR_PDH_DNUM
11676: (
11677: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11678: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11679: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11680: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11681: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 11678: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE

11674:
11675: FUNCTION GET_REV_USR_ATTR_PDH_DNUM
11676: (
11677: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11678: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11679: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11680: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11681: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11682: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 11679: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE

11675: FUNCTION GET_REV_USR_ATTR_PDH_DNUM
11676: (
11677: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11678: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11679: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11680: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11681: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11682: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11683: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 11680: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

11676: (
11677: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11678: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11679: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11680: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11681: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11682: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11683: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11684: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 11681: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

11677: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11678: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11679: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11680: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11681: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11682: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11683: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11684: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11685: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE

Line 11682: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

11678: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11679: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11680: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11681: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11682: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11683: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11684: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11685: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11686: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 11683: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

11679: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11680: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11681: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11682: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11683: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11684: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11685: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11686: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11687: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 11684: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

11680: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11681: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11682: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11683: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11684: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11685: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11686: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11687: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11688: )

Line 11685: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE

11681: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11682: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11683: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11684: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11685: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11686: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11687: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11688: )
11689: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS

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

11683: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11684: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11685: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11686: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11687: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11688: )
11689: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS
11690: BEGIN
11691: RETURN GET_REV_USR_ATTR_NUM

Line 11689: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS

11685: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11686: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11687: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11688: )
11689: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS
11690: BEGIN
11691: RETURN GET_REV_USR_ATTR_NUM
11692: (
11693: p_batch_id => p_batch_id

Line 11716: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

11712: -- in the interface table.
11713: --------------------------------------------------------------------------------------------
11714: FUNCTION GET_REV_USR_ATTR_SS_VSTR
11715: (
11716: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11717: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11718: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11719: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11720: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 11717: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE

11713: --------------------------------------------------------------------------------------------
11714: FUNCTION GET_REV_USR_ATTR_SS_VSTR
11715: (
11716: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11717: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11718: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11719: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11720: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11721: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 11718: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE

11714: FUNCTION GET_REV_USR_ATTR_SS_VSTR
11715: (
11716: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11717: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11718: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11719: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11720: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11721: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11722: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 11719: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

11715: (
11716: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11717: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11718: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11719: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11720: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11721: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11722: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11723: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 11720: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

11716: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11717: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11718: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11719: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11720: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11721: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11722: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11723: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11724: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 11721: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

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

Line 11722: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

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

Line 11723: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

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

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

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

Line 11727: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS

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

Line 11748: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

11744: END GET_REV_USR_ATTR_SS_VSTR;
11745:
11746: FUNCTION GET_REV_USR_ATTR_PDH_VSTR
11747: (
11748: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11749: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11750: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11751: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11752: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 11749: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE

11745:
11746: FUNCTION GET_REV_USR_ATTR_PDH_VSTR
11747: (
11748: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11749: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11750: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11751: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11752: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11753: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 11750: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE

11746: FUNCTION GET_REV_USR_ATTR_PDH_VSTR
11747: (
11748: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11749: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11750: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11751: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11752: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11753: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11754: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 11751: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

11747: (
11748: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11749: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11750: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11751: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11752: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11753: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11754: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11755: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 11752: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

11748: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11749: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11750: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11751: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11752: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11753: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11754: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11755: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11756: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 11753: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

11749: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11750: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11751: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11752: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11753: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11754: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11755: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11756: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11757: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 11754: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

11750: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11751: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11752: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11753: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11754: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11755: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11756: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11757: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11758: )

Line 11755: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

11751: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11752: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11753: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11754: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11755: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11756: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11757: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11758: )
11759: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS

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

11753: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11754: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11755: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11756: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11757: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11758: )
11759: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS
11760: BEGIN
11761: RETURN GET_REV_USR_ATTR_STR

Line 11759: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS

11755: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11756: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11757: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11758: )
11759: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_STR%TYPE IS
11760: BEGIN
11761: RETURN GET_REV_USR_ATTR_STR
11762: (
11763: p_batch_id => p_batch_id

Line 11785: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

11781: -- in the interface table.
11782: --------------------------------------------------------------------------------------------
11783: FUNCTION GET_REV_USR_ATTR_SS_VDATE
11784: (
11785: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11786: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11787: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11788: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11789: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 11786: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE

11782: --------------------------------------------------------------------------------------------
11783: FUNCTION GET_REV_USR_ATTR_SS_VDATE
11784: (
11785: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11786: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11787: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11788: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11789: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11790: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 11787: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE

11783: FUNCTION GET_REV_USR_ATTR_SS_VDATE
11784: (
11785: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11786: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11787: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11788: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11789: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11790: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11791: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 11788: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

11784: (
11785: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11786: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11787: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11788: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11789: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11790: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11791: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11792: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 11789: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

11785: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11786: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11787: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11788: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11789: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11790: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11791: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11792: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11793: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 11790: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

11786: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11787: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11788: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11789: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11790: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11791: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11792: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11793: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11794: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 11791: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

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

Line 11792: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

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

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

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

Line 11796: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS

11792: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11793: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11794: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11795: )
11796: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS
11797: BEGIN
11798: RETURN GET_REV_USR_ATTR_DATE
11799: (
11800: p_batch_id => p_batch_id

Line 11817: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

11813: END GET_REV_USR_ATTR_SS_VDATE;
11814:
11815: FUNCTION GET_REV_USR_ATTR_PDH_VDATE
11816: (
11817: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11818: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11819: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11820: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11821: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 11818: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE

11814:
11815: FUNCTION GET_REV_USR_ATTR_PDH_VDATE
11816: (
11817: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11818: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11819: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11820: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11821: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11822: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 11819: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE

11815: FUNCTION GET_REV_USR_ATTR_PDH_VDATE
11816: (
11817: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11818: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11819: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11820: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11821: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11822: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11823: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 11820: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

11816: (
11817: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11818: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11819: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11820: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11821: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11822: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11823: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11824: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 11821: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

11817: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11818: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11819: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11820: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11821: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11822: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11823: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11824: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11825: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 11822: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

11818: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11819: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11820: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11821: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11822: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11823: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11824: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11825: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11826: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 11823: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

11819: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11820: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11821: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11822: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11823: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11824: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11825: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11826: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11827: )

Line 11824: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

11820: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11821: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11822: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11823: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11824: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11825: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11826: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11827: )
11828: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS

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

11822: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11823: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11824: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11825: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11826: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11827: )
11828: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS
11829: BEGIN
11830: RETURN GET_REV_USR_ATTR_DATE

Line 11828: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS

11824: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11825: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11826: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11827: )
11828: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_DATE%TYPE IS
11829: BEGIN
11830: RETURN GET_REV_USR_ATTR_DATE
11831: (
11832: p_batch_id => p_batch_id

Line 11855: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

11851: -- p_output_uom_code parameter is ignored (no uom conversions performed)
11852: --------------------------------------------------------------------------------------------
11853: FUNCTION GET_REV_USR_ATTR_SS_VNUM
11854: (
11855: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11856: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11857: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11858: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11859: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 11856: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE

11852: --------------------------------------------------------------------------------------------
11853: FUNCTION GET_REV_USR_ATTR_SS_VNUM
11854: (
11855: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11856: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11857: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11858: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11859: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11860: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 11857: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE

11853: FUNCTION GET_REV_USR_ATTR_SS_VNUM
11854: (
11855: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11856: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11857: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11858: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11859: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11860: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11861: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 11858: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

11854: (
11855: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11856: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11857: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11858: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11859: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11860: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11861: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11862: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 11859: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

11855: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11856: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11857: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11858: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11859: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11860: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11861: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11862: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11863: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE

Line 11860: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

11856: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
11857: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11858: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11859: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11860: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11861: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11862: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11863: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11864: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 11861: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

11857: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
11858: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11859: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11860: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11861: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11862: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11863: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11864: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11865: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 11862: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

11858: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11859: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11860: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11861: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11862: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11863: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11864: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11865: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11866: )

Line 11863: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE

11859: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11860: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11861: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11862: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11863: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11864: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11865: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11866: )
11867: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS

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

11861: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11862: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11863: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11864: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11865: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11866: )
11867: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS
11868: BEGIN
11869: RETURN GET_REV_USR_ATTR_NUM

Line 11867: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS

11863: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11864: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11865: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11866: )
11867: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS
11868: BEGIN
11869: RETURN GET_REV_USR_ATTR_NUM
11870: (
11871: p_batch_id => p_batch_id

Line 11889: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

11885: END GET_REV_USR_ATTR_SS_VNUM;
11886:
11887: FUNCTION GET_REV_USR_ATTR_PDH_VNUM
11888: (
11889: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11890: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11891: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11892: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11893: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

Line 11890: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE

11886:
11887: FUNCTION GET_REV_USR_ATTR_PDH_VNUM
11888: (
11889: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11890: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11891: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11892: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11893: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11894: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

Line 11891: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE

11887: FUNCTION GET_REV_USR_ATTR_PDH_VNUM
11888: (
11889: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11890: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11891: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11892: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11893: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11894: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11895: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

Line 11892: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

11888: (
11889: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11890: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11891: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11892: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11893: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11894: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11895: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11896: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

Line 11893: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE

11889: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
11890: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11891: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11892: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11893: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11894: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11895: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11896: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11897: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE

Line 11894: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE

11890: , p_inventory_item_id IN EGO_ITM_USR_ATTR_INTRFC.INVENTORY_ITEM_ID%TYPE
11891: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11892: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11893: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11894: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11895: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11896: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11897: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11898: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE

Line 11895: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE

11891: , p_item_number IN EGO_ITM_USR_ATTR_INTRFC.ITEM_NUMBER%TYPE
11892: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11893: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11894: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11895: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11896: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11897: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11898: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11899: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL

Line 11896: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE

11892: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
11893: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11894: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11895: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11896: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11897: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11898: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11899: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11900: )

Line 11897: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE

11893: , p_revision_code IN EGO_ITM_USR_ATTR_INTRFC.REVISION%TYPE
11894: , p_attr_group_type IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_TYPE%TYPE
11895: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11896: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11897: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11898: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11899: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11900: )
11901: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS

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

11895: , p_attr_group_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_GROUP_INT_NAME%TYPE
11896: , p_attr_name IN EGO_ITM_USR_ATTR_INTRFC.ATTR_INT_NAME%TYPE
11897: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11898: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11899: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11900: )
11901: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS
11902: BEGIN
11903: RETURN GET_REV_USR_ATTR_NUM

Line 11901: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS

11897: , p_output_uom_code IN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_UOM%TYPE
11898: , p_do_processed_rows_flag IN FLAG DEFAULT FND_API.G_FALSE
11899: , p_request_id IN EGO_ITM_USR_ATTR_INTRFC.REQUEST_ID%TYPE DEFAULT NULL
11900: )
11901: RETURN EGO_ITM_USR_ATTR_INTRFC.ATTR_VALUE_NUM%TYPE IS
11902: BEGIN
11903: RETURN GET_REV_USR_ATTR_NUM
11904: (
11905: p_batch_id => p_batch_id

Line 12029: -- EGO_ITM_USR_ATTR_INTRFC --

12025: AND SOURCE_SYSTEM_REFERENCE = p_src_system_ref
12026: AND PROCESS_FLAG = 0;
12027:
12028: -----------------------------
12029: -- EGO_ITM_USR_ATTR_INTRFC --
12030: -----------------------------
12031: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI
12032: SET ORGANIZATION_ID =
12033: NVL(ORGANIZATION_ID,

Line 12031: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI

12027:
12028: -----------------------------
12029: -- EGO_ITM_USR_ATTR_INTRFC --
12030: -----------------------------
12031: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI
12032: SET ORGANIZATION_ID =
12033: NVL(ORGANIZATION_ID,
12034: (SELECT MP.ORGANIZATION_ID
12035: FROM MTL_PARAMETERS MP

Line 12172: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE

12168: -- MSI interface, and finally, the user-defined attributes interface table. --
12169: ------------------------------------------------------------------------------------------
12170: FUNCTION GET_LATEST_REVISION_FUNC
12171: (
12172: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
12173: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
12174: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
12175: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
12176: )

Line 12173: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE

12169: ------------------------------------------------------------------------------------------
12170: FUNCTION GET_LATEST_REVISION_FUNC
12171: (
12172: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
12173: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
12174: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
12175: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
12176: )
12177: RETURN VARCHAR2

Line 12174: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE

12170: FUNCTION GET_LATEST_REVISION_FUNC
12171: (
12172: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
12173: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
12174: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
12175: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
12176: )
12177: RETURN VARCHAR2
12178: IS

Line 12175: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE

12171: (
12172: p_batch_id IN EGO_ITM_USR_ATTR_INTRFC.DATA_SET_ID%TYPE
12173: , p_source_system_id IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_ID%TYPE
12174: , p_source_system_reference IN EGO_ITM_USR_ATTR_INTRFC.SOURCE_SYSTEM_REFERENCE%TYPE
12175: , p_organization_id IN EGO_ITM_USR_ATTR_INTRFC.ORGANIZATION_ID%TYPE
12176: )
12177: RETURN VARCHAR2
12178: IS
12179: