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_PVT dependencies on CN_PAYMENT_TRANSACTIONS

Line 8: payment_transaction_id cn_payment_transactions.payment_transaction_id%TYPE,

4: G_RELEASE_ALL CONSTANT VARCHAR2 (20) := 'RELEASE_ALL' ;
5: G_RESET_TO_UNPAID CONSTANT VARCHAR2 (20) := 'RESET_TO_UNPAID' ;
6:
7: TYPE pmt_tran_rec IS RECORD (
8: payment_transaction_id cn_payment_transactions.payment_transaction_id%TYPE,
9: amount cn_payment_transactions.amount%TYPE,
10: payment_amount cn_payment_transactions.payment_amount%TYPE,
11: payment_diff cn_payment_transactions.payment_amount%TYPE,
12: quota_id cn_payment_transactions.quota_id%TYPE,

Line 9: amount cn_payment_transactions.amount%TYPE,

5: G_RESET_TO_UNPAID CONSTANT VARCHAR2 (20) := 'RESET_TO_UNPAID' ;
6:
7: TYPE pmt_tran_rec IS RECORD (
8: payment_transaction_id cn_payment_transactions.payment_transaction_id%TYPE,
9: amount cn_payment_transactions.amount%TYPE,
10: payment_amount cn_payment_transactions.payment_amount%TYPE,
11: payment_diff cn_payment_transactions.payment_amount%TYPE,
12: quota_id cn_payment_transactions.quota_id%TYPE,
13: quota_name cn_quotas.NAME%TYPE,

Line 10: payment_amount cn_payment_transactions.payment_amount%TYPE,

6:
7: TYPE pmt_tran_rec IS RECORD (
8: payment_transaction_id cn_payment_transactions.payment_transaction_id%TYPE,
9: amount cn_payment_transactions.amount%TYPE,
10: payment_amount cn_payment_transactions.payment_amount%TYPE,
11: payment_diff cn_payment_transactions.payment_amount%TYPE,
12: quota_id cn_payment_transactions.quota_id%TYPE,
13: quota_name cn_quotas.NAME%TYPE,
14: incentive_type_code cn_payment_transactions.incentive_type_code%TYPE,

Line 11: payment_diff cn_payment_transactions.payment_amount%TYPE,

7: TYPE pmt_tran_rec IS RECORD (
8: payment_transaction_id cn_payment_transactions.payment_transaction_id%TYPE,
9: amount cn_payment_transactions.amount%TYPE,
10: payment_amount cn_payment_transactions.payment_amount%TYPE,
11: payment_diff cn_payment_transactions.payment_amount%TYPE,
12: quota_id cn_payment_transactions.quota_id%TYPE,
13: quota_name cn_quotas.NAME%TYPE,
14: incentive_type_code cn_payment_transactions.incentive_type_code%TYPE,
15: incentive_type cn_lookups.meaning%TYPE,

Line 12: quota_id cn_payment_transactions.quota_id%TYPE,

8: payment_transaction_id cn_payment_transactions.payment_transaction_id%TYPE,
9: amount cn_payment_transactions.amount%TYPE,
10: payment_amount cn_payment_transactions.payment_amount%TYPE,
11: payment_diff cn_payment_transactions.payment_amount%TYPE,
12: quota_id cn_payment_transactions.quota_id%TYPE,
13: quota_name cn_quotas.NAME%TYPE,
14: incentive_type_code cn_payment_transactions.incentive_type_code%TYPE,
15: incentive_type cn_lookups.meaning%TYPE,
16: hold_flag cn_payment_transactions.hold_flag%TYPE,

Line 14: incentive_type_code cn_payment_transactions.incentive_type_code%TYPE,

10: payment_amount cn_payment_transactions.payment_amount%TYPE,
11: payment_diff cn_payment_transactions.payment_amount%TYPE,
12: quota_id cn_payment_transactions.quota_id%TYPE,
13: quota_name cn_quotas.NAME%TYPE,
14: incentive_type_code cn_payment_transactions.incentive_type_code%TYPE,
15: incentive_type cn_lookups.meaning%TYPE,
16: hold_flag cn_payment_transactions.hold_flag%TYPE,
17: hold_flag_desc cn_lookups.meaning%TYPE,
18: waive_flag cn_payment_transactions.waive_flag%TYPE,

Line 16: hold_flag cn_payment_transactions.hold_flag%TYPE,

12: quota_id cn_payment_transactions.quota_id%TYPE,
13: quota_name cn_quotas.NAME%TYPE,
14: incentive_type_code cn_payment_transactions.incentive_type_code%TYPE,
15: incentive_type cn_lookups.meaning%TYPE,
16: hold_flag cn_payment_transactions.hold_flag%TYPE,
17: hold_flag_desc cn_lookups.meaning%TYPE,
18: waive_flag cn_payment_transactions.waive_flag%TYPE,
19: waive_flag_desc cn_lookups.meaning%TYPE,
20: pay_element_type_id cn_payment_transactions.pay_element_type_id%TYPE,

Line 18: waive_flag cn_payment_transactions.waive_flag%TYPE,

14: incentive_type_code cn_payment_transactions.incentive_type_code%TYPE,
15: incentive_type cn_lookups.meaning%TYPE,
16: hold_flag cn_payment_transactions.hold_flag%TYPE,
17: hold_flag_desc cn_lookups.meaning%TYPE,
18: waive_flag cn_payment_transactions.waive_flag%TYPE,
19: waive_flag_desc cn_lookups.meaning%TYPE,
20: pay_element_type_id cn_payment_transactions.pay_element_type_id%TYPE,
21: pay_element_name pay_element_types_f.element_name%TYPE,
22: recoverable_flag cn_payment_transactions.recoverable_flag%TYPE,

Line 20: pay_element_type_id cn_payment_transactions.pay_element_type_id%TYPE,

16: hold_flag cn_payment_transactions.hold_flag%TYPE,
17: hold_flag_desc cn_lookups.meaning%TYPE,
18: waive_flag cn_payment_transactions.waive_flag%TYPE,
19: waive_flag_desc cn_lookups.meaning%TYPE,
20: pay_element_type_id cn_payment_transactions.pay_element_type_id%TYPE,
21: pay_element_name pay_element_types_f.element_name%TYPE,
22: recoverable_flag cn_payment_transactions.recoverable_flag%TYPE,
23: recoverable_flag_desc cn_lookups.meaning%TYPE
24: );

Line 22: recoverable_flag cn_payment_transactions.recoverable_flag%TYPE,

18: waive_flag cn_payment_transactions.waive_flag%TYPE,
19: waive_flag_desc cn_lookups.meaning%TYPE,
20: pay_element_type_id cn_payment_transactions.pay_element_type_id%TYPE,
21: pay_element_name pay_element_types_f.element_name%TYPE,
22: recoverable_flag cn_payment_transactions.recoverable_flag%TYPE,
23: recoverable_flag_desc cn_lookups.meaning%TYPE
24: );
25:
26: TYPE pmt_tran_tbl IS TABLE OF pmt_tran_rec

Line 31: payrun_id cn_payment_transactions.payrun_id%TYPE,

27: INDEX BY BINARY_INTEGER;
28:
29: TYPE pmt_process_rec IS RECORD (
30: p_action VARCHAR2(250),
31: payrun_id cn_payment_transactions.payrun_id%TYPE,
32: salesrep_id cn_payment_transactions.credited_salesrep_id%TYPE,
33: worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE,
34: quota_id cn_quotas.quota_id%TYPE,
35: revenue_class_id cn_revenue_classes.revenue_class_id%TYPE,

Line 32: salesrep_id cn_payment_transactions.credited_salesrep_id%TYPE,

28:
29: TYPE pmt_process_rec IS RECORD (
30: p_action VARCHAR2(250),
31: payrun_id cn_payment_transactions.payrun_id%TYPE,
32: salesrep_id cn_payment_transactions.credited_salesrep_id%TYPE,
33: worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE,
34: quota_id cn_quotas.quota_id%TYPE,
35: revenue_class_id cn_revenue_classes.revenue_class_id%TYPE,
36: invoice_number VARCHAR2(4000),

Line 39: hold_flag cn_payment_transactions.hold_flag%TYPE,

35: revenue_class_id cn_revenue_classes.revenue_class_id%TYPE,
36: invoice_number VARCHAR2(4000),
37: order_number NUMBER,
38: customer VARCHAR2(4000),
39: hold_flag cn_payment_transactions.hold_flag%TYPE,
40: request_id NUMBER,
41: org_id NUMBER,
42: object_version_number NUMBER,
43: is_processing VARCHAR2(30) := 'NO'

Line 88: p_payment_transaction_id IN cn_payment_transactions.payment_transaction_id%TYPE,

84: p_validation_level IN NUMBER,
85: x_return_status OUT NOCOPY VARCHAR2,
86: x_msg_count OUT NOCOPY NUMBER,
87: x_msg_data OUT NOCOPY VARCHAR2,
88: p_payment_transaction_id IN cn_payment_transactions.payment_transaction_id%TYPE,
89: p_hold_flag IN cn_payment_transactions.hold_flag%TYPE,
90: p_recoverable_flag IN cn_payment_transactions.recoverable_flag%TYPE,
91: p_payment_amount IN cn_payment_transactions.payment_amount%TYPE,
92: p_waive_flag IN cn_payment_transactions.waive_flag%TYPE,

Line 89: p_hold_flag IN cn_payment_transactions.hold_flag%TYPE,

85: x_return_status OUT NOCOPY VARCHAR2,
86: x_msg_count OUT NOCOPY NUMBER,
87: x_msg_data OUT NOCOPY VARCHAR2,
88: p_payment_transaction_id IN cn_payment_transactions.payment_transaction_id%TYPE,
89: p_hold_flag IN cn_payment_transactions.hold_flag%TYPE,
90: p_recoverable_flag IN cn_payment_transactions.recoverable_flag%TYPE,
91: p_payment_amount IN cn_payment_transactions.payment_amount%TYPE,
92: p_waive_flag IN cn_payment_transactions.waive_flag%TYPE,
93: p_incentive_type_code IN cn_payment_transactions.incentive_type_code%TYPE,

Line 90: p_recoverable_flag IN cn_payment_transactions.recoverable_flag%TYPE,

86: x_msg_count OUT NOCOPY NUMBER,
87: x_msg_data OUT NOCOPY VARCHAR2,
88: p_payment_transaction_id IN cn_payment_transactions.payment_transaction_id%TYPE,
89: p_hold_flag IN cn_payment_transactions.hold_flag%TYPE,
90: p_recoverable_flag IN cn_payment_transactions.recoverable_flag%TYPE,
91: p_payment_amount IN cn_payment_transactions.payment_amount%TYPE,
92: p_waive_flag IN cn_payment_transactions.waive_flag%TYPE,
93: p_incentive_type_code IN cn_payment_transactions.incentive_type_code%TYPE,
94: p_payrun_id IN cn_payment_transactions.payrun_id%TYPE,

Line 91: p_payment_amount IN cn_payment_transactions.payment_amount%TYPE,

87: x_msg_data OUT NOCOPY VARCHAR2,
88: p_payment_transaction_id IN cn_payment_transactions.payment_transaction_id%TYPE,
89: p_hold_flag IN cn_payment_transactions.hold_flag%TYPE,
90: p_recoverable_flag IN cn_payment_transactions.recoverable_flag%TYPE,
91: p_payment_amount IN cn_payment_transactions.payment_amount%TYPE,
92: p_waive_flag IN cn_payment_transactions.waive_flag%TYPE,
93: p_incentive_type_code IN cn_payment_transactions.incentive_type_code%TYPE,
94: p_payrun_id IN cn_payment_transactions.payrun_id%TYPE,
95: p_salesrep_id IN cn_payment_transactions.credited_salesrep_id%TYPE,

Line 92: p_waive_flag IN cn_payment_transactions.waive_flag%TYPE,

88: p_payment_transaction_id IN cn_payment_transactions.payment_transaction_id%TYPE,
89: p_hold_flag IN cn_payment_transactions.hold_flag%TYPE,
90: p_recoverable_flag IN cn_payment_transactions.recoverable_flag%TYPE,
91: p_payment_amount IN cn_payment_transactions.payment_amount%TYPE,
92: p_waive_flag IN cn_payment_transactions.waive_flag%TYPE,
93: p_incentive_type_code IN cn_payment_transactions.incentive_type_code%TYPE,
94: p_payrun_id IN cn_payment_transactions.payrun_id%TYPE,
95: p_salesrep_id IN cn_payment_transactions.credited_salesrep_id%TYPE,
96: x_status OUT NOCOPY VARCHAR2,

Line 93: p_incentive_type_code IN cn_payment_transactions.incentive_type_code%TYPE,

89: p_hold_flag IN cn_payment_transactions.hold_flag%TYPE,
90: p_recoverable_flag IN cn_payment_transactions.recoverable_flag%TYPE,
91: p_payment_amount IN cn_payment_transactions.payment_amount%TYPE,
92: p_waive_flag IN cn_payment_transactions.waive_flag%TYPE,
93: p_incentive_type_code IN cn_payment_transactions.incentive_type_code%TYPE,
94: p_payrun_id IN cn_payment_transactions.payrun_id%TYPE,
95: p_salesrep_id IN cn_payment_transactions.credited_salesrep_id%TYPE,
96: x_status OUT NOCOPY VARCHAR2,
97: x_loading_status OUT NOCOPY VARCHAR2,

Line 94: p_payrun_id IN cn_payment_transactions.payrun_id%TYPE,

90: p_recoverable_flag IN cn_payment_transactions.recoverable_flag%TYPE,
91: p_payment_amount IN cn_payment_transactions.payment_amount%TYPE,
92: p_waive_flag IN cn_payment_transactions.waive_flag%TYPE,
93: p_incentive_type_code IN cn_payment_transactions.incentive_type_code%TYPE,
94: p_payrun_id IN cn_payment_transactions.payrun_id%TYPE,
95: p_salesrep_id IN cn_payment_transactions.credited_salesrep_id%TYPE,
96: x_status OUT NOCOPY VARCHAR2,
97: x_loading_status OUT NOCOPY VARCHAR2,
98: --R12

Line 95: p_salesrep_id IN cn_payment_transactions.credited_salesrep_id%TYPE,

91: p_payment_amount IN cn_payment_transactions.payment_amount%TYPE,
92: p_waive_flag IN cn_payment_transactions.waive_flag%TYPE,
93: p_incentive_type_code IN cn_payment_transactions.incentive_type_code%TYPE,
94: p_payrun_id IN cn_payment_transactions.payrun_id%TYPE,
95: p_salesrep_id IN cn_payment_transactions.credited_salesrep_id%TYPE,
96: x_status OUT NOCOPY VARCHAR2,
97: x_loading_status OUT NOCOPY VARCHAR2,
98: --R12
99: p_org_id IN cn_payment_transactions.org_id%TYPE,

Line 99: p_org_id IN cn_payment_transactions.org_id%TYPE,

95: p_salesrep_id IN cn_payment_transactions.credited_salesrep_id%TYPE,
96: x_status OUT NOCOPY VARCHAR2,
97: x_loading_status OUT NOCOPY VARCHAR2,
98: --R12
99: p_org_id IN cn_payment_transactions.org_id%TYPE,
100: p_object_version_number IN OUT NOCOPY cn_payment_transactions.object_version_number%TYPE
101: );
102:
103: --============================================================================

Line 100: p_object_version_number IN OUT NOCOPY cn_payment_transactions.object_version_number%TYPE

96: x_status OUT NOCOPY VARCHAR2,
97: x_loading_status OUT NOCOPY VARCHAR2,
98: --R12
99: p_org_id IN cn_payment_transactions.org_id%TYPE,
100: p_object_version_number IN OUT NOCOPY cn_payment_transactions.object_version_number%TYPE
101: );
102:
103: --============================================================================
104: -- Start of Comments

Line 109: -- Usage : To create new records in cn_payment_transactions

105: --
106: -- API name : Create_Pmt_Transactons
107: -- Type : Private.
108: -- Pre-reqs : None.
109: -- Usage : To create new records in cn_payment_transactions
110: -- Parameters :
111: -- IN : p_api_version IN NUMBER Require
112: -- p_init_msg_list IN VARCHAR2 Optional
113: -- Default = FND_API.G_FALSE

Line 144: p_org_id IN cn_payment_transactions.org_id%TYPE,

140: p_incentive_type_code IN VARCHAR2,
141: p_recoverable_flag IN VARCHAR2,
142: p_payment_amount IN NUMBER,
143: p_quota_id IN NUMBER,
144: p_org_id IN cn_payment_transactions.org_id%TYPE,
145: p_object_version_number IN cn_payment_transactions.object_version_number%TYPE,
146: x_pmt_transaction_id OUT NOCOPY NUMBER,
147: x_status OUT NOCOPY VARCHAR2,
148: x_loading_status OUT NOCOPY VARCHAR2,

Line 145: p_object_version_number IN cn_payment_transactions.object_version_number%TYPE,

141: p_recoverable_flag IN VARCHAR2,
142: p_payment_amount IN NUMBER,
143: p_quota_id IN NUMBER,
144: p_org_id IN cn_payment_transactions.org_id%TYPE,
145: p_object_version_number IN cn_payment_transactions.object_version_number%TYPE,
146: x_pmt_transaction_id OUT NOCOPY NUMBER,
147: x_status OUT NOCOPY VARCHAR2,
148: x_loading_status OUT NOCOPY VARCHAR2,
149: x_return_status OUT NOCOPY VARCHAR2,

Line 159: -- Usage : To delete the cn_payment_transactions only manual pmt

155: --
156: -- API name : Delete_Pmt_Transactons
157: -- Type : Private.
158: -- Pre-reqs : None.
159: -- Usage : To delete the cn_payment_transactions only manual pmt
160: -- Parameters :
161: -- IN : p_api_version IN NUMBER Require
162: -- p_init_msg_list IN VARCHAR2 Optional
163: -- Default = FND_API.G_FALSE