DBA Data[Home] [Help]

APPS.JA_CN_ITEMIZATION_INTERFACE dependencies on FND_LOOKUP_VALUES

Line 253: from FND_LOOKUP_VALUES

249: --validate THIRD_PARTY_TYPE.
250: if l_error_flag<>'Y' and l_THIRD_PARTY_TYPE is not null then
251: select count(*)
252: into l_count
253: from FND_LOOKUP_VALUES
254: where LANGUAGE = userenv('LANG')
255: and lookup_code = l_THIRD_PARTY_TYPE
256: and lookup_type = 'JA_CN_THIRDPARTY_TYPE' ;
257: if l_count=0 then

Line 327: from FND_LOOKUP_VALUES

323: --check project source
324: if l_error_flag<>'Y' then
325: select count(*)
326: into l_count
327: from FND_LOOKUP_VALUES
328: where lookup_code = l_PROJECT_SOURCE
329: and lookup_type like 'JA_CN_PROJECT_SOURCE'
330: and LANGUAGE = userenv('LANG') ;
331: if l_count=0 then

Line 1760: L_DESCRIPTION FND_LOOKUP_VALUES.DESCRIPTION%TYPE;

1756: L_LEDGER_NAME GL_LEDGERS.NAME%TYPE;
1757: L_JOURNAL_GROUP JA_CN_ITEM_INTERFACE.JOURNAL_GROUP%TYPE;
1758: L_JE_LINE_NUM JA_CN_ITEM_INTERFACE.JE_LINE_NUM%TYPE;
1759: L_STATUS_CODE JA_CN_ITEM_INTERFACE.STATUS%TYPE;
1760: L_DESCRIPTION FND_LOOKUP_VALUES.DESCRIPTION%TYPE;
1761:
1762: l_period_from VARCHAR2(15);
1763:
1764:

Line 1770: FROM JA_CN_ITEM_INTERFACE JA,FND_LOOKUP_VALUES FND

1766: SELECT JOURNAL_GROUP,
1767: JE_LINE_NUM,
1768: STATUS,
1769: fnd.description
1770: FROM JA_CN_ITEM_INTERFACE JA,FND_LOOKUP_VALUES FND
1771: WHERE FND.meaning=JA.status
1772: AND FND.LANGUAGE = userenv('LANG')
1773: AND FND.lookup_type='JA_CN_ITEM_ERROR_CODE'
1774: AND LEDGER_ID = p_ledger_id

Line 1959: -- l_Phase_Code Fnd_Lookup_Values.Lookup_Code%TYPE;

1955: l_Post_Con_Req_Id number(15):=0;
1956: l_Result boolean;
1957: l_Conc_Succ BOOLEAN;
1958: l_Post_Fail EXCEPTION;
1959: -- l_Phase_Code Fnd_Lookup_Values.Lookup_Code%TYPE;
1960: -- l_Status_Code Fnd_Lookup_Values.Lookup_Code%TYPE;
1961: l_third_party_number ja_cn_journal_lines.third_party_number%type;
1962: l_third_party_id ja_cn_journal_lines.third_party_id%type;
1963: l_third_party_type ja_cn_journal_lines.third_party_type%type;

Line 1960: -- l_Status_Code Fnd_Lookup_Values.Lookup_Code%TYPE;

1956: l_Result boolean;
1957: l_Conc_Succ BOOLEAN;
1958: l_Post_Fail EXCEPTION;
1959: -- l_Phase_Code Fnd_Lookup_Values.Lookup_Code%TYPE;
1960: -- l_Status_Code Fnd_Lookup_Values.Lookup_Code%TYPE;
1961: l_third_party_number ja_cn_journal_lines.third_party_number%type;
1962: l_third_party_id ja_cn_journal_lines.third_party_id%type;
1963: l_third_party_type ja_cn_journal_lines.third_party_type%type;
1964: l_project_number ja_cn_journal_lines.project_number%type;