APPS.PA_CC_TP_RULES_BG_PKG dependencies on PA_CC_TP_RULES_BG

Line 1: package body PA_CC_TP_RULES_BG_PKG AS

1: package body PA_CC_TP_RULES_BG_PKG AS
2: /* $Header: PAXTPRTB.pls 120.2 2005/08/05 03:28:35 rgandhi noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,/*File.sql.39*/
5: X_TP_RULE_ID in NUMBER,

Line 38: cursor C is select ROWID from PA_CC_TP_RULES_BG

34: X_LAST_UPDATE_DATE in DATE,
35: X_LAST_UPDATED_BY in NUMBER,
36: X_LAST_UPDATE_LOGIN in NUMBER
37: ) is
38: cursor C is select ROWID from PA_CC_TP_RULES_BG
39: where TP_RULE_ID = X_TP_RULE_ID;
40: begin
41: insert into PA_CC_TP_RULES_BG (
42: TP_RULE_ID,

Line 41: insert into PA_CC_TP_RULES_BG (

37: ) is
38: cursor C is select ROWID from PA_CC_TP_RULES_BG
39: where TP_RULE_ID = X_TP_RULE_ID;
40: begin
41: insert into PA_CC_TP_RULES_BG (
42: TP_RULE_ID,
43: BUSINESS_GROUP_ID,
44: NAME,
45: RULE_TYPE,

Line 172: from PA_CC_TP_RULES_BG

168: ATTRIBUTE13,
169: ATTRIBUTE14,
170: ATTRIBUTE15,
171: DESCRIPTION
172: from PA_CC_TP_RULES_BG
173: where TP_RULE_ID = X_TP_RULE_ID
174: for update of TP_RULE_ID nowait;
175: begin
176: for tlinfo in c1 loop

Line 266: update PA_CC_TP_RULES_BG set

262: X_LAST_UPDATED_BY in NUMBER,
263: X_LAST_UPDATE_LOGIN in NUMBER
264: ) is
265: begin
266: update PA_CC_TP_RULES_BG set
267: BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID,
268: tp_rule_id = x_tp_rule_id,
269: NAME = X_NAME,
270: RULE_TYPE = X_RULE_TYPE,

Line 308: delete from PA_CC_TP_RULES_BG

304: procedure DELETE_ROW (
305: X_TP_RULE_ID in NUMBER
306: ) is
307: begin
308: delete from PA_CC_TP_RULES_BG
309: where TP_RULE_ID = X_TP_RULE_ID;
310:
311: if (sql%notfound) then
312: raise no_data_found;

Line 317: end PA_CC_TP_RULES_BG_PKG;

313: end if;
314:
315: end DELETE_ROW;
316:
317: end PA_CC_TP_RULES_BG_PKG;