[Home] [Help]
1830: AND PERIOD1.effective_period_num >=
1831: ( SELECT PERIOD2.effective_period_num
1832: FROM GL_PERIOD_STATUSES PERIOD2,
1833: GL_DATE_PERIOD_MAP DPM,
1834: GL_SETS_OF_BOOKS SOB
1835: WHERE SOB.set_of_books_id = p_set_of_books_id
1836: AND DPM.period_set_name = SOB.period_set_name
1837: AND DPM.period_type = SOB.accounted_period_type
1838: AND trunc(DPM.accounting_date) = trunc(p_reference_date)
1895: AND PERIOD1.effective_period_num >=
1896: ( SELECT PERIOD2.effective_period_num
1897: FROM GL_PERIOD_STATUSES PERIOD2,
1898: GL_DATE_PERIOD_MAP DPM,
1899: GL_SETS_OF_BOOKS SOB
1900: WHERE SOB.set_of_books_id = p_set_of_books_id
1901: AND DPM.period_set_name = SOB.period_set_name
1902: AND DPM.period_type = SOB.accounted_period_type
1903: AND trunc(DPM.accounting_date) = trunc(p_reference_date)
1956: * Modified the name of the first parameter.
1957: */
1958: FUNCTION get_prvdr_gl_date( p_reference_date IN DATE,
1959: p_application_id IN NUMBER ,
1960: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE
1961: )
1962: return date
1963: IS
1964: l_prof_new_gldate_derivation varchar2(1);
2045: */
2046:
2047: FUNCTION get_recvr_gl_date( p_reference_date IN DATE,
2048: p_application_id IN NUMBER ,
2049: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE
2050: )
2051: return date
2052: IS
2053: l_prof_new_gldate_derivation VARCHAR2(1) := 'N';
2338: -- This function is called by Transaction Import to get the gl period name.
2339: ----------------------------------------------------------------------------
2340: PROCEDURE GetGlPeriodNameDate( p_pa_date IN DATE,
2341: p_application_id IN NUMBER ,
2342: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
2343: x_gl_date OUT NOCOPY DATE,
2344: x_period_name OUT NOCOPY VARCHAR2
2345: )
2346: IS
3117: INTO l_gl_period_name
3118: ,l_gl_period_start_date
3119: ,l_gl_period_end_date
3120: FROM gl_periods glp
3121: ,gl_sets_of_books glsob
3122: ,pa_implementations_all imp
3123: WHERE glsob.period_set_name = glp.period_set_name
3124: AND glp.period_type = glsob.accounted_period_type
3125: AND glp.adjustment_period_flag <> 'Y'
3522: ----------------------------------------------------------------------------------------------------------------
3523: FUNCTION get_rev_accrual_date( p_calling_module IN VARCHAR2,
3524: p_reference_date IN DATE,
3525: p_application_id IN NUMBER ,
3526: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
3527: p_prvdr_recvr_flg IN VARCHAR2,
3528: p_epp_flag IN VARCHAR2,
3529: x_gl_period_name OUT NOCOPY VARCHAR2,
3530: x_return_status OUT NOCOPY VARCHAR2,
3721: ----------------------------------------------------------------------------------------------------------------
3722: PROCEDURE get_accrual_gl_dt_period(p_calling_module IN VARCHAR2,
3723: p_reference_date IN DATE,
3724: p_application_id IN NUMBER ,
3725: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
3726: p_prvdr_recvr_flg IN VARCHAR2,
3727: p_epp_flag IN VARCHAR2,
3728: x_gl_accr_period_name OUT NOCOPY VARCHAR2,
3729: x_gl_accr_dt OUT NOCOPY DATE,
5137: AND PERIOD1.effective_period_num >=
5138: (SELECT PERIOD2.effective_period_num
5139: FROM GL_PERIOD_STATUSES PERIOD2,
5140: GL_DATE_PERIOD_MAP DPM,
5141: GL_SETS_OF_BOOKS SOB
5142: WHERE SOB.set_of_books_id = l_set_of_books_id
5143: AND DPM.period_set_name = SOB.period_set_name
5144: AND DPM.period_type = SOB.accounted_period_type
5145: AND trunc(DPM.accounting_date) = trunc(p_reference_date)
5176: AND PERIOD1.effective_period_num >=
5177: (SELECT PERIOD2.effective_period_num
5178: FROM GL_PERIOD_STATUSES PERIOD2,
5179: GL_DATE_PERIOD_MAP DPM,
5180: GL_SETS_OF_BOOKS SOB
5181: WHERE SOB.set_of_books_id = l_set_of_books_id
5182: AND DPM.period_set_name = SOB.period_set_name
5183: AND DPM.period_type = SOB.accounted_period_type
5184: AND trunc(DPM.accounting_date) = trunc(p_reference_date)