APPS.FRM_DELIVERY_OPTIONS_PKG dependencies on FRM_DELIVERY_OPTIONS_B

Line 18: cursor C is select ROWID from FRM_DELIVERY_OPTIONS_B

14: X_LAST_UPDATE_DATE in DATE,
15: X_LAST_UPDATED_BY in NUMBER,
16: X_LAST_UPDATE_LOGIN in NUMBER
17: ) is
18: cursor C is select ROWID from FRM_DELIVERY_OPTIONS_B
19: where DELIVERY_ID = X_DELIVERY_ID
20: ;
21: begin
22: insert into FRM_DELIVERY_OPTIONS_B (

Line 22: insert into FRM_DELIVERY_OPTIONS_B (

18: cursor C is select ROWID from FRM_DELIVERY_OPTIONS_B
19: where DELIVERY_ID = X_DELIVERY_ID
20: ;
21: begin
22: insert into FRM_DELIVERY_OPTIONS_B (
23: CONFIGURATION_ID,
24: DELIVERY_ID,
25: DELIVERY_TYPE,
26: START_DATE,

Line 101: from FRM_DELIVERY_OPTIONS_B

97: DELIVERY_TYPE,
98: START_DATE,
99: END_DATE,
100: OBJECT_VERSION_NUMBER
101: from FRM_DELIVERY_OPTIONS_B
102: where DELIVERY_ID = X_DELIVERY_ID
103: for update of DELIVERY_ID nowait;
104: recinfo c%rowtype;
105:

Line 162: update FRM_DELIVERY_OPTIONS_B set

158: X_LAST_UPDATED_BY in NUMBER,
159: X_LAST_UPDATE_LOGIN in NUMBER
160: ) is
161: begin
162: update FRM_DELIVERY_OPTIONS_B set
163: CONFIGURATION_ID = X_CONFIGURATION_ID,
164: DELIVERY_TYPE = X_DELIVERY_TYPE,
165: START_DATE = X_START_DATE,
166: END_DATE = X_END_DATE,

Line 202: delete from FRM_DELIVERY_OPTIONS_B

198: if (sql%notfound) then
199: raise no_data_found;
200: end if;
201:
202: delete from FRM_DELIVERY_OPTIONS_B
203: where DELIVERY_ID = X_DELIVERY_ID;
204:
205: if (sql%notfound) then
206: raise no_data_found;

Line 216: from FRM_DELIVERY_OPTIONS_B B

212: begin
213: delete from FRM_DELIVERY_OPTIONS_TL T
214: where not exists
215: (select NULL
216: from FRM_DELIVERY_OPTIONS_B B
217: where B.DELIVERY_ID = T.DELIVERY_ID
218: );
219:
220: update FRM_DELIVERY_OPTIONS_TL T set (