APPS.PA_CC_TP_SCHEDULE_LINES_PKG dependencies on PA_CC_TP_SCHEDULE_LINES

Line 1: package body PA_CC_TP_SCHEDULE_LINES_PKG AS

1: package body PA_CC_TP_SCHEDULE_LINES_PKG AS
2: /* $Header: PAXTPSLB.pls 120.2 2005/08/05 02:15:39 rgandhi ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY varchar2,/*File.sql.39*/
5: X_SCHEDULE_LINE_ID in NUMBER,

Line 40: cursor C is select ROWID from PA_CC_TP_SCHEDULE_LINES

36: X_ATTRIBUTE13 in VARCHAR2,
37: X_ATTRIBUTE14 in VARCHAR2,
38: X_ATTRIBUTE15 in VARCHAR2
39: ) is
40: cursor C is select ROWID from PA_CC_TP_SCHEDULE_LINES
41: where TP_SCHEDULE_ID = X_TP_SCHEDULE_ID
42: and TP_SCHEDULE_LINE_ID=X_SCHEDULE_LINE_ID;
43: begin
44: insert into PA_CC_TP_SCHEDULE_LINES (

Line 44: insert into PA_CC_TP_SCHEDULE_LINES (

40: cursor C is select ROWID from PA_CC_TP_SCHEDULE_LINES
41: where TP_SCHEDULE_ID = X_TP_SCHEDULE_ID
42: and TP_SCHEDULE_LINE_ID=X_SCHEDULE_LINE_ID;
43: begin
44: insert into PA_CC_TP_SCHEDULE_LINES (
45: TP_SCHEDULE_LINE_ID,
46: TP_SCHEDULE_ID,
47: PRVDR_ORGANIZATION_ID,
48: START_DATE_ACTIVE,

Line 195: from PA_CC_TP_SCHEDULE_LINES

191: ATTRIBUTE12,
192: ATTRIBUTE13,
193: ATTRIBUTE14,
194: ATTRIBUTE15
195: from PA_CC_TP_SCHEDULE_LINES
196: where TP_SCHEDULE_ID = X_TP_SCHEDULE_ID
197: and TP_SCHEDULE_LINE_ID=X_SCHEDULE_LINE_ID
198: for update of TP_SCHEDULE_ID nowait;
199: tlinfo c1%rowtype;

Line 313: update PA_CC_TP_SCHEDULE_LINES set

309: X_ATTRIBUTE14 in VARCHAR2,
310: X_ATTRIBUTE15 in VARCHAR2
311: ) is
312: begin
313: update PA_CC_TP_SCHEDULE_LINES set
314: TP_SCHEDULE_LINE_ID=X_SCHEDULE_LINE_ID,
315: TP_SCHEDULE_ID=X_TP_SCHEDULE_ID,
316: PRVDR_ORGANIZATION_ID=X_PRVDR_ORGANIZATION_ID,
317: START_DATE_ACTIVE=X_START_DATE_ACTIVE,

Line 356: delete from PA_CC_TP_SCHEDULE_LINES

352: procedure DELETE_ROW (
353: X_ROWID in varchar2
354: ) is
355: begin
356: delete from PA_CC_TP_SCHEDULE_LINES
357: where Rowid = X_rowid;
358: if (sql%notfound) then
359: raise no_data_found;
360: end if;

Line 364: end PA_CC_TP_SCHEDULE_LINES_PKG;

360: end if;
361: end DELETE_ROW;
362:
363:
364: end PA_CC_TP_SCHEDULE_LINES_PKG;