DBA Data[Home] [Help]

APPS.JAI_JAR_TL_TRIGGER_PKG dependencies on JAI_RGM_DEFINITIONS

Line 324: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;

320: WHERE
321: upper(jrttv.tax_type) = upper(cp_tax_type);
322:
323:
324: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
325: lv_attr_value JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
326:
327: -- Start of bug 4089440
328: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;

Line 328: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;

324: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
325: lv_attr_value JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
326:
327: -- Start of bug 4089440
328: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
329: lv_error_flag VARCHAR2(2) ;
330: lv_error_message VARCHAR2(4000) ;
331: -- End of bug 4089440
332:

Line 1313: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;

1309: v_trans_type VARCHAR2(30);
1310: v_line_tax_amount NUMBER := 0;
1311: l_tcs_line_num NUMBER := 0;
1312: l_tcs_sur_line_num NUMBER := 0;
1313: ln_tcs_regime_id JAI_RGM_DEFINITIONS.regime_id%type;
1314: l_org_id NUMBER;
1315: l_bill_to_customer_id NUMBER;
1316: l_bill_to_site_use_id NUMBER;
1317: ln_organization_id NUMBER;

Line 1398: CURSOR GC_GET_REGIME_ID (CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE)

1394:
1395: -- added by sriram - bug # 2779967
1396:
1397: /*Bug 8371741 - Start*/
1398: CURSOR GC_GET_REGIME_ID (CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE)
1399: IS
1400: SELECT REGIME_ID
1401: FROM JAI_RGM_DEFINITIONS
1402: WHERE REGIME_CODE = CP_REGIME_CODE;

Line 1401: FROM JAI_RGM_DEFINITIONS

1397: /*Bug 8371741 - Start*/
1398: CURSOR GC_GET_REGIME_ID (CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE)
1399: IS
1400: SELECT REGIME_ID
1401: FROM JAI_RGM_DEFINITIONS
1402: WHERE REGIME_CODE = CP_REGIME_CODE;
1403:
1404: Cursor transaction_type_cur IS
1405: Select a.type

Line 1595: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;

1591: WHERE
1592: upper(jrttv.tax_type) = upper(cp_tax_type);
1593:
1594:
1595: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
1596: lv_attr_value JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
1597:
1598: -- Start of bug 4089440
1599: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;

Line 1599: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;

1595: ln_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
1596: lv_attr_value JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
1597:
1598: -- Start of bug 4089440
1599: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
1600: lv_error_flag VARCHAR2(2) ;
1601: lv_error_message VARCHAR2(4000) ;
1602: -- End of bug 4089440
1603: