DBA Data[Home] [Help]

APPS.PSB_WS_DISTRIBUTION_RULES_PVT dependencies on FND_GLOBAL

Line 6: g_chr10 CONSTANT VARCHAR2(1) := FND_GLOBAL.Newline;

2: /* $Header: PSBVWDRB.pls 120.2 2005/07/13 11:30:49 shtripat ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_WS_Distribution_Rules_PVT';
5:
6: g_chr10 CONSTANT VARCHAR2(1) := FND_GLOBAL.Newline;
7:
8: G_DBUG VARCHAR2(2000) := 'start';
9:
10: PROCEDURE Pass_Rule_ID ( p_rule_id IN NUMBER) AS

Line 92: P_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

88: if(P_MODE = 'I') then
89: P_LAST_UPDATED_BY := 1;
90: P_LAST_UPDATE_LOGIN := 0;
91: elsif (P_MODE = 'R') then
92: P_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
93: if P_LAST_UPDATED_BY is NULL then
94: P_LAST_UPDATED_BY := -1;
95: end if;
96: P_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line 96: P_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

92: P_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
93: if P_LAST_UPDATED_BY is NULL then
94: P_LAST_UPDATED_BY := -1;
95: end if;
96: P_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
97: if P_LAST_UPDATE_LOGIN is NULL then
98: P_LAST_UPDATE_LOGIN := -1;
99: end if;
100: else

Line 493: P_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

489: if(P_MODE = 'I') then
490: P_LAST_UPDATED_BY := 1;
491: P_LAST_UPDATE_LOGIN := 0;
492: elsif (P_MODE = 'R') then
493: P_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
494: if P_LAST_UPDATED_BY is NULL then
495: P_LAST_UPDATED_BY := -1;
496: end if;
497: P_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line 497: P_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

493: P_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
494: if P_LAST_UPDATED_BY is NULL then
495: P_LAST_UPDATED_BY := -1;
496: end if;
497: P_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
498: if P_LAST_UPDATE_LOGIN is NULL then
499: P_LAST_UPDATE_LOGIN := -1;
500: end if;
501: else

Line 845: P_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

841: if(P_MODE = 'I') then
842: P_LAST_UPDATED_BY := 1;
843: P_LAST_UPDATE_LOGIN := 0;
844: elsif (P_MODE = 'R') then
845: P_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
846: if P_LAST_UPDATED_BY is NULL then
847: P_LAST_UPDATED_BY := -1;
848: end if;
849: P_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line 849: P_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

845: P_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
846: if P_LAST_UPDATED_BY is NULL then
847: P_LAST_UPDATED_BY := -1;
848: end if;
849: P_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
850: if P_LAST_UPDATE_LOGIN is NULL then
851: P_LAST_UPDATE_LOGIN := -1;
852: end if;
853: else

Line 997: P_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

993: if(P_MODE = 'I') then
994: P_LAST_UPDATED_BY := 1;
995: P_LAST_UPDATE_LOGIN := 0;
996: elsif (P_MODE = 'R') then
997: P_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
998: if P_LAST_UPDATED_BY is NULL then
999: P_LAST_UPDATED_BY := -1;
1000: end if;
1001: P_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line 1001: P_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

997: P_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
998: if P_LAST_UPDATED_BY is NULL then
999: P_LAST_UPDATED_BY := -1;
1000: end if;
1001: P_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
1002: if P_LAST_UPDATE_LOGIN is NULL then
1003: P_LAST_UPDATE_LOGIN := -1;
1004: end if;
1005: else