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 248: jai_cmn_utils_pkg.check_jai_exists to check if localization has been installed.

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

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

292:
293: Sl No. Bug Dependent on
294: Bug/Patch set Details
295: -------------------------------------------------------------------------------------------------
296: 1 4036241 4033992 Call to jai_cmn_utils_pkg.check_jai_exists, whcih was created thru bug
297: 4033992.
298: ja_in_util_pkg_s.sql 115.0
299: ja_in_util_pkg_b.sql 115.0
300:

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

330: v_reqn_ctr :=0;
331: v_new_org_id := pr_new.ORG_ID; --pramasub 6066485
332:
333: --if
334: -- jai_cmn_utils_pkg.check_jai_exists (p_calling_object => 'JA_IN_REQN_TAX_INSERT_TRG',
335: -- p_org_id => pr_new.org_id)
336:
337: -- =
338: -- FALSE

Line 632: --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

628: ELSE
629: IF v_rate_type = 'User' THEN
630: conv_rate := 1/v_rate;
631: ELSE
632: --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
633: conv_rate := 1/jai_cmn_utils_pkg.currency_conversion( v_sob_hrou_id, v_currency, v_rate_date, v_rate_type, v_rate );
634: END IF;
635: END IF;
636:

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

629: IF v_rate_type = 'User' THEN
630: conv_rate := 1/v_rate;
631: ELSE
632: --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
633: conv_rate := 1/jai_cmn_utils_pkg.currency_conversion( v_sob_hrou_id, v_currency, v_rate_date, v_rate_type, v_rate );
634: END IF;
635: END IF;
636:
637: v_line_amount := v_line_amount * conv_rate;

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

1216: 10. 13-Jun-2005 File Version: 116.2
1217: Ramananda for bug#4428980. Removal of SQL LITERALs is done
1218:
1219: 11. 08-Jul-2005 Sanjikum for Bug#4483042
1220: 1) Added a call to jai_cmn_utils_pkg.validate_po_type, to check whether for the current PO
1221: IL functionality should work or not.
1222:
1223: 12. 08-Jul-2005 Sanjikum for Bug#4483042, File version 117.2
1224: 1) Added a new column in cursor - Fetch_Po_Vendor_Id_Cur

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

1362: v_style_id; --Added by Sanjikum for Bug#4483042
1363: CLOSE Fetch_Po_Vendor_Id_Cur;
1364:
1365: --code added by Sanjikum for Bug#4483042
1366: IF jai_cmn_utils_pkg.validate_po_type(p_style_id => v_style_id) = FALSE THEN
1367: return;
1368: END IF;
1369:
1370: -- Start Modification by Gaurav for PO Autocreate issue 17-aug-00

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

1640: IF nvl(v_adhoc_flag, 'N') = 'Y' THEN
1641: IF v_t_curr <> v_po_curr THEN
1642: -- Vijay Shankar for Bug# 2782356
1643: IF v_debug THEN
1644: UTL_FILE.PUT_LINE(v_myfilehandle, '3 jai_cmn_utils_pkg.currency_conversion('||v_set_of_book_id
1645: ||', '''||v_po_curr
1646: ||''', to_date('||v_po_conv_date
1647: ||','''||'''DD/MM/YYYY''||''), '''||v_po_conv_type
1648: ||''', '||v_po_conv_rate ||');'

Line 1658: 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 );

1654: END IF;
1655:
1656: -- as tax_currency is same as functional currency and v_curr_conv_rate contains conversion from v_po_curr to func_curr
1657: IF v_t_curr = v_currency_code THEN
1658: 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 );
1659:
1660: v_tax_amount := v_tax_amt / v_curr_conv_rate;
1661: IF v_debug THEN
1662: UTL_FILE.PUT_LINE(v_myfilehandle, '5.1 multiply ');

Line 1666: 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 );

1662: UTL_FILE.PUT_LINE(v_myfilehandle, '5.1 multiply ');
1663: END IF;
1664:
1665: ELSE -- now tax_currency is not equal to functional currency, so division is fine
1666: 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 );
1667: v_tax_amount := v_tax_amt * v_curr_conv_rate;
1668: IF v_debug THEN
1669: UTL_FILE.PUT_LINE(v_myfilehandle, '5.2 divide' );
1670: END IF;

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

2032:
2033: 3. 30/11/2005 Aparajita for bug#4036241. Version#115.1
2034:
2035: Introduced the call to centralized packaged procedure,
2036: jai_cmn_utils_pkg.check_jai_exists to check if localization has been installed.
2037:
2038: 5. 17/mar-2005 Rchandan for bug#4245365 Version#115.3
2039: Changes made to calculate VAT assessable value . This vat assessable is passed
2040: to the procedure that calculates the VAT related taxes

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

2069:
2070: Sl No. Bug Dependent on
2071: Bug/Patch set Details
2072: -------------------------------------------------------------------------------------------------
2073: 1 4036241 4033992 Call to jai_cmn_utils_pkg.check_jai_exists, whcih was created thru bug
2074: 4033992.
2075: ja_in_util_pkg_s.sql 115.0
2076: ja_in_util_pkg_b.sql 115.0
2077: 2. 4245365 4245089 VAT implementation

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

2105: v_deliver_to_loc_id := pr_new.DELIVER_TO_LOCATION_ID;--Added by Xiao Lv for bug 10043656
2106:
2107:
2108: --if
2109: -- jai_cmn_utils_pkg.check_jai_exists (p_calling_object => 'JA_IN_REQN_TAX_UPDATE_TRG',
2110: -- p_org_id => pr_new.org_id)
2111:
2112: -- =
2113: -- FALSE

Line 2390: 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 );

2386: ELSE
2387: IF v_rate_type = 'User' THEN
2388: conv_rate := 1/v_rate;
2389: ELSE
2390: 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 );
2391: END IF;
2392: END IF;
2393:
2394: v_assessable_value := jai_cmn_setup_pkg.get_po_assessable_value( v_vendor_id, v_site_id,

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

2638: AND requisition_line_id = v_line_id;
2639:
2640: UPDATE JAI_PO_REQ_LINE_TAXES jrtl --ja_in_reqn_tax_lines jrtl
2641: SET tax_amount = tax_amount * DECODE(nvl(pr_new.CURRENCY_CODE,'INR'),
2642: 'INR',jai_cmn_utils_pkg.currency_conversion( v_gl_set_of_bks_id, pr_old.CURRENCY_CODE,
2643: pr_old.rate_date, pr_old.rate_type, pr_old.rate ),conv_rate)
2644: WHERE requisition_header_id = v_header_id
2645: AND requisition_line_id = v_line_id
2646: AND exists ( SELECT 1

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

2801:
2802: 1. 30/11/2005 Aparajita for bug#4036241. Version#115.1
2803:
2804: Introduced the call to centralized packaged procedure,
2805: jai_cmn_utils_pkg.check_jai_exists to check if localization has been installed.
2806:
2807: 2. 15/03/2005 Brathod for bug#4250072 , Version#115.2
2808: Modified the trigger for VAT implementation (vat assessable value)
2809:

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

2828:
2829: Sl No. Bug Dependent on
2830: Bug/Patch set Details
2831: -------------------------------------------------------------------------------------------------
2832: 1 4036241 4033992 Call to jai_cmn_utils_pkg.check_jai_exists, whcih was created thru bug
2833: 4033992.
2834: ja_in_util_pkg_s.sql 115.0
2835: ja_in_util_pkg_b.sql 115.0
2836:

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

2863: v_last_update_login := pr_new.Last_Update_Login;
2864:
2865:
2866: --if
2867: -- jai_cmn_utils_pkg.check_jai_exists (p_calling_object => 'JA_IN_REQN_CURR_UPD_TRG',
2868: -- p_org_id => pr_new.org_id)
2869:
2870: -- =
2871: -- FALSE

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

3104: ELSE
3105: IF v_rate_type = 'User' THEN
3106: conv_rate := 1/v_rate;
3107: ELSE
3108: conv_rate := jai_cmn_utils_pkg.currency_conversion( v_gl_set_of_bks_id, v_currency, v_rate_date, v_rate_type, v_rate );
3109: END IF;
3110: END IF;
3111:
3112: v_assessable_value := jai_cmn_setup_pkg.get_po_assessable_value( v_vendor_id, v_site_id,