APPS.PA_ALLOC_SOURCE_LINES_PKG dependencies on PA_ALLOC_SOURCE_LINES

Line 1: package body PA_ALLOC_SOURCE_LINES_PKG AS

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

Line 22: cursor C is select ROWID from PA_ALLOC_SOURCE_LINES

18: X_LAST_UPDATE_DATE in DATE,
19: X_LAST_UPDATED_BY in NUMBER,
20: X_LAST_UPDATE_LOGIN in NUMBER
21: ) is
22: cursor C is select ROWID from PA_ALLOC_SOURCE_LINES
23: where RULE_ID = X_RULE_ID
24: and LINE_NUM = X_LINE_NUM;
25: begin
26:

Line 27: insert into PA_ALLOC_SOURCE_LINES (

23: where RULE_ID = X_RULE_ID
24: and LINE_NUM = X_LINE_NUM;
25: begin
26:
27: insert into PA_ALLOC_SOURCE_LINES (
28: RULE_ID,
29: LINE_NUM,
30: PROJECT_ORG_ID,
31: TASK_ORG_ID,

Line 95: from PA_ALLOC_SOURCE_LINES

91: SERVICE_TYPE,
92: PROJECT_ID,
93: TASK_ID,
94: EXCLUDE_FLAG
95: from PA_ALLOC_SOURCE_LINES
96: where RULE_ID = X_RULE_ID
97: and LINE_NUM = X_LINE_NUM
98: for update of RULE_ID nowait;
99: tlinfo c1%rowtype;

Line 166: update PA_ALLOC_SOURCE_LINES set

162: ) is
163:
164: begin
165:
166: update PA_ALLOC_SOURCE_LINES set
167: LINE_NUM = X_LINE_NUM,
168: PROJECT_ORG_ID = X_PROJECT_ORG_ID,
169: TASK_ORG_ID = X_TASK_ORG_ID,
170: PROJECT_TYPE = X_PROJECT_TYPE,

Line 193: delete from PA_ALLOC_SOURCE_LINES

189: -- X_RULE_ID in NUMBER,
190: -- X_LINE_NUM in NUMBER
191: ) is
192: begin
193: delete from PA_ALLOC_SOURCE_LINES
194: where ROWID = X_ROWID ;
195: --RULE_ID = X_RULE_ID
196: -- and LINE_NUM = X_LINE_NUM;
197: if (sql%notfound) then

Line 202: end PA_ALLOC_SOURCE_LINES_PKG;

198: raise no_data_found;
199: end if;
200: end DELETE_ROW;
201:
202: end PA_ALLOC_SOURCE_LINES_PKG;