APPS.JA_CN_PS_CYB_EXPORT_PKG dependencies on JA_CN_UTILITY

Line 112: lv_bea_cursor_sql := lv_bea_cursor_sql || ' WHERE JA_CN_UTILITY.get_balancing_segment(gcc.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value';

108:
109: --3) BSV condition
110: lv_bea_cursor_sql:= lv_bea_cursor_sql || ' AND EXISTS (SELECT llbg.Bal_Seg_Value ';
111: lv_bea_cursor_sql := lv_bea_cursor_sql || ' FROM ja_cn_ledger_le_bsv_gt llbg';
112: lv_bea_cursor_sql := lv_bea_cursor_sql || ' WHERE JA_CN_UTILITY.get_balancing_segment(gcc.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value';
113: lv_bea_cursor_sql := lv_bea_cursor_sql || ' AND llbg.Ledger_Id = ' || pn_ledger_id; --parameter: pn_ledger_id
114: lv_bea_cursor_sql := lv_bea_cursor_sql || ' AND llbg.Legal_Entity_Id =' || pn_legal_entity_id || ')'; --parameter: pn_legal_entity_id;
115: --4) Period condition
116: lv_bea_cursor_sql := lv_bea_cursor_sql || ' AND Gle.period_set_name = Gp.period_set_name';

Line 264: IF ja_cn_utility.populate_ledger_le_bsv_gt(pn_ledger_id, pn_legal_entity_id) <> 'S'

260: --Step0: Populate balancing segment values to table ja_cn_ledger_le_bsv_gt
261: DELETE
262: FROM JA_CN_LEDGER_LE_BSV_GT;
263: COMMIT ;
264: IF ja_cn_utility.populate_ledger_le_bsv_gt(pn_ledger_id, pn_legal_entity_id) <> 'S'
265: THEN
266: RETURN;
267: END IF;
268:

Line 269: lv_exp_fun_cat_segment_column := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CEFC'

265: THEN
266: RETURN;
267: END IF;
268:
269: lv_exp_fun_cat_segment_column := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CEFC'
270: ,pn_application_id => 101
271: ,pn_coa_id => pn_coa_id);
272: lv_exp_eco_cat_segment_column := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CEEC'
273: ,pn_application_id => 101

Line 272: lv_exp_eco_cat_segment_column := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CEEC'

268:
269: lv_exp_fun_cat_segment_column := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CEFC'
270: ,pn_application_id => 101
271: ,pn_coa_id => pn_coa_id);
272: lv_exp_eco_cat_segment_column := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CEEC'
273: ,pn_application_id => 101
274: ,pn_coa_id => pn_coa_id);
275: lv_project_segment_column := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CPRO'
276: ,pn_application_id => 101

Line 275: lv_project_segment_column := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CPRO'

271: ,pn_coa_id => pn_coa_id);
272: lv_exp_eco_cat_segment_column := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CEEC'
273: ,pn_application_id => 101
274: ,pn_coa_id => pn_coa_id);
275: lv_project_segment_column := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CPRO'
276: ,pn_application_id => 101
277: ,pn_coa_id => pn_coa_id);
278:
279: lv_budget_type_segment_column := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CBTY'

Line 279: lv_budget_type_segment_column := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CBTY'

275: lv_project_segment_column := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CPRO'
276: ,pn_application_id => 101
277: ,pn_coa_id => pn_coa_id);
278:
279: lv_budget_type_segment_column := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CBTY'
280: ,pn_application_id => 101
281: ,pn_coa_id => pn_coa_id);
282: lv_budget_type_value := JA_CN_UTILITY.Get_Budget_Type_Value(pn_coa_id => pn_coa_id
283: ,pv_flexfield_code => 'LYBA'

Line 282: lv_budget_type_value := JA_CN_UTILITY.Get_Budget_Type_Value(pn_coa_id => pn_coa_id

278:
279: lv_budget_type_segment_column := JA_CN_UTILITY.Get_Attribute_Column(pv_flexfield_code => 'CBTY'
280: ,pn_application_id => 101
281: ,pn_coa_id => pn_coa_id);
282: lv_budget_type_value := JA_CN_UTILITY.Get_Budget_Type_Value(pn_coa_id => pn_coa_id
283: ,pv_flexfield_code => 'LYBA'
284: );
285:
286: --fixed bug 10316565 by ChuanLing Shao

Line 350: lv_bi_cursor_sql := lv_bi_cursor_sql || ' WHERE JA_CN_UTILITY.get_balancing_segment(gcc.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value';

346: END IF;
347: --3) BSV condition
348: lv_bi_cursor_sql := lv_bi_cursor_sql || ' AND EXISTS (SELECT llbg.Bal_Seg_Value ';
349: lv_bi_cursor_sql := lv_bi_cursor_sql || ' FROM ja_cn_ledger_le_bsv_gt llbg';
350: lv_bi_cursor_sql := lv_bi_cursor_sql || ' WHERE JA_CN_UTILITY.get_balancing_segment(gcc.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value';
351: lv_bi_cursor_sql := lv_bi_cursor_sql || ' AND llbg.Ledger_Id = ' || pn_ledger_id; --parameter: pn_ledger_id
352: lv_bi_cursor_sql := lv_bi_cursor_sql || ' AND llbg.Legal_Entity_Id =' || pn_legal_entity_id || ')'; --parameter: pn_legal_entity_id;
353: --4) Period condition
354: lv_bi_cursor_sql := lv_bi_cursor_sql || ' AND Gle.period_set_name = Gp.period_set_name';

Line 402: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENT_YEAR_BUDGET_TARGET'

398: ,lv_project;
399: */
400: EXIT WHEN lc_budget_information%NOTFOUND;
401:
402: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENT_YEAR_BUDGET_TARGET'
403: ,Ja_Cn_Utility.GV_TAG_TYPE_START
404: );
405: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR'
406: ,pv_accounting_year

Line 403: ,Ja_Cn_Utility.GV_TAG_TYPE_START

399: */
400: EXIT WHEN lc_budget_information%NOTFOUND;
401:
402: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENT_YEAR_BUDGET_TARGET'
403: ,Ja_Cn_Utility.GV_TAG_TYPE_START
404: );
405: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR'
406: ,pv_accounting_year
407: );

Line 405: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR'

401:
402: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENT_YEAR_BUDGET_TARGET'
403: ,Ja_Cn_Utility.GV_TAG_TYPE_START
404: );
405: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR'
406: ,pv_accounting_year
407: );
408: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
409: ,ln_accounting_period_num

Line 408: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'

404: );
405: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_YEAR'
406: ,pv_accounting_year
407: );
408: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
409: ,ln_accounting_period_num
410: );
411: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_CODE'
412: ,lv_exp_fun_cat

Line 411: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_CODE'

407: );
408: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
409: ,ln_accounting_period_num
410: );
411: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_CODE'
412: ,lv_exp_fun_cat
413: );
414: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_NAME'
415: ,JA_CN_UTILITY.Get_Segment_Value_Desc(pv_flexfield_code => 'CEFC'

Line 414: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_NAME'

410: );
411: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_CODE'
412: ,lv_exp_fun_cat
413: );
414: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_NAME'
415: ,JA_CN_UTILITY.Get_Segment_Value_Desc(pv_flexfield_code => 'CEFC'
416: ,pv_flex_value => lv_exp_fun_cat
417: ,pn_coa_id => pn_coa_id)
418: );

Line 415: ,JA_CN_UTILITY.Get_Segment_Value_Desc(pv_flexfield_code => 'CEFC'

411: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_CODE'
412: ,lv_exp_fun_cat
413: );
414: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_NAME'
415: ,JA_CN_UTILITY.Get_Segment_Value_Desc(pv_flexfield_code => 'CEFC'
416: ,pv_flex_value => lv_exp_fun_cat
417: ,pn_coa_id => pn_coa_id)
418: );
419: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_CODE'

Line 419: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_CODE'

415: ,JA_CN_UTILITY.Get_Segment_Value_Desc(pv_flexfield_code => 'CEFC'
416: ,pv_flex_value => lv_exp_fun_cat
417: ,pn_coa_id => pn_coa_id)
418: );
419: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_CODE'
420: ,lv_exp_eco_cat
421: );
422: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_NAME'
423: ,JA_CN_UTILITY.Get_Segment_Value_Desc(pv_flexfield_code => 'CEEC'

Line 422: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_NAME'

418: );
419: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_CODE'
420: ,lv_exp_eco_cat
421: );
422: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_NAME'
423: ,JA_CN_UTILITY.Get_Segment_Value_Desc(pv_flexfield_code => 'CEEC'
424: ,pv_flex_value => lv_exp_eco_cat
425: ,pn_coa_id => pn_coa_id)
426: );

Line 423: ,JA_CN_UTILITY.Get_Segment_Value_Desc(pv_flexfield_code => 'CEEC'

419: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_CODE'
420: ,lv_exp_eco_cat
421: );
422: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_NAME'
423: ,JA_CN_UTILITY.Get_Segment_Value_Desc(pv_flexfield_code => 'CEEC'
424: ,pv_flex_value => lv_exp_eco_cat
425: ,pn_coa_id => pn_coa_id)
426: );
427: Ja_Cn_Utility.Add_Child_Node('PROJECT_ID'

Line 427: Ja_Cn_Utility.Add_Child_Node('PROJECT_ID'

423: ,JA_CN_UTILITY.Get_Segment_Value_Desc(pv_flexfield_code => 'CEEC'
424: ,pv_flex_value => lv_exp_eco_cat
425: ,pn_coa_id => pn_coa_id)
426: );
427: Ja_Cn_Utility.Add_Child_Node('PROJECT_ID'
428: ,lv_project
429: );
430: lv_fun_nature_code := JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'AFTY'
431: ,pv_project_id => lv_project

Line 430: lv_fun_nature_code := JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'AFTY'

426: );
427: Ja_Cn_Utility.Add_Child_Node('PROJECT_ID'
428: ,lv_project
429: );
430: lv_fun_nature_code := JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'AFTY'
431: ,pv_project_id => lv_project
432: ,pn_coa_id => pn_coa_id);
433:
434: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_CODE'

Line 434: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_CODE'

430: lv_fun_nature_code := JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'AFTY'
431: ,pv_project_id => lv_project
432: ,pn_coa_id => pn_coa_id);
433:
434: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_CODE'
435: ,lv_fun_nature_code
436: );
437: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_NAME'
438: ,JA_CN_UTILITY.Get_Attribute_Value_Desc(pv_flexfield_code => 'AFTY'

Line 437: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_NAME'

433:
434: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_CODE'
435: ,lv_fun_nature_code
436: );
437: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_NAME'
438: ,JA_CN_UTILITY.Get_Attribute_Value_Desc(pv_flexfield_code => 'AFTY'
439: ,pv_flex_value => lv_fun_nature_code
440: ,pn_coa_id => pn_coa_id)
441: );

Line 438: ,JA_CN_UTILITY.Get_Attribute_Value_Desc(pv_flexfield_code => 'AFTY'

434: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_CODE'
435: ,lv_fun_nature_code
436: );
437: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_NAME'
438: ,JA_CN_UTILITY.Get_Attribute_Value_Desc(pv_flexfield_code => 'AFTY'
439: ,pv_flex_value => lv_fun_nature_code
440: ,pn_coa_id => pn_coa_id)
441: );
442: lv_bud_source_code := JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'ABSO'

Line 442: lv_bud_source_code := JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'ABSO'

438: ,JA_CN_UTILITY.Get_Attribute_Value_Desc(pv_flexfield_code => 'AFTY'
439: ,pv_flex_value => lv_fun_nature_code
440: ,pn_coa_id => pn_coa_id)
441: );
442: lv_bud_source_code := JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'ABSO'
443: ,pv_project_id => lv_project
444: ,pn_coa_id => pn_coa_id);
445: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_CODE'
446: ,lv_bud_source_code

Line 445: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_CODE'

441: );
442: lv_bud_source_code := JA_CN_UTILITY.Get_Attribute_Value(pv_flexfield_code => 'ABSO'
443: ,pv_project_id => lv_project
444: ,pn_coa_id => pn_coa_id);
445: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_CODE'
446: ,lv_bud_source_code
447: );
448: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_NAME'
449: ,JA_CN_UTILITY.Get_Attribute_Value_Desc(pv_flexfield_code => 'ABSO'

Line 448: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_NAME'

444: ,pn_coa_id => pn_coa_id);
445: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_CODE'
446: ,lv_bud_source_code
447: );
448: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_NAME'
449: ,JA_CN_UTILITY.Get_Attribute_Value_Desc(pv_flexfield_code => 'ABSO'
450: ,pv_flex_value => lv_bud_source_code
451: ,pn_coa_id => pn_coa_id)
452: );

Line 449: ,JA_CN_UTILITY.Get_Attribute_Value_Desc(pv_flexfield_code => 'ABSO'

445: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_CODE'
446: ,lv_bud_source_code
447: );
448: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_NAME'
449: ,JA_CN_UTILITY.Get_Attribute_Value_Desc(pv_flexfield_code => 'ABSO'
450: ,pv_flex_value => lv_bud_source_code
451: ,pn_coa_id => pn_coa_id)
452: );
453: ln_current_year_budget_amt := Get_Budget_Expenditure_Amount(pn_ledger_id => pn_ledger_id

Line 462: ,pv_budget_type_value => JA_CN_UTILITY.Get_Budget_Type_Value(pn_coa_id => pn_coa_id

458: ,pv_exp_eco_category_code => lv_exp_eco_cat
459: ,pv_project_segment_column => lv_project_segment_column
460: ,pv_project_id => lv_project
461: ,pv_budget_type_segment_column => lv_budget_type_segment_column
462: ,pv_budget_type_value => JA_CN_UTILITY.Get_Budget_Type_Value(pn_coa_id => pn_coa_id
463: ,pv_flexfield_code => 'CYBA')
464: ,pv_accounting_year => pv_accounting_year
465: ,pv_period_to => NULL
466: );

Line 467: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_AMOUNT'

463: ,pv_flexfield_code => 'CYBA')
464: ,pv_accounting_year => pv_accounting_year
465: ,pv_period_to => NULL
466: );
467: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_AMOUNT'
468: ,ln_current_year_budget_amt
469: ,Ja_Cn_Utility.GV_TYPE_NUMBER
470: ,Ja_Cn_Utility.GV_REQUIRED_YES
471: );

Line 469: ,Ja_Cn_Utility.GV_TYPE_NUMBER

465: ,pv_period_to => NULL
466: );
467: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_AMOUNT'
468: ,ln_current_year_budget_amt
469: ,Ja_Cn_Utility.GV_TYPE_NUMBER
470: ,Ja_Cn_Utility.GV_REQUIRED_YES
471: );
472: ln_accumulated_inc_amount := Get_Budget_Expenditure_Amount(pn_ledger_id => pn_ledger_id
473: ,pn_legal_entity_id => pn_legal_entity_id

Line 470: ,Ja_Cn_Utility.GV_REQUIRED_YES

466: );
467: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_AMOUNT'
468: ,ln_current_year_budget_amt
469: ,Ja_Cn_Utility.GV_TYPE_NUMBER
470: ,Ja_Cn_Utility.GV_REQUIRED_YES
471: );
472: ln_accumulated_inc_amount := Get_Budget_Expenditure_Amount(pn_ledger_id => pn_ledger_id
473: ,pn_legal_entity_id => pn_legal_entity_id
474: ,pv_exp_fun_cat_segment_column => lv_exp_fun_cat_segment_column

Line 481: ,pv_budget_type_value => JA_CN_UTILITY.Get_Budget_Type_Value(pn_coa_id => pn_coa_id

477: ,pv_exp_eco_category_code => lv_exp_eco_cat
478: ,pv_project_segment_column => lv_project_segment_column
479: ,pv_project_id => lv_project
480: ,pv_budget_type_segment_column => lv_budget_type_segment_column
481: ,pv_budget_type_value => JA_CN_UTILITY.Get_Budget_Type_Value(pn_coa_id => pn_coa_id
482: ,pv_flexfield_code => 'ICPA')
483: ,pv_accounting_year => pv_accounting_year
484: ,pv_period_to => lv_period_name
485: );

Line 486: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_INCREASING_AMOUNT'

482: ,pv_flexfield_code => 'ICPA')
483: ,pv_accounting_year => pv_accounting_year
484: ,pv_period_to => lv_period_name
485: );
486: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_INCREASING_AMOUNT'
487: ,ln_accumulated_inc_amount
488: ,Ja_Cn_Utility.GV_TYPE_NUMBER
489: ,Ja_Cn_Utility.GV_REQUIRED_YES
490: );

Line 488: ,Ja_Cn_Utility.GV_TYPE_NUMBER

484: ,pv_period_to => lv_period_name
485: );
486: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_INCREASING_AMOUNT'
487: ,ln_accumulated_inc_amount
488: ,Ja_Cn_Utility.GV_TYPE_NUMBER
489: ,Ja_Cn_Utility.GV_REQUIRED_YES
490: );
491: ln_accumulated_dec_amount := Get_Budget_Expenditure_Amount(pn_ledger_id => pn_ledger_id
492: ,pn_legal_entity_id => pn_legal_entity_id

Line 489: ,Ja_Cn_Utility.GV_REQUIRED_YES

485: );
486: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_INCREASING_AMOUNT'
487: ,ln_accumulated_inc_amount
488: ,Ja_Cn_Utility.GV_TYPE_NUMBER
489: ,Ja_Cn_Utility.GV_REQUIRED_YES
490: );
491: ln_accumulated_dec_amount := Get_Budget_Expenditure_Amount(pn_ledger_id => pn_ledger_id
492: ,pn_legal_entity_id => pn_legal_entity_id
493: ,pv_exp_fun_cat_segment_column => lv_exp_fun_cat_segment_column

Line 500: ,pv_budget_type_value => JA_CN_UTILITY.Get_Budget_Type_Value(pn_coa_id => pn_coa_id

496: ,pv_exp_eco_category_code => lv_exp_eco_cat
497: ,pv_project_segment_column => lv_project_segment_column
498: ,pv_project_id => lv_project
499: ,pv_budget_type_segment_column => lv_budget_type_segment_column
500: ,pv_budget_type_value => JA_CN_UTILITY.Get_Budget_Type_Value(pn_coa_id => pn_coa_id
501: ,pv_flexfield_code => 'DCPA')
502: ,pv_accounting_year => pv_accounting_year
503: ,pv_period_to => lv_period_name
504: );

Line 505: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_DECREASING_AMOUNT'

501: ,pv_flexfield_code => 'DCPA')
502: ,pv_accounting_year => pv_accounting_year
503: ,pv_period_to => lv_period_name
504: );
505: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_DECREASING_AMOUNT'
506: ,ln_accumulated_dec_amount
507: ,Ja_Cn_Utility.GV_TYPE_NUMBER
508: ,Ja_Cn_Utility.GV_REQUIRED_YES
509: );

Line 507: ,Ja_Cn_Utility.GV_TYPE_NUMBER

503: ,pv_period_to => lv_period_name
504: );
505: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_DECREASING_AMOUNT'
506: ,ln_accumulated_dec_amount
507: ,Ja_Cn_Utility.GV_TYPE_NUMBER
508: ,Ja_Cn_Utility.GV_REQUIRED_YES
509: );
510: Ja_Cn_Utility.Add_Child_Node('TOTAL_AMOUNT'
511: ,NVL(ln_current_year_budget_amt,0)

Line 508: ,Ja_Cn_Utility.GV_REQUIRED_YES

504: );
505: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_DECREASING_AMOUNT'
506: ,ln_accumulated_dec_amount
507: ,Ja_Cn_Utility.GV_TYPE_NUMBER
508: ,Ja_Cn_Utility.GV_REQUIRED_YES
509: );
510: Ja_Cn_Utility.Add_Child_Node('TOTAL_AMOUNT'
511: ,NVL(ln_current_year_budget_amt,0)
512: +NVL(ln_accumulated_inc_amount,0)

Line 510: Ja_Cn_Utility.Add_Child_Node('TOTAL_AMOUNT'

506: ,ln_accumulated_dec_amount
507: ,Ja_Cn_Utility.GV_TYPE_NUMBER
508: ,Ja_Cn_Utility.GV_REQUIRED_YES
509: );
510: Ja_Cn_Utility.Add_Child_Node('TOTAL_AMOUNT'
511: ,NVL(ln_current_year_budget_amt,0)
512: +NVL(ln_accumulated_inc_amount,0)
513: -NVL(ln_accumulated_dec_amount,0)
514: );

Line 515: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENT_YEAR_BUDGET_TARGET'

511: ,NVL(ln_current_year_budget_amt,0)
512: +NVL(ln_accumulated_inc_amount,0)
513: -NVL(ln_accumulated_dec_amount,0)
514: );
515: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENT_YEAR_BUDGET_TARGET'
516: ,Ja_Cn_Utility.GV_TAG_TYPE_END
517: );
518: ln_rec_count := ln_rec_count + 1; -- added for fixing bug#: 10103231
519: END LOOP;

Line 516: ,Ja_Cn_Utility.GV_TAG_TYPE_END

512: +NVL(ln_accumulated_inc_amount,0)
513: -NVL(ln_accumulated_dec_amount,0)
514: );
515: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENT_YEAR_BUDGET_TARGET'
516: ,Ja_Cn_Utility.GV_TAG_TYPE_END
517: );
518: ln_rec_count := ln_rec_count + 1; -- added for fixing bug#: 10103231
519: END LOOP;
520: CLOSE lc_budget_information;

Line 530: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENT_YEAR_BUDGET_TARGET'

526: -- added for fixing bug#: 10103231 --BEGIN--
527: -- There is no data found for employee record
528: IF ln_rec_count = 0
529: THEN
530: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENT_YEAR_BUDGET_TARGET'
531: ,Ja_Cn_Utility.GV_TAG_TYPE_START
532: );
533: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
534: ,pv_accounting_year

Line 531: ,Ja_Cn_Utility.GV_TAG_TYPE_START

527: -- There is no data found for employee record
528: IF ln_rec_count = 0
529: THEN
530: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENT_YEAR_BUDGET_TARGET'
531: ,Ja_Cn_Utility.GV_TAG_TYPE_START
532: );
533: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
534: ,pv_accounting_year
535: ,4

Line 533: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'

529: THEN
530: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENT_YEAR_BUDGET_TARGET'
531: ,Ja_Cn_Utility.GV_TAG_TYPE_START
532: );
533: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
534: ,pv_accounting_year
535: ,4
536: ,Ja_Cn_Utility.GV_REQUIRED_YES
537: ,Ja_Cn_Utility.GV_MODULE_GLSI

Line 536: ,Ja_Cn_Utility.GV_REQUIRED_YES

532: );
533: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
534: ,pv_accounting_year
535: ,4
536: ,Ja_Cn_Utility.GV_REQUIRED_YES
537: ,Ja_Cn_Utility.GV_MODULE_GLSI
538: );
539: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
540: ,NULL

Line 537: ,Ja_Cn_Utility.GV_MODULE_GLSI

533: Ja_Cn_Utility.Add_Fixed_Child_Node('ACCOUNTING_YEAR'
534: ,pv_accounting_year
535: ,4
536: ,Ja_Cn_Utility.GV_REQUIRED_YES
537: ,Ja_Cn_Utility.GV_MODULE_GLSI
538: );
539: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
540: ,NULL
541: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 539: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'

535: ,4
536: ,Ja_Cn_Utility.GV_REQUIRED_YES
537: ,Ja_Cn_Utility.GV_MODULE_GLSI
538: );
539: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
540: ,NULL
541: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
542: ,Ja_Cn_Utility.GV_REQUIRED_YES
543: );

Line 541: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

537: ,Ja_Cn_Utility.GV_MODULE_GLSI
538: );
539: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
540: ,NULL
541: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
542: ,Ja_Cn_Utility.GV_REQUIRED_YES
543: );
544: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_CODE'
545: ,NULL

Line 542: ,Ja_Cn_Utility.GV_REQUIRED_YES

538: );
539: Ja_Cn_Utility.Add_Child_Node('ACCOUNTING_PERIOD_NUMBER'
540: ,NULL
541: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
542: ,Ja_Cn_Utility.GV_REQUIRED_YES
543: );
544: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_CODE'
545: ,NULL
546: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 544: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_CODE'

540: ,NULL
541: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
542: ,Ja_Cn_Utility.GV_REQUIRED_YES
543: );
544: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_CODE'
545: ,NULL
546: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
547: ,Ja_Cn_Utility.GV_REQUIRED_YES
548: );

Line 546: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

542: ,Ja_Cn_Utility.GV_REQUIRED_YES
543: );
544: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_CODE'
545: ,NULL
546: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
547: ,Ja_Cn_Utility.GV_REQUIRED_YES
548: );
549: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_NAME'
550: ,NULL

Line 547: ,Ja_Cn_Utility.GV_REQUIRED_YES

543: );
544: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_CODE'
545: ,NULL
546: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
547: ,Ja_Cn_Utility.GV_REQUIRED_YES
548: );
549: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_NAME'
550: ,NULL
551: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 549: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_NAME'

545: ,NULL
546: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
547: ,Ja_Cn_Utility.GV_REQUIRED_YES
548: );
549: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_NAME'
550: ,NULL
551: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
552: ,Ja_Cn_Utility.GV_REQUIRED_YES
553: );

Line 551: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

547: ,Ja_Cn_Utility.GV_REQUIRED_YES
548: );
549: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_NAME'
550: ,NULL
551: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
552: ,Ja_Cn_Utility.GV_REQUIRED_YES
553: );
554: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_CODE'
555: ,NULL

Line 552: ,Ja_Cn_Utility.GV_REQUIRED_YES

548: );
549: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_FUN_CATEGORY_NAME'
550: ,NULL
551: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
552: ,Ja_Cn_Utility.GV_REQUIRED_YES
553: );
554: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_CODE'
555: ,NULL
556: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 554: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_CODE'

550: ,NULL
551: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
552: ,Ja_Cn_Utility.GV_REQUIRED_YES
553: );
554: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_CODE'
555: ,NULL
556: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
557: ,Ja_Cn_Utility.GV_REQUIRED_YES
558: );

Line 556: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

552: ,Ja_Cn_Utility.GV_REQUIRED_YES
553: );
554: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_CODE'
555: ,NULL
556: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
557: ,Ja_Cn_Utility.GV_REQUIRED_YES
558: );
559: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_NAME'
560: ,NULL

Line 557: ,Ja_Cn_Utility.GV_REQUIRED_YES

553: );
554: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_CODE'
555: ,NULL
556: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
557: ,Ja_Cn_Utility.GV_REQUIRED_YES
558: );
559: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_NAME'
560: ,NULL
561: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 559: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_NAME'

555: ,NULL
556: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
557: ,Ja_Cn_Utility.GV_REQUIRED_YES
558: );
559: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_NAME'
560: ,NULL
561: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
562: ,Ja_Cn_Utility.GV_REQUIRED_YES
563: );

Line 561: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

557: ,Ja_Cn_Utility.GV_REQUIRED_YES
558: );
559: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_NAME'
560: ,NULL
561: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
562: ,Ja_Cn_Utility.GV_REQUIRED_YES
563: );
564: Ja_Cn_Utility.Add_Child_Node('PROJECT_ID'
565: ,NULL

Line 562: ,Ja_Cn_Utility.GV_REQUIRED_YES

558: );
559: Ja_Cn_Utility.Add_Child_Node('EXPENDITURE_ECO_CATEGORY_NAME'
560: ,NULL
561: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
562: ,Ja_Cn_Utility.GV_REQUIRED_YES
563: );
564: Ja_Cn_Utility.Add_Child_Node('PROJECT_ID'
565: ,NULL
566: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 564: Ja_Cn_Utility.Add_Child_Node('PROJECT_ID'

560: ,NULL
561: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
562: ,Ja_Cn_Utility.GV_REQUIRED_YES
563: );
564: Ja_Cn_Utility.Add_Child_Node('PROJECT_ID'
565: ,NULL
566: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
567: ,Ja_Cn_Utility.GV_REQUIRED_YES
568: );

Line 566: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

562: ,Ja_Cn_Utility.GV_REQUIRED_YES
563: );
564: Ja_Cn_Utility.Add_Child_Node('PROJECT_ID'
565: ,NULL
566: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
567: ,Ja_Cn_Utility.GV_REQUIRED_YES
568: );
569: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_CODE'
570: ,NULL

Line 567: ,Ja_Cn_Utility.GV_REQUIRED_YES

563: );
564: Ja_Cn_Utility.Add_Child_Node('PROJECT_ID'
565: ,NULL
566: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
567: ,Ja_Cn_Utility.GV_REQUIRED_YES
568: );
569: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_CODE'
570: ,NULL
571: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 569: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_CODE'

565: ,NULL
566: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
567: ,Ja_Cn_Utility.GV_REQUIRED_YES
568: );
569: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_CODE'
570: ,NULL
571: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
572: ,Ja_Cn_Utility.GV_REQUIRED_YES
573: );

Line 571: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

567: ,Ja_Cn_Utility.GV_REQUIRED_YES
568: );
569: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_CODE'
570: ,NULL
571: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
572: ,Ja_Cn_Utility.GV_REQUIRED_YES
573: );
574: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_NAME'
575: ,NULL

Line 572: ,Ja_Cn_Utility.GV_REQUIRED_YES

568: );
569: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_CODE'
570: ,NULL
571: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
572: ,Ja_Cn_Utility.GV_REQUIRED_YES
573: );
574: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_NAME'
575: ,NULL
576: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 574: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_NAME'

570: ,NULL
571: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
572: ,Ja_Cn_Utility.GV_REQUIRED_YES
573: );
574: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_NAME'
575: ,NULL
576: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
577: ,Ja_Cn_Utility.GV_REQUIRED_YES
578: );

Line 576: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

572: ,Ja_Cn_Utility.GV_REQUIRED_YES
573: );
574: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_NAME'
575: ,NULL
576: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
577: ,Ja_Cn_Utility.GV_REQUIRED_YES
578: );
579: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_CODE'
580: ,NULL

Line 577: ,Ja_Cn_Utility.GV_REQUIRED_YES

573: );
574: Ja_Cn_Utility.Add_Child_Node('FUND_NATURE_NAME'
575: ,NULL
576: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
577: ,Ja_Cn_Utility.GV_REQUIRED_YES
578: );
579: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_CODE'
580: ,NULL
581: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 579: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_CODE'

575: ,NULL
576: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
577: ,Ja_Cn_Utility.GV_REQUIRED_YES
578: );
579: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_CODE'
580: ,NULL
581: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
582: ,Ja_Cn_Utility.GV_REQUIRED_YES
583: );

Line 581: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

577: ,Ja_Cn_Utility.GV_REQUIRED_YES
578: );
579: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_CODE'
580: ,NULL
581: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
582: ,Ja_Cn_Utility.GV_REQUIRED_YES
583: );
584: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_NAME'
585: ,NULL

Line 582: ,Ja_Cn_Utility.GV_REQUIRED_YES

578: );
579: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_CODE'
580: ,NULL
581: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
582: ,Ja_Cn_Utility.GV_REQUIRED_YES
583: );
584: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_NAME'
585: ,NULL
586: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

Line 584: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_NAME'

580: ,NULL
581: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
582: ,Ja_Cn_Utility.GV_REQUIRED_YES
583: );
584: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_NAME'
585: ,NULL
586: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
587: ,Ja_Cn_Utility.GV_REQUIRED_YES
588: );

Line 586: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2

582: ,Ja_Cn_Utility.GV_REQUIRED_YES
583: );
584: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_NAME'
585: ,NULL
586: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
587: ,Ja_Cn_Utility.GV_REQUIRED_YES
588: );
589: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_AMOUNT'
590: ,NULL

Line 587: ,Ja_Cn_Utility.GV_REQUIRED_YES

583: );
584: Ja_Cn_Utility.Add_Child_Node('BUDGET_SOURCE_NAME'
585: ,NULL
586: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
587: ,Ja_Cn_Utility.GV_REQUIRED_YES
588: );
589: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_AMOUNT'
590: ,NULL
591: ,Ja_Cn_Utility.GV_TYPE_NUMBER

Line 589: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_AMOUNT'

585: ,NULL
586: ,Ja_Cn_Utility.GV_TYPE_VARCHAR2
587: ,Ja_Cn_Utility.GV_REQUIRED_YES
588: );
589: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_AMOUNT'
590: ,NULL
591: ,Ja_Cn_Utility.GV_TYPE_NUMBER
592: ,Ja_Cn_Utility.GV_REQUIRED_YES
593: );

Line 591: ,Ja_Cn_Utility.GV_TYPE_NUMBER

587: ,Ja_Cn_Utility.GV_REQUIRED_YES
588: );
589: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_AMOUNT'
590: ,NULL
591: ,Ja_Cn_Utility.GV_TYPE_NUMBER
592: ,Ja_Cn_Utility.GV_REQUIRED_YES
593: );
594: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_INCREASING_AMOUNT'
595: ,NULL

Line 592: ,Ja_Cn_Utility.GV_REQUIRED_YES

588: );
589: Ja_Cn_Utility.Add_Child_Node('CURRENT_YEAR_BUDGET_AMOUNT'
590: ,NULL
591: ,Ja_Cn_Utility.GV_TYPE_NUMBER
592: ,Ja_Cn_Utility.GV_REQUIRED_YES
593: );
594: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_INCREASING_AMOUNT'
595: ,NULL
596: ,Ja_Cn_Utility.GV_TYPE_NUMBER

Line 594: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_INCREASING_AMOUNT'

590: ,NULL
591: ,Ja_Cn_Utility.GV_TYPE_NUMBER
592: ,Ja_Cn_Utility.GV_REQUIRED_YES
593: );
594: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_INCREASING_AMOUNT'
595: ,NULL
596: ,Ja_Cn_Utility.GV_TYPE_NUMBER
597: ,Ja_Cn_Utility.GV_REQUIRED_YES
598: );

Line 596: ,Ja_Cn_Utility.GV_TYPE_NUMBER

592: ,Ja_Cn_Utility.GV_REQUIRED_YES
593: );
594: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_INCREASING_AMOUNT'
595: ,NULL
596: ,Ja_Cn_Utility.GV_TYPE_NUMBER
597: ,Ja_Cn_Utility.GV_REQUIRED_YES
598: );
599: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_DECREASING_AMOUNT'
600: ,NULL

Line 597: ,Ja_Cn_Utility.GV_REQUIRED_YES

593: );
594: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_INCREASING_AMOUNT'
595: ,NULL
596: ,Ja_Cn_Utility.GV_TYPE_NUMBER
597: ,Ja_Cn_Utility.GV_REQUIRED_YES
598: );
599: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_DECREASING_AMOUNT'
600: ,NULL
601: ,Ja_Cn_Utility.GV_TYPE_NUMBER

Line 599: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_DECREASING_AMOUNT'

595: ,NULL
596: ,Ja_Cn_Utility.GV_TYPE_NUMBER
597: ,Ja_Cn_Utility.GV_REQUIRED_YES
598: );
599: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_DECREASING_AMOUNT'
600: ,NULL
601: ,Ja_Cn_Utility.GV_TYPE_NUMBER
602: ,Ja_Cn_Utility.GV_REQUIRED_YES
603: );

Line 601: ,Ja_Cn_Utility.GV_TYPE_NUMBER

597: ,Ja_Cn_Utility.GV_REQUIRED_YES
598: );
599: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_DECREASING_AMOUNT'
600: ,NULL
601: ,Ja_Cn_Utility.GV_TYPE_NUMBER
602: ,Ja_Cn_Utility.GV_REQUIRED_YES
603: );
604: Ja_Cn_Utility.Add_Child_Node('TOTAL_AMOUNT'
605: ,NULL

Line 602: ,Ja_Cn_Utility.GV_REQUIRED_YES

598: );
599: Ja_Cn_Utility.Add_Child_Node('ACCUMULATED_DECREASING_AMOUNT'
600: ,NULL
601: ,Ja_Cn_Utility.GV_TYPE_NUMBER
602: ,Ja_Cn_Utility.GV_REQUIRED_YES
603: );
604: Ja_Cn_Utility.Add_Child_Node('TOTAL_AMOUNT'
605: ,NULL
606: ,Ja_Cn_Utility.GV_TYPE_NUMBER

Line 604: Ja_Cn_Utility.Add_Child_Node('TOTAL_AMOUNT'

600: ,NULL
601: ,Ja_Cn_Utility.GV_TYPE_NUMBER
602: ,Ja_Cn_Utility.GV_REQUIRED_YES
603: );
604: Ja_Cn_Utility.Add_Child_Node('TOTAL_AMOUNT'
605: ,NULL
606: ,Ja_Cn_Utility.GV_TYPE_NUMBER
607: ,Ja_Cn_Utility.GV_REQUIRED_YES
608: );

Line 606: ,Ja_Cn_Utility.GV_TYPE_NUMBER

602: ,Ja_Cn_Utility.GV_REQUIRED_YES
603: );
604: Ja_Cn_Utility.Add_Child_Node('TOTAL_AMOUNT'
605: ,NULL
606: ,Ja_Cn_Utility.GV_TYPE_NUMBER
607: ,Ja_Cn_Utility.GV_REQUIRED_YES
608: );
609: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENT_YEAR_BUDGET_TARGET'
610: ,Ja_Cn_Utility.GV_TAG_TYPE_END

Line 607: ,Ja_Cn_Utility.GV_REQUIRED_YES

603: );
604: Ja_Cn_Utility.Add_Child_Node('TOTAL_AMOUNT'
605: ,NULL
606: ,Ja_Cn_Utility.GV_TYPE_NUMBER
607: ,Ja_Cn_Utility.GV_REQUIRED_YES
608: );
609: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENT_YEAR_BUDGET_TARGET'
610: ,Ja_Cn_Utility.GV_TAG_TYPE_END
611: );

Line 609: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENT_YEAR_BUDGET_TARGET'

605: ,NULL
606: ,Ja_Cn_Utility.GV_TYPE_NUMBER
607: ,Ja_Cn_Utility.GV_REQUIRED_YES
608: );
609: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENT_YEAR_BUDGET_TARGET'
610: ,Ja_Cn_Utility.GV_TAG_TYPE_END
611: );
612: END IF; --ln_rec_count = 0
613: -- added for fixing bug#: 10103231 --END--

Line 610: ,Ja_Cn_Utility.GV_TAG_TYPE_END

606: ,Ja_Cn_Utility.GV_TYPE_NUMBER
607: ,Ja_Cn_Utility.GV_REQUIRED_YES
608: );
609: Ja_Cn_Utility.Add_Sub_Root_Node('CURRENT_YEAR_BUDGET_TARGET'
610: ,Ja_Cn_Utility.GV_TAG_TYPE_END
611: );
612: END IF; --ln_rec_count = 0
613: -- added for fixing bug#: 10103231 --END--
614: