DBA Data[Home] [Help]

APPS.FV_YE_CARRYFORWARD dependencies on FV_YE_CARRYFORWARD

Line 1: PACKAGE BODY Fv_Ye_Carryforward AS

1: PACKAGE BODY Fv_Ye_Carryforward AS
2: --$Header: FVXYECFB.pls 120.23.12020000.4 2013/02/13 14:57:33 snama ship $
3: -- ======================================================================
4: -- Variable Naming Conventions
5: -- ======================================================================

Line 613: AND FV_YE_CARRYFORWARD.Check_bal_seg_value(GCC.'||VG_BAL_SEG_VALUE||',

609: AND l.je_header_id = h.je_header_id
610:
611:
612:
613: AND FV_YE_CARRYFORWARD.Check_bal_seg_value(GCC.'||VG_BAL_SEG_VALUE||',
614: :sob_id,
615: :bal_seg_val_opt_code) = '||''''||'Y'||''''||
616: ' AND xl.code_combination_id = l.code_combination_id
617: AND gir.je_header_id = h.je_header_id

Line 659: || ' MAX(fv_ye_carryforward.convert_to_num(l.reference_1)) '

655: || vg_jrnl_group_id || ' , '''
656: || vg_carryfor_period || ''' , '
657: || vg_coa_id
658: || ' , gcc.code_combination_id , '
659: || ' MAX(fv_ye_carryforward.convert_to_num(l.reference_1)) '
660: || vl_attribute_cols || '
661: FROM gl_je_lines l , fv_be_trx_dtls b, gl_je_headers h , gl_code_combinations gcc
662: WHERE l.code_combination_id = gcc.code_combination_id
663: AND FV_YE_CARRYFORWARD.Check_bal_seg_value(GCC.'|| VG_BAL_SEG_VALUE||', :sob_id,:bal_seg_val_opt_code ) = '||''''||'Y'||''''||

Line 663: AND FV_YE_CARRYFORWARD.Check_bal_seg_value(GCC.'|| VG_BAL_SEG_VALUE||', :sob_id,:bal_seg_val_opt_code ) = '||''''||'Y'||''''||

659: || ' MAX(fv_ye_carryforward.convert_to_num(l.reference_1)) '
660: || vl_attribute_cols || '
661: FROM gl_je_lines l , fv_be_trx_dtls b, gl_je_headers h , gl_code_combinations gcc
662: WHERE l.code_combination_id = gcc.code_combination_id
663: AND FV_YE_CARRYFORWARD.Check_bal_seg_value(GCC.'|| VG_BAL_SEG_VALUE||', :sob_id,:bal_seg_val_opt_code ) = '||''''||'Y'||''''||
664: ' AND l.je_header_id = h.je_header_id
665: AND NVL(h.je_from_sla_flag, ''N'') IN (''N'',''U'')
666: AND EXISTS (SELECT 1
667: FROM gl_periods

Line 671: AND nvl(Fv_Ye_Carryforward.Convert_To_Num(l.reference_1),-99)=b.transaction_id(+)

667: FROM gl_periods
668: WHERE period_year = :closing_fyr
669: AND period_set_name = :period_set_name
670: AND period_name = l.period_name)
671: AND nvl(Fv_Ye_Carryforward.Convert_To_Num(l.reference_1),-99)=b.transaction_id(+)
672: AND l.ledger_id = b.set_of_books_id(+)
673: AND l.status = ''P''
674: AND h.actual_flag = ''A''
675: AND h.ledger_id = :sob_id

Line 985: g_module_name := 'fv.plsql.Fv_Ye_Carryforward.';

981: RETURN 'N';
982: END Check_bal_seg_value;
983:
984: BEGIN
985: g_module_name := 'fv.plsql.Fv_Ye_Carryforward.';
986: END Fv_Ye_Carryforward;

Line 986: END Fv_Ye_Carryforward;

982: END Check_bal_seg_value;
983:
984: BEGIN
985: g_module_name := 'fv.plsql.Fv_Ye_Carryforward.';
986: END Fv_Ye_Carryforward;