[Home] [Help]
PACKAGE: APPS.CN_PMT_TRANS_PKG
Source
1 PACKAGE cn_pmt_trans_pkg AUTHID CURRENT_USER 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,
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,
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,
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,
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,
41 attribute4 cn_payment_transactions.attribute4%TYPE := fnd_api.g_miss_char,
42 attribute5 cn_payment_transactions.attribute5%TYPE := fnd_api.g_miss_char,
43 attribute6 cn_payment_transactions.attribute6%TYPE := fnd_api.g_miss_char,
44 attribute7 cn_payment_transactions.attribute7%TYPE := fnd_api.g_miss_char,
45 attribute8 cn_payment_transactions.attribute8%TYPE := fnd_api.g_miss_char,
46 attribute9 cn_payment_transactions.attribute9%TYPE := fnd_api.g_miss_char,
47 attribute10 cn_payment_transactions.attribute10%TYPE := fnd_api.g_miss_char,
48 attribute11 cn_payment_transactions.attribute11%TYPE := fnd_api.g_miss_char,
49 attribute12 cn_payment_transactions.attribute12%TYPE := fnd_api.g_miss_char,
50 attribute13 cn_payment_transactions.attribute13%TYPE := fnd_api.g_miss_char,
51 attribute14 cn_payment_transactions.attribute14%TYPE := fnd_api.g_miss_char,
52 attribute15 cn_payment_transactions.attribute15%TYPE,
53 --R12
54 org_id cn_payment_transactions.org_id%TYPE,
55 object_version_number cn_payment_transactions.object_version_number%TYPE
56 );
57
58 TYPE pmt_trans_rec_tbl_type IS TABLE OF pmt_trans_rec_type
59 INDEX BY BINARY_INTEGER;
60
61 --============================================================================
62 -- Procedure Name: Insert Record
63 -- Description: Insert Record ( Only One record )
64 --============================================================================
65 PROCEDURE INSERT_RECORD (
66 p_tran_rec IN pmt_trans_rec_type
67 );
68
69 --============================================================================
70 -- Procedure Name : Delete_Record
71 -- Purpose : Delete the Payment Transactions
72 --============================================================================
73 PROCEDURE DELETE_RECORD (
74 p_payment_transaction_id NUMBER
75 );
76
77 --============================================================================
78 -- Procedure Name: Insert Record ( Batch Insert )
79 -- Description: Insert Record API called from Create Worksheet
80 -- Called From: cnvwkshb.pls
81 --============================================================================
82 PROCEDURE INSERT_RECORD (
83 p_pay_by_transaction IN VARCHAR2,
84 p_salesrep_id IN NUMBER,
85 p_payrun_id IN NUMBER,
86 p_pay_date IN DATE,
87 p_incentive_type IN VARCHAR2,
88 p_pay_period_id IN NUMBER,
89 p_credit_type_id IN NUMBER,
90 p_posting_batch_id IN NUMBER,
91 --R12
92 p_org_id IN NUMBER
93 );
94
95 --============================================================================
96 -- Function : get_pmt_tran_id
97 -- Description : Main update procedure to update payment
98 -- transactions
99 -- Called From : cnvpmtrb.pls ( Create_Pmt_Transactions )
100 -- Bug 3866089 (the same as 11.5.8 bug 3841926, 11.5.10 3866116) by jjhuang on 11/1/04
101 --============================================================================
102 FUNCTION get_pmt_tran_id
103 RETURN NUMBER;
104 END cn_pmt_trans_pkg;