APPS.FRM_DELIVERY_CONFIGS_PKG dependencies on FRM_DELIVERY_CONFIGURATIONS_B

Line 16: cursor C is select ROWID from FRM_DELIVERY_CONFIGURATIONS_B

12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from FRM_DELIVERY_CONFIGURATIONS_B
17: where CONFIGURATION_ID = X_CONFIGURATION_ID
18: ;
19: begin
20: insert into FRM_DELIVERY_CONFIGURATIONS_B (

Line 20: insert into FRM_DELIVERY_CONFIGURATIONS_B (

16: cursor C is select ROWID from FRM_DELIVERY_CONFIGURATIONS_B
17: where CONFIGURATION_ID = X_CONFIGURATION_ID
18: ;
19: begin
20: insert into FRM_DELIVERY_CONFIGURATIONS_B (
21: CONFIGURATION_ID,
22: START_DATE,
23: END_DATE,
24: OBJECT_VERSION_NUMBER,

Line 91: from FRM_DELIVERY_CONFIGURATIONS_B

87: cursor c is select
88: START_DATE,
89: END_DATE,
90: OBJECT_VERSION_NUMBER
91: from FRM_DELIVERY_CONFIGURATIONS_B
92: where CONFIGURATION_ID = X_CONFIGURATION_ID
93: for update of CONFIGURATION_ID nowait;
94: recinfo c%rowtype;
95:

Line 148: update FRM_DELIVERY_CONFIGURATIONS_B set

144: X_LAST_UPDATED_BY in NUMBER,
145: X_LAST_UPDATE_LOGIN in NUMBER
146: ) is
147: begin
148: update FRM_DELIVERY_CONFIGURATIONS_B set
149: START_DATE = X_START_DATE,
150: END_DATE = X_END_DATE,
151: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
152: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 186: delete from FRM_DELIVERY_CONFIGURATIONS_B

182: if (sql%notfound) then
183: raise no_data_found;
184: end if;
185:
186: delete from FRM_DELIVERY_CONFIGURATIONS_B
187: where CONFIGURATION_ID = X_CONFIGURATION_ID;
188:
189: if (sql%notfound) then
190: raise no_data_found;

Line 200: from FRM_DELIVERY_CONFIGURATIONS_B B

196: begin
197: delete from FRM_DELIVERY_CONFIGURATIONS_TL T
198: where not exists
199: (select NULL
200: from FRM_DELIVERY_CONFIGURATIONS_B B
201: where B.CONFIGURATION_ID = T.CONFIGURATION_ID
202: );
203:
204: update FRM_DELIVERY_CONFIGURATIONS_TL T set (