APPS.GML_OP_PRSL_TYP_PKG dependencies on OP_PRSL_TYP_B

Line 20: cursor C is select ROWID from OP_PRSL_TYP_B

16: X_LAST_UPDATE_DATE in DATE,
17: X_LAST_UPDATED_BY in NUMBER,
18: X_LAST_UPDATE_LOGIN in NUMBER
19: ) is
20: cursor C is select ROWID from OP_PRSL_TYP_B
21: where PRESALES_ORD_TYPE = X_PRESALES_ORD_TYPE
22: ;
23: begin
24: insert into OP_PRSL_TYP_B (

Line 24: insert into OP_PRSL_TYP_B (

20: cursor C is select ROWID from OP_PRSL_TYP_B
21: where PRESALES_ORD_TYPE = X_PRESALES_ORD_TYPE
22: ;
23: begin
24: insert into OP_PRSL_TYP_B (
25: PRESALES_ORD_TYPE,
26: LANG_CODE,
27: RELEASE_SCHED_REQD,
28: PRICELIST_IND,

Line 110: from OP_PRSL_TYP_B

106: PRICELIST_IND,
107: TRANS_CNT,
108: TEXT_CODE,
109: DELETE_MARK
110: from OP_PRSL_TYP_B
111: where PRESALES_ORD_TYPE = X_PRESALES_ORD_TYPE
112: for update of PRESALES_ORD_TYPE nowait;
113: recinfo c%rowtype;
114:

Line 176: update OP_PRSL_TYP_B set

172: X_LAST_UPDATED_BY in NUMBER,
173: X_LAST_UPDATE_LOGIN in NUMBER
174: ) is
175: begin
176: update OP_PRSL_TYP_B set
177: LANG_CODE = X_LANG_CODE,
178: RELEASE_SCHED_REQD = X_RELEASE_SCHED_REQD,
179: PRICELIST_IND = X_PRICELIST_IND,
180: TRANS_CNT = X_TRANS_CNT,

Line 218: delete from OP_PRSL_TYP_B

214: if (sql%notfound) then
215: raise no_data_found;
216: end if;
217:
218: delete from OP_PRSL_TYP_B
219: where PRESALES_ORD_TYPE = X_PRESALES_ORD_TYPE;
220:
221: if (sql%notfound) then
222: raise no_data_found;

Line 232: from OP_PRSL_TYP_B B

228: begin
229: delete from OP_PRSL_TYP_TL T
230: where not exists
231: (select NULL
232: from OP_PRSL_TYP_B B
233: where B.PRESALES_ORD_TYPE = T.PRESALES_ORD_TYPE
234: );
235:
236: update OP_PRSL_TYP_TL T set (