DBA Data[Home] [Help]

APPS.PV_PG_INVITE_HEADERS_PKG dependencies on FND_GLOBAL

Line 89: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

85: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
86: DECODE( p_qp_list_header_id, FND_API.g_miss_char, NULL, p_qp_list_header_id),
87: DECODE( p_invite_type_code, FND_API.g_miss_char, NULL, p_invite_type_code),
88: DECODE( p_invite_for_program_id, FND_API.G_MISS_NUM, NULL, p_invite_for_program_id),
89: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
90: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
91: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
92: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
93: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

Line 91: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

87: DECODE( p_invite_type_code, FND_API.g_miss_char, NULL, p_invite_type_code),
88: DECODE( p_invite_for_program_id, FND_API.G_MISS_NUM, NULL, p_invite_for_program_id),
89: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
90: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
91: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
92: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
93: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
94: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),
95: DECODE( p_invite_end_date, FND_API.G_MISS_DATE, NULL, p_invite_end_date),

Line 93: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

89: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
90: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
91: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
92: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
93: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
94: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),
95: DECODE( p_invite_end_date, FND_API.G_MISS_DATE, NULL, p_invite_end_date),
96: DECODE( p_order_header_id, FND_API.G_MISS_NUM, NULL, p_order_header_id),
97: DECODE( p_invited_by_partner_id, FND_API.G_MISS_NUM, NULL, p_invited_by_partner_id),

Line 116: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),

112: SELECT
113: DECODE( px_invite_header_id, FND_API.G_MISS_NUM, NULL, px_invite_header_id),
114: l.language_code,
115: DECODE( p_last_update_date, NULL, SYSDATE, p_last_update_date),
116: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
117: DECODE( p_creation_date, NULL, SYSDATE, p_creation_date),
118: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
119: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
120: USERENV('LANG'),

Line 118: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),

114: l.language_code,
115: DECODE( p_last_update_date, NULL, SYSDATE, p_last_update_date),
116: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
117: DECODE( p_creation_date, NULL, SYSDATE, p_creation_date),
118: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
119: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
120: USERENV('LANG'),
121: DECODE( p_EMAIL_CONTENT , FND_API.G_MISS_CHAR, NULL, p_EMAIL_CONTENT)
122: FROM fnd_languages l

Line 119: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

115: DECODE( p_last_update_date, NULL, SYSDATE, p_last_update_date),
116: DECODE( p_last_updated_by, NULL, FND_GLOBAL.USER_ID, p_last_updated_by),
117: DECODE( p_creation_date, NULL, SYSDATE, p_creation_date),
118: DECODE( p_created_by, NULL, FND_GLOBAL.USER_ID, p_created_by),
119: DECODE( p_last_update_login, NULL, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
120: USERENV('LANG'),
121: DECODE( p_EMAIL_CONTENT , FND_API.G_MISS_CHAR, NULL, p_EMAIL_CONTENT)
122: FROM fnd_languages l
123: WHERE l.installed_flag IN ('I','B')