[Home] [Help]
78: l_attribute_column4third_party ja_cn_dff_assignments.attribute_column%TYPE;
79: l_attribute_column4personnel ja_cn_dff_assignments.attribute_column%TYPE;
80: l_attribute_column4project ja_cn_dff_assignments.attribute_column%TYPE;
81: l_account_segment ja_cn_journal_lines.account_segment%TYPE;
82: l_ja_cn_subsidiary_gbl_tmp_row ja_cn_subsidiary_gt%ROWTYPE;
83: l_journal_lines_gbl_tmp_row ja_cn_journal_lines_gt%ROWTYPE;
84: l_sql_stmt VARCHAR2(30000) := '';
85: l_journal_number ja_cn_journal_lines_gt.journal_number%TYPE := '';
86: l_journal_line_number NUMBER := 0;
192: period_name
193: @COLUMN_CLAUSE
194: ) ' ||
195: prefix_a ||
196: ' left join JA_CN_SUBSIDIARY_GT s on ' ||
197: prefix_a ||
198: '.account_segment=s.ACCOUNT_SEGMENT_VALUE' ||
199: ' LEFT JOIN gl_je_categories_vl ' ||
200: prefix_b || ' ON ' ||
244: (end_date BETWEEN l_start_date AND l_end_date)))
245: AND ledger_id = p_ledger_id;--set_of_books_id = l_set_of_books_id;
246:
247: CURSOR c_in_ja_cn_subsidiary_gbl_tmp IS
248: SELECT * FROM ja_cn_subsidiary_gt;
249:
250: CURSOR c_in_journal_lines_gbl_tmp IS
251: SELECT *
252: FROM ja_cn_journal_lines_gt
448: 'Fetched account segments start below:');
449:
450: END IF;
451: --the context code is not necessary to be a condition to query out the signs for subsidiary
452: l_sql_stmt := 'insert into JA_CN_SUBSIDIARY_GT (ACCOUNT_SEGMENT_VALUE, HAS_THIRD_PARTY,HAS_COST_CENTER,HAS_PERSONNEL,HAS_PROJECT) select flex_value,' ||
453: nvl(to_char(l_attribute_column4third_party), 'null') || ',' ||
454: nvl(to_char(l_attribute_column4cost_center), 'null') || ',' ||
455: nvl(to_char(l_attribute_column4personnel), 'null') || ',' ||
456: nvl(to_char(l_attribute_column4project), 'null') ||