APPS.PA_ALLOC_RESOURCES_PKG dependencies on PA_ALLOC_RESOURCES

Line 1: package body PA_ALLOC_RESOURCES_PKG AS

1: package body PA_ALLOC_RESOURCES_PKG AS
2: /* $Header: PAXATRSB.pls 120.2 2005/08/19 16:18:57 ramurthy noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_RULE_ID in NUMBER,

Line 18: cursor C is select ROWID from PA_ALLOC_RESOURCES

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 PA_ALLOC_RESOURCES
19: where RULE_ID = X_RULE_ID
20: and MEMBER_TYPE = X_MEMBER_TYPE
21: and RESOURCE_LIST_MEMBER_ID = X_RESOURCE_LIST_MEMBER_ID;
22:

Line 25: insert into PA_ALLOC_RESOURCES (

21: and RESOURCE_LIST_MEMBER_ID = X_RESOURCE_LIST_MEMBER_ID;
22:
23: begin
24:
25: insert into PA_ALLOC_RESOURCES (
26: RULE_ID,
27: MEMBER_TYPE,
28: RESOURCE_LIST_MEMBER_ID,
29: EXCLUDE_FLAG,

Line 77: from PA_ALLOC_RESOURCES

73: EXCLUDE_FLAG,
74: TARGET_EXPND_TYPE,
75: OFFSET_EXPND_TYPE,
76: RESOURCE_PERCENTAGE
77: from PA_ALLOC_RESOURCES
78: where RULE_ID = X_RULE_ID
79: and MEMBER_TYPE = X_MEMBER_TYPE
80: and RESOURCE_LIST_MEMBER_ID = X_RESOURCE_LIST_MEMBER_ID
81: for update of RULE_ID nowait;

Line 131: update PA_ALLOC_RESOURCES set

127: is
128:
129: begin
130:
131: update PA_ALLOC_RESOURCES set
132: RESOURCE_LIST_MEMBER_ID = X_RESOURCE_LIST_MEMBER_ID,
133: EXCLUDE_FLAG = X_EXCLUDE_FLAG,
134: TARGET_EXPND_TYPE = X_TARGET_EXPND_TYPE,
135: OFFSET_EXPND_TYPE = X_OFFSET_EXPND_TYPE,

Line 150: delete from PA_ALLOC_RESOURCES

146:
147: procedure DELETE_ROW (X_ROWID in varchar2
148: ) is
149: begin
150: delete from PA_ALLOC_RESOURCES
151: where ROWID = X_ROWID;
152: if (sql%notfound) then
153: raise no_data_found;
154: end if;

Line 157: end PA_ALLOC_RESOURCES_PKG;

153: raise no_data_found;
154: end if;
155: end DELETE_ROW;
156:
157: end PA_ALLOC_RESOURCES_PKG;