DBA Data[Home] [Help]

APPS.CN_FORMULA_COMMON_PKG dependencies on CN_PMT_TRANS_PKG

Line 86: l_pmt_trans_rec CN_PMT_TRANS_PKG.pmt_trans_rec_type;

82: g_refresh_flag VARCHAR2(1);
83:
84: PROCEDURE revert_posting_line (p_commission_line_id NUMBER)
85: IS
86: l_pmt_trans_rec CN_PMT_TRANS_PKG.pmt_trans_rec_type;
87:
88: CURSOR get_comm_line_rec IS
89: (SELECT CN_API.G_MISS_ID payment_transaction_id,
90: -1 posting_batch_id,

Line 222: CN_PMT_TRANS_PKG.Insert_Record(l_pmt_trans_rec);

218: l_pmt_trans_rec.amount := l_pmt_trans_rec.amount * -1;
219: l_pmt_trans_rec.payment_amount := 0 - l_pmt_trans_rec.payment_amount;
220:
221: -- insert record into CN_PAYMENT_TRANSACTIONS
222: CN_PMT_TRANS_PKG.Insert_Record(l_pmt_trans_rec);
223:
224: -- make sure it is not reverted twice
225: update cn_commission_lines
226: set posting_status = 'REVERTED',