DBA Data[Home] [Help]

APPS.JAI_RETRO_PRC_PKG dependencies on JAI_RETRO_PRC_PKG

Line 1: PACKAGE BODY JAI_RETRO_PRC_PKG AS

1: PACKAGE BODY JAI_RETRO_PRC_PKG AS
2: --$Header: jai_retro_prc.plb 120.9.12020000.2 2012/12/30 10:31:54 anupgupt ship $
3: --|+======================================================================+
4: --| Copyright (c) 2007 Oracle Corporation Redwood Shores, California, USA |
5: --| All rights reserved. |

Line 8: --| JAI_RETRO_PRC_PKG.plb |

4: --| Copyright (c) 2007 Oracle Corporation Redwood Shores, California, USA |
5: --| All rights reserved. |
6: --+=======================================================================+
7: --| FILENAME |
8: --| JAI_RETRO_PRC_PKG.plb |
9: --| |
10: --| DESCRIPTION |
11: --| This package offer funcitons to process the retro receipt |
12: --| |

Line 1019: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'

1015: , p_entered_cr => NULL
1016: , p_currency_code => 'INR'
1017: , p_accounting_date => SYSDATE
1018: , p_reference_10 => NULL
1019: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'
1020: , p_reference_24 => 'rcv_transactions'
1021: , p_reference_25 => 'transaction_id'
1022: , p_reference_26 => to_char(pn_transaction_id)
1023: , p_destination => 'G'

Line 1056: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'

1052: , p_entered_cr => pn_amount
1053: , p_currency_code => 'INR'
1054: , p_accounting_date => SYSDATE
1055: , p_reference_10 => NULL
1056: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'
1057: , p_reference_24 => 'rcv_transactions'
1058: , p_reference_25 => 'transaction_id'
1059: , p_reference_26 => to_char(pn_transaction_id)
1060: , p_destination => 'G'

Line 1100: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'

1096: , p_entered_cr => NULL
1097: , p_currency_code => 'INR'
1098: , p_accounting_date => SYSDATE
1099: , p_reference_10 => NULL
1100: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'
1101: , p_reference_24 => 'rcv_transactions'
1102: , p_reference_25 => 'transaction_id'
1103: , p_reference_26 => to_char(pn_transaction_id)
1104: , p_destination => 'S'

Line 1136: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'

1132: , p_entered_cr => pn_amount
1133: , p_currency_code => 'INR'
1134: , p_accounting_date => SYSDATE
1135: , p_reference_10 => NULL
1136: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'
1137: , p_reference_24 => 'rcv_transactions'
1138: , p_reference_25 => 'transaction_id'
1139: , p_reference_26 => to_char(pn_transaction_id)
1140: , p_destination => 'S'

Line 1228: , p_reference_23 => 'JAI_RETRO_PRC_PKG.Do_Accounting'

1224: , p_currency_conversion_date => NULL
1225: , p_currency_conversion_type => NULL
1226: , p_currency_conversion_rate => NULL
1227: , p_reference_10 => 'JAI Retropricing Unclaim Entry for the Receipt Number '||lv_receipt_num ||' for the Organization code '||lv_organization_code
1228: , p_reference_23 => 'JAI_RETRO_PRC_PKG.Do_Accounting'
1229: , p_reference_24 => 'rcv_transactions'
1230: , p_reference_25 => 'transaction_id'
1231: , p_reference_26 => to_char(pn_transaction_id)
1232: , p_process_message => lv_process_message

Line 1304: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'

1300: , p_currency_conversion_date => NULL
1301: , p_currency_conversion_type => NULL
1302: , p_currency_conversion_rate => NULL
1303: , p_reference_10 => 'India Localization.....'
1304: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'
1305: , p_reference_24 => 'rcv_transactions'
1306: , p_reference_25 => 'transaction_id'
1307: , p_reference_26 => to_char(pn_transaction_id)
1308: , p_process_message => lv_process_message

Line 1538: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'

1534: , p_entered_cr => NULL
1535: , p_currency_code => 'INR'
1536: , p_accounting_date => SYSDATE
1537: , p_reference_10 => NULL
1538: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'
1539: , p_reference_24 => 'rcv_transactions'
1540: , p_reference_25 => 'transaction_id'
1541: , p_reference_26 => to_char(pn_transaction_id)
1542: , p_destination => 'G' --G indicates GL Interface Entries,

Line 1590: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'

1586: , p_entered_cr => ln_tax_diff_tot --ln_amount --Total tax difference in INR
1587: , p_currency_code => 'INR'
1588: , p_accounting_date => SYSDATE
1589: , p_reference_10 => NULL
1590: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'
1591: , p_reference_24 => 'rcv_transactions'
1592: , p_reference_25 => 'transaction_id'
1593: , p_reference_26 => to_char(pn_transaction_id)
1594: , p_destination => 'G' --GL Interface Entries

Line 2085: pv_called_from => 'JAI_RETRO_PRC_PKG.DO_VAT_CLAIM',

2081: pn_batch_id => NULL,
2082: pn_inv_organization_id => ln_organization_id, -- fetched above
2083: pv_invoice_no => pv_supp_vat_inv_no,
2084: pd_invoice_date => pd_supp_vat_inv_date,
2085: pv_called_from => 'JAI_RETRO_PRC_PKG.DO_VAT_CLAIM',
2086: pv_process_flag => lv_process_status,
2087: pv_process_message => lv_process_message,
2088: --Added by Bo Li for bug9305067 2010-4-14 BEGIN
2089: --------------------------------------------------

Line 2106: lv_reference_23 := 'JAI_RETRO_PRC_PKG.DO_VAT_CLAIM';

2102: raise_application_error(-20120,'VAT repository Entry retruned with error : '||lv_process_message);
2103: END IF;
2104:
2105: lv_reference_10 := 'India Local Retroactive VAT Claim Entries For Receipt:'||lv_receipt_number;
2106: lv_reference_23 := 'JAI_RETRO_PRC_PKG.DO_VAT_CLAIM';
2107: lv_reference_24 := 'JAI_RETRO_TAX_CHANGES';
2108: lv_reference_25 := 'transaction_id';
2109: lv_reference_26 := pn_transaction_id;
2110:

Line 3768: END JAI_RETRO_PRC_PKG;

3764: pv_process_flag := 'UE';
3765: pv_process_message := 'When updating tax line change history.'||SQLERRM;
3766: END Update_Price_Changes;
3767:
3768: END JAI_RETRO_PRC_PKG;