[Home] [Help]
37: X_SET_OF_BOOKS_ID in NUMBER,
38: X_POETA_START_DATE in DATE DEFAULT NULL,
39: X_POETA_END_DATE in DATE DEFAULT NULL
40: ) is
41: cursor C is select ROWID from PSP_DEFAULT_LABOR_SCHEDULES
42: where ORG_SCHEDULE_ID = X_ORG_SCHEDULE_ID
43: and business_group_id = X_BUSINESS_GROUP_ID
44: and set_of_books_id = X_SET_OF_BOOKS_ID;
45: X_LAST_UPDATE_DATE DATE;
62: else
63: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
64: app_exception.raise_exception;
65: end if;
66: insert into PSP_DEFAULT_LABOR_SCHEDULES (
67: ORG_SCHEDULE_ID,
68: ORGANIZATION_ID,
69: SCHEDULE_BEGIN_DATE,
70: SCHEDULE_END_DATE,
211: ATTRIBUTE14,
212: ATTRIBUTE15,
213: BUSINESS_GROUP_ID,
214: SET_OF_BOOKS_ID
215: from PSP_DEFAULT_LABOR_SCHEDULES
216: where ORG_SCHEDULE_ID = X_ORG_SCHEDULE_ID
217: and BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID
218: and SET_OF_BOOKS_ID = X_SET_OF_BOOKS_ID
219: for update of ORG_SCHEDULE_ID nowait;
370: else
371: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
372: app_exception.raise_exception;
373: end if;
374: update PSP_DEFAULT_LABOR_SCHEDULES set
375: ORGANIZATION_ID = X_ORGANIZATION_ID,
376: SCHEDULE_BEGIN_DATE = X_SCHEDULE_BEGIN_DATE,
377: SCHEDULE_END_DATE = X_SCHEDULE_END_DATE,
378: GL_CODE_COMBINATION_ID = X_GL_CODE_COMBINATION_ID,
449: X_SET_OF_BOOKS_ID in NUMBER,
450: X_POETA_START_DATE in DATE DEFAULT NULL,
451: X_POETA_END_DATE in DATE DEFAULT NULL
452: ) is
453: cursor c1 is select rowid from PSP_DEFAULT_LABOR_SCHEDULES
454: where ORG_SCHEDULE_ID = X_ORG_SCHEDULE_ID
455: and BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID
456: and SET_OF_BOOKS_ID = X_SET_OF_BOOKS_ID
457: ;
543: X_BUSINESS_GROUP_ID in NUMBER,
544: X_SET_OF_BOOKS_ID in NUMBER
545: ) is
546: begin
547: delete from PSP_DEFAULT_LABOR_SCHEDULES
548: where ORG_SCHEDULE_ID = X_ORG_SCHEDULE_ID
549: and BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID
550: and SET_OF_BOOKS_ID = X_SET_OF_BOOKS_ID;
551: if (sql%notfound) then