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.7 2008/04/21 07:52:10 jianliu noship $
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 1014: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'

1010: , p_entered_cr => NULL
1011: , p_currency_code => 'INR'
1012: , p_accounting_date => SYSDATE
1013: , p_reference_10 => NULL
1014: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'
1015: , p_reference_24 => 'rcv_transactions'
1016: , p_reference_25 => 'transaction_id'
1017: , p_reference_26 => to_char(pn_transaction_id)
1018: , p_destination => 'G'

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

1047: , p_entered_cr => pn_amount
1048: , p_currency_code => 'INR'
1049: , p_accounting_date => SYSDATE
1050: , p_reference_10 => NULL
1051: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'
1052: , p_reference_24 => 'rcv_transactions'
1053: , p_reference_25 => 'transaction_id'
1054: , p_reference_26 => to_char(pn_transaction_id)
1055: , p_destination => 'G'

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

1091: , p_entered_cr => NULL
1092: , p_currency_code => 'INR'
1093: , p_accounting_date => SYSDATE
1094: , p_reference_10 => NULL
1095: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'
1096: , p_reference_24 => 'rcv_transactions'
1097: , p_reference_25 => 'transaction_id'
1098: , p_reference_26 => to_char(pn_transaction_id)
1099: , p_destination => 'S'

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

1127: , p_entered_cr => pn_amount
1128: , p_currency_code => 'INR'
1129: , p_accounting_date => SYSDATE
1130: , p_reference_10 => NULL
1131: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'
1132: , p_reference_24 => 'rcv_transactions'
1133: , p_reference_25 => 'transaction_id'
1134: , p_reference_26 => to_char(pn_transaction_id)
1135: , p_destination => 'S'

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

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

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

1295: , p_currency_conversion_date => NULL
1296: , p_currency_conversion_type => NULL
1297: , p_currency_conversion_rate => NULL
1298: , p_reference_10 => 'India Localization.....'
1299: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'
1300: , p_reference_24 => 'rcv_transactions'
1301: , p_reference_25 => 'transaction_id'
1302: , p_reference_26 => to_char(pn_transaction_id)
1303: , p_process_message => lv_process_message

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

1529: , p_entered_cr => NULL
1530: , p_currency_code => 'INR'
1531: , p_accounting_date => SYSDATE
1532: , p_reference_10 => NULL
1533: , p_reference_23 => 'jai_retro_prc_pkg.do_accounting'
1534: , p_reference_24 => 'rcv_transactions'
1535: , p_reference_25 => 'transaction_id'
1536: , p_reference_26 => to_char(pn_transaction_id)
1537: , p_destination => 'G' --G indicates GL Interface Entries,

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

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

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

2076: pn_batch_id => NULL,
2077: pn_inv_organization_id => ln_organization_id, -- fetched above
2078: pv_invoice_no => pv_supp_vat_inv_no,
2079: pd_invoice_date => pd_supp_vat_inv_date,
2080: pv_called_from => 'JAI_RETRO_PRC_PKG.DO_VAT_CLAIM',
2081: pv_process_flag => lv_process_status,
2082: pv_process_message => lv_process_message,
2083: pv_attribute_context => NULL,
2084: pv_attribute1 => NULL,

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

2093: raise_application_error(-20120,'VAT repository Entry retruned with error : '||lv_process_message);
2094: END IF;
2095:
2096: lv_reference_10 := 'India Local Retroactive VAT Claim Entries For Receipt:'||lv_receipt_number;
2097: lv_reference_23 := 'JAI_RETRO_PRC_PKG.DO_VAT_CLAIM';
2098: lv_reference_24 := 'JAI_RETRO_TAX_CHANGES';
2099: lv_reference_25 := 'transaction_id';
2100: lv_reference_26 := pn_transaction_id;
2101:

Line 3723: END JAI_RETRO_PRC_PKG;

3719: pv_process_flag := 'UE';
3720: pv_process_message := 'When updating tax line change history.'||SQLERRM;
3721: END Update_Price_Changes;
3722:
3723: END JAI_RETRO_PRC_PKG;