DBA Data[Home] [Help]

APPS.CN_RATE_TIERS_PKG dependencies on FND_GLOBAL

Line 24: X_CREATED_BY IN CN_RATE_TIERS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,

20: --R12 MOAC Changes--Start
21: X_ORG_ID IN CN_RATE_TIERS.ORG_ID%TYPE,
22: --R12 MOAC Changes--End
23: X_CREATION_DATE IN CN_RATE_TIERS.CREATION_DATE%TYPE := SYSDATE,
24: X_CREATED_BY IN CN_RATE_TIERS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
25: X_LAST_UPDATE_DATE IN CN_RATE_TIERS.LAST_UPDATE_DATE%TYPE := SYSDATE,
26: X_LAST_UPDATED_BY IN CN_RATE_TIERS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
27: X_LAST_UPDATE_LOGIN IN CN_RATE_TIERS.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID) IS
28:

Line 26: X_LAST_UPDATED_BY IN CN_RATE_TIERS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,

22: --R12 MOAC Changes--End
23: X_CREATION_DATE IN CN_RATE_TIERS.CREATION_DATE%TYPE := SYSDATE,
24: X_CREATED_BY IN CN_RATE_TIERS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
25: X_LAST_UPDATE_DATE IN CN_RATE_TIERS.LAST_UPDATE_DATE%TYPE := SYSDATE,
26: X_LAST_UPDATED_BY IN CN_RATE_TIERS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
27: X_LAST_UPDATE_LOGIN IN CN_RATE_TIERS.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID) IS
28:
29: CURSOR C IS SELECT RATE_TIER_ID FROM CN_RATE_TIERS
30: WHERE RATE_TIER_ID = X_RATE_TIER_ID;

Line 27: X_LAST_UPDATE_LOGIN IN CN_RATE_TIERS.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID) IS

23: X_CREATION_DATE IN CN_RATE_TIERS.CREATION_DATE%TYPE := SYSDATE,
24: X_CREATED_BY IN CN_RATE_TIERS.CREATED_BY%TYPE := FND_GLOBAL.USER_ID,
25: X_LAST_UPDATE_DATE IN CN_RATE_TIERS.LAST_UPDATE_DATE%TYPE := SYSDATE,
26: X_LAST_UPDATED_BY IN CN_RATE_TIERS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
27: X_LAST_UPDATE_LOGIN IN CN_RATE_TIERS.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID) IS
28:
29: CURSOR C IS SELECT RATE_TIER_ID FROM CN_RATE_TIERS
30: WHERE RATE_TIER_ID = X_RATE_TIER_ID;
31:

Line 143: X_LAST_UPDATED_BY IN CN_RATE_TIERS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,

139: X_COMMISSION_AMOUNT IN CN_RATE_TIERS.COMMISSION_AMOUNT%TYPE,
140: X_RATE_SEQUENCE IN CN_RATE_TIERS.RATE_SEQUENCE%TYPE,
141: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE,
142: X_LAST_UPDATE_DATE IN CN_RATE_TIERS.LAST_UPDATE_DATE%TYPE := SYSDATE,
143: X_LAST_UPDATED_BY IN CN_RATE_TIERS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
144: X_LAST_UPDATE_LOGIN IN CN_RATE_TIERS.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID) IS
145:
146: l_commission_amount_old number := 0;
147: BEGIN

Line 144: X_LAST_UPDATE_LOGIN IN CN_RATE_TIERS.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID) IS

140: X_RATE_SEQUENCE IN CN_RATE_TIERS.RATE_SEQUENCE%TYPE,
141: X_OBJECT_VERSION_NUMBER IN OUT NOCOPY CN_RATE_TIERS.OBJECT_VERSION_NUMBER%TYPE,
142: X_LAST_UPDATE_DATE IN CN_RATE_TIERS.LAST_UPDATE_DATE%TYPE := SYSDATE,
143: X_LAST_UPDATED_BY IN CN_RATE_TIERS.LAST_UPDATED_BY%TYPE := FND_GLOBAL.USER_ID,
144: X_LAST_UPDATE_LOGIN IN CN_RATE_TIERS.LAST_UPDATE_LOGIN%TYPE:= FND_GLOBAL.LOGIN_ID) IS
145:
146: l_commission_amount_old number := 0;
147: BEGIN
148: X_OBJECT_VERSION_NUMBER := X_OBJECT_VERSION_NUMBER + 1;