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

[Home] [Help]

APPS.BOM_BULKLOAD_PVT_PKG dependencies on EGO_RESULTS_FMT_USAGES

Line 677: Ego_Results_Fmt_Usages erf,

673: bcc.Bom_Intf_Table_Name,
674: bcc.Operation_Type,
675: bcc.Lookup_Type
676: FROM
677: Ego_Results_Fmt_Usages erf,
678: Bom_Component_Columns bcc
679: WHERE
680: (Region_Code = 'BOM_RESULT_DUMMY_REGION'
681: OR -- Fix for import Region

Line 774: -- Getting the Intf_column names from the ego_results_fmt_usages for the attributes

770: FND_FILE.PUT_LINE( FND_FILE.LOG,'No Rows to Process for Data Separation' );
771: return;
772: end if;
773:
774: -- Getting the Intf_column names from the ego_results_fmt_usages for the attributes
775: -- of OrgCode and CompSeqId. Previously we hard-coding them
776: IF l_debug = 'Y' THEN
777: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_ORG_CODE before :--->' || G_INTF_ORG_CODE);
778: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_COMP_SEQ_ID before :--->' || G_INTF_COMP_SEQ_ID);

Line 784: Select INTF_COLUMN_NAME into G_INTF_ORG_CODE FROM Ego_Results_Fmt_Usages erf

780: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_PARENT_REVISION before :--->' || G_INTF_PARENT_REVISION);
781: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_REVISION before :--->' || G_INTF_REVISION);
782: END IF;
783:
784: Select INTF_COLUMN_NAME into G_INTF_ORG_CODE FROM Ego_Results_Fmt_Usages erf
785: WHERE Resultfmt_Usage_Id = p_Resultfmt_Usage_Id AND ATTRIBUTE_CODE = 'ORGANIZATION_CODE';
786:
787: BEGIN -- In imort formats may not be having the attribute ComponentSequenceId
788: Select INTF_COLUMN_NAME into G_INTF_COMP_SEQ_ID FROM Ego_Results_Fmt_Usages erf

Line 788: Select INTF_COLUMN_NAME into G_INTF_COMP_SEQ_ID FROM Ego_Results_Fmt_Usages erf

784: Select INTF_COLUMN_NAME into G_INTF_ORG_CODE FROM Ego_Results_Fmt_Usages erf
785: WHERE Resultfmt_Usage_Id = p_Resultfmt_Usage_Id AND ATTRIBUTE_CODE = 'ORGANIZATION_CODE';
786:
787: BEGIN -- In imort formats may not be having the attribute ComponentSequenceId
788: Select INTF_COLUMN_NAME into G_INTF_COMP_SEQ_ID FROM Ego_Results_Fmt_Usages erf
789: WHERE Resultfmt_Usage_Id = p_Resultfmt_Usage_Id AND ATTRIBUTE_CODE = 'COMPONENT_SEQUENCE_ID';
790: EXCEPTION
791: WHEN NO_DATA_FOUND THEN
792: G_INTF_COMP_SEQ_ID := 'NULL';

Line 796: Select INTF_COLUMN_NAME into G_INTF_ASSEMBLY_TYPE FROM Ego_Results_Fmt_Usages erf

792: G_INTF_COMP_SEQ_ID := 'NULL';
793: END;
794:
795: BEGIN
796: Select INTF_COLUMN_NAME into G_INTF_ASSEMBLY_TYPE FROM Ego_Results_Fmt_Usages erf
797: WHERE Resultfmt_Usage_Id = p_Resultfmt_Usage_Id AND ATTRIBUTE_CODE = 'SUB_ASSEMBLY_TYPE';
798: EXCEPTION
799: WHEN NO_DATA_FOUND THEN
800: G_INTF_ASSEMBLY_TYPE := 'NULL';

Line 804: Select INTF_COLUMN_NAME into G_INTF_PARENT_REVISION FROM Ego_Results_Fmt_Usages erf

800: G_INTF_ASSEMBLY_TYPE := 'NULL';
801: END;
802:
803: BEGIN
804: Select INTF_COLUMN_NAME into G_INTF_PARENT_REVISION FROM Ego_Results_Fmt_Usages erf
805: WHERE Resultfmt_Usage_Id = p_Resultfmt_Usage_Id AND ATTRIBUTE_CODE = 'PARENT_REVISION_CODE';
806: EXCEPTION
807: WHEN NO_DATA_FOUND THEN
808: G_INTF_PARENT_REVISION := 'NULL';

Line 812: Select INTF_COLUMN_NAME into G_INTF_REVISION FROM Ego_Results_Fmt_Usages erf

808: G_INTF_PARENT_REVISION := 'NULL';
809: END;
810:
811: BEGIN
812: Select INTF_COLUMN_NAME into G_INTF_REVISION FROM Ego_Results_Fmt_Usages erf
813: WHERE Resultfmt_Usage_Id = p_Resultfmt_Usage_Id AND ATTRIBUTE_CODE = 'REVISION';
814: EXCEPTION
815: WHEN NO_DATA_FOUND THEN
816: G_INTF_REVISION := 'NULL';

Line 828: Select INTF_COLUMN_NAME into G_INTF_REF_DESIG FROM Ego_Results_Fmt_Usages erf

824: FND_FILE.PUT_LINE( FND_FILE.LOG,'G_INTF_REVISION after :--->' || G_INTF_REVISION);
825: END IF;
826:
827: BEGIN -- In imort formats may not be having the attribute COMPONENT_REFERENCE_DESIGNATOR
828: Select INTF_COLUMN_NAME into G_INTF_REF_DESIG FROM Ego_Results_Fmt_Usages erf
829: WHERE Resultfmt_Usage_Id = p_Resultfmt_Usage_Id AND ATTRIBUTE_CODE = 'COMPONENT_REFERENCE_DESIGNATOR';
830: EXCEPTION
831: WHEN NO_DATA_FOUND THEN
832: G_INTF_REF_DESIG := 'NULL';

Line 1921: FROM ego_results_fmt_usages

1917: -- To retrieve Attribute group codes, for given Result Format Usage ID.
1918: ------------------------------------------------------------------------------
1919: CURSOR c_user_attr_group_codes (c_resultfmt_usage_id IN NUMBER) IS
1920: SELECT DISTINCT To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, '$$') - 1)) attr_group_id
1921: FROM ego_results_fmt_usages
1922: WHERE resultfmt_usage_id = c_resultfmt_usage_id
1923: AND attribute_code LIKE '%$$%'
1924: AND To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, '$$') - 1)) IN --attr_group_id
1925: ------------------------------------------------------------------------------

Line 2098: l_dyn_sql := l_dyn_sql || ' FROM ego_results_fmt_usages ';

2094: -- Fetch Organization ID, Item Number in Temp PLSQL tables.
2095: --------------------------------------------------------------------
2096: l_dyn_sql := '';
2097: l_dyn_sql := ' SELECT To_Number(SUBSTR(attribute_code, INSTR(attribute_code, ''$$'')+2)) attr_id, intf_column_name ';
2098: l_dyn_sql := l_dyn_sql || ' FROM ego_results_fmt_usages ';
2099: l_dyn_sql := l_dyn_sql || ' WHERE resultfmt_usage_id = :RESULTFMT_USAGE_ID';
2100: l_dyn_sql := l_dyn_sql || ' AND attribute_code LIKE :ATTRIBUTE_CODE ';
2101:
2102: Write_Debug(l_dyn_sql);