APPS.GML_OP_ORDR_STS_PKG dependencies on OP_ORDR_STS_B

Line 18: cursor C is select ROWID from OP_ORDR_STS_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 OP_ORDR_STS_B
19: where ORDER_STATUS = X_ORDER_STATUS
20: ;
21: begin
22: insert into OP_ORDR_STS_B (

Line 22: insert into OP_ORDR_STS_B (

18: cursor C is select ROWID from OP_ORDR_STS_B
19: where ORDER_STATUS = X_ORDER_STATUS
20: ;
21: begin
22: insert into OP_ORDR_STS_B (
23: ORDER_STATUS,
24: LANG_CODE,
25: TRANS_CNT,
26: TEXT_CODE,

Line 95: /* BUG 1272860 Changed table from OP_ORDR_STS_B to OP_ORDR_STS_VL in cursor c. */

91: X_DELETE_MARK in NUMBER,
92: X_ORDER_STATUS_CODE in VARCHAR2,
93: X_ORDER_STATUS_DESC in VARCHAR2
94: ) is
95: /* BUG 1272860 Changed table from OP_ORDR_STS_B to OP_ORDR_STS_VL in cursor c. */
96: cursor c is select
97: LANG_CODE,
98: TRANS_CNT,
99: TEXT_CODE,

Line 164: update OP_ORDR_STS_B set

160: X_LAST_UPDATED_BY in NUMBER,
161: X_LAST_UPDATE_LOGIN in NUMBER
162: ) is
163: begin
164: update OP_ORDR_STS_B set
165: LANG_CODE = X_LANG_CODE,
166: TRANS_CNT = X_TRANS_CNT,
167: TEXT_CODE = X_TEXT_CODE,
168: DELETE_MARK = X_DELETE_MARK,

Line 204: delete from OP_ORDR_STS_B

200: if (sql%notfound) then
201: raise no_data_found;
202: end if;
203:
204: delete from OP_ORDR_STS_B
205: where ORDER_STATUS = X_ORDER_STATUS;
206:
207: if (sql%notfound) then
208: raise no_data_found;

Line 218: from OP_ORDR_STS_B B

214: begin
215: delete from OP_ORDR_STS_TL T
216: where not exists
217: (select NULL
218: from OP_ORDR_STS_B B
219: where B.ORDER_STATUS = T.ORDER_STATUS
220: );
221:
222: update OP_ORDR_STS_TL T set (