75: DECODE(P_ATTRIBUTE13 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE13),
76: DECODE(P_ATTRIBUTE14 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE14),
77: DECODE(P_ATTRIBUTE15 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE15),
78: p_object_version_number,
79: NVL(FND_GLOBAL.user_id,-1),
80: TRUNC(SYSDATE),
81: NVL(FND_GLOBAL.user_id,-1),
82: TRUNC(SYSDATE),
83: NVL(FND_GLOBAL.login_id,-1));
77: DECODE(P_ATTRIBUTE15 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE15),
78: p_object_version_number,
79: NVL(FND_GLOBAL.user_id,-1),
80: TRUNC(SYSDATE),
81: NVL(FND_GLOBAL.user_id,-1),
82: TRUNC(SYSDATE),
83: NVL(FND_GLOBAL.login_id,-1));
84:
85: arp_standard.debug('Insert_schedule_Row -');
79: NVL(FND_GLOBAL.user_id,-1),
80: TRUNC(SYSDATE),
81: NVL(FND_GLOBAL.user_id,-1),
82: TRUNC(SYSDATE),
83: NVL(FND_GLOBAL.login_id,-1));
84:
85: arp_standard.debug('Insert_schedule_Row -');
86: EXCEPTION
87: WHEN OTHERS THEN
170: FND_API.G_MISS_CHAR, NULL,
171: NULL , ATTRIBUTE15, P_ATTRIBUTE15),
172: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
173: LAST_UPDATE_DATE = TRUNC(SYSDATE),
174: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),
175: LAST_UPDATE_LOGIN = NVL(FND_GLOBAL.login_id,-1)
176: WHERE SCHEDULE_ID = P_SCHEDULE_ID
177: RETURNING OBJECT_VERSION_NUMBER INTO x_OBJECT_VERSION_NUMBER;
178: arp_standard.debug('Insert_schedule_Row -');
171: NULL , ATTRIBUTE15, P_ATTRIBUTE15),
172: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
173: LAST_UPDATE_DATE = TRUNC(SYSDATE),
174: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),
175: LAST_UPDATE_LOGIN = NVL(FND_GLOBAL.login_id,-1)
176: WHERE SCHEDULE_ID = P_SCHEDULE_ID
177: RETURNING OBJECT_VERSION_NUMBER INTO x_OBJECT_VERSION_NUMBER;
178: arp_standard.debug('Insert_schedule_Row -');
179: EXCEPTION
272: DECODE(P_ATTRIBUTE13 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE13),
273: DECODE(P_ATTRIBUTE14 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE14),
274: DECODE(P_ATTRIBUTE15 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE15),
275: P_OBJECT_VERSION_NUMBER,
276: NVL(FND_GLOBAL.user_id,-1),
277: TRUNC(SYSDATE),
278: NVL(FND_GLOBAL.user_id,-1),
279: TRUNC(SYSDATE),
280: NVL(FND_GLOBAL.login_id,-1));
274: DECODE(P_ATTRIBUTE15 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE15),
275: P_OBJECT_VERSION_NUMBER,
276: NVL(FND_GLOBAL.user_id,-1),
277: TRUNC(SYSDATE),
278: NVL(FND_GLOBAL.user_id,-1),
279: TRUNC(SYSDATE),
280: NVL(FND_GLOBAL.login_id,-1));
281:
282: arp_standard.debug('Insert_Head_Row -');
276: NVL(FND_GLOBAL.user_id,-1),
277: TRUNC(SYSDATE),
278: NVL(FND_GLOBAL.user_id,-1),
279: TRUNC(SYSDATE),
280: NVL(FND_GLOBAL.login_id,-1));
281:
282: arp_standard.debug('Insert_Head_Row -');
283: EXCEPTION
284: WHEN OTHERS THEN
379: FND_API.G_MISS_CHAR, NULL,
380: NULL , ATTRIBUTE15, P_ATTRIBUTE15),
381: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
382: LAST_UPDATE_DATE = TRUNC(SYSDATE),
383: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),
384: LAST_UPDATE_LOGIN = NVL(FND_GLOBAL.login_id,-1)
385: WHERE SCHEDULE_HEADER_ID = P_SCHEDULE_HEADER_ID
386: RETURNING OBJECT_VERSION_NUMBER INTO x_OBJECT_VERSION_NUMBER;
387:
380: NULL , ATTRIBUTE15, P_ATTRIBUTE15),
381: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
382: LAST_UPDATE_DATE = TRUNC(SYSDATE),
383: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),
384: LAST_UPDATE_LOGIN = NVL(FND_GLOBAL.login_id,-1)
385: WHERE SCHEDULE_HEADER_ID = P_SCHEDULE_HEADER_ID
386: RETURNING OBJECT_VERSION_NUMBER INTO x_OBJECT_VERSION_NUMBER;
387:
388: arp_standard.debug('Update_Head_Row -');
482: DECODE(P_ATTRIBUTE13 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE13),
483: DECODE(P_ATTRIBUTE14 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE14),
484: DECODE(P_ATTRIBUTE15 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE15),
485: P_OBJECT_VERSION_NUMBER,
486: NVL(FND_GLOBAL.user_id,-1),
487: TRUNC(SYSDATE),
488: NVL(FND_GLOBAL.user_id,-1),
489: TRUNC(SYSDATE),
490: NVL(FND_GLOBAL.login_id,-1));
484: DECODE(P_ATTRIBUTE15 ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE15),
485: P_OBJECT_VERSION_NUMBER,
486: NVL(FND_GLOBAL.user_id,-1),
487: TRUNC(SYSDATE),
488: NVL(FND_GLOBAL.user_id,-1),
489: TRUNC(SYSDATE),
490: NVL(FND_GLOBAL.login_id,-1));
491:
492: arp_standard.debug('Insert_Line_Row -');
486: NVL(FND_GLOBAL.user_id,-1),
487: TRUNC(SYSDATE),
488: NVL(FND_GLOBAL.user_id,-1),
489: TRUNC(SYSDATE),
490: NVL(FND_GLOBAL.login_id,-1));
491:
492: arp_standard.debug('Insert_Line_Row -');
493: EXCEPTION
494: WHEN OTHERS THEN
581: FND_API.G_MISS_CHAR, NULL,
582: NULL , ATTRIBUTE15, P_ATTRIBUTE15),
583: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
584: LAST_UPDATE_DATE = TRUNC(SYSDATE),
585: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),
586: LAST_UPDATE_LOGIN = NVL(FND_GLOBAL.login_id,-1)
587: WHERE SCHEDULE_LINE_ID = P_SCHEDULE_LINE_ID;
588:
589:
582: NULL , ATTRIBUTE15, P_ATTRIBUTE15),
583: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
584: LAST_UPDATE_DATE = TRUNC(SYSDATE),
585: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),
586: LAST_UPDATE_LOGIN = NVL(FND_GLOBAL.login_id,-1)
587: WHERE SCHEDULE_LINE_ID = P_SCHEDULE_LINE_ID;
588:
589:
590: arp_standard.debug('Update_Line_Row -');