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.ZX_FC_CODES_PKG dependencies on ZX_FC_CODES_DENORM_B

Line 49: p_concat_code Zx_Fc_Codes_Denorm_B.CONCAT_CLASSIF_CODE%TYPE;

45: p_type_code ZX_FC_TYPES_VL.CLASSIFICATION_TYPE_CODE%TYPE;
46: p_type_name ZX_FC_TYPES_VL.CLASSIFICATION_TYPE_NAME%TYPE;
47: p_type_categ ZX_FC_TYPES_VL.Classification_Type_Categ_Code%TYPE;
48: p_delimiter ZX_FC_TYPES_VL.DELIMITER%TYPE;
49: p_concat_code Zx_Fc_Codes_Denorm_B.CONCAT_CLASSIF_CODE%TYPE;
50: p_concat_name Zx_Fc_Codes_Denorm_B.CONCAT_CLASSIF_NAME%TYPE;
51: p_code_level Zx_Fc_Codes_Denorm_B.CLASSIFICATION_CODE_LEVEL%TYPE;
52: p_parent_name Zx_Fc_Codes_Denorm_B.CLASSIFICATION_NAME%TYPE;
53: TYPE p_seg_t IS TABLE OF VARCHAR2(30) index BY BINARY_INTEGER;

Line 50: p_concat_name Zx_Fc_Codes_Denorm_B.CONCAT_CLASSIF_NAME%TYPE;

46: p_type_name ZX_FC_TYPES_VL.CLASSIFICATION_TYPE_NAME%TYPE;
47: p_type_categ ZX_FC_TYPES_VL.Classification_Type_Categ_Code%TYPE;
48: p_delimiter ZX_FC_TYPES_VL.DELIMITER%TYPE;
49: p_concat_code Zx_Fc_Codes_Denorm_B.CONCAT_CLASSIF_CODE%TYPE;
50: p_concat_name Zx_Fc_Codes_Denorm_B.CONCAT_CLASSIF_NAME%TYPE;
51: p_code_level Zx_Fc_Codes_Denorm_B.CLASSIFICATION_CODE_LEVEL%TYPE;
52: p_parent_name Zx_Fc_Codes_Denorm_B.CLASSIFICATION_NAME%TYPE;
53: TYPE p_seg_t IS TABLE OF VARCHAR2(30) index BY BINARY_INTEGER;
54: TYPE p_seg_tn IS TABLE OF Zx_Fc_Codes_Denorm_B.CLASSIFICATION_NAME%TYPE index BY BINARY_INTEGER;

Line 51: p_code_level Zx_Fc_Codes_Denorm_B.CLASSIFICATION_CODE_LEVEL%TYPE;

47: p_type_categ ZX_FC_TYPES_VL.Classification_Type_Categ_Code%TYPE;
48: p_delimiter ZX_FC_TYPES_VL.DELIMITER%TYPE;
49: p_concat_code Zx_Fc_Codes_Denorm_B.CONCAT_CLASSIF_CODE%TYPE;
50: p_concat_name Zx_Fc_Codes_Denorm_B.CONCAT_CLASSIF_NAME%TYPE;
51: p_code_level Zx_Fc_Codes_Denorm_B.CLASSIFICATION_CODE_LEVEL%TYPE;
52: p_parent_name Zx_Fc_Codes_Denorm_B.CLASSIFICATION_NAME%TYPE;
53: TYPE p_seg_t IS TABLE OF VARCHAR2(30) index BY BINARY_INTEGER;
54: TYPE p_seg_tn IS TABLE OF Zx_Fc_Codes_Denorm_B.CLASSIFICATION_NAME%TYPE index BY BINARY_INTEGER;
55: p_seg p_seg_t;

Line 52: p_parent_name Zx_Fc_Codes_Denorm_B.CLASSIFICATION_NAME%TYPE;

48: p_delimiter ZX_FC_TYPES_VL.DELIMITER%TYPE;
49: p_concat_code Zx_Fc_Codes_Denorm_B.CONCAT_CLASSIF_CODE%TYPE;
50: p_concat_name Zx_Fc_Codes_Denorm_B.CONCAT_CLASSIF_NAME%TYPE;
51: p_code_level Zx_Fc_Codes_Denorm_B.CLASSIFICATION_CODE_LEVEL%TYPE;
52: p_parent_name Zx_Fc_Codes_Denorm_B.CLASSIFICATION_NAME%TYPE;
53: TYPE p_seg_t IS TABLE OF VARCHAR2(30) index BY BINARY_INTEGER;
54: TYPE p_seg_tn IS TABLE OF Zx_Fc_Codes_Denorm_B.CLASSIFICATION_NAME%TYPE index BY BINARY_INTEGER;
55: p_seg p_seg_t;
56: p_seg_name p_seg_tn;

Line 54: TYPE p_seg_tn IS TABLE OF Zx_Fc_Codes_Denorm_B.CLASSIFICATION_NAME%TYPE index BY BINARY_INTEGER;

50: p_concat_name Zx_Fc_Codes_Denorm_B.CONCAT_CLASSIF_NAME%TYPE;
51: p_code_level Zx_Fc_Codes_Denorm_B.CLASSIFICATION_CODE_LEVEL%TYPE;
52: p_parent_name Zx_Fc_Codes_Denorm_B.CLASSIFICATION_NAME%TYPE;
53: TYPE p_seg_t IS TABLE OF VARCHAR2(30) index BY BINARY_INTEGER;
54: TYPE p_seg_tn IS TABLE OF Zx_Fc_Codes_Denorm_B.CLASSIFICATION_NAME%TYPE index BY BINARY_INTEGER;
55: p_seg p_seg_t;
56: p_seg_name p_seg_tn;
57: p_tmp_seg p_seg_t;
58: p_tmp_seg_name p_seg_tn;

Line 78: ZX_FC_CODES_DENORM_B

74: SEGMENT6,SEGMENT7,SEGMENT8,SEGMENT9,SEGMENT10,
75: SEGMENT1_NAME,SEGMENT2_NAME,SEGMENT3_NAME,SEGMENT4_NAME,SEGMENT5_NAME,
76: SEGMENT6_NAME,SEGMENT7_NAME,SEGMENT8_NAME,SEGMENT9_NAME,SEGMENT10_NAME
77: FROM
78: ZX_FC_CODES_DENORM_B
79: WHERE
80: CLASSIFICATION_ID = X_PARENT_CLASSIFICATION_ID AND
81: LANGUAGE = userenv('LANG');
82: begin

Line 249: INSERT INTO Zx_Fc_Codes_Denorm_B(

245: END LOOP;
246: END IF;
247: CLOSE C_GET_TYPES_INFO;
248:
249: INSERT INTO Zx_Fc_Codes_Denorm_B(
250: CLASSIFICATION_TYPE_ID,
251: CLASSIFICATION_TYPE_CODE,
252: CLASSIFICATION_TYPE_NAME,
253: Classification_Type_Categ_Code,

Line 351: from Zx_Fc_Codes_Denorm_B Denorm

347: from FND_LANGUAGES L
348: where L.INSTALLED_FLAG in ('I', 'B')
349: and not exists
350: (select NULL
351: from Zx_Fc_Codes_Denorm_B Denorm
352: where Denorm.CLASSIFICATION_ID = X_CLASSIFICATION_ID
353: and Denorm.LANGUAGE = L.LANGUAGE_CODE);
354:
355: end INSERT_ROW;

Line 557: p_concat_name Zx_Fc_Codes_Denorm_B.CONCAT_CLASSIF_NAME%TYPE;

553: X_Program_Login_Id in NUMBER,
554: X_OBJECT_VERSION_NUMBER in NUMBER
555: ) is
556: p_delimiter ZX_FC_TYPES_VL.DELIMITER%TYPE;
557: p_concat_name Zx_Fc_Codes_Denorm_B.CONCAT_CLASSIF_NAME%TYPE;
558: begin
559: update ZX_FC_CODES_B set
560: Classification_Code = X_Classification_Code,
561: CLASSIFICATION_TYPE_CODE = X_CLASSIFICATION_TYPE_CODE,

Line 614: Zx_Fc_Codes_Denorm_B CodeDenorm where CLASSIFICATION_ID = X_PARENT_CLASSIFICATION_ID

610: IF X_PARENT_CLASSIFICATION_ID IS NOT NULL THEN
611: select DELIMITER into p_delimiter FROM ZX_FC_TYPES_B WHERE
612: CLASSIFICATION_TYPE_CODE = X_CLASSIFICATION_TYPE_CODE;
613: select CONCAT_CLASSIF_NAME into p_concat_name from
614: Zx_Fc_Codes_Denorm_B CodeDenorm where CLASSIFICATION_ID = X_PARENT_CLASSIFICATION_ID
615: and userenv('LANG') in (LANGUAGE);
616: END IF;
617: -- start bug#7600239
618: update Zx_Fc_Codes_Denorm_B set

Line 618: update Zx_Fc_Codes_Denorm_B set

614: Zx_Fc_Codes_Denorm_B CodeDenorm where CLASSIFICATION_ID = X_PARENT_CLASSIFICATION_ID
615: and userenv('LANG') in (LANGUAGE);
616: END IF;
617: -- start bug#7600239
618: update Zx_Fc_Codes_Denorm_B set
619: COUNTRY_CODE = X_COUNTRY_CODE,
620: EFFECTIVE_TO = X_EFFECTIVE_TO,
621: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
622: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 629: update Zx_Fc_Codes_Denorm_B set

625: PROGRAM_ID=X_PROGRAM_ID ,
626: Program_Login_Id=X_Program_Login_Id
627: where CLASSIFICATION_ID = X_CLASSIFICATION_ID;
628:
629: update Zx_Fc_Codes_Denorm_B set
630: CLASSIFICATION_NAME = X_CLASSIFICATION_NAME,
631: CONCAT_CLASSIF_NAME = p_concat_name || p_delimiter || X_CLASSIFICATION_NAME,
632: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
633: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 715: /* Logic to delete/update/insert into zx_fc_codes_denorm_b table */

711: from ZX_FC_CODES_TL T
712: where T.CLASSIFICATION_ID = B.CLASSIFICATION_ID
713: and T.LANGUAGE = L.LANGUAGE_CODE);
714:
715: /* Logic to delete/update/insert into zx_fc_codes_denorm_b table */
716:
717: delete from ZX_FC_CODES_DENORM_B T
718: where not exists
719: (select NULL

Line 717: delete from ZX_FC_CODES_DENORM_B T

713: and T.LANGUAGE = L.LANGUAGE_CODE);
714:
715: /* Logic to delete/update/insert into zx_fc_codes_denorm_b table */
716:
717: delete from ZX_FC_CODES_DENORM_B T
718: where not exists
719: (select NULL
720: from ZX_FC_CODES_B B
721: where B.CLASSIFICATION_ID = T.CLASSIFICATION_ID

Line 725: SOURCE_LANG column in the ZX_FC_CODES_DENORM_B table */

721: where B.CLASSIFICATION_ID = T.CLASSIFICATION_ID
722: );
723:
724: /* commented out the following code, as we don't have
725: SOURCE_LANG column in the ZX_FC_CODES_DENORM_B table */
726: /*
727: update ZX_FC_CODES_DENORM_B T set (
728: CLASSIFICATION_NAME
729: ) = (select

Line 727: update ZX_FC_CODES_DENORM_B T set (

723:
724: /* commented out the following code, as we don't have
725: SOURCE_LANG column in the ZX_FC_CODES_DENORM_B table */
726: /*
727: update ZX_FC_CODES_DENORM_B T set (
728: CLASSIFICATION_NAME
729: ) = (select
730: B.CLASSIFICATION_NAME
731: from ZX_FC_CODES_DENORM_B B

Line 731: from ZX_FC_CODES_DENORM_B B

727: update ZX_FC_CODES_DENORM_B T set (
728: CLASSIFICATION_NAME
729: ) = (select
730: B.CLASSIFICATION_NAME
731: from ZX_FC_CODES_DENORM_B B
732: where B.CLASSIFICATION_ID = T.CLASSIFICATION_ID
733: and B.LANGUAGE = T.SOURCE_LANG)
734: where (
735: T.CLASSIFICATION_ID,

Line 740: from ZX_FC_CODES_DENORM_B SUBB, ZX_FC_CODES_DENORM_B SUBT

736: T.LANGUAGE
737: ) in (select
738: SUBT.CLASSIFICATION_ID,
739: SUBT.LANGUAGE
740: from ZX_FC_CODES_DENORM_B SUBB, ZX_FC_CODES_DENORM_B SUBT
741: where SUBB.CLASSIFICATION_ID = SUBT.CLASSIFICATION_ID
742: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
743: and (SUBB.CLASSIFICATION_NAME <> SUBT.CLASSIFICATION_NAME
744: ));

Line 747: insert into ZX_FC_CODES_DENORM_B (

743: and (SUBB.CLASSIFICATION_NAME <> SUBT.CLASSIFICATION_NAME
744: ));
745: */
746:
747: insert into ZX_FC_CODES_DENORM_B (
748: CLASSIFICATION_ID,
749: CLASSIFICATION_CODE,
750: CLASSIFICATION_NAME,
751: CLASSIFICATION_TYPE_ID,

Line 845: from ZX_FC_CODES_DENORM_B B, FND_LANGUAGES L

841: B.LAST_UPDATED_BY,
842: B.LAST_UPDATE_DATE,
843: B.LAST_UPDATE_LOGIN,
844: L.LANGUAGE_CODE
845: from ZX_FC_CODES_DENORM_B B, FND_LANGUAGES L
846: where L.INSTALLED_FLAG in ('I', 'B')
847: and B.LANGUAGE = userenv('LANG')
848: and not exists
849: (select NULL

Line 850: from ZX_FC_CODES_DENORM_B T

846: where L.INSTALLED_FLAG in ('I', 'B')
847: and B.LANGUAGE = userenv('LANG')
848: and not exists
849: (select NULL
850: from ZX_FC_CODES_DENORM_B T
851: where T.CLASSIFICATION_ID = B.CLASSIFICATION_ID
852: and T.LANGUAGE = L.LANGUAGE_CODE);
853:
854: end ADD_LANGUAGE;