18: -- ----------------------------------------------------------------------------------------
19:
20: -- WHO Globals
21:
22: G_LAST_UPDATED_BY NUMBER(15) := FND_GLOBAL.USER_ID;
23: G_LAST_UPDATE_DATE DATE := SYSDATE;
24: G_CREATION_DATE DATE := SYSDATE;
25: G_CREATED_BY NUMBER(15) := FND_GLOBAL.USER_ID;
26: G_LAST_UPDATE_LOGIN NUMBER(15) := FND_GLOBAL.LOGIN_ID;
21:
22: G_LAST_UPDATED_BY NUMBER(15) := FND_GLOBAL.USER_ID;
23: G_LAST_UPDATE_DATE DATE := SYSDATE;
24: G_CREATION_DATE DATE := SYSDATE;
25: G_CREATED_BY NUMBER(15) := FND_GLOBAL.USER_ID;
26: G_LAST_UPDATE_LOGIN NUMBER(15) := FND_GLOBAL.LOGIN_ID;
27:
28: -- Local Package Globals
29:
22: G_LAST_UPDATED_BY NUMBER(15) := FND_GLOBAL.USER_ID;
23: G_LAST_UPDATE_DATE DATE := SYSDATE;
24: G_CREATION_DATE DATE := SYSDATE;
25: G_CREATED_BY NUMBER(15) := FND_GLOBAL.USER_ID;
26: G_LAST_UPDATE_LOGIN NUMBER(15) := FND_GLOBAL.LOGIN_ID;
27:
28: -- Local Package Globals
29:
30: G_PKG_NAME CONSTANT VARCHAR2(30) := ' PA_STATUS_PUB';