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.CN_PAYMENT_WORKSHEETS_PKG dependencies on CN_API

Line 134: x_payrun_id cn_payment_worksheets.payrun_id%TYPE := cn_api.g_miss_id,

130: -- Purpose : To Update the Payment worksheet
131: --============================================================================
132: PROCEDURE UPDATE_RECORD (
133: x_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE,
134: x_payrun_id cn_payment_worksheets.payrun_id%TYPE := cn_api.g_miss_id,
135: x_salesrep_id cn_payment_worksheets.salesrep_id%TYPE := cn_api.g_miss_id,
136: x_cost_center_id cn_payment_worksheets.cost_center_id%TYPE := cn_api.g_miss_id,
137: x_role_id cn_payment_worksheets.role_id%TYPE := cn_api.g_miss_id,
138: x_credit_type_id cn_payment_worksheets.credit_type_id%TYPE := cn_api.g_miss_id,

Line 135: x_salesrep_id cn_payment_worksheets.salesrep_id%TYPE := cn_api.g_miss_id,

131: --============================================================================
132: PROCEDURE UPDATE_RECORD (
133: x_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE,
134: x_payrun_id cn_payment_worksheets.payrun_id%TYPE := cn_api.g_miss_id,
135: x_salesrep_id cn_payment_worksheets.salesrep_id%TYPE := cn_api.g_miss_id,
136: x_cost_center_id cn_payment_worksheets.cost_center_id%TYPE := cn_api.g_miss_id,
137: x_role_id cn_payment_worksheets.role_id%TYPE := cn_api.g_miss_id,
138: x_credit_type_id cn_payment_worksheets.credit_type_id%TYPE := cn_api.g_miss_id,
139: x_returned_funds_flag cn_payment_worksheets.returned_funds_flag%TYPE := '~',

Line 136: x_cost_center_id cn_payment_worksheets.cost_center_id%TYPE := cn_api.g_miss_id,

132: PROCEDURE UPDATE_RECORD (
133: x_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE,
134: x_payrun_id cn_payment_worksheets.payrun_id%TYPE := cn_api.g_miss_id,
135: x_salesrep_id cn_payment_worksheets.salesrep_id%TYPE := cn_api.g_miss_id,
136: x_cost_center_id cn_payment_worksheets.cost_center_id%TYPE := cn_api.g_miss_id,
137: x_role_id cn_payment_worksheets.role_id%TYPE := cn_api.g_miss_id,
138: x_credit_type_id cn_payment_worksheets.credit_type_id%TYPE := cn_api.g_miss_id,
139: x_returned_funds_flag cn_payment_worksheets.returned_funds_flag%TYPE := '~',
140: x_post_subledger_flag cn_payment_worksheets.post_subledger_flag%TYPE := '~',

Line 137: x_role_id cn_payment_worksheets.role_id%TYPE := cn_api.g_miss_id,

133: x_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE,
134: x_payrun_id cn_payment_worksheets.payrun_id%TYPE := cn_api.g_miss_id,
135: x_salesrep_id cn_payment_worksheets.salesrep_id%TYPE := cn_api.g_miss_id,
136: x_cost_center_id cn_payment_worksheets.cost_center_id%TYPE := cn_api.g_miss_id,
137: x_role_id cn_payment_worksheets.role_id%TYPE := cn_api.g_miss_id,
138: x_credit_type_id cn_payment_worksheets.credit_type_id%TYPE := cn_api.g_miss_id,
139: x_returned_funds_flag cn_payment_worksheets.returned_funds_flag%TYPE := '~',
140: x_post_subledger_flag cn_payment_worksheets.post_subledger_flag%TYPE := '~',
141: x_pay_cap cn_payment_worksheets.pay_cap%TYPE := fnd_api.g_miss_num,

Line 138: x_credit_type_id cn_payment_worksheets.credit_type_id%TYPE := cn_api.g_miss_id,

134: x_payrun_id cn_payment_worksheets.payrun_id%TYPE := cn_api.g_miss_id,
135: x_salesrep_id cn_payment_worksheets.salesrep_id%TYPE := cn_api.g_miss_id,
136: x_cost_center_id cn_payment_worksheets.cost_center_id%TYPE := cn_api.g_miss_id,
137: x_role_id cn_payment_worksheets.role_id%TYPE := cn_api.g_miss_id,
138: x_credit_type_id cn_payment_worksheets.credit_type_id%TYPE := cn_api.g_miss_id,
139: x_returned_funds_flag cn_payment_worksheets.returned_funds_flag%TYPE := '~',
140: x_post_subledger_flag cn_payment_worksheets.post_subledger_flag%TYPE := '~',
141: x_pay_cap cn_payment_worksheets.pay_cap%TYPE := fnd_api.g_miss_num,
142: x_minimum_amount cn_payment_worksheets.minimum_amount%TYPE := fnd_api.g_miss_num,

Line 163: x_convert_to_type_id cn_payment_worksheets.convert_to_type_id%TYPE := cn_api.g_miss_id,

159: x_payee_comm_paid cn_payment_worksheets.payee_comm_paid%TYPE := fnd_api.g_miss_num,
160: x_payee_bonus_due_bb cn_payment_worksheets.payee_bonus_due_bb%TYPE := fnd_api.g_miss_num,
161: x_payee_bonus_ptd cn_payment_worksheets.payee_bonus_ptd%TYPE := fnd_api.g_miss_num,
162: x_payee_bonus_paid cn_payment_worksheets.payee_bonus_paid%TYPE := fnd_api.g_miss_num,
163: x_convert_to_type_id cn_payment_worksheets.convert_to_type_id%TYPE := cn_api.g_miss_id,
164: x_credit_conv_fct_id cn_payment_worksheets.credit_conv_fct_id%TYPE := cn_api.g_miss_id,
165: x_convert_to_paid cn_payment_worksheets.convert_to_paid%TYPE := fnd_api.g_miss_num,
166: x_reviewed_by_analyst cn_payment_worksheets_all.reviewed_by_analyst%TYPE := fnd_api.g_miss_char,
167: x_analyst_notes cn_payment_worksheets_all.analyst_notes%TYPE := fnd_api.g_miss_char,

Line 164: x_credit_conv_fct_id cn_payment_worksheets.credit_conv_fct_id%TYPE := cn_api.g_miss_id,

160: x_payee_bonus_due_bb cn_payment_worksheets.payee_bonus_due_bb%TYPE := fnd_api.g_miss_num,
161: x_payee_bonus_ptd cn_payment_worksheets.payee_bonus_ptd%TYPE := fnd_api.g_miss_num,
162: x_payee_bonus_paid cn_payment_worksheets.payee_bonus_paid%TYPE := fnd_api.g_miss_num,
163: x_convert_to_type_id cn_payment_worksheets.convert_to_type_id%TYPE := cn_api.g_miss_id,
164: x_credit_conv_fct_id cn_payment_worksheets.credit_conv_fct_id%TYPE := cn_api.g_miss_id,
165: x_convert_to_paid cn_payment_worksheets.convert_to_paid%TYPE := fnd_api.g_miss_num,
166: x_reviewed_by_analyst cn_payment_worksheets_all.reviewed_by_analyst%TYPE := fnd_api.g_miss_char,
167: x_analyst_notes cn_payment_worksheets_all.analyst_notes%TYPE := fnd_api.g_miss_char,
168: x_posting_status cn_payment_worksheets.posting_status%TYPE := fnd_api.g_miss_char,

Line 246: SELECT DECODE (x_salesrep_id, cn_api.g_miss_id, l_payment_worksheet_rec.salesrep_id, x_salesrep_id),

242: INTO l_payment_worksheet_rec;
243:
244: CLOSE payment_worksheet_cur;
245:
246: SELECT DECODE (x_salesrep_id, cn_api.g_miss_id, l_payment_worksheet_rec.salesrep_id, x_salesrep_id),
247: DECODE (x_cost_center_id, cn_api.g_miss_id, l_payment_worksheet_rec.cost_center_id, x_cost_center_id),
248: DECODE (x_role_id, cn_api.g_miss_id, l_payment_worksheet_rec.role_id, x_role_id),
249: DECODE (x_credit_type_id, cn_api.g_miss_id, l_payment_worksheet_rec.credit_type_id, x_credit_type_id),
250: DECODE (x_returned_funds_flag, '~', l_payment_worksheet_rec.returned_funds_flag, x_returned_funds_flag),

Line 247: DECODE (x_cost_center_id, cn_api.g_miss_id, l_payment_worksheet_rec.cost_center_id, x_cost_center_id),

243:
244: CLOSE payment_worksheet_cur;
245:
246: SELECT DECODE (x_salesrep_id, cn_api.g_miss_id, l_payment_worksheet_rec.salesrep_id, x_salesrep_id),
247: DECODE (x_cost_center_id, cn_api.g_miss_id, l_payment_worksheet_rec.cost_center_id, x_cost_center_id),
248: DECODE (x_role_id, cn_api.g_miss_id, l_payment_worksheet_rec.role_id, x_role_id),
249: DECODE (x_credit_type_id, cn_api.g_miss_id, l_payment_worksheet_rec.credit_type_id, x_credit_type_id),
250: DECODE (x_returned_funds_flag, '~', l_payment_worksheet_rec.returned_funds_flag, x_returned_funds_flag),
251: DECODE (x_post_subledger_flag, '~', l_payment_worksheet_rec.post_subledger_flag, x_post_subledger_flag),

Line 248: DECODE (x_role_id, cn_api.g_miss_id, l_payment_worksheet_rec.role_id, x_role_id),

244: CLOSE payment_worksheet_cur;
245:
246: SELECT DECODE (x_salesrep_id, cn_api.g_miss_id, l_payment_worksheet_rec.salesrep_id, x_salesrep_id),
247: DECODE (x_cost_center_id, cn_api.g_miss_id, l_payment_worksheet_rec.cost_center_id, x_cost_center_id),
248: DECODE (x_role_id, cn_api.g_miss_id, l_payment_worksheet_rec.role_id, x_role_id),
249: DECODE (x_credit_type_id, cn_api.g_miss_id, l_payment_worksheet_rec.credit_type_id, x_credit_type_id),
250: DECODE (x_returned_funds_flag, '~', l_payment_worksheet_rec.returned_funds_flag, x_returned_funds_flag),
251: DECODE (x_post_subledger_flag, '~', l_payment_worksheet_rec.post_subledger_flag, x_post_subledger_flag),
252: DECODE (x_pay_cap, fnd_api.g_miss_num, l_payment_worksheet_rec.pay_cap, x_pay_cap),

Line 249: DECODE (x_credit_type_id, cn_api.g_miss_id, l_payment_worksheet_rec.credit_type_id, x_credit_type_id),

245:
246: SELECT DECODE (x_salesrep_id, cn_api.g_miss_id, l_payment_worksheet_rec.salesrep_id, x_salesrep_id),
247: DECODE (x_cost_center_id, cn_api.g_miss_id, l_payment_worksheet_rec.cost_center_id, x_cost_center_id),
248: DECODE (x_role_id, cn_api.g_miss_id, l_payment_worksheet_rec.role_id, x_role_id),
249: DECODE (x_credit_type_id, cn_api.g_miss_id, l_payment_worksheet_rec.credit_type_id, x_credit_type_id),
250: DECODE (x_returned_funds_flag, '~', l_payment_worksheet_rec.returned_funds_flag, x_returned_funds_flag),
251: DECODE (x_post_subledger_flag, '~', l_payment_worksheet_rec.post_subledger_flag, x_post_subledger_flag),
252: DECODE (x_pay_cap, fnd_api.g_miss_num, l_payment_worksheet_rec.pay_cap, x_pay_cap),
253: DECODE (x_minimum_amount, fnd_api.g_miss_num, l_payment_worksheet_rec.minimum_amount, x_minimum_amount),

Line 274: DECODE (x_convert_to_type_id, cn_api.g_miss_id, l_payment_worksheet_rec.convert_to_type_id, x_convert_to_type_id),

270: DECODE (x_payee_comm_paid, fnd_api.g_miss_num, l_payment_worksheet_rec.payee_comm_paid, x_payee_comm_paid),
271: DECODE (x_payee_bonus_due_bb, fnd_api.g_miss_num, l_payment_worksheet_rec.payee_bonus_due_bb, x_payee_bonus_due_bb),
272: DECODE (x_payee_bonus_ptd, fnd_api.g_miss_num, l_payment_worksheet_rec.payee_bonus_ptd, x_payee_bonus_ptd),
273: DECODE (x_payee_bonus_paid, fnd_api.g_miss_num, l_payment_worksheet_rec.payee_bonus_paid, x_payee_bonus_paid),
274: DECODE (x_convert_to_type_id, cn_api.g_miss_id, l_payment_worksheet_rec.convert_to_type_id, x_convert_to_type_id),
275: DECODE (x_credit_conv_fct_id, cn_api.g_miss_id, l_payment_worksheet_rec.credit_conv_fct_id, x_credit_conv_fct_id),
276: DECODE (x_convert_to_paid, fnd_api.g_miss_num, l_payment_worksheet_rec.convert_to_paid, x_convert_to_paid),
277: DECODE (x_reviewed_by_analyst, fnd_api.g_miss_char, l_payment_worksheet_rec.reviewed_by_analyst, x_reviewed_by_analyst),
278: DECODE (x_analyst_notes, fnd_api.g_miss_char, l_payment_worksheet_rec.analyst_notes, x_analyst_notes),

Line 275: DECODE (x_credit_conv_fct_id, cn_api.g_miss_id, l_payment_worksheet_rec.credit_conv_fct_id, x_credit_conv_fct_id),

271: DECODE (x_payee_bonus_due_bb, fnd_api.g_miss_num, l_payment_worksheet_rec.payee_bonus_due_bb, x_payee_bonus_due_bb),
272: DECODE (x_payee_bonus_ptd, fnd_api.g_miss_num, l_payment_worksheet_rec.payee_bonus_ptd, x_payee_bonus_ptd),
273: DECODE (x_payee_bonus_paid, fnd_api.g_miss_num, l_payment_worksheet_rec.payee_bonus_paid, x_payee_bonus_paid),
274: DECODE (x_convert_to_type_id, cn_api.g_miss_id, l_payment_worksheet_rec.convert_to_type_id, x_convert_to_type_id),
275: DECODE (x_credit_conv_fct_id, cn_api.g_miss_id, l_payment_worksheet_rec.credit_conv_fct_id, x_credit_conv_fct_id),
276: DECODE (x_convert_to_paid, fnd_api.g_miss_num, l_payment_worksheet_rec.convert_to_paid, x_convert_to_paid),
277: DECODE (x_reviewed_by_analyst, fnd_api.g_miss_char, l_payment_worksheet_rec.reviewed_by_analyst, x_reviewed_by_analyst),
278: DECODE (x_analyst_notes, fnd_api.g_miss_char, l_payment_worksheet_rec.analyst_notes, x_analyst_notes),
279: DECODE (x_posting_status, fnd_api.g_miss_char, l_payment_worksheet_rec.posting_status, x_posting_status),