APPS.ZX_FC_CODES_PKG dependencies on ZX_FC_CODES_B

Line 59: cursor C is select ROWID from ZX_FC_CODES_B

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;
59: cursor C is select ROWID from ZX_FC_CODES_B
60: where CLASSIFICATION_ID = X_CLASSIFICATION_ID ;
61: cursor C_GET_TYPES_INFO is
62: SELECT
63: TYPE.CLASSIFICATION_TYPE_ID,

Line 83: insert into ZX_FC_CODES_B (

79: WHERE
80: CLASSIFICATION_ID = X_PARENT_CLASSIFICATION_ID AND
81: LANGUAGE = userenv('LANG');
82: begin
83: insert into ZX_FC_CODES_B (
84: CLASSIFICATION_ID,
85: Classification_Code,
86: CLASSIFICATION_TYPE_CODE,
87: PARENT_CLASSIFICATION_ID,

Line 422: from ZX_FC_CODES_B

418: PROGRAM_APPLICATION_ID,
419: PROGRAM_ID,
420: Program_Login_Id ,
421: OBJECT_VERSION_NUMBER
422: from ZX_FC_CODES_B
423: where CLASSIFICATION_ID = X_CLASSIFICATION_ID
424: for update of CLASSIFICATION_ID nowait;
425: recinfo c%rowtype;
426: cursor c1 is select

Line 559: update ZX_FC_CODES_B set

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,
562: PARENT_CLASSIFICATION_ID = X_PARENT_CLASSIFICATION_ID,
563: PARENT_CLASSIFICATION_CODE = X_PARENT_CLASSIFICATION_CODE,

Line 652: delete from ZX_FC_CODES_B

648: where CLASSIFICATION_ID = X_CLASSIFICATION_ID;
649: if (sql%notfound) then
650: raise no_data_found;
651: end if;
652: delete from ZX_FC_CODES_B
653: where CLASSIFICATION_ID = X_CLASSIFICATION_ID;
654: if (sql%notfound) then
655: raise no_data_found;
656: end if;

Line 665: from ZX_FC_CODES_B B

661: begin
662: delete from ZX_FC_CODES_TL T
663: where not exists
664: (select NULL
665: from ZX_FC_CODES_B B
666: where B.CLASSIFICATION_ID = T.CLASSIFICATION_ID
667: );
668: update ZX_FC_CODES_TL T set (
669: CLASSIFICATION_NAME

Line 720: from ZX_FC_CODES_B B

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
722: );
723:
724: /* commented out the following code, as we don't have