APPS.CN_COMM_LINES_API_PKG dependencies on CN_COMMISSION_HEADERS

Line 2021: FROM cn_commission_headers a,

2017:
2018: CURSOR header_cur (l_commission_header_id NUMBER) IS
2019: SELECT a.*,
2020: b.salesrep_number employee_number
2021: FROM cn_commission_headers a,
2022: cn_rs_salesreps b
2023: WHERE a.direct_salesrep_id = b.salesrep_id AND
2024: a.commission_header_id = l_commission_header_id
2025: AND a.org_id = x_org_id

Line 2048: l_trx_type cn_commission_headers.trx_type%TYPE;

2044: l_comm_lines_api_id NUMBER;
2045: l_reversal_header_id NUMBER;
2046: l_adjust_status VARCHAR2(20);
2047: l_quantity NUMBER;
2048: l_trx_type cn_commission_headers.trx_type%TYPE;
2049: l_transaction_amount NUMBER;
2050: l_transaction_amount_orig cn_commission_headers.transaction_amount_orig%TYPE;
2051: l_src_transaction_amount NUMBER;
2052: l_acctd_transaction_amount NUMBER;

Line 2050: l_transaction_amount_orig cn_commission_headers.transaction_amount_orig%TYPE;

2046: l_adjust_status VARCHAR2(20);
2047: l_quantity NUMBER;
2048: l_trx_type cn_commission_headers.trx_type%TYPE;
2049: l_transaction_amount NUMBER;
2050: l_transaction_amount_orig cn_commission_headers.transaction_amount_orig%TYPE;
2051: l_src_transaction_amount NUMBER;
2052: l_acctd_transaction_amount NUMBER;
2053: l_negate_flag VARCHAR2(1);
2054: l_reversal_flag VARCHAR2(1);

Line 2073: FROM cn_commission_headers

2069: SELECT commission_header_id,adjust_status,quantity,trx_type,
2070: transaction_amount,transaction_amount_orig
2071: INTO l_reversal_header_id,l_adjust_status,l_quantity,l_trx_type,
2072: l_transaction_amount,l_transaction_amount_orig
2073: FROM cn_commission_headers
2074: WHERE comm_lines_api_id = api_line_rec.comm_lines_api_id
2075: AND org_id = x_org_id
2076: AND (adjust_status NOT IN ('FROZEN','REVERSAL') OR
2077: adjust_status IS NULL)

Line 2087: UPDATE cn_commission_headers

2083: l_negate_flag := 'Y';
2084: l_adjust_status := 'REVERSAL';
2085: l_reversal_flag := 'Y';
2086: --
2087: UPDATE cn_commission_headers
2088: SET adjust_status = 'FROZEN',
2089: reversal_header_id = l_reversal_header_id,
2090: reversal_flag = l_reversal_flag,
2091: adjust_date = l_adjust_date,