APPS.PA_ALLOC_RULES_ALL_PKG dependencies on PA_ALLOC_RULES_ALL

Line 1: package body PA_ALLOC_RULES_ALL_PKG AS

1: package body PA_ALLOC_RULES_ALL_PKG AS
2: /* $Header: PAXATRLB.pls 120.2 2005/06/20 12:58:54 dlanka noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_RULE_ID in out NOCOPY NUMBER,

Line 68: cursor C is select ROWID from PA_ALLOC_RULES_ALL

64: X_BASIS_RBS_VERSION In Number ,
65: X_ORG_ID in number
66:
67: ) is
68: cursor C is select ROWID from PA_ALLOC_RULES_ALL
69: where RULE_ID = X_RULE_ID;
70: CURSOR C1 is Select pa_alloc_rules_s.nextval from sys.dual;
71: --X_LAST_UPDATE_DATE DATE;
72: --X_LAST_UPDATED_BY NUMBER;

Line 82: insert into PA_ALLOC_RULES_ALL (

78: open C1;
79: fetch C1 into X_RULE_ID;
80: close C1;
81: end if;
82: insert into PA_ALLOC_RULES_ALL (
83: RULE_ID,
84: RULE_NAME,
85: DESCRIPTION,
86: POOL_PERCENT,

Line 337: from PA_ALLOC_RULES_ALL

333: BASIS_RESOURCE_STRUCT_TYPE ,
334: ALLOC_RBS_VERSION ,
335: BASIS_RBS_VERSION
336:
337: from PA_ALLOC_RULES_ALL
338: where RULE_ID = X_RULE_ID
339: for update of RULE_ID nowait;
340: tlinfo c1%rowtype;
341:

Line 589: update PA_ALLOC_RULES_ALL set

585:
586: ) is
587: begin
588:
589: update PA_ALLOC_RULES_ALL set
590: RULE_NAME = X_RULE_NAME,
591: DESCRIPTION = X_DESCRIPTION,
592: POOL_PERCENT = X_POOL_PERCENT,
593: PERIOD_TYPE = X_PERIOD_TYPE,

Line 662: delete from PA_ALLOC_RULES_ALL

658: procedure DELETE_ROW (
659: X_RULE_ID in NUMBER
660: ) is
661: begin
662: delete from PA_ALLOC_RULES_ALL
663: where RULE_ID = X_RULE_ID;
664: if (sql%notfound) then
665: raise no_data_found;
666: end if;

Line 686: end PA_ALLOC_RULES_ALL_PKG;

682: /* Bug 2573742 Ends */
683:
684: end DELETE_ROW;
685:
686: end PA_ALLOC_RULES_ALL_PKG;