eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_PG_INVITE_HEADERS_PKG dependencies on FND_API

Line 84: DECODE( px_invite_header_id, FND_API.G_MISS_NUM, NULL, px_invite_header_id),

80: order_header_id,
81: invited_by_partner_id,
82: trxn_extension_id
83: ) VALUES (
84: DECODE( px_invite_header_id, FND_API.G_MISS_NUM, NULL, px_invite_header_id),
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),

Line 85: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),

81: invited_by_partner_id,
82: trxn_extension_id
83: ) VALUES (
84: DECODE( px_invite_header_id, FND_API.G_MISS_NUM, NULL, px_invite_header_id),
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),

Line 86: DECODE( p_qp_list_header_id, FND_API.g_miss_char, NULL, p_qp_list_header_id),

82: trxn_extension_id
83: ) VALUES (
84: DECODE( px_invite_header_id, FND_API.G_MISS_NUM, NULL, px_invite_header_id),
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),

Line 87: DECODE( p_invite_type_code, FND_API.g_miss_char, NULL, p_invite_type_code),

83: ) VALUES (
84: DECODE( px_invite_header_id, FND_API.G_MISS_NUM, NULL, px_invite_header_id),
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),

Line 88: DECODE( p_invite_for_program_id, FND_API.G_MISS_NUM, NULL, p_invite_for_program_id),

84: DECODE( px_invite_header_id, FND_API.G_MISS_NUM, NULL, px_invite_header_id),
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),

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 90: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

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),
94: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),

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 92: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

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),
96: DECODE( p_order_header_id, FND_API.G_MISS_NUM, NULL, p_order_header_id),

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 94: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),

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),
98: DECODE( p_trxn_extension_id, FND_API.G_MISS_NUM, NULL, p_trxn_extension_id)

Line 95: DECODE( p_invite_end_date, FND_API.G_MISS_DATE, NULL, p_invite_end_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),
98: DECODE( p_trxn_extension_id, FND_API.G_MISS_NUM, NULL, p_trxn_extension_id)
99: );

Line 96: DECODE( p_order_header_id, FND_API.G_MISS_NUM, NULL, p_order_header_id),

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),
98: DECODE( p_trxn_extension_id, FND_API.G_MISS_NUM, NULL, p_trxn_extension_id)
99: );
100:

Line 97: DECODE( p_invited_by_partner_id, FND_API.G_MISS_NUM, NULL, p_invited_by_partner_id),

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),
98: DECODE( p_trxn_extension_id, FND_API.G_MISS_NUM, NULL, p_trxn_extension_id)
99: );
100:
101: INSERT INTO pv_pg_invite_headers_tl(

Line 98: DECODE( p_trxn_extension_id, FND_API.G_MISS_NUM, NULL, p_trxn_extension_id)

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),
98: DECODE( p_trxn_extension_id, FND_API.G_MISS_NUM, NULL, p_trxn_extension_id)
99: );
100:
101: INSERT INTO pv_pg_invite_headers_tl(
102: invite_header_id ,

Line 113: DECODE( px_invite_header_id, FND_API.G_MISS_NUM, NULL, px_invite_header_id),

109: source_lang ,
110: EMAIL_CONTENT
111: )
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),

Line 121: DECODE( p_EMAIL_CONTENT , FND_API.G_MISS_CHAR, NULL, p_EMAIL_CONTENT)

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')
124: AND NOT EXISTS(SELECT NULL FROM pv_pg_invite_headers_tl t
125: WHERE t.invite_header_id = DECODE( px_invite_header_id, FND_API.G_MISS_NUM, NULL, px_invite_header_id)

Line 125: WHERE t.invite_header_id = DECODE( px_invite_header_id, FND_API.G_MISS_NUM, NULL, px_invite_header_id)

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')
124: AND NOT EXISTS(SELECT NULL FROM pv_pg_invite_headers_tl t
125: WHERE t.invite_header_id = DECODE( px_invite_header_id, FND_API.G_MISS_NUM, NULL, px_invite_header_id)
126: AND t.language = l.language_code);
127: END Insert_Row;
128:
129:

Line 165: invite_header_id = DECODE( p_invite_header_id, null, invite_header_id, FND_API.G_MISS_NUM, null, p_invite_header_id),

161: IS
162: BEGIN
163: Update pv_pg_invite_headers_b
164: SET
165: invite_header_id = DECODE( p_invite_header_id, null, invite_header_id, FND_API.G_MISS_NUM, null, p_invite_header_id),
166: object_version_number = nvl(p_object_version_number,0) + 1 ,
167: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.g_miss_char, null, p_qp_list_header_id),
168: invite_type_code = DECODE( p_invite_type_code, null, invite_type_code, FND_API.g_miss_char, null, p_invite_type_code),
169: invite_for_program_id = DECODE( p_invite_for_program_id, null, invite_for_program_id, FND_API.G_MISS_NUM, null, p_invite_for_program_id),

Line 167: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.g_miss_char, null, p_qp_list_header_id),

163: Update pv_pg_invite_headers_b
164: SET
165: invite_header_id = DECODE( p_invite_header_id, null, invite_header_id, FND_API.G_MISS_NUM, null, p_invite_header_id),
166: object_version_number = nvl(p_object_version_number,0) + 1 ,
167: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.g_miss_char, null, p_qp_list_header_id),
168: invite_type_code = DECODE( p_invite_type_code, null, invite_type_code, FND_API.g_miss_char, null, p_invite_type_code),
169: invite_for_program_id = DECODE( p_invite_for_program_id, null, invite_for_program_id, FND_API.G_MISS_NUM, null, p_invite_for_program_id),
170: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
171: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

Line 168: invite_type_code = DECODE( p_invite_type_code, null, invite_type_code, FND_API.g_miss_char, null, p_invite_type_code),

164: SET
165: invite_header_id = DECODE( p_invite_header_id, null, invite_header_id, FND_API.G_MISS_NUM, null, p_invite_header_id),
166: object_version_number = nvl(p_object_version_number,0) + 1 ,
167: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.g_miss_char, null, p_qp_list_header_id),
168: invite_type_code = DECODE( p_invite_type_code, null, invite_type_code, FND_API.g_miss_char, null, p_invite_type_code),
169: invite_for_program_id = DECODE( p_invite_for_program_id, null, invite_for_program_id, FND_API.G_MISS_NUM, null, p_invite_for_program_id),
170: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
171: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
172: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

Line 169: invite_for_program_id = DECODE( p_invite_for_program_id, null, invite_for_program_id, FND_API.G_MISS_NUM, null, p_invite_for_program_id),

165: invite_header_id = DECODE( p_invite_header_id, null, invite_header_id, FND_API.G_MISS_NUM, null, p_invite_header_id),
166: object_version_number = nvl(p_object_version_number,0) + 1 ,
167: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.g_miss_char, null, p_qp_list_header_id),
168: invite_type_code = DECODE( p_invite_type_code, null, invite_type_code, FND_API.g_miss_char, null, p_invite_type_code),
169: invite_for_program_id = DECODE( p_invite_for_program_id, null, invite_for_program_id, FND_API.G_MISS_NUM, null, p_invite_for_program_id),
170: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
171: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
172: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
173: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),

Line 170: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

166: object_version_number = nvl(p_object_version_number,0) + 1 ,
167: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.g_miss_char, null, p_qp_list_header_id),
168: invite_type_code = DECODE( p_invite_type_code, null, invite_type_code, FND_API.g_miss_char, null, p_invite_type_code),
169: invite_for_program_id = DECODE( p_invite_for_program_id, null, invite_for_program_id, FND_API.G_MISS_NUM, null, p_invite_for_program_id),
170: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
171: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
172: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
173: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
174: invite_end_date = DECODE( p_invite_end_date, null, invite_end_date, FND_API.G_MISS_DATE, null, p_invite_end_date),

Line 171: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

167: qp_list_header_id = DECODE( p_qp_list_header_id, null, qp_list_header_id, FND_API.g_miss_char, null, p_qp_list_header_id),
168: invite_type_code = DECODE( p_invite_type_code, null, invite_type_code, FND_API.g_miss_char, null, p_invite_type_code),
169: invite_for_program_id = DECODE( p_invite_for_program_id, null, invite_for_program_id, FND_API.G_MISS_NUM, null, p_invite_for_program_id),
170: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
171: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
172: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
173: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
174: invite_end_date = DECODE( p_invite_end_date, null, invite_end_date, FND_API.G_MISS_DATE, null, p_invite_end_date),
175: order_header_id = DECODE( p_order_header_id, null, order_header_id, FND_API.G_MISS_NUM, null, p_order_header_id),

Line 172: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

168: invite_type_code = DECODE( p_invite_type_code, null, invite_type_code, FND_API.g_miss_char, null, p_invite_type_code),
169: invite_for_program_id = DECODE( p_invite_for_program_id, null, invite_for_program_id, FND_API.G_MISS_NUM, null, p_invite_for_program_id),
170: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
171: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
172: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
173: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
174: invite_end_date = DECODE( p_invite_end_date, null, invite_end_date, FND_API.G_MISS_DATE, null, p_invite_end_date),
175: order_header_id = DECODE( p_order_header_id, null, order_header_id, FND_API.G_MISS_NUM, null, p_order_header_id),
176: invited_by_partner_id = DECODE( p_invited_by_partner_id, null, invited_by_partner_id, FND_API.G_MISS_NUM, null, p_invited_by_partner_id),

Line 173: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),

169: invite_for_program_id = DECODE( p_invite_for_program_id, null, invite_for_program_id, FND_API.G_MISS_NUM, null, p_invite_for_program_id),
170: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
171: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
172: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
173: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
174: invite_end_date = DECODE( p_invite_end_date, null, invite_end_date, FND_API.G_MISS_DATE, null, p_invite_end_date),
175: order_header_id = DECODE( p_order_header_id, null, order_header_id, FND_API.G_MISS_NUM, null, p_order_header_id),
176: invited_by_partner_id = DECODE( p_invited_by_partner_id, null, invited_by_partner_id, FND_API.G_MISS_NUM, null, p_invited_by_partner_id),
177: trxn_extension_id = DECODE( p_trxn_extension_id, null, trxn_extension_id, FND_API.G_MISS_NUM, null, p_trxn_extension_id)

Line 174: invite_end_date = DECODE( p_invite_end_date, null, invite_end_date, FND_API.G_MISS_DATE, null, p_invite_end_date),

170: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
171: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
172: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
173: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
174: invite_end_date = DECODE( p_invite_end_date, null, invite_end_date, FND_API.G_MISS_DATE, null, p_invite_end_date),
175: order_header_id = DECODE( p_order_header_id, null, order_header_id, FND_API.G_MISS_NUM, null, p_order_header_id),
176: invited_by_partner_id = DECODE( p_invited_by_partner_id, null, invited_by_partner_id, FND_API.G_MISS_NUM, null, p_invited_by_partner_id),
177: trxn_extension_id = DECODE( p_trxn_extension_id, null, trxn_extension_id, FND_API.G_MISS_NUM, null, p_trxn_extension_id)
178: WHERE invite_header_id = p_invite_header_id

Line 175: order_header_id = DECODE( p_order_header_id, null, order_header_id, FND_API.G_MISS_NUM, null, p_order_header_id),

171: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
172: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
173: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
174: invite_end_date = DECODE( p_invite_end_date, null, invite_end_date, FND_API.G_MISS_DATE, null, p_invite_end_date),
175: order_header_id = DECODE( p_order_header_id, null, order_header_id, FND_API.G_MISS_NUM, null, p_order_header_id),
176: invited_by_partner_id = DECODE( p_invited_by_partner_id, null, invited_by_partner_id, FND_API.G_MISS_NUM, null, p_invited_by_partner_id),
177: trxn_extension_id = DECODE( p_trxn_extension_id, null, trxn_extension_id, FND_API.G_MISS_NUM, null, p_trxn_extension_id)
178: WHERE invite_header_id = p_invite_header_id
179: AND object_version_number = p_object_version_number;

Line 176: invited_by_partner_id = DECODE( p_invited_by_partner_id, null, invited_by_partner_id, FND_API.G_MISS_NUM, null, p_invited_by_partner_id),

172: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
173: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
174: invite_end_date = DECODE( p_invite_end_date, null, invite_end_date, FND_API.G_MISS_DATE, null, p_invite_end_date),
175: order_header_id = DECODE( p_order_header_id, null, order_header_id, FND_API.G_MISS_NUM, null, p_order_header_id),
176: invited_by_partner_id = DECODE( p_invited_by_partner_id, null, invited_by_partner_id, FND_API.G_MISS_NUM, null, p_invited_by_partner_id),
177: trxn_extension_id = DECODE( p_trxn_extension_id, null, trxn_extension_id, FND_API.G_MISS_NUM, null, p_trxn_extension_id)
178: WHERE invite_header_id = p_invite_header_id
179: AND object_version_number = p_object_version_number;
180:

Line 177: trxn_extension_id = DECODE( p_trxn_extension_id, null, trxn_extension_id, FND_API.G_MISS_NUM, null, p_trxn_extension_id)

173: partner_id = DECODE( p_partner_id, null, partner_id, FND_API.G_MISS_NUM, null, p_partner_id),
174: invite_end_date = DECODE( p_invite_end_date, null, invite_end_date, FND_API.G_MISS_DATE, null, p_invite_end_date),
175: order_header_id = DECODE( p_order_header_id, null, order_header_id, FND_API.G_MISS_NUM, null, p_order_header_id),
176: invited_by_partner_id = DECODE( p_invited_by_partner_id, null, invited_by_partner_id, FND_API.G_MISS_NUM, null, p_invited_by_partner_id),
177: trxn_extension_id = DECODE( p_trxn_extension_id, null, trxn_extension_id, FND_API.G_MISS_NUM, null, p_trxn_extension_id)
178: WHERE invite_header_id = p_invite_header_id
179: AND object_version_number = p_object_version_number;
180:
181: UPDATE pv_pg_invite_headers_tl

Line 182: set EMAIL_CONTENT = DECODE( p_EMAIL_CONTENT, null, EMAIL_CONTENT, FND_API.g_miss_char, null, p_EMAIL_CONTENT),

178: WHERE invite_header_id = p_invite_header_id
179: AND object_version_number = p_object_version_number;
180:
181: UPDATE pv_pg_invite_headers_tl
182: set EMAIL_CONTENT = DECODE( p_EMAIL_CONTENT, null, EMAIL_CONTENT, FND_API.g_miss_char, null, p_EMAIL_CONTENT),
183: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
184: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
185: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
186: source_lang = USERENV('LANG')

Line 183: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

179: AND object_version_number = p_object_version_number;
180:
181: UPDATE pv_pg_invite_headers_tl
182: set EMAIL_CONTENT = DECODE( p_EMAIL_CONTENT, null, EMAIL_CONTENT, FND_API.g_miss_char, null, p_EMAIL_CONTENT),
183: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
184: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
185: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
186: source_lang = USERENV('LANG')
187: WHERE invite_header_id = p_invite_header_id

Line 184: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

180:
181: UPDATE pv_pg_invite_headers_tl
182: set EMAIL_CONTENT = DECODE( p_EMAIL_CONTENT, null, EMAIL_CONTENT, FND_API.g_miss_char, null, p_EMAIL_CONTENT),
183: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
184: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
185: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
186: source_lang = USERENV('LANG')
187: WHERE invite_header_id = p_invite_header_id
188: AND USERENV('LANG') IN (language, source_lang);

Line 185: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

181: UPDATE pv_pg_invite_headers_tl
182: set EMAIL_CONTENT = DECODE( p_EMAIL_CONTENT, null, EMAIL_CONTENT, FND_API.g_miss_char, null, p_EMAIL_CONTENT),
183: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
184: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
185: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
186: source_lang = USERENV('LANG')
187: WHERE invite_header_id = p_invite_header_id
188: AND USERENV('LANG') IN (language, source_lang);
189:

Line 191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

187: WHERE invite_header_id = p_invite_header_id
188: AND USERENV('LANG') IN (language, source_lang);
189:
190: IF (SQL%NOTFOUND) THEN
191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
192: END IF;
193:
194:
195: END Update_Row;

Line 221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

217: DELETE FROM pv_pg_invite_headers_b
218: WHERE invite_header_id = p_invite_header_id
219: AND object_version_number = p_object_version_number;
220: If (SQL%NOTFOUND) then
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
222: End If;
223: END Delete_Row ;
224:
225:

Line 259: RAISE FND_API.g_exc_error;

255: FETCH c INTO Recinfo;
256: IF (c%NOTFOUND) THEN
257: CLOSE c;
258: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
259: RAISE FND_API.g_exc_error;
260: END IF;
261: CLOSE c;
262: END Lock_Row;
263: