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.

[Home] [Help]

APPS.JAI_CMN_RCV_MATCHING_PKG dependencies on JAI_CMN_MATCH_TAXES

Line 62: Fix ; Insert statement into Jai_cmn_match_Taxes did not included the PK

58: Forward porting the changes done in 11i bug#5907436
59:
60: 7. 26/09/2007 rchandan for bug#6447097. File version 120.10
61: Issue : QA observations of Inter org
62: Fix ; Insert statement into Jai_cmn_match_Taxes did not included the PK
63: match_tax_id.
64:
65: --------------------------------------------------------------------------------------------------------------------*/
66: -- fields in the view

Line 490: FROM JAI_CMN_MATCH_TAXES

486:
487:
488: CURSOR Chk_Rcd_Cur IS
489: SELECT NVL( COUNT( * ), 0 )
490: FROM JAI_CMN_MATCH_TAXES
491: WHERE Ref_Line_Id = p_ref_line_id
492: AND Subinventory = p_subinventory
493: AND Receipt_Id = p_receipt_id
494: AND Order_Invoice = 'O';

Line 498: FROM JAI_CMN_MATCH_TAXES

494: AND Order_Invoice = 'O';
495:
496: CURSOR Chk_Rcd_AR_Cur IS
497: SELECT NVL( COUNT( * ), 0 )
498: FROM JAI_CMN_MATCH_TAXES
499: WHERE Ref_Line_Id = p_ref_line_id
500: AND Receipt_Id = p_receipt_id
501: AND Order_Invoice = 'I';
502:

Line 505: FROM JAI_CMN_MATCH_TAXES

501: AND Order_Invoice = 'I';
502:
503: CURSOR Fetch_Totals_Cur( line_no IN NUMBER ) IS
504: SELECT SUM( NVL( Tax_Amount, 0 ) )
505: FROM JAI_CMN_MATCH_TAXES
506: WHERE Subinventory = p_subinventory
507: AND Ref_Line_Id = p_ref_line_id
508: AND Tax_Line_No = line_no;
509:

Line 512: FROM JAI_CMN_MATCH_TAXES

508: AND Tax_Line_No = line_no;
509:
510: CURSOR Fetch_Totals_AR_Cur( line_no IN NUMBER ) IS
511: SELECT SUM( NVL( Tax_Amount, 0 ) )
512: FROM JAI_CMN_MATCH_TAXES
513: WHERE Ref_Line_Id = p_ref_line_id
514: AND Tax_Line_No = line_no;
515:
516: CURSOR Fetch_Total_AR_Cur( line_no IN NUMBER ) IS

Line 519: FROM JAI_CMN_MATCH_TAXES

515:
516: CURSOR Fetch_Total_AR_Cur( line_no IN NUMBER ) IS
517: SELECT SUM( NVL( Tax_Amount, 0 ) ) tax_amount, SUM( NVL( Base_Tax_Amount, 0 ) ) base_tax_amount,
518: SUM( NVL( Func_Tax_Amount, 0 ) ) func_tax_amount
519: FROM JAI_CMN_MATCH_TAXES
520: WHERE Ref_Line_Id = p_ref_line_id
521: AND Tax_Line_No = line_no
522: AND Receipt_ID IS NOT NULL;
523:

Line 591: INSERT INTO JAI_CMN_MATCH_TAXES(MATCH_TAX_ID, REF_LINE_ID,

587: CLOSE Fetch_Exempt_Cur;
588:
589: FOR rec in oe_tax_cur LOOP
590: IF v_count = 0 THEN
591: INSERT INTO JAI_CMN_MATCH_TAXES(MATCH_TAX_ID, REF_LINE_ID,
592: SUBINVENTORY,
593: TAX_LINE_NO,
594: PRECEDENCE_1,
595: PRECEDENCE_2,

Line 621: VALUES ( JAI_CMN_MATCH_TAXES_S.nextval, p_ref_line_id,

617: RECEIPT_ID,
618: ORDER_INVOICE )
619:
620:
621: VALUES ( JAI_CMN_MATCH_TAXES_S.nextval, p_ref_line_id,
622: p_subinventory,
623: z.lno,
624: rec.p_1,
625: rec.p_2,

Line 1050: DELETE JAI_CMN_MATCH_TAXES

1046: OPEN Fetch_Totals_Cur( i );
1047: FETCH Fetch_Totals_Cur INTO v_cum_amount;
1048: CLOSE Fetch_Totals_Cur;
1049: IF p_line_quantity = 0 THEN
1050: DELETE JAI_CMN_MATCH_TAXES
1051: WHERE Ref_Line_Id = p_ref_line_id
1052: AND nvl(Subinventory,'###') = nvl(p_subinventory,'###')
1053: AND receipt_id = p_receipt_id
1054: AND Tax_Line_No = i;

Line 1056: UPDATE JAI_CMN_MATCH_TAXES

1052: AND nvl(Subinventory,'###') = nvl(p_subinventory,'###')
1053: AND receipt_id = p_receipt_id
1054: AND Tax_Line_No = i;
1055: ELSE
1056: UPDATE JAI_CMN_MATCH_TAXES
1057: SET Tax_Amount = tax_amt_tab(i),
1058: Base_Tax_Amount = tax_target_tab(i),
1059: Func_Tax_Amount = tax_amt_tab(i) ,
1060: --* NVL( p_curr_conv_factor, 1 ),

Line 1138: FROM JAI_CMN_MATCH_TAXES

1134: WHERE Link_To_Cust_Trx_Line_Id = p_link_to_cust_trx_line_id;
1135:
1136: CURSOR Chk_Tax_Count_Cur IS
1137: SELECT NVL( MAX( Tax_Line_No ), 0 )
1138: FROM JAI_CMN_MATCH_TAXES
1139: WHERE Ref_Line_Id = p_ref_line_id;
1140:
1141: CURSOR Fetch_New_Taxes_Cur IS
1142: SELECT *

Line 1183: Commented insert into JAI_CMN_MATCH_TAXES

1179: Added a cursor Get_Receipt_taxes to fetch taxes from Receipts
1180: When Manual Invoice is matched against a Receipt
1181:
1182: 2. 10/01/2005 brathod for Bug#4111609 Version#115.1
1183: Commented insert into JAI_CMN_MATCH_TAXES
1184: since it is not required
1185: base bug# 4146708 creates objects
1186:
1187: --------------------------------------------------------------------------------------------*/

Line 1215: INSERT INTO JAI_CMN_MATCH_TAXES(MATCH_TAX_ID, REF_LINE_ID,

1211:
1212: /* bug# 4111609 insertion not required. So code commented */
1213:
1214: /*
1215: INSERT INTO JAI_CMN_MATCH_TAXES(MATCH_TAX_ID, REF_LINE_ID,
1216: SUBINVENTORY,
1217: TAX_LINE_NO,
1218: PRECEDENCE_1,
1219: PRECEDENCE_2,

Line 1243: VALUES ( JAI_CMN_MATCH_TAXES_S.nextval, p_ref_line_id,

1239: LAST_UPDATE_LOGIN,
1240: LAST_UPDATED_BY,
1241: RECEIPT_ID,
1242: ORDER_INVOICE )
1243: VALUES ( JAI_CMN_MATCH_TAXES_S.nextval, p_ref_line_id,
1244: NULL,
1245: rec1.tax_line_no,
1246: rec1.p_1,
1247: rec1.p_2,

Line 1293: DELETE JAI_CMN_MATCH_TAXES

1289: p_qty,
1290: p_curr_conv_factor,
1291: 'I' );
1292: ELSE
1293: DELETE JAI_CMN_MATCH_TAXES
1294: WHERE Ref_Line_Id = p_ref_line_id
1295: AND receipt_id = p_receipt_id;
1296:
1297: FOR Rec IN Fetch_AR_Line_Info_Cur LOOP

Line 1609: FROM JAI_CMN_MATCH_TAXES

1605:
1606:
1607: CURSOR Chk_Rcd_Cur IS
1608: SELECT NVL( COUNT( * ), 0 )
1609: FROM JAI_CMN_MATCH_TAXES
1610: WHERE Ref_Line_Id = p_ref_line_id
1611: AND Subinventory = p_subinventory
1612: AND Receipt_Id = p_receipt_id
1613: AND Order_Invoice = 'O';

Line 1617: FROM JAI_CMN_MATCH_TAXES

1613: AND Order_Invoice = 'O';
1614:
1615: CURSOR Chk_Rcd_AR_Cur IS
1616: SELECT NVL( COUNT( * ), 0 )
1617: FROM JAI_CMN_MATCH_TAXES
1618: WHERE Ref_Line_Id = p_ref_line_id
1619: AND Receipt_Id = p_receipt_id
1620: AND Order_Invoice = 'I';
1621:

Line 1624: FROM JAI_CMN_MATCH_TAXES

1620: AND Order_Invoice = 'I';
1621:
1622: CURSOR Fetch_Totals_Cur( line_no IN NUMBER ) IS
1623: SELECT SUM( NVL( Tax_Amount, 0 ) )
1624: FROM JAI_CMN_MATCH_TAXES
1625: WHERE Subinventory = p_subinventory
1626: AND Ref_Line_Id = p_ref_line_id
1627: AND Tax_Line_No = line_no;
1628:

Line 1631: FROM JAI_CMN_MATCH_TAXES

1627: AND Tax_Line_No = line_no;
1628:
1629: CURSOR Fetch_Totals_AR_Cur( line_no IN NUMBER ) IS
1630: SELECT SUM( NVL( Tax_Amount, 0 ) )
1631: FROM JAI_CMN_MATCH_TAXES
1632: WHERE Ref_Line_Id = p_ref_line_id
1633: AND Tax_Line_No = line_no;
1634:
1635: CURSOR Fetch_Total_AR_Cur( line_no IN NUMBER ) IS

Line 1638: FROM JAI_CMN_MATCH_TAXES

1634:
1635: CURSOR Fetch_Total_AR_Cur( line_no IN NUMBER ) IS
1636: SELECT SUM( NVL( Tax_Amount, 0 ) ) tax_amount, SUM( NVL( Base_Tax_Amount, 0 ) ) base_tax_amount,
1637: SUM( NVL( Func_Tax_Amount, 0 ) ) func_tax_amount
1638: FROM JAI_CMN_MATCH_TAXES
1639: WHERE Ref_Line_Id = p_ref_line_id
1640: AND Tax_Line_No = line_no
1641: AND Receipt_ID IS NOT NULL;
1642:

Line 1932: INSERT INTO JAI_CMN_MATCH_TAXES(MATCH_TAX_ID, REF_LINE_ID,

1928: CLOSE Fetch_Exempt_Cur;
1929:
1930: FOR rec in oe_tax_cur(ln_cess_check, ln_sh_cess_check) LOOP/*Bug 5989740 bduvarag*/
1931: IF v_count = 0 THEN
1932: INSERT INTO JAI_CMN_MATCH_TAXES(MATCH_TAX_ID, REF_LINE_ID,
1933: SUBINVENTORY,
1934: TAX_LINE_NO,
1935: PRECEDENCE_1,
1936: PRECEDENCE_2,

Line 1960: VALUES ( JAI_CMN_MATCH_TAXES_S.nextval, p_ref_line_id,

1956: LAST_UPDATE_LOGIN,
1957: LAST_UPDATED_BY,
1958: RECEIPT_ID,
1959: ORDER_INVOICE )
1960: VALUES ( JAI_CMN_MATCH_TAXES_S.nextval, p_ref_line_id,
1961: p_subinventory,
1962: rec.lno,
1963: rec.p_1,
1964: rec.p_2,

Line 2280: INSERT INTO JAI_CMN_MATCH_TAXES(MATCH_TAX_ID, REF_LINE_ID,

2276: FOR rec in ar_tax_cur(ln_cess_check, ln_sh_cess_check) LOOP/*Bug 5989740 bduvarag*/
2277:
2278: IF v_count = 0 THEN
2279:
2280: INSERT INTO JAI_CMN_MATCH_TAXES(MATCH_TAX_ID, REF_LINE_ID,
2281: SUBINVENTORY,
2282: TAX_LINE_NO,
2283: PRECEDENCE_1,
2284: PRECEDENCE_2,

Line 2308: VALUES ( JAI_CMN_MATCH_TAXES_S.nextval, p_ref_line_id,

2304: LAST_UPDATE_LOGIN,
2305: LAST_UPDATED_BY,
2306: RECEIPT_ID,
2307: ORDER_INVOICE )
2308: VALUES ( JAI_CMN_MATCH_TAXES_S.nextval, p_ref_line_id,
2309: p_subinventory,
2310: rec.lno,
2311: rec.p_1,
2312: rec.p_2,

Line 2636: INSERT INTO Jai_cmn_match_Taxes( match_tax_id, --6447097

2632: IF v_count = 0 THEN
2633:
2634:
2635:
2636: INSERT INTO Jai_cmn_match_Taxes( match_tax_id, --6447097
2637: REF_LINE_ID,
2638: SUBINVENTORY,
2639: TAX_LINE_NO,
2640: PRECEDENCE_1,

Line 2666: VALUES ( jai_cmn_match_taxes_s.nextval,--6447097

2662: PRECEDENCE_8,
2663: PRECEDENCE_9,
2664: PRECEDENCE_10
2665: )
2666: VALUES ( jai_cmn_match_taxes_s.nextval,--6447097
2667: p_ref_line_id,
2668: p_subinventory,
2669: rec.lno,
2670: rec.p_1,

Line 3612: DELETE JAI_CMN_MATCH_TAXES

3608: OPEN Fetch_Totals_Cur( i );
3609: FETCH Fetch_Totals_Cur INTO v_cum_amount;
3610: CLOSE Fetch_Totals_Cur;
3611: IF p_line_quantity = 0 THEN
3612: DELETE JAI_CMN_MATCH_TAXES
3613: WHERE Ref_Line_Id = p_ref_line_id
3614: AND nvl(Subinventory,'###') = nvl(p_subinventory,'###')
3615: AND receipt_id = p_receipt_id
3616: AND Tax_Line_No = i;

Line 3618: UPDATE JAI_CMN_MATCH_TAXES

3614: AND nvl(Subinventory,'###') = nvl(p_subinventory,'###')
3615: AND receipt_id = p_receipt_id
3616: AND Tax_Line_No = i;
3617: ELSE
3618: UPDATE JAI_CMN_MATCH_TAXES
3619: SET Tax_Amount = tax_amt_tab(i),
3620: Base_Tax_Amount = tax_target_tab(i),
3621: Func_Tax_Amount = tax_amt_tab(i) * NVL( p_curr_conv_factor, 1 ),
3622: Total_Tax_Amount = v_cum_amount

Line 3633: DELETE JAI_CMN_MATCH_TAXES

3629: OPEN Fetch_Totals_AR_Cur( i );
3630: FETCH Fetch_Totals_AR_Cur INTO v_cum_amount;
3631: CLOSE Fetch_Totals_AR_Cur;
3632: IF p_line_quantity = 0 THEN
3633: DELETE JAI_CMN_MATCH_TAXES
3634: WHERE Ref_Line_Id = p_ref_line_id
3635: AND nvl(Subinventory,'###') = nvl(p_subinventory,'###')
3636: AND receipt_id = p_receipt_id
3637: AND Tax_Line_No = i;

Line 3639: UPDATE JAI_CMN_MATCH_TAXES

3635: AND nvl(Subinventory,'###') = nvl(p_subinventory,'###')
3636: AND receipt_id = p_receipt_id
3637: AND Tax_Line_No = i;
3638: ELSE
3639: UPDATE JAI_CMN_MATCH_TAXES
3640: SET Tax_Amount = tax_amt_tab(i),
3641: Base_Tax_Amount = tax_target_tab(i),
3642: Func_Tax_Amount = tax_amt_tab(i) * NVL( p_curr_conv_factor, 1 ),
3643: Total_Tax_Amount = v_cum_amount

Line 3677: UPDATE Jai_cmn_match_Taxes

3673: WHERE source_doc_line_id = p_ref_line_id
3674: AND source_doc_type = 'INTERORG_XFER'
3675: AND Tax_Line_No = i;
3676:
3677: UPDATE Jai_cmn_match_Taxes
3678: SET Tax_Amount = tax_amt_tab(i),
3679: Base_Tax_Amount = tax_target_tab(i),
3680: Func_Tax_Amount = tax_amt_tab(i) * NVL( p_curr_conv_factor, 1 )
3681: WHERE Ref_Line_Id = p_ref_line_id