APPS.ZX_FC_TYPES_PKG dependencies on ZX_FC_TYPES_B

Line 48: cursor C is select ROWID from ZX_FC_TYPES_B

44: X_PROGRAM_ID in NUMBER,
45: X_Program_Login_Id in NUMBER,
46: X_OBJECT_VERSION_NUMBER in NUMBER
47: ) is
48: cursor C is select ROWID from ZX_FC_TYPES_B
49: where CLASSIFICATION_TYPE_ID = X_CLASSIFICATION_TYPE_ID
50: ;
51: l_row_id VARCHAR2(80);
52: l_seq_val NUMBER;

Line 56: insert into ZX_FC_TYPES_B (

52: l_seq_val NUMBER;
53: l_count NUMBER;
54: begin
55:
56: insert into ZX_FC_TYPES_B (
57: CLASSIFICATION_TYPE_ID,
58: CLASSIFICATION_TYPE_CODE,
59: Classification_Type_Categ_Code,
60: CLASSIFICATION_TYPE_GROUP_CODE,

Line 320: from ZX_FC_TYPES_B

316: PROGRAM_APPLICATION_ID,
317: PROGRAM_ID,
318: Program_Login_Id,
319: OBJECT_VERSION_NUMBER
320: from ZX_FC_TYPES_B
321: where CLASSIFICATION_TYPE_ID = X_CLASSIFICATION_TYPE_ID
322: for update of CLASSIFICATION_TYPE_ID nowait;
323: recinfo c%rowtype;
324: cursor c1 is select

Line 471: update ZX_FC_TYPES_B set

467: ) is
468: l_det_factor_id NUMBER;
469: begin
470:
471: update ZX_FC_TYPES_B set
472: CLASSIFICATION_TYPE_CODE = X_CLASSIFICATION_TYPE_CODE,
473: Classification_Type_Categ_Code = X_Classification_Type_Categ_Co,
474: CLASSIFICATION_TYPE_GROUP_CODE = X_CLASSIFICATION_TYPE_GROUP_CO,
475: DELIMITER = X_DELIMITER,

Line 570: delete from ZX_FC_TYPES_B

566: where CLASSIFICATION_TYPE_ID = X_CLASSIFICATION_TYPE_ID;
567: if (sql%notfound) then
568: raise no_data_found;
569: end if;
570: delete from ZX_FC_TYPES_B
571: where CLASSIFICATION_TYPE_ID = X_CLASSIFICATION_TYPE_ID;
572: if (sql%notfound) then
573: raise no_data_found;
574: end if;

Line 583: from ZX_FC_TYPES_B B

579: begin
580: delete from ZX_FC_TYPES_TL T
581: where not exists
582: (select NULL
583: from ZX_FC_TYPES_B B
584: where B.CLASSIFICATION_TYPE_ID = T.CLASSIFICATION_TYPE_ID
585: );
586: update ZX_FC_TYPES_TL T set (
587: CLASSIFICATION_TYPE_NAME