APPS.PA_ALLOC_TARGET_LINES_PKG dependencies on PA_ALLOC_TARGET_LINES

Line 1: package body PA_ALLOC_TARGET_LINES_PKG AS

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

Line 24: cursor C is select ROWID from PA_ALLOC_TARGET_LINES

20: X_LAST_UPDATE_DATE in DATE,
21: X_LAST_UPDATED_BY in NUMBER,
22: X_LAST_UPDATE_LOGIN in NUMBER
23: ) is
24: cursor C is select ROWID from PA_ALLOC_TARGET_LINES
25: where RULE_ID = X_RULE_ID
26: and LINE_NUM = X_LINE_NUM;
27: begin
28: insert into PA_ALLOC_TARGET_LINES (

Line 28: insert into PA_ALLOC_TARGET_LINES (

24: cursor C is select ROWID from PA_ALLOC_TARGET_LINES
25: where RULE_ID = X_RULE_ID
26: and LINE_NUM = X_LINE_NUM;
27: begin
28: insert into PA_ALLOC_TARGET_LINES (
29: RULE_ID,
30: LINE_NUM,
31: PROJECT_ORG_ID,
32: TASK_ORG_ID,

Line 105: from PA_ALLOC_TARGET_LINES

101: TASK_ID,
102: EXCLUDE_FLAG,
103: BILLABLE_ONLY_FLAG,
104: LINE_PERCENT
105: from PA_ALLOC_TARGET_LINES
106: where RULE_ID = X_RULE_ID
107: and LINE_NUM = X_LINE_NUM
108: for update of RULE_ID nowait;
109: tlinfo c1%rowtype;

Line 184: update PA_ALLOC_TARGET_LINES set

180: ) is
181:
182: begin
183:
184: update PA_ALLOC_TARGET_LINES set
185: LINE_NUM = X_LINE_NUM,
186: PROJECT_ORG_ID = X_PROJECT_ORG_ID,
187: TASK_ORG_ID = X_TASK_ORG_ID,
188: PROJECT_TYPE = X_PROJECT_TYPE,

Line 214: delete from PA_ALLOC_TARGET_LINES

210: --X_RULE_ID in NUMBER,
211: --X_LINE_NUM in NUMBER
212: ) is
213: begin
214: delete from PA_ALLOC_TARGET_LINES
215: where ROWID = X_ROWID;
216: --RULE_ID = X_RULE_ID
217: -- and LINE_NUM = X_LINE_NUM;
218: if (sql%notfound) then

Line 222: end PA_ALLOC_TARGET_LINES_PKG;

218: if (sql%notfound) then
219: raise no_data_found;
220: end if;
221: end DELETE_ROW;
222: end PA_ALLOC_TARGET_LINES_PKG;