APPS.QPR_TRANSF_RULES_PKG dependencies on QPR_TRANSF_RULES_B

Line 41: cursor C is select ROWID from QPR_TRANSF_RULES_B

37: X_LAST_UPDATE_DATE in DATE,
38: X_LAST_UPDATED_BY in NUMBER,
39: X_LAST_UPDATE_LOGIN in NUMBER
40: ) is
41: cursor C is select ROWID from QPR_TRANSF_RULES_B
42: where TRANSF_RULE_ID = X_TRANSF_RULE_ID
43: ;
44: begin
45: insert into QPR_TRANSF_RULES_B (

Line 45: insert into QPR_TRANSF_RULES_B (

41: cursor C is select ROWID from QPR_TRANSF_RULES_B
42: where TRANSF_RULE_ID = X_TRANSF_RULE_ID
43: ;
44: begin
45: insert into QPR_TRANSF_RULES_B (
46: TRANSF_RULE_ID,
47: TRANSF_HEADER_ID,
48: LEVEL_VALUE_FROM,
49: LEVEL_VALUE_TO,

Line 223: from QPR_TRANSF_RULES_B

219: LIMIT_DIM_LEVEL,
220: LIMIT_DIM_LEVEL_VALUE,
221: PROGRAM_LOGIN_ID,
222: REQUEST_ID
223: from QPR_TRANSF_RULES_B
224: where TRANSF_RULE_ID = X_TRANSF_RULE_ID
225: for update of TRANSF_RULE_ID nowait;
226: recinfo c%rowtype;
227:

Line 357: update QPR_TRANSF_RULES_B set

353: X_LAST_UPDATED_BY in NUMBER,
354: X_LAST_UPDATE_LOGIN in NUMBER
355: ) is
356: begin
357: update QPR_TRANSF_RULES_B set
358: TRANSF_HEADER_ID = X_TRANSF_HEADER_ID,
359: LEVEL_VALUE_FROM = X_LEVEL_VALUE_FROM,
360: LEVEL_VALUE_TO = X_LEVEL_VALUE_TO,
361: LEVEL_DESC_FROM = X_LEVEL_DESC_FROM,

Line 420: delete from QPR_TRANSF_RULES_B

416: if (sql%notfound) then
417: raise no_data_found;
418: end if;
419:
420: delete from QPR_TRANSF_RULES_B
421: where TRANSF_RULE_ID = X_TRANSF_RULE_ID;
422:
423: if (sql%notfound) then
424: raise no_data_found;

Line 434: from QPR_TRANSF_RULES_B B

430: begin
431: delete from QPR_TRANSF_RULES_TL T
432: where not exists
433: (select NULL
434: from QPR_TRANSF_RULES_B B
435: where B.TRANSF_RULE_ID = T.TRANSF_RULE_ID
436: );
437:
438: update QPR_TRANSF_RULES_TL T set (