APPS.JA_CN_ITEMIZATION_INTERFACE dependencies on JA_CN_ITEM_INTERFACE_S

Line 916: l_sql:='update ja_cn_item_interface set '

912: exit when c_Inst_segments%notfound;
913: end loop;
914: close c_Inst_segments;
915:
916: l_sql:='update ja_cn_item_interface set '
917: || l_Company_Column_Name ||' = ''' || l_Company_value ||''', '
918: || l_Account_Column_Name ||' = ''' || l_Account_value ||''', '
919: || l_Cost_CRT_Column_Name ||' = ''' || l_Cost_CRT_value ||'''
920: where rowid='''||l_rowid||'''';

Line 1759: L_STATUS_CODE JA_CN_ITEM_INTERFACE.STATUS%TYPE;

1755: L_LE_NAME HR_ALL_ORGANIZATION_UNITS.NAME%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:

Line 2389: SELECT ja_cn_item_interface_s.NEXTVAL into l_header_id FROM Dual;

2385: open c_journal_group;
2386: loop
2387: fetch c_journal_group into l_journal_group;
2388: exit when c_journal_group%notfound;
2389: SELECT ja_cn_item_interface_s.NEXTVAL into l_header_id FROM Dual;
2390: update ja_cn_journal_lines
2391: set je_header_id = l_header_id
2392: where status = 'U'
2393: and je_header_id = l_journal_group;