APPS.ZX_CONDITION_GROUPS_PKG dependencies on ZX_CONDITION_GROUPS_B

Line 138: cursor C is select ROWID from ZX_CONDITION_GROUPS_B

134: X_PROGRAM_ID in NUMBER,
135: X_PROGRAM_LOGIN_ID in NUMBER,
136: X_CONSTRAINT_ID IN NUMBER,
137: X_OBJECT_VERSION_NUMBER in NUMBER) is
138: cursor C is select ROWID from ZX_CONDITION_GROUPS_B
139: where CONDITION_GROUP_ID = X_CONDITION_GROUP_ID ;
140: begin
141: insert into ZX_CONDITION_GROUPS_B (
142: DETERMINING_FACTOR_CODE10,

Line 141: insert into ZX_CONDITION_GROUPS_B (

137: X_OBJECT_VERSION_NUMBER in NUMBER) is
138: cursor C is select ROWID from ZX_CONDITION_GROUPS_B
139: where CONDITION_GROUP_ID = X_CONDITION_GROUP_ID ;
140: begin
141: insert into ZX_CONDITION_GROUPS_B (
142: DETERMINING_FACTOR_CODE10,
143: COUNTRY_CODE,
144: TAX_PARAMETER_CODE10,
145: DATA_TYPE10_Code,

Line 699: from ZX_CONDITION_GROUPS_B

695: PROGRAM_ID,
696: PROGRAM_LOGIN_ID ,
697: CONSTRAINT_ID ,
698: OBJECT_VERSION_NUMBER
699: from ZX_CONDITION_GROUPS_B
700: where CONDITION_GROUP_ID = X_CONDITION_GROUP_ID
701: for update of CONDITION_GROUP_ID nowait;
702: recinfo c%rowtype;
703: cursor c1 is select

Line 1217: update ZX_CONDITION_GROUPS_B set

1213: UPDATE ZX_PROCESS_RESULTS SET Enabled_Flag = 'N'
1214: WHERE CONDITION_GROUP_ID = X_CONDITION_GROUP_ID;
1215: end if;
1216:
1217: update ZX_CONDITION_GROUPS_B set
1218: DETERMINING_FACTOR_CODE10 = X_DETERMINING_FACTOR_CODE10,
1219: COUNTRY_CODE = X_COUNTRY_CODE,
1220: TAX_PARAMETER_CODE10 = X_TAX_PARAMETER_CODE10,
1221: DATA_TYPE10_CODE = X_DATA_TYPE10_Code,

Line 1376: delete from ZX_CONDITION_GROUPS_B

1372: where CONDITION_GROUP_ID = X_CONDITION_GROUP_ID;
1373: if (sql%notfound) then
1374: raise no_data_found;
1375: end if;
1376: delete from ZX_CONDITION_GROUPS_B
1377: where CONDITION_GROUP_ID = X_CONDITION_GROUP_ID;
1378: if (sql%notfound) then
1379: raise no_data_found;
1380: end if;

Line 1394: from ZX_CONDITION_GROUPS_B B

1390: begin
1391: delete from ZX_CONDITION_GROUPS_TL T
1392: where not exists
1393: (select NULL
1394: from ZX_CONDITION_GROUPS_B B
1395: where B.CONDITION_GROUP_ID = T.CONDITION_GROUP_ID);
1396: update ZX_CONDITION_GROUPS_TL T set (
1397: CONDITION_GROUP_NAME,
1398: CONDITION_GROUP_DESC) = (select B.CONDITION_GROUP_NAME,

Line 1580: INSERT INTO ZX_CONDITION_GROUPS_B (

1576: begin
1577:
1578: If x_condition_group_id.count <> 0 then
1579: forall i in x_condition_group_id.first..x_condition_group_id.last
1580: INSERT INTO ZX_CONDITION_GROUPS_B (
1581: DETERMINING_FACTOR_CODE10,
1582: COUNTRY_CODE,
1583: TAX_PARAMETER_CODE10,
1584: DATA_TYPE10_Code,