APPS.ZX_FC_TYPES_PKG dependencies on ZX_DETERMINING_FACTORS_B

Line 173: SELECT Zx_Determining_Factors_B_S.nextval into l_seq_val FROM DUAL;

169: close c;
170: raise no_data_found;
171: end if;
172: close c;
173: SELECT Zx_Determining_Factors_B_S.nextval into l_seq_val FROM DUAL;
174:
175: ZX_DETERMINING_FACTORS_PKG.INSERT_ROW(
176: X_ROWID,
177: l_seq_val, --X_DETERMINING_FACTOR_ID,

Line 206: select count(*) into l_count from ZX_DETERMINING_FACTORS_B where

202: -- If FC Group Code is not null then insert into determining factors. Bug # 5111304
203: IF X_CLASSIFICATION_TYPE_GROUP_CO IS NOT NULL and
204: X_CLASSIFICATION_TYPE_CATEG_CO = 'PRODUCT_FISCAL_CLASS' THEN
205:
206: select count(*) into l_count from ZX_DETERMINING_FACTORS_B where
207: DETERMINING_FACTOR_CLASS_CODE = X_CLASSIFICATION_TYPE_CATEG_CO and
208: DETERMINING_FACTOR_CODE = X_CLASSIFICATION_TYPE_GROUP_CO;
209:
210: -- If FC Group code not exists then insert into determining factors

Line 213: SELECT Zx_Determining_Factors_B_S.nextval into l_seq_val FROM DUAL;

209:
210: -- If FC Group code not exists then insert into determining factors
211: IF l_count = 0 THEN
212:
213: SELECT Zx_Determining_Factors_B_S.nextval into l_seq_val FROM DUAL;
214:
215: ZX_DETERMINING_FACTORS_PKG.INSERT_ROW(
216: X_ROWID,
217: l_seq_val, --X_DETERMINING_FACTOR_ID,

Line 530: SELECT DETERMINING_FACTOR_ID INTO l_det_factor_id FROM ZX_DETERMINING_FACTORS_B

526: Since Classification Type Name and FC Group Code is non updatable field in the UI.*/
527:
528: if( X_Record_Type_Code <> 'SEEDED' ) then
529:
530: SELECT DETERMINING_FACTOR_ID INTO l_det_factor_id FROM ZX_DETERMINING_FACTORS_B
531: WHERE DETERMINING_FACTOR_CODE = X_CLASSIFICATION_TYPE_CODE AND Tax_Rules_Flag = 'Y';
532:
533: ZX_DETERMINING_FACTORS_PKG.UPDATE_ROW
534: (l_det_factor_id, --X_DETERMINING_FACTOR_ID