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,NVL(preserve_credit_override_flag,'N') 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 := NVL(l_presrv_credit_override_flag,'N');
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 447: SELECT cn_comm_lines_api_s.NEXTVAL

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

Line 994: cn_comm_lines_api_pkg.insert_row(l_api_rec);

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

Line 1096: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;

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

Line 1146: SELECT cn_comm_lines_api_s.NEXTVAL

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

Line 1173: cn_comm_lines_api_pkg.insert_row(l_api_rec);

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

Line 1193: FROM cn_comm_lines_api l

1189: x_adjust_comments VARCHAR2) IS
1190: --
1191: CURSOR api_cur(l_comm_lines_api_id NUMBER) IS
1192: SELECT l.comm_lines_api_id,NVL(l.adjust_status,'NEW') adjust_status
1193: FROM cn_comm_lines_api l
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

Line 1215: l_api_rec cn_comm_lines_api_pkg.comm_lines_api_rec_type;

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

Line 1297: SELECT cn_comm_lines_api_s.NEXTVAL

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

Line 1324: cn_comm_lines_api_pkg.insert_row(l_api_rec);

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

Line 1470: FROM cn_comm_lines_api ccla,

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

Line 1548: FROM CN_COMM_LINES_API

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

Line 1558: SELECT COMM_LINES_API_ID, ORG_ID FROM CN_COMM_LINES_API

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

Line 1584: UPDATE CN_COMM_LINES_API

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