APPS.QPR_TRANSF_GROUPS_PKG dependencies on QPR_TRANSF_GROUPS_B

Line 17: cursor C is select ROWID from QPR_TRANSF_GROUPS_B

13: X_LAST_UPDATE_DATE in DATE,
14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER
16: ) is
17: cursor C is select ROWID from QPR_TRANSF_GROUPS_B
18: where TRANSF_GROUP_ID = X_TRANSF_GROUP_ID
19: ;
20: begin
21: insert into QPR_TRANSF_GROUPS_B (

Line 21: insert into QPR_TRANSF_GROUPS_B (

17: cursor C is select ROWID from QPR_TRANSF_GROUPS_B
18: where TRANSF_GROUP_ID = X_TRANSF_GROUP_ID
19: ;
20: begin
21: insert into QPR_TRANSF_GROUPS_B (
22: PROGRAM_LOGIN_ID,
23: REQUEST_ID,
24: TRANSF_GROUP_ID,
25: TRANSF_TYPE_CODE,

Line 103: from QPR_TRANSF_GROUPS_B

99: cursor c is select
100: PROGRAM_LOGIN_ID,
101: REQUEST_ID,
102: TRANSF_TYPE_CODE
103: from QPR_TRANSF_GROUPS_B
104: where TRANSF_GROUP_ID = X_TRANSF_GROUP_ID
105: for update of TRANSF_GROUP_ID nowait;
106: recinfo c%rowtype;
107:

Line 166: update QPR_TRANSF_GROUPS_B set

162: X_LAST_UPDATED_BY in NUMBER,
163: X_LAST_UPDATE_LOGIN in NUMBER
164: ) is
165: begin
166: update QPR_TRANSF_GROUPS_B set
167: PROGRAM_LOGIN_ID = X_PROGRAM_LOGIN_ID,
168: REQUEST_ID = X_REQUEST_ID,
169: TRANSF_TYPE_CODE = X_TRANSF_TYPE_CODE,
170: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 205: delete from QPR_TRANSF_GROUPS_B

201: if (sql%notfound) then
202: raise no_data_found;
203: end if;
204:
205: delete from QPR_TRANSF_GROUPS_B
206: where TRANSF_GROUP_ID = X_TRANSF_GROUP_ID;
207:
208: if (sql%notfound) then
209: raise no_data_found;

Line 219: from QPR_TRANSF_GROUPS_B B

215: begin
216: delete from QPR_TRANSF_GROUPS_TL T
217: where not exists
218: (select NULL
219: from QPR_TRANSF_GROUPS_B B
220: where B.TRANSF_GROUP_ID = T.TRANSF_GROUP_ID
221: );
222:
223: update QPR_TRANSF_GROUPS_TL T set (