APPS.PSP_SCHEDULE_LINES_PKG dependencies on PSP_SCHEDULE_LINES

Line 1: package body PSP_SCHEDULE_LINES_PKG as

1: package body PSP_SCHEDULE_LINES_PKG as
2: --$Header: PSPLSLIB.pls 115.8 2002/11/18 12:14:58 lveerubh ship $
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_SCHEDULE_LINE_ID in NUMBER,

Line 39: cursor C is select ROWID from PSP_SCHEDULE_LINES

35: X_MODE in VARCHAR2 default 'R',
36: X_BUSINESS_GROUP_ID in NUMBER,
37: X_SET_OF_BOOKS_ID in NUMBER
38: ) is
39: cursor C is select ROWID from PSP_SCHEDULE_LINES
40: where SCHEDULE_LINE_ID = X_SCHEDULE_LINE_ID
41: and business_group_id = X_BUSINESS_GROUP_ID
42: and set_of_books_id = X_SET_OF_BOOKS_ID;
43: X_LAST_UPDATE_DATE DATE;

Line 64: insert into PSP_SCHEDULE_LINES (

60: else
61: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
62: app_exception.raise_exception;
63: end if;
64: insert into PSP_SCHEDULE_LINES (
65: SCHEDULE_LINE_ID,
66: SCHEDULE_HIERARCHY_ID,
67: GL_CODE_COMBINATION_ID,
68: PROJECT_ID,

Line 218: from PSP_SCHEDULE_LINES

214: ATTRIBUTE14,
215: ATTRIBUTE15,
216: BUSINESS_GROUP_ID,
217: SET_OF_BOOKS_ID
218: from PSP_SCHEDULE_LINES
219: where SCHEDULE_LINE_ID = X_SCHEDULE_LINE_ID
220: and business_group_id = X_BUSINESS_GROUP_ID
221: and set_of_books_id = X_SET_OF_BOOKS_ID
222: for update of SCHEDULE_LINE_ID nowait;

Line 371: update PSP_SCHEDULE_LINES set

367: else
368: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
369: app_exception.raise_exception;
370: end if;
371: update PSP_SCHEDULE_LINES set
372: SCHEDULE_HIERARCHY_ID = X_SCHEDULE_HIERARCHY_ID,
373: GL_CODE_COMBINATION_ID = X_GL_CODE_COMBINATION_ID,
374: PROJECT_ID = X_PROJECT_ID,
375: EXPENDITURE_ORGANIZATION_ID = X_EXPENDITURE_ORGANIZATION_ID,

Line 449: cursor c1 is select rowid from PSP_SCHEDULE_LINES

445: X_MODE in VARCHAR2 default 'R',
446: X_BUSINESS_GROUP_ID in NUMBER,
447: X_SET_OF_BOOKS_ID in NUMBER
448: ) is
449: cursor c1 is select rowid from PSP_SCHEDULE_LINES
450: where SCHEDULE_LINE_ID = X_SCHEDULE_LINE_ID
451: and business_group_id = X_BUSINESS_GROUP_ID
452: and set_of_books_id = X_SET_OF_BOOKS_ID
453: ;

Line 542: delete from PSP_SCHEDULE_LINES

538: X_BUSINESS_GROUP_ID in NUMBER,
539: X_SET_OF_BOOKS_ID in NUMBER
540: ) is
541: begin
542: delete from PSP_SCHEDULE_LINES
543: where SCHEDULE_LINE_ID = X_SCHEDULE_LINE_ID
544: and business_group_id = X_BUSINESS_GROUP_ID
545: and set_of_books_id = X_SET_OF_BOOKS_ID
546: ;

Line 552: end PSP_SCHEDULE_LINES_PKG;

548: raise no_data_found;
549: end if;
550: end DELETE_ROW;
551:
552: end PSP_SCHEDULE_LINES_PKG;