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_PMT_TRANS_PKG dependencies on CN_API

Line 5: posting_batch_id cn_payment_transactions.posting_batch_id%TYPE := cn_api.g_miss_id,

1: PACKAGE cn_pmt_trans_pkg AS
2: -- $Header: cntpmtrs.pls 120.5 2005/09/24 14:10:57 fmburu ship $ --+
3: TYPE pmt_trans_rec_type IS RECORD (
4: payment_transaction_id cn_payment_transactions.payment_transaction_id%TYPE,
5: posting_batch_id cn_payment_transactions.posting_batch_id%TYPE := cn_api.g_miss_id,
6: credited_salesrep_id cn_payment_transactions.credited_salesrep_id%TYPE := cn_api.g_miss_id,
7: payee_salesrep_id cn_payment_transactions.payee_salesrep_id%TYPE := cn_api.g_miss_id,
8: quota_id cn_payment_transactions.quota_id%TYPE := cn_api.g_miss_id,
9: pay_period_id cn_payment_transactions.pay_period_id%TYPE := cn_api.g_miss_id,

Line 6: credited_salesrep_id cn_payment_transactions.credited_salesrep_id%TYPE := cn_api.g_miss_id,

2: -- $Header: cntpmtrs.pls 120.5 2005/09/24 14:10:57 fmburu ship $ --+
3: TYPE pmt_trans_rec_type IS RECORD (
4: payment_transaction_id cn_payment_transactions.payment_transaction_id%TYPE,
5: posting_batch_id cn_payment_transactions.posting_batch_id%TYPE := cn_api.g_miss_id,
6: credited_salesrep_id cn_payment_transactions.credited_salesrep_id%TYPE := cn_api.g_miss_id,
7: payee_salesrep_id cn_payment_transactions.payee_salesrep_id%TYPE := cn_api.g_miss_id,
8: quota_id cn_payment_transactions.quota_id%TYPE := cn_api.g_miss_id,
9: pay_period_id cn_payment_transactions.pay_period_id%TYPE := cn_api.g_miss_id,
10: incentive_type_code cn_payment_transactions.incentive_type_code%TYPE := fnd_api.g_miss_char,

Line 7: payee_salesrep_id cn_payment_transactions.payee_salesrep_id%TYPE := cn_api.g_miss_id,

3: TYPE pmt_trans_rec_type IS RECORD (
4: payment_transaction_id cn_payment_transactions.payment_transaction_id%TYPE,
5: posting_batch_id cn_payment_transactions.posting_batch_id%TYPE := cn_api.g_miss_id,
6: credited_salesrep_id cn_payment_transactions.credited_salesrep_id%TYPE := cn_api.g_miss_id,
7: payee_salesrep_id cn_payment_transactions.payee_salesrep_id%TYPE := cn_api.g_miss_id,
8: quota_id cn_payment_transactions.quota_id%TYPE := cn_api.g_miss_id,
9: pay_period_id cn_payment_transactions.pay_period_id%TYPE := cn_api.g_miss_id,
10: incentive_type_code cn_payment_transactions.incentive_type_code%TYPE := fnd_api.g_miss_char,
11: credit_type_id cn_payment_transactions.credit_type_id%TYPE := cn_api.g_miss_id,

Line 8: quota_id cn_payment_transactions.quota_id%TYPE := cn_api.g_miss_id,

4: payment_transaction_id cn_payment_transactions.payment_transaction_id%TYPE,
5: posting_batch_id cn_payment_transactions.posting_batch_id%TYPE := cn_api.g_miss_id,
6: credited_salesrep_id cn_payment_transactions.credited_salesrep_id%TYPE := cn_api.g_miss_id,
7: payee_salesrep_id cn_payment_transactions.payee_salesrep_id%TYPE := cn_api.g_miss_id,
8: quota_id cn_payment_transactions.quota_id%TYPE := cn_api.g_miss_id,
9: pay_period_id cn_payment_transactions.pay_period_id%TYPE := cn_api.g_miss_id,
10: incentive_type_code cn_payment_transactions.incentive_type_code%TYPE := fnd_api.g_miss_char,
11: credit_type_id cn_payment_transactions.credit_type_id%TYPE := cn_api.g_miss_id,
12: payrun_id cn_payment_transactions.payrun_id%TYPE := cn_api.g_miss_id,

Line 9: pay_period_id cn_payment_transactions.pay_period_id%TYPE := cn_api.g_miss_id,

5: posting_batch_id cn_payment_transactions.posting_batch_id%TYPE := cn_api.g_miss_id,
6: credited_salesrep_id cn_payment_transactions.credited_salesrep_id%TYPE := cn_api.g_miss_id,
7: payee_salesrep_id cn_payment_transactions.payee_salesrep_id%TYPE := cn_api.g_miss_id,
8: quota_id cn_payment_transactions.quota_id%TYPE := cn_api.g_miss_id,
9: pay_period_id cn_payment_transactions.pay_period_id%TYPE := cn_api.g_miss_id,
10: incentive_type_code cn_payment_transactions.incentive_type_code%TYPE := fnd_api.g_miss_char,
11: credit_type_id cn_payment_transactions.credit_type_id%TYPE := cn_api.g_miss_id,
12: payrun_id cn_payment_transactions.payrun_id%TYPE := cn_api.g_miss_id,
13: amount cn_payment_transactions.amount%TYPE := cn_api.g_miss_num,

Line 11: credit_type_id cn_payment_transactions.credit_type_id%TYPE := cn_api.g_miss_id,

7: payee_salesrep_id cn_payment_transactions.payee_salesrep_id%TYPE := cn_api.g_miss_id,
8: quota_id cn_payment_transactions.quota_id%TYPE := cn_api.g_miss_id,
9: pay_period_id cn_payment_transactions.pay_period_id%TYPE := cn_api.g_miss_id,
10: incentive_type_code cn_payment_transactions.incentive_type_code%TYPE := fnd_api.g_miss_char,
11: credit_type_id cn_payment_transactions.credit_type_id%TYPE := cn_api.g_miss_id,
12: payrun_id cn_payment_transactions.payrun_id%TYPE := cn_api.g_miss_id,
13: amount cn_payment_transactions.amount%TYPE := cn_api.g_miss_num,
14: payment_amount cn_payment_transactions.payment_amount%TYPE := cn_api.g_miss_num,
15: hold_flag cn_payment_transactions.hold_flag%TYPE := fnd_api.g_miss_char,

Line 12: payrun_id cn_payment_transactions.payrun_id%TYPE := cn_api.g_miss_id,

8: quota_id cn_payment_transactions.quota_id%TYPE := cn_api.g_miss_id,
9: pay_period_id cn_payment_transactions.pay_period_id%TYPE := cn_api.g_miss_id,
10: incentive_type_code cn_payment_transactions.incentive_type_code%TYPE := fnd_api.g_miss_char,
11: credit_type_id cn_payment_transactions.credit_type_id%TYPE := cn_api.g_miss_id,
12: payrun_id cn_payment_transactions.payrun_id%TYPE := cn_api.g_miss_id,
13: amount cn_payment_transactions.amount%TYPE := cn_api.g_miss_num,
14: payment_amount cn_payment_transactions.payment_amount%TYPE := cn_api.g_miss_num,
15: hold_flag cn_payment_transactions.hold_flag%TYPE := fnd_api.g_miss_char,
16: paid_flag cn_payment_transactions.paid_flag%TYPE := fnd_api.g_miss_char,

Line 13: amount cn_payment_transactions.amount%TYPE := cn_api.g_miss_num,

9: pay_period_id cn_payment_transactions.pay_period_id%TYPE := cn_api.g_miss_id,
10: incentive_type_code cn_payment_transactions.incentive_type_code%TYPE := fnd_api.g_miss_char,
11: credit_type_id cn_payment_transactions.credit_type_id%TYPE := cn_api.g_miss_id,
12: payrun_id cn_payment_transactions.payrun_id%TYPE := cn_api.g_miss_id,
13: amount cn_payment_transactions.amount%TYPE := cn_api.g_miss_num,
14: payment_amount cn_payment_transactions.payment_amount%TYPE := cn_api.g_miss_num,
15: hold_flag cn_payment_transactions.hold_flag%TYPE := fnd_api.g_miss_char,
16: paid_flag cn_payment_transactions.paid_flag%TYPE := fnd_api.g_miss_char,
17: waive_flag cn_payment_transactions.waive_flag%TYPE := fnd_api.g_miss_char,

Line 14: payment_amount cn_payment_transactions.payment_amount%TYPE := cn_api.g_miss_num,

10: incentive_type_code cn_payment_transactions.incentive_type_code%TYPE := fnd_api.g_miss_char,
11: credit_type_id cn_payment_transactions.credit_type_id%TYPE := cn_api.g_miss_id,
12: payrun_id cn_payment_transactions.payrun_id%TYPE := cn_api.g_miss_id,
13: amount cn_payment_transactions.amount%TYPE := cn_api.g_miss_num,
14: payment_amount cn_payment_transactions.payment_amount%TYPE := cn_api.g_miss_num,
15: hold_flag cn_payment_transactions.hold_flag%TYPE := fnd_api.g_miss_char,
16: paid_flag cn_payment_transactions.paid_flag%TYPE := fnd_api.g_miss_char,
17: waive_flag cn_payment_transactions.waive_flag%TYPE := fnd_api.g_miss_char,
18: recoverable_flag cn_payment_transactions.recoverable_flag%TYPE := fnd_api.g_miss_char,

Line 19: commission_header_id cn_payment_transactions.commission_header_id%TYPE := cn_api.g_miss_id,

15: hold_flag cn_payment_transactions.hold_flag%TYPE := fnd_api.g_miss_char,
16: paid_flag cn_payment_transactions.paid_flag%TYPE := fnd_api.g_miss_char,
17: waive_flag cn_payment_transactions.waive_flag%TYPE := fnd_api.g_miss_char,
18: recoverable_flag cn_payment_transactions.recoverable_flag%TYPE := fnd_api.g_miss_char,
19: commission_header_id cn_payment_transactions.commission_header_id%TYPE := cn_api.g_miss_id,
20: commission_line_id cn_payment_transactions.commission_line_id%TYPE := cn_api.g_miss_id,
21: pay_element_type_id cn_payment_transactions.pay_element_type_id%TYPE,
22: srp_plan_assign_id cn_payment_transactions.srp_plan_assign_id%TYPE := cn_api.g_miss_id,
23: processed_date cn_payment_transactions.processed_date%TYPE := fnd_api.g_miss_date,

Line 20: commission_line_id cn_payment_transactions.commission_line_id%TYPE := cn_api.g_miss_id,

16: paid_flag cn_payment_transactions.paid_flag%TYPE := fnd_api.g_miss_char,
17: waive_flag cn_payment_transactions.waive_flag%TYPE := fnd_api.g_miss_char,
18: recoverable_flag cn_payment_transactions.recoverable_flag%TYPE := fnd_api.g_miss_char,
19: commission_header_id cn_payment_transactions.commission_header_id%TYPE := cn_api.g_miss_id,
20: commission_line_id cn_payment_transactions.commission_line_id%TYPE := cn_api.g_miss_id,
21: pay_element_type_id cn_payment_transactions.pay_element_type_id%TYPE,
22: srp_plan_assign_id cn_payment_transactions.srp_plan_assign_id%TYPE := cn_api.g_miss_id,
23: processed_date cn_payment_transactions.processed_date%TYPE := fnd_api.g_miss_date,
24: processed_period_id cn_payment_transactions.processed_period_id%TYPE := cn_api.g_miss_id,

Line 22: srp_plan_assign_id cn_payment_transactions.srp_plan_assign_id%TYPE := cn_api.g_miss_id,

18: recoverable_flag cn_payment_transactions.recoverable_flag%TYPE := fnd_api.g_miss_char,
19: commission_header_id cn_payment_transactions.commission_header_id%TYPE := cn_api.g_miss_id,
20: commission_line_id cn_payment_transactions.commission_line_id%TYPE := cn_api.g_miss_id,
21: pay_element_type_id cn_payment_transactions.pay_element_type_id%TYPE,
22: srp_plan_assign_id cn_payment_transactions.srp_plan_assign_id%TYPE := cn_api.g_miss_id,
23: processed_date cn_payment_transactions.processed_date%TYPE := fnd_api.g_miss_date,
24: processed_period_id cn_payment_transactions.processed_period_id%TYPE := cn_api.g_miss_id,
25: quota_rule_id cn_payment_transactions.quota_rule_id%TYPE := cn_api.g_miss_id,
26: event_factor cn_payment_transactions.event_factor%TYPE := cn_api.g_miss_num,

Line 24: processed_period_id cn_payment_transactions.processed_period_id%TYPE := cn_api.g_miss_id,

20: commission_line_id cn_payment_transactions.commission_line_id%TYPE := cn_api.g_miss_id,
21: pay_element_type_id cn_payment_transactions.pay_element_type_id%TYPE,
22: srp_plan_assign_id cn_payment_transactions.srp_plan_assign_id%TYPE := cn_api.g_miss_id,
23: processed_date cn_payment_transactions.processed_date%TYPE := fnd_api.g_miss_date,
24: processed_period_id cn_payment_transactions.processed_period_id%TYPE := cn_api.g_miss_id,
25: quota_rule_id cn_payment_transactions.quota_rule_id%TYPE := cn_api.g_miss_id,
26: event_factor cn_payment_transactions.event_factor%TYPE := cn_api.g_miss_num,
27: payment_factor cn_payment_transactions.payment_factor%TYPE := cn_api.g_miss_num,
28: quota_factor cn_payment_transactions.quota_factor%TYPE := cn_api.g_miss_num,

Line 25: quota_rule_id cn_payment_transactions.quota_rule_id%TYPE := cn_api.g_miss_id,

21: pay_element_type_id cn_payment_transactions.pay_element_type_id%TYPE,
22: srp_plan_assign_id cn_payment_transactions.srp_plan_assign_id%TYPE := cn_api.g_miss_id,
23: processed_date cn_payment_transactions.processed_date%TYPE := fnd_api.g_miss_date,
24: processed_period_id cn_payment_transactions.processed_period_id%TYPE := cn_api.g_miss_id,
25: quota_rule_id cn_payment_transactions.quota_rule_id%TYPE := cn_api.g_miss_id,
26: event_factor cn_payment_transactions.event_factor%TYPE := cn_api.g_miss_num,
27: payment_factor cn_payment_transactions.payment_factor%TYPE := cn_api.g_miss_num,
28: quota_factor cn_payment_transactions.quota_factor%TYPE := cn_api.g_miss_num,
29: input_achieved cn_payment_transactions.input_achieved%TYPE := cn_api.g_miss_num,

Line 26: event_factor cn_payment_transactions.event_factor%TYPE := cn_api.g_miss_num,

22: srp_plan_assign_id cn_payment_transactions.srp_plan_assign_id%TYPE := cn_api.g_miss_id,
23: processed_date cn_payment_transactions.processed_date%TYPE := fnd_api.g_miss_date,
24: processed_period_id cn_payment_transactions.processed_period_id%TYPE := cn_api.g_miss_id,
25: quota_rule_id cn_payment_transactions.quota_rule_id%TYPE := cn_api.g_miss_id,
26: event_factor cn_payment_transactions.event_factor%TYPE := cn_api.g_miss_num,
27: payment_factor cn_payment_transactions.payment_factor%TYPE := cn_api.g_miss_num,
28: quota_factor cn_payment_transactions.quota_factor%TYPE := cn_api.g_miss_num,
29: input_achieved cn_payment_transactions.input_achieved%TYPE := cn_api.g_miss_num,
30: rate_tier_id cn_payment_transactions.rate_tier_id%TYPE := cn_api.g_miss_id,

Line 27: payment_factor cn_payment_transactions.payment_factor%TYPE := cn_api.g_miss_num,

23: processed_date cn_payment_transactions.processed_date%TYPE := fnd_api.g_miss_date,
24: processed_period_id cn_payment_transactions.processed_period_id%TYPE := cn_api.g_miss_id,
25: quota_rule_id cn_payment_transactions.quota_rule_id%TYPE := cn_api.g_miss_id,
26: event_factor cn_payment_transactions.event_factor%TYPE := cn_api.g_miss_num,
27: payment_factor cn_payment_transactions.payment_factor%TYPE := cn_api.g_miss_num,
28: quota_factor cn_payment_transactions.quota_factor%TYPE := cn_api.g_miss_num,
29: input_achieved cn_payment_transactions.input_achieved%TYPE := cn_api.g_miss_num,
30: rate_tier_id cn_payment_transactions.rate_tier_id%TYPE := cn_api.g_miss_id,
31: payee_line_id cn_payment_transactions.payee_line_id%TYPE := cn_api.g_miss_id,

Line 28: quota_factor cn_payment_transactions.quota_factor%TYPE := cn_api.g_miss_num,

24: processed_period_id cn_payment_transactions.processed_period_id%TYPE := cn_api.g_miss_id,
25: quota_rule_id cn_payment_transactions.quota_rule_id%TYPE := cn_api.g_miss_id,
26: event_factor cn_payment_transactions.event_factor%TYPE := cn_api.g_miss_num,
27: payment_factor cn_payment_transactions.payment_factor%TYPE := cn_api.g_miss_num,
28: quota_factor cn_payment_transactions.quota_factor%TYPE := cn_api.g_miss_num,
29: input_achieved cn_payment_transactions.input_achieved%TYPE := cn_api.g_miss_num,
30: rate_tier_id cn_payment_transactions.rate_tier_id%TYPE := cn_api.g_miss_id,
31: payee_line_id cn_payment_transactions.payee_line_id%TYPE := cn_api.g_miss_id,
32: commission_rate cn_payment_transactions.commission_rate%TYPE := cn_api.g_miss_num,

Line 29: input_achieved cn_payment_transactions.input_achieved%TYPE := cn_api.g_miss_num,

25: quota_rule_id cn_payment_transactions.quota_rule_id%TYPE := cn_api.g_miss_id,
26: event_factor cn_payment_transactions.event_factor%TYPE := cn_api.g_miss_num,
27: payment_factor cn_payment_transactions.payment_factor%TYPE := cn_api.g_miss_num,
28: quota_factor cn_payment_transactions.quota_factor%TYPE := cn_api.g_miss_num,
29: input_achieved cn_payment_transactions.input_achieved%TYPE := cn_api.g_miss_num,
30: rate_tier_id cn_payment_transactions.rate_tier_id%TYPE := cn_api.g_miss_id,
31: payee_line_id cn_payment_transactions.payee_line_id%TYPE := cn_api.g_miss_id,
32: commission_rate cn_payment_transactions.commission_rate%TYPE := cn_api.g_miss_num,
33: trx_type cn_payment_transactions.trx_type%TYPE := fnd_api.g_miss_char,

Line 30: rate_tier_id cn_payment_transactions.rate_tier_id%TYPE := cn_api.g_miss_id,

26: event_factor cn_payment_transactions.event_factor%TYPE := cn_api.g_miss_num,
27: payment_factor cn_payment_transactions.payment_factor%TYPE := cn_api.g_miss_num,
28: quota_factor cn_payment_transactions.quota_factor%TYPE := cn_api.g_miss_num,
29: input_achieved cn_payment_transactions.input_achieved%TYPE := cn_api.g_miss_num,
30: rate_tier_id cn_payment_transactions.rate_tier_id%TYPE := cn_api.g_miss_id,
31: payee_line_id cn_payment_transactions.payee_line_id%TYPE := cn_api.g_miss_id,
32: commission_rate cn_payment_transactions.commission_rate%TYPE := cn_api.g_miss_num,
33: trx_type cn_payment_transactions.trx_type%TYPE := fnd_api.g_miss_char,
34: role_id cn_payment_transactions.role_id%TYPE := cn_api.g_miss_id,

Line 31: payee_line_id cn_payment_transactions.payee_line_id%TYPE := cn_api.g_miss_id,

27: payment_factor cn_payment_transactions.payment_factor%TYPE := cn_api.g_miss_num,
28: quota_factor cn_payment_transactions.quota_factor%TYPE := cn_api.g_miss_num,
29: input_achieved cn_payment_transactions.input_achieved%TYPE := cn_api.g_miss_num,
30: rate_tier_id cn_payment_transactions.rate_tier_id%TYPE := cn_api.g_miss_id,
31: payee_line_id cn_payment_transactions.payee_line_id%TYPE := cn_api.g_miss_id,
32: commission_rate cn_payment_transactions.commission_rate%TYPE := cn_api.g_miss_num,
33: trx_type cn_payment_transactions.trx_type%TYPE := fnd_api.g_miss_char,
34: role_id cn_payment_transactions.role_id%TYPE := cn_api.g_miss_id,
35: expense_ccid cn_payment_transactions.expense_ccid%TYPE := cn_api.g_miss_id,

Line 32: commission_rate cn_payment_transactions.commission_rate%TYPE := cn_api.g_miss_num,

28: quota_factor cn_payment_transactions.quota_factor%TYPE := cn_api.g_miss_num,
29: input_achieved cn_payment_transactions.input_achieved%TYPE := cn_api.g_miss_num,
30: rate_tier_id cn_payment_transactions.rate_tier_id%TYPE := cn_api.g_miss_id,
31: payee_line_id cn_payment_transactions.payee_line_id%TYPE := cn_api.g_miss_id,
32: commission_rate cn_payment_transactions.commission_rate%TYPE := cn_api.g_miss_num,
33: trx_type cn_payment_transactions.trx_type%TYPE := fnd_api.g_miss_char,
34: role_id cn_payment_transactions.role_id%TYPE := cn_api.g_miss_id,
35: expense_ccid cn_payment_transactions.expense_ccid%TYPE := cn_api.g_miss_id,
36: liability_ccid cn_payment_transactions.liability_ccid%TYPE := cn_api.g_miss_id,

Line 34: role_id cn_payment_transactions.role_id%TYPE := cn_api.g_miss_id,

30: rate_tier_id cn_payment_transactions.rate_tier_id%TYPE := cn_api.g_miss_id,
31: payee_line_id cn_payment_transactions.payee_line_id%TYPE := cn_api.g_miss_id,
32: commission_rate cn_payment_transactions.commission_rate%TYPE := cn_api.g_miss_num,
33: trx_type cn_payment_transactions.trx_type%TYPE := fnd_api.g_miss_char,
34: role_id cn_payment_transactions.role_id%TYPE := cn_api.g_miss_id,
35: expense_ccid cn_payment_transactions.expense_ccid%TYPE := cn_api.g_miss_id,
36: liability_ccid cn_payment_transactions.liability_ccid%TYPE := cn_api.g_miss_id,
37: attribute_category cn_payment_transactions.attribute_category%TYPE := fnd_api.g_miss_char,
38: attribute1 cn_payment_transactions.attribute1%TYPE := fnd_api.g_miss_char,

Line 35: expense_ccid cn_payment_transactions.expense_ccid%TYPE := cn_api.g_miss_id,

31: payee_line_id cn_payment_transactions.payee_line_id%TYPE := cn_api.g_miss_id,
32: commission_rate cn_payment_transactions.commission_rate%TYPE := cn_api.g_miss_num,
33: trx_type cn_payment_transactions.trx_type%TYPE := fnd_api.g_miss_char,
34: role_id cn_payment_transactions.role_id%TYPE := cn_api.g_miss_id,
35: expense_ccid cn_payment_transactions.expense_ccid%TYPE := cn_api.g_miss_id,
36: liability_ccid cn_payment_transactions.liability_ccid%TYPE := cn_api.g_miss_id,
37: attribute_category cn_payment_transactions.attribute_category%TYPE := fnd_api.g_miss_char,
38: attribute1 cn_payment_transactions.attribute1%TYPE := fnd_api.g_miss_char,
39: attribute2 cn_payment_transactions.attribute2%TYPE := fnd_api.g_miss_char,

Line 36: liability_ccid cn_payment_transactions.liability_ccid%TYPE := cn_api.g_miss_id,

32: commission_rate cn_payment_transactions.commission_rate%TYPE := cn_api.g_miss_num,
33: trx_type cn_payment_transactions.trx_type%TYPE := fnd_api.g_miss_char,
34: role_id cn_payment_transactions.role_id%TYPE := cn_api.g_miss_id,
35: expense_ccid cn_payment_transactions.expense_ccid%TYPE := cn_api.g_miss_id,
36: liability_ccid cn_payment_transactions.liability_ccid%TYPE := cn_api.g_miss_id,
37: attribute_category cn_payment_transactions.attribute_category%TYPE := fnd_api.g_miss_char,
38: attribute1 cn_payment_transactions.attribute1%TYPE := fnd_api.g_miss_char,
39: attribute2 cn_payment_transactions.attribute2%TYPE := fnd_api.g_miss_char,
40: attribute3 cn_payment_transactions.attribute3%TYPE := fnd_api.g_miss_char,