DBA Data[Home] [Help]

APPS.AR_CHARGE_SCHEDULE_PKG dependencies on FND_GLOBAL

Line 79: NVL(FND_GLOBAL.user_id,-1),

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));

Line 81: NVL(FND_GLOBAL.user_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 -');

Line 83: NVL(FND_GLOBAL.login_id,-1));

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

Line 174: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),

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 -');

Line 175: LAST_UPDATE_LOGIN = NVL(FND_GLOBAL.login_id,-1)

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

Line 276: NVL(FND_GLOBAL.user_id,-1),

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));

Line 278: NVL(FND_GLOBAL.user_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 -');

Line 280: NVL(FND_GLOBAL.login_id,-1));

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

Line 383: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),

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:

Line 384: LAST_UPDATE_LOGIN = NVL(FND_GLOBAL.login_id,-1)

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 -');

Line 486: NVL(FND_GLOBAL.user_id,-1),

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));

Line 488: NVL(FND_GLOBAL.user_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 -');

Line 490: NVL(FND_GLOBAL.login_id,-1));

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

Line 585: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),

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:

Line 586: LAST_UPDATE_LOGIN = NVL(FND_GLOBAL.login_id,-1)

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 -');