APPS.JA_CN_FSG_FORMULA_EXTRACT_PKG dependencies on JA_CN_CFS_ROW_CGS_GT

Line 86: ja_cn_cfs_row_cgs_gt

82: IS
83: SELECT
84: axis_seq
85: FROM
86: ja_cn_cfs_row_cgs_gt
87: WHERE axis_set_id=ln_axis_set_id
88: AND display_flag='Y'
89: ORDER BY axis_seq
90: FOR UPDATE;

Line 100: ja_cn_cfs_row_cgs_gt

96: ,change_sign_flag
97: ,rowcnt
98: ,lincnt
99: FROM
100: ja_cn_cfs_row_cgs_gt
101: WHERE axis_set_id=ln_axis_set_id
102: AND axis_seq = ln_axis_seq
103: AND display_flag='Y';
104:

Line 113: ,ja_cn_cfs_row_cgs_gt jccrcg

109: ,jccrcg.lincnt
110: ,jccrcg.change_sign_flag
111: FROM
112: ja_cn_cfs_calculations_gt jcccg
113: ,ja_cn_cfs_row_cgs_gt jccrcg
114: WHERE jcccg.axis_set_id=ln_axis_set_id
115: AND jcccg.axis_seq=ln_axis_seq
116: AND jcccg.axis_set_id=jccrcg.axis_set_id
117: AND jcccg.cal_axis_seq=jccrcg.axis_seq

Line 149: --ja_cn_cfs_row_cgs_gt according to parameters

145: END IF;
146:
147: --Commented by Jianchao Chi for bug 11675682
148: --1.Populate formula data to table ja_cn_cfs_calculations_gt and
149: --ja_cn_cfs_row_cgs_gt according to parameters
150: --Populate_Formula(pn_coa =>ln_coa
151: -- ,pn_axis_set_id =>ln_axis_set_id
152: -- ,pn_axis_seq => ln_axis_seq);
153:

Line 189: ja_cn_cfs_row_cgs_gt

185: lv_lincnt:='l1'||lpad(to_char(ln_row_count),5,'0');
186:
187: --Update current row with row count and line count
188: UPDATE
189: ja_cn_cfs_row_cgs_gt
190: SET
191: rowcnt=lv_rowcnt
192: ,lincnt=lv_lincnt
193: WHERE CURRENT OF c_axis_seq;

Line 203: ja_cn_cfs_row_cgs_gt

199:
200: SELECT COUNT(*)
201: INTO ln_row_count
202: FROM
203: ja_cn_cfs_row_cgs_gt
204: WHERE axis_set_id=ln_axis_set_id
205: AND axis_seq = ln_axis_seq
206: AND display_flag='Y'
207: AND calculation_flag='Y';

Line 601: --Insert current item(Row) into the tempoary table 'ja_cn_cfs_row_cgs_gt'

597: END LOOP; --WHILE c_report_calculation%FOUND
598:
599: CLOSE c_report_calculations;
600:
601: --Insert current item(Row) into the tempoary table 'ja_cn_cfs_row_cgs_gt'
602: --and set value of the column 'CALCULATION_FLAG' as 'Y'. If current item(Row) has calcuation lines with
603: --wrong operator, then set value of the column 'TYPE' as 'E'
604:
605: IF lv_exit_flag='Y'

Line 614: ja_cn_cfs_row_cgs_gt

610: END IF; --lv_exit_flag='Y'
611:
612: INSERT
613: INTO
614: ja_cn_cfs_row_cgs_gt
615: (application_id
616: ,axis_set_id
617: ,axis_seq
618: ,type

Line 648: ja_cn_cfs_row_cgs_gt

644: AND rrc.axis_seq<=ln_axis_seq;
645:
646: --Update current row with row count and line count
647: UPDATE
648: ja_cn_cfs_row_cgs_gt
649: SET
650: rowcnt='r1'||lpad(to_char(ln_row_count),5,'0')
651: ,lincnt='l1'||lpad(to_char(ln_row_count),5,'0')
652: WHERE