DBA Data[Home] [Help]

APPS.JA_CN_APAB_EXPORT_PKG dependencies on FND_LOOKUP_VALUES

Line 71: lv_debit FND_LOOKUP_VALUES.MEANING%TYPE;

67: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
68: ln_exception_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
69: NO_DATA EXCEPTION;
70:
71: lv_debit FND_LOOKUP_VALUES.MEANING%TYPE;
72: lv_credit FND_LOOKUP_VALUES.MEANING%TYPE;
73: lv_dr_cr_begin FND_LOOKUP_VALUES.MEANING%TYPE;
74: lv_dr_cr_end FND_LOOKUP_VALUES.MEANING%TYPE;
75: lv_message VARCHAR2(300);

Line 72: lv_credit FND_LOOKUP_VALUES.MEANING%TYPE;

68: ln_exception_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
69: NO_DATA EXCEPTION;
70:
71: lv_debit FND_LOOKUP_VALUES.MEANING%TYPE;
72: lv_credit FND_LOOKUP_VALUES.MEANING%TYPE;
73: lv_dr_cr_begin FND_LOOKUP_VALUES.MEANING%TYPE;
74: lv_dr_cr_end FND_LOOKUP_VALUES.MEANING%TYPE;
75: lv_message VARCHAR2(300);
76:

Line 73: lv_dr_cr_begin FND_LOOKUP_VALUES.MEANING%TYPE;

69: NO_DATA EXCEPTION;
70:
71: lv_debit FND_LOOKUP_VALUES.MEANING%TYPE;
72: lv_credit FND_LOOKUP_VALUES.MEANING%TYPE;
73: lv_dr_cr_begin FND_LOOKUP_VALUES.MEANING%TYPE;
74: lv_dr_cr_end FND_LOOKUP_VALUES.MEANING%TYPE;
75: lv_message VARCHAR2(300);
76:
77: l_functional_currency fnd_currencies_vl.NAME%TYPE;

Line 74: lv_dr_cr_end FND_LOOKUP_VALUES.MEANING%TYPE;

70:
71: lv_debit FND_LOOKUP_VALUES.MEANING%TYPE;
72: lv_credit FND_LOOKUP_VALUES.MEANING%TYPE;
73: lv_dr_cr_begin FND_LOOKUP_VALUES.MEANING%TYPE;
74: lv_dr_cr_end FND_LOOKUP_VALUES.MEANING%TYPE;
75: lv_message VARCHAR2(300);
76:
77: l_functional_currency fnd_currencies_vl.NAME%TYPE;
78: l_functional_currency_code fnd_currencies_vl.CURRENCY_CODE%TYPE;

Line 328: FROM FND_LOOKUP_VALUES

324:
325: --Get the Chinese characters of Debit and Credit
326: SELECT MEANING
327: INTO lv_debit
328: FROM FND_LOOKUP_VALUES
329: WHERE LOOKUP_TYPE = 'JA_CN_DEBIT_CREDIT'
330: AND LOOKUP_CODE = 'D'
331: AND LANGUAGE = USERENV('LANG');
332:

Line 335: FROM FND_LOOKUP_VALUES

331: AND LANGUAGE = USERENV('LANG');
332:
333: SELECT MEANING
334: INTO lv_credit
335: FROM FND_LOOKUP_VALUES
336: WHERE LOOKUP_TYPE = 'JA_CN_DEBIT_CREDIT'
337: AND LOOKUP_CODE = 'C'
338: AND LANGUAGE = USERENV('LANG');
339: