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.JAI_PO_RLA_TRIGGER_PKG dependencies on JAI_CMN_UTILS_PKG

Line 242: jai_cmn_utils_pkg.check_jai_exists to check if localization has been installed.

238:
239: 4. 30/11/2005 Aparajita for bug#4036241. Version#115.1
240:
241: Introduced the call to centralized packaged procedure,
242: jai_cmn_utils_pkg.check_jai_exists to check if localization has been installed.
243:
244: 5. 17/mar-2005 Rchandan for bug#4245365 Version#115.3
245: Changes made to calculate VAT assessable value . This vat assessable is passed
246: to the procedure that calculates the VAT related taxes

Line 281: 1 4036241 4033992 Call to jai_cmn_utils_pkg.check_jai_exists, whcih was created thru bug

277:
278: Sl No. Bug Dependent on
279: Bug/Patch set Details
280: -------------------------------------------------------------------------------------------------
281: 1 4036241 4033992 Call to jai_cmn_utils_pkg.check_jai_exists, whcih was created thru bug
282: 4033992.
283: ja_in_util_pkg_s.sql 115.0
284: ja_in_util_pkg_b.sql 115.0
285:

Line 318: -- jai_cmn_utils_pkg.check_jai_exists (p_calling_object => 'JA_IN_REQN_TAX_INSERT_TRG',

314: v_reqn_ctr :=0;
315: v_new_org_id := pr_new.ORG_ID; --pramasub 6066485
316:
317: --if
318: -- jai_cmn_utils_pkg.check_jai_exists (p_calling_object => 'JA_IN_REQN_TAX_INSERT_TRG',
319: -- p_org_id => pr_new.org_id)
320:
321: -- =
322: -- FALSE

Line 609: --conv_rate := 1/jai_cmn_utils_pkg.currency_conversion( v_gl_set_of_bks_id, v_currency, v_rate_date, v_rate_type, v_rate ); pramasub 6066485

605: ELSE
606: IF v_rate_type = 'User' THEN
607: conv_rate := 1/v_rate;
608: ELSE
609: --conv_rate := 1/jai_cmn_utils_pkg.currency_conversion( v_gl_set_of_bks_id, v_currency, v_rate_date, v_rate_type, v_rate ); pramasub 6066485
610: conv_rate := 1/jai_cmn_utils_pkg.currency_conversion( v_sob_hrou_id, v_currency, v_rate_date, v_rate_type, v_rate );
611: END IF;
612: END IF;
613:

Line 610: conv_rate := 1/jai_cmn_utils_pkg.currency_conversion( v_sob_hrou_id, v_currency, v_rate_date, v_rate_type, v_rate );

606: IF v_rate_type = 'User' THEN
607: conv_rate := 1/v_rate;
608: ELSE
609: --conv_rate := 1/jai_cmn_utils_pkg.currency_conversion( v_gl_set_of_bks_id, v_currency, v_rate_date, v_rate_type, v_rate ); pramasub 6066485
610: conv_rate := 1/jai_cmn_utils_pkg.currency_conversion( v_sob_hrou_id, v_currency, v_rate_date, v_rate_type, v_rate );
611: END IF;
612: END IF;
613:
614: v_line_amount := v_line_amount * conv_rate;

Line 1132: 1) Added a call to jai_cmn_utils_pkg.validate_po_type, to check whether for the current PO

1128: 10. 13-Jun-2005 File Version: 116.2
1129: Ramananda for bug#4428980. Removal of SQL LITERALs is done
1130:
1131: 11. 08-Jul-2005 Sanjikum for Bug#4483042
1132: 1) Added a call to jai_cmn_utils_pkg.validate_po_type, to check whether for the current PO
1133: IL functionality should work or not.
1134:
1135: 12. 08-Jul-2005 Sanjikum for Bug#4483042, File version 117.2
1136: 1) Added a new column in cursor - Fetch_Po_Vendor_Id_Cur

Line 1265: IF jai_cmn_utils_pkg.validate_po_type(p_style_id => v_style_id) = FALSE THEN

1261: v_style_id; --Added by Sanjikum for Bug#4483042
1262: CLOSE Fetch_Po_Vendor_Id_Cur;
1263:
1264: --code added by Sanjikum for Bug#4483042
1265: IF jai_cmn_utils_pkg.validate_po_type(p_style_id => v_style_id) = FALSE THEN
1266: return;
1267: END IF;
1268:
1269: -- Start Modification by Gaurav for PO Autocreate issue 17-aug-00

Line 1541: UTL_FILE.PUT_LINE(v_myfilehandle, '3 jai_cmn_utils_pkg.currency_conversion('||v_set_of_book_id

1537: IF nvl(v_adhoc_flag, 'N') = 'Y' THEN
1538: IF v_t_curr <> v_po_curr THEN
1539: -- Vijay Shankar for Bug# 2782356
1540: IF v_debug THEN
1541: UTL_FILE.PUT_LINE(v_myfilehandle, '3 jai_cmn_utils_pkg.currency_conversion('||v_set_of_book_id
1542: ||', '''||v_po_curr
1543: ||''', to_date('||v_po_conv_date
1544: ||','''||'''DD/MM/YYYY''||''), '''||v_po_conv_type
1545: ||''', '||v_po_conv_rate ||');'

Line 1555: v_curr_conv_rate := jai_cmn_utils_pkg.currency_conversion( v_set_of_book_id , v_po_curr , v_po_conv_date , v_po_conv_type, v_po_conv_rate );

1551: END IF;
1552:
1553: -- as tax_currency is same as functional currency and v_curr_conv_rate contains conversion from v_po_curr to func_curr
1554: IF v_t_curr = v_currency_code THEN
1555: v_curr_conv_rate := jai_cmn_utils_pkg.currency_conversion( v_set_of_book_id , v_po_curr , v_po_conv_date , v_po_conv_type, v_po_conv_rate );
1556:
1557: v_tax_amount := v_tax_amt / v_curr_conv_rate;
1558: IF v_debug THEN
1559: UTL_FILE.PUT_LINE(v_myfilehandle, '5.1 multiply ');

Line 1563: v_curr_conv_rate := jai_cmn_utils_pkg.currency_conversion( v_set_of_book_id , v_t_curr , v_po_conv_date , v_po_conv_type, v_po_conv_rate );

1559: UTL_FILE.PUT_LINE(v_myfilehandle, '5.1 multiply ');
1560: END IF;
1561:
1562: ELSE -- now tax_currency is not equal to functional currency, so division is fine
1563: v_curr_conv_rate := jai_cmn_utils_pkg.currency_conversion( v_set_of_book_id , v_t_curr , v_po_conv_date , v_po_conv_type, v_po_conv_rate );
1564: v_tax_amount := v_tax_amt * v_curr_conv_rate;
1565: IF v_debug THEN
1566: UTL_FILE.PUT_LINE(v_myfilehandle, '5.2 divide' );
1567: END IF;

Line 1905: jai_cmn_utils_pkg.check_jai_exists to check if localization has been installed.

1901:
1902: 3. 30/11/2005 Aparajita for bug#4036241. Version#115.1
1903:
1904: Introduced the call to centralized packaged procedure,
1905: jai_cmn_utils_pkg.check_jai_exists to check if localization has been installed.
1906:
1907: 5. 17/mar-2005 Rchandan for bug#4245365 Version#115.3
1908: Changes made to calculate VAT assessable value . This vat assessable is passed
1909: to the procedure that calculates the VAT related taxes

Line 1940: 1 4036241 4033992 Call to jai_cmn_utils_pkg.check_jai_exists, whcih was created thru bug

1936:
1937: Sl No. Bug Dependent on
1938: Bug/Patch set Details
1939: -------------------------------------------------------------------------------------------------
1940: 1 4036241 4033992 Call to jai_cmn_utils_pkg.check_jai_exists, whcih was created thru bug
1941: 4033992.
1942: ja_in_util_pkg_s.sql 115.0
1943: ja_in_util_pkg_b.sql 115.0
1944: 2. 4245365 4245089 VAT implementation

Line 1975: -- jai_cmn_utils_pkg.check_jai_exists (p_calling_object => 'JA_IN_REQN_TAX_UPDATE_TRG',

1971: v_operating_id :=pr_new.ORG_ID;
1972:
1973:
1974: --if
1975: -- jai_cmn_utils_pkg.check_jai_exists (p_calling_object => 'JA_IN_REQN_TAX_UPDATE_TRG',
1976: -- p_org_id => pr_new.org_id)
1977:
1978: -- =
1979: -- FALSE

Line 2256: conv_rate := 1/jai_cmn_utils_pkg.currency_conversion( v_gl_set_of_bks_id, v_currency, v_rate_date, v_rate_type, v_rate );

2252: ELSE
2253: IF v_rate_type = 'User' THEN
2254: conv_rate := 1/v_rate;
2255: ELSE
2256: conv_rate := 1/jai_cmn_utils_pkg.currency_conversion( v_gl_set_of_bks_id, v_currency, v_rate_date, v_rate_type, v_rate );
2257: END IF;
2258: END IF;
2259:
2260: v_assessable_value := jai_cmn_setup_pkg.get_po_assessable_value( v_vendor_id, v_site_id,

Line 2424: 'INR',jai_cmn_utils_pkg.currency_conversion( v_gl_set_of_bks_id, pr_old.CURRENCY_CODE,

2420: AND requisition_line_id = v_line_id;
2421:
2422: UPDATE JAI_PO_REQ_LINE_TAXES jrtl --ja_in_reqn_tax_lines jrtl
2423: SET tax_amount = tax_amount * DECODE(nvl(pr_new.CURRENCY_CODE,'INR'),
2424: 'INR',jai_cmn_utils_pkg.currency_conversion( v_gl_set_of_bks_id, pr_old.CURRENCY_CODE,
2425: pr_old.rate_date, pr_old.rate_type, pr_old.rate ),conv_rate)
2426: WHERE requisition_header_id = v_header_id
2427: AND requisition_line_id = v_line_id
2428: AND exists ( SELECT 1

Line 2582: jai_cmn_utils_pkg.check_jai_exists to check if localization has been installed.

2578:
2579: 1. 30/11/2005 Aparajita for bug#4036241. Version#115.1
2580:
2581: Introduced the call to centralized packaged procedure,
2582: jai_cmn_utils_pkg.check_jai_exists to check if localization has been installed.
2583:
2584: 2. 15/03/2005 Brathod for bug#4250072 , Version#115.2
2585: Modified the trigger for VAT implementation (vat assessable value)
2586:

Line 2609: 1 4036241 4033992 Call to jai_cmn_utils_pkg.check_jai_exists, whcih was created thru bug

2605:
2606: Sl No. Bug Dependent on
2607: Bug/Patch set Details
2608: -------------------------------------------------------------------------------------------------
2609: 1 4036241 4033992 Call to jai_cmn_utils_pkg.check_jai_exists, whcih was created thru bug
2610: 4033992.
2611: ja_in_util_pkg_s.sql 115.0
2612: ja_in_util_pkg_b.sql 115.0
2613:

Line 2643: -- jai_cmn_utils_pkg.check_jai_exists (p_calling_object => 'JA_IN_REQN_CURR_UPD_TRG',

2639: v_last_update_login := pr_new.Last_Update_Login;
2640:
2641:
2642: --if
2643: -- jai_cmn_utils_pkg.check_jai_exists (p_calling_object => 'JA_IN_REQN_CURR_UPD_TRG',
2644: -- p_org_id => pr_new.org_id)
2645:
2646: -- =
2647: -- FALSE

Line 2884: conv_rate := jai_cmn_utils_pkg.currency_conversion( v_gl_set_of_bks_id, v_currency, v_rate_date, v_rate_type, v_rate );

2880: ELSE
2881: IF v_rate_type = 'User' THEN
2882: conv_rate := 1/v_rate;
2883: ELSE
2884: conv_rate := jai_cmn_utils_pkg.currency_conversion( v_gl_set_of_bks_id, v_currency, v_rate_date, v_rate_type, v_rate );
2885: END IF;
2886: END IF;
2887:
2888: v_assessable_value := jai_cmn_setup_pkg.get_po_assessable_value( v_vendor_id, v_site_id,