APPS.CN_ADJUSTMENTS_PKG dependencies on CN_COMMISSION_HEADERS

Line 97: l_trx_type cn_commission_headers.trx_type%TYPE;

93: l_reversal_header_id NUMBER;
94: l_reversal_flag VARCHAR2(1);
95: l_next_step CHAR(1) := 'Y';
96: l_load_status cn_comm_lines_api.load_status%TYPE;
97: l_trx_type cn_commission_headers.trx_type%TYPE;
98: l_transaction_amount_orig cn_commission_headers.transaction_amount_orig%TYPE;
99: -- PL/SQL tables/columns
100: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;
101: -- Added for bug 7524578

Line 98: l_transaction_amount_orig cn_commission_headers.transaction_amount_orig%TYPE;

94: l_reversal_flag VARCHAR2(1);
95: l_next_step CHAR(1) := 'Y';
96: l_load_status cn_comm_lines_api.load_status%TYPE;
97: l_trx_type cn_commission_headers.trx_type%TYPE;
98: l_transaction_amount_orig cn_commission_headers.transaction_amount_orig%TYPE;
99: -- PL/SQL tables/columns
100: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;
101: -- Added for bug 7524578
102: l_territory_id NUMBER;

Line 113: FROM cn_commission_headers a,

109: WHERE comm_lines_api_id = x_comm_lines_api_id;
110: --
111: CURSOR header_cur(l_commission_header_id NUMBER) IS
112: SELECT a.*,b.employee_number
113: FROM cn_commission_headers a,
114: cn_salesreps b
115: WHERE a.direct_salesrep_id = b.salesrep_id
116: AND commission_header_id = l_commission_header_id;
117:

Line 145: l_next_step := 'N'; -- It need not check in cn_commission_headers table.

141: adjusted_by = x_adjusted_by,
142: adjust_comments = x_adjust_comments
143: WHERE comm_lines_api_id = x_comm_lines_api_id;
144: --
145: l_next_step := 'N'; -- It need not check in cn_commission_headers table.
146: EXCEPTION
147: WHEN OTHERS THEN
148: NULL;
149: END;

Line 166: FROM cn_commission_headers

162: SELECT commission_header_id,adjust_status,quantity,trx_type,
163: transaction_amount,transaction_amount_orig
164: INTO l_reversal_header_id,l_adjust_status,l_quantity,l_trx_type,
165: l_transaction_amount,l_transaction_amount_orig
166: FROM cn_commission_headers
167: WHERE comm_lines_api_id = x_comm_lines_api_id
168: AND (adjust_status NOT IN ('FROZEN','REVERSAL')) -- OR
169: -- adjust_status IS NULL)
170: AND trx_type NOT IN ('ITD','GRP','THR');

Line 179: UPDATE cn_commission_headers

175: l_negate_flag := 'Y';
176: l_adjust_status := 'REVERSAL';
177: l_reversal_flag := 'Y';
178: --
179: UPDATE cn_commission_headers
180: SET adjust_status = 'FROZEN',
181: reversal_header_id = l_reversal_header_id,
182: reversal_flag = l_reversal_flag,
183: adjust_date = l_adjust_date,

Line 1198: FROM cn_commission_headers h

1194: WHERE adj_comm_lines_api_id = l_comm_lines_api_id;
1195: --
1196: CURSOR header_cur(l_comm_lines_api_id NUMBER) IS
1197: SELECT h.comm_lines_api_id,NVL(h.adjust_status,'NEW') adjust_status
1198: FROM cn_commission_headers h
1199: WHERE adj_comm_lines_api_id = l_comm_lines_api_id;
1200: --
1201: assign_select_cursor NUMBER(15);
1202: sql_stmt VARCHAR2(5000);

Line 1375: FROM cn_commission_headers cch,

1371: x_cust_info_rec.bill_to_contact,
1372: x_cust_info_rec.ship_to_contact_id,
1373: x_cust_info_rec.ship_to_contact
1374:
1375: FROM cn_commission_headers cch,
1376: (SELECT CUST_ACCT.CUST_ACCOUNT_ID CUSTOMER_ID, substrb(PARTY.PARTY_NAME,1,50) CUSTOMER_NAME,
1377: CUST_ACCT.ACCOUNT_NUMBER CUSTOMER_NUMBER
1378: FROM HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT
1379: WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID) rac,