eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_ADJUSTMENTS_PKG dependencies on CN_COMM_LINES_API

Line 96: l_load_status cn_comm_lines_api.load_status%TYPE;

92: l_status VARCHAR2(10);
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;

Line 100: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;

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;
103: l_terr_name VARCHAR2(2000);
104: l_presrv_credit_override_flag VARCHAR2(1);

Line 108: FROM cn_comm_lines_api

104: l_presrv_credit_override_flag VARCHAR2(1);
105: --
106: CURSOR api_cur IS
107: SELECT *
108: FROM cn_comm_lines_api
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

Line 121: FROM cn_comm_lines_api

117:
118: -- Added for bug 7524578
119: CURSOR api_cur_terr IS
120: SELECT terr_id,terr_name,preserve_credit_override_flag
121: FROM cn_comm_lines_api
122: WHERE comm_lines_api_id = x_comm_lines_api_id;
123:
124: BEGIN
125: -- First check whether the record is available in cn_comm_lines_api table.

Line 125: -- First check whether the record is available in cn_comm_lines_api table.

121: FROM cn_comm_lines_api
122: WHERE comm_lines_api_id = x_comm_lines_api_id;
123:
124: BEGIN
125: -- First check whether the record is available in cn_comm_lines_api table.
126: BEGIN
127: SELECT adjust_status,load_status,quantity,
128: acctd_transaction_amount,transaction_amount
129: INTO l_adjust_status,l_load_status,l_quantity,

Line 131: FROM cn_comm_lines_api

127: SELECT adjust_status,load_status,quantity,
128: acctd_transaction_amount,transaction_amount
129: INTO l_adjust_status,l_load_status,l_quantity,
130: l_acctd_transaction_amount,l_transaction_amount
131: FROM cn_comm_lines_api
132: WHERE comm_lines_api_id = x_comm_lines_api_id
133: AND load_status <> 'LOADED'
134: AND (adjust_status NOT IN ('FROZEN','REVERSAL') OR
135: adjust_status IS NULL);

Line 137: UPDATE cn_comm_lines_api api

133: AND load_status <> 'LOADED'
134: AND (adjust_status NOT IN ('FROZEN','REVERSAL') OR
135: adjust_status IS NULL);
136: --
137: UPDATE cn_comm_lines_api api
138: SET load_status = 'OBSOLETE',
139: adjust_status = 'FROZEN',
140: adjust_date = l_adjust_date,
141: adjusted_by = x_adjusted_by,

Line 194: SELECT cn_comm_lines_api_s.NEXTVAL

190: WHERE comm_lines_api_id = x_comm_lines_api_id;
191: FOR api_curs_rec IN header_cur(l_reversal_header_id)
192: LOOP
193: --
194: SELECT cn_comm_lines_api_s.NEXTVAL
195: INTO l_comm_lines_api_id
196: FROM dual;
197: --
198: l_api_rec.salesrep_id := api_curs_rec.direct_salesrep_id;

Line 376: cn_comm_lines_api_pkg.insert_row(l_api_rec);

372: l_api_rec.terr_id := l_territory_id;
373: l_api_rec.terr_name := l_terr_name;
374: l_api_rec.preserve_credit_override_flag := l_presrv_credit_override_flag;
375: --
376: cn_comm_lines_api_pkg.insert_row(l_api_rec);
377: --
378: END LOOP;
379: EXCEPTION
380: WHEN OTHERS THEN

Line 389: FROM CN_COMM_LINES_API

385: /* Added for Crediting Bug */
386: BEGIN
387: SELECT COMM_LINES_API_ID, TERR_ID, ORG_ID
388: INTO l_comm_lines_api_id, l_terr_id, l_org_id
389: FROM CN_COMM_LINES_API
390: WHERE COMM_LINES_API_ID = x_comm_lines_api_id;
391:
392: update_credit_credentials(
393: l_comm_lines_api_id,

Line 425: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;

421: l_adjust_date DATE := SYSDATE;
422: l_comm_lines_api_id NUMBER;
423: l_counter NUMBER := 0;
424: -- PL/SQL tables/columns
425: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;
426: l_existing_data cn_invoice_changes_pvt.invoice_tbl;
427: l_new_data cn_invoice_changes_pvt.invoice_tbl;
428: --
429: BEGIN

Line 446: SELECT cn_comm_lines_api_s.NEXTVAL

442: ELSE
443: l_adjust_status := 'MASSASGN';
444: END IF;
445: --
446: SELECT cn_comm_lines_api_s.NEXTVAL
447: INTO l_comm_lines_api_id
448: FROM DUAL;
449: --
450:

Line 993: cn_comm_lines_api_pkg.insert_row(l_api_rec);

989: l_api_rec.preserve_credit_override_flag := 'Y';
990: END IF;
991:
992: l_api_rec.adj_comm_lines_api_id := x_adj_data(i).comm_lines_api_id;
993: cn_comm_lines_api_pkg.insert_row(l_api_rec);
994:
995: --
996: IF ((g_track_invoice = 'Y') AND (l_api_rec.trx_type = 'INV')) THEN
997: l_counter := l_counter + 1;

Line 1094: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;

1090: l_adj_tbl cn_get_tx_data_pub.adj_tbl_type;
1091: -- PL/SQL tables/records
1092: l_newtx_rec cn_get_tx_data_pub.adj_rec_type;
1093: o_newtx_rec cn_get_tx_data_pub.adj_rec_type;
1094: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;
1095: -- To mask this non-standard API
1096: x_return_status VARCHAR2(1000);
1097: BEGIN
1098: deal_select_cursor := DBMS_SQL.open_cursor;

Line 1144: SELECT cn_comm_lines_api_s.NEXTVAL

1140: INTO l_salesrep_number
1141: FROM cn_salesreps
1142: WHERE salesrep_id = x_salesrep_id;
1143: --
1144: SELECT cn_comm_lines_api_s.NEXTVAL
1145: INTO l_ins_comm_lines_api_id
1146: FROM dual;
1147: --
1148: l_newtx_rec.direct_salesrep_id := x_salesrep_id;

Line 1171: cn_comm_lines_api_pkg.insert_row(l_api_rec);

1167: cn_invoice_changes_pvt.convert_adj_to_api(
1168: p_adj_rec => o_newtx_rec,
1169: x_api_rec => l_api_rec);
1170: --
1171: cn_comm_lines_api_pkg.insert_row(l_api_rec);
1172: --
1173: END IF;
1174: ELSE
1175: EXIT;

Line 1191: FROM cn_comm_lines_api l

1187: x_adjust_comments VARCHAR2) IS
1188: --
1189: CURSOR api_cur(l_comm_lines_api_id NUMBER) IS
1190: SELECT l.comm_lines_api_id,l.adjust_status
1191: FROM cn_comm_lines_api l
1192: WHERE adj_comm_lines_api_id = l_comm_lines_api_id;
1193: --
1194: CURSOR header_cur(l_comm_lines_api_id NUMBER) IS
1195: SELECT h.comm_lines_api_id,h.adjust_status

Line 1213: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;

1209: -- PL/SQL tables/records
1210: l_adj_tbl cn_get_tx_data_pub.adj_tbl_type;
1211: l_newtx_rec cn_get_tx_data_pub.adj_rec_type;
1212: o_newtx_rec cn_get_tx_data_pub.adj_rec_type;
1213: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;
1214: -- To mask this non-standard API
1215: x_return_status VARCHAR2(1000);
1216: --
1217: BEGIN

Line 1295: SELECT cn_comm_lines_api_s.NEXTVAL

1291: INTO l_salesrep_number
1292: FROM cn_salesreps
1293: WHERE salesrep_id = x_to_salesrep_id;
1294: --
1295: SELECT cn_comm_lines_api_s.NEXTVAL
1296: INTO l_ins_comm_lines_api_id
1297: FROM dual;
1298: --
1299: l_newtx_rec.direct_salesrep_id := x_to_salesrep_id;

Line 1322: cn_comm_lines_api_pkg.insert_row(l_api_rec);

1318: cn_invoice_changes_pvt.convert_adj_to_api(
1319: p_adj_rec => o_newtx_rec,
1320: x_api_rec => l_api_rec);
1321: --
1322: cn_comm_lines_api_pkg.insert_row(l_api_rec);
1323: --
1324: END IF;
1325: ELSE
1326: exit;

Line 1468: FROM cn_comm_lines_api ccla,

1464: x_cust_info_rec.bill_to_contact,
1465: x_cust_info_rec.ship_to_contact_id,
1466: x_cust_info_rec.ship_to_contact
1467:
1468: FROM cn_comm_lines_api ccla,
1469: (SELECT CUST_ACCT.CUST_ACCOUNT_ID CUSTOMER_ID, substrb(PARTY.PARTY_NAME,1,50) CUSTOMER_NAME,
1470: CUST_ACCT.ACCOUNT_NUMBER CUSTOMER_NUMBER
1471: FROM HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT
1472: WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID) rac,

Line 1546: FROM CN_COMM_LINES_API

1542: IS
1543: /* Added to fix Crediting bug */
1544: CURSOR l_csr_credited_trx(l_nbr_comm_lines_api_id NUMBER, l_nbr_org_id NUMBER) IS
1545: SELECT COMM_LINES_API_ID, ORG_ID
1546: FROM CN_COMM_LINES_API
1547: WHERE ORG_ID = l_nbr_org_id
1548: AND TERR_ID IS NOT NULL
1549: AND (adjust_status NOT IN ('FROZEN','REVERSAL','SCA PENDING') OR
1550: adjust_status IS NULL)

Line 1556: SELECT COMM_LINES_API_ID, ORG_ID FROM CN_COMM_LINES_API

1552: CONNECT BY PRIOR COMM_LINES_API_ID = ADJ_COMM_LINES_API_ID;
1553:
1554:
1555: CURSOR l_csr_parent_trx(l_nbr_comm_lines_api_id NUMBER, l_nbr_org_id NUMBER) IS
1556: SELECT COMM_LINES_API_ID, ORG_ID FROM CN_COMM_LINES_API
1557: WHERE ORG_ID = l_nbr_org_id
1558: AND TERR_ID IS NULL
1559: AND (adjust_status NOT IN ('FROZEN','REVERSAL','SCA PENDING') OR
1560: adjust_status IS NULL)

Line 1582: UPDATE CN_COMM_LINES_API

1578: ELSE IF p_terr_id IS NOT NULL
1579: THEN
1580: FOR parent_trx IN l_csr_parent_trx(p_comm_lines_api_id, p_org_id)
1581: LOOP
1582: UPDATE CN_COMM_LINES_API
1583: SET PRESERVE_CREDIT_OVERRIDE_FLAG = 'Y',
1584: ADJUSTED_BY = p_adjusted_by
1585: WHERE COMM_LINES_API_ID = parent_trx.comm_lines_api_id
1586: AND ORG_ID = parent_trx.org_id;