APPS.CN_COMM_LINES_API_PKG dependencies on CN_COMMISSION_HEADERS

Line 2020: FROM cn_commission_headers a,

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

Line 2047: l_trx_type cn_commission_headers.trx_type%TYPE;

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

Line 2049: l_transaction_amount_orig cn_commission_headers.transaction_amount_orig%TYPE;

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

Line 2072: FROM cn_commission_headers

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

Line 2086: UPDATE cn_commission_headers

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