[Home] [Help]
1847: AND PERIOD1.effective_period_num >=
1848: ( SELECT PERIOD2.effective_period_num
1849: FROM GL_PERIOD_STATUSES PERIOD2,
1850: GL_DATE_PERIOD_MAP DPM,
1851: GL_SETS_OF_BOOKS SOB
1852: WHERE SOB.set_of_books_id = p_set_of_books_id
1853: AND DPM.period_set_name = SOB.period_set_name
1854: AND DPM.period_type = SOB.accounted_period_type
1855: AND trunc(DPM.accounting_date) = trunc(p_reference_date)
1912: AND PERIOD1.effective_period_num >=
1913: ( SELECT PERIOD2.effective_period_num
1914: FROM GL_PERIOD_STATUSES PERIOD2,
1915: GL_DATE_PERIOD_MAP DPM,
1916: GL_SETS_OF_BOOKS SOB
1917: WHERE SOB.set_of_books_id = p_set_of_books_id
1918: AND DPM.period_set_name = SOB.period_set_name
1919: AND DPM.period_type = SOB.accounted_period_type
1920: AND trunc(DPM.accounting_date) = trunc(p_reference_date)
1973: * Modified the name of the first parameter.
1974: */
1975: FUNCTION get_prvdr_gl_date( p_reference_date IN DATE,
1976: p_application_id IN NUMBER ,
1977: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE
1978: )
1979: return date
1980: IS
1981: l_prof_new_gldate_derivation varchar2(1);
2062: */
2063:
2064: FUNCTION get_recvr_gl_date( p_reference_date IN DATE,
2065: p_application_id IN NUMBER ,
2066: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE
2067: )
2068: return date
2069: IS
2070: l_prof_new_gldate_derivation VARCHAR2(1) := 'N';
2355: -- This function is called by Transaction Import to get the gl period name.
2356: ----------------------------------------------------------------------------
2357: PROCEDURE GetGlPeriodNameDate( p_pa_date IN DATE,
2358: p_application_id IN NUMBER ,
2359: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
2360: x_gl_date OUT NOCOPY DATE,
2361: x_period_name OUT NOCOPY VARCHAR2
2362: )
2363: IS
3155: INTO l_gl_period_name
3156: ,l_gl_period_start_date
3157: ,l_gl_period_end_date
3158: FROM gl_periods glp
3159: ,gl_sets_of_books glsob
3160: ,pa_implementations_all imp
3161: WHERE glsob.period_set_name = glp.period_set_name
3162: AND glp.period_type = glsob.accounted_period_type
3163: AND glp.adjustment_period_flag <> 'Y'
3560: ----------------------------------------------------------------------------------------------------------------
3561: FUNCTION get_rev_accrual_date( p_calling_module IN VARCHAR2,
3562: p_reference_date IN DATE,
3563: p_application_id IN NUMBER ,
3564: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
3565: p_prvdr_recvr_flg IN VARCHAR2,
3566: p_epp_flag IN VARCHAR2,
3567: x_gl_period_name OUT NOCOPY VARCHAR2,
3568: x_return_status OUT NOCOPY VARCHAR2,
3759: ----------------------------------------------------------------------------------------------------------------
3760: PROCEDURE get_accrual_gl_dt_period(p_calling_module IN VARCHAR2,
3761: p_reference_date IN DATE,
3762: p_application_id IN NUMBER ,
3763: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
3764: p_prvdr_recvr_flg IN VARCHAR2,
3765: p_epp_flag IN VARCHAR2,
3766: x_gl_accr_period_name OUT NOCOPY VARCHAR2,
3767: x_gl_accr_dt OUT NOCOPY DATE,
5175: AND PERIOD1.effective_period_num >=
5176: (SELECT PERIOD2.effective_period_num
5177: FROM GL_PERIOD_STATUSES PERIOD2,
5178: GL_DATE_PERIOD_MAP DPM,
5179: GL_SETS_OF_BOOKS SOB
5180: WHERE SOB.set_of_books_id = l_set_of_books_id
5181: AND DPM.period_set_name = SOB.period_set_name
5182: AND DPM.period_type = SOB.accounted_period_type
5183: AND trunc(DPM.accounting_date) = trunc(p_reference_date)
5214: AND PERIOD1.effective_period_num >=
5215: (SELECT PERIOD2.effective_period_num
5216: FROM GL_PERIOD_STATUSES PERIOD2,
5217: GL_DATE_PERIOD_MAP DPM,
5218: GL_SETS_OF_BOOKS SOB
5219: WHERE SOB.set_of_books_id = l_set_of_books_id
5220: AND DPM.period_set_name = SOB.period_set_name
5221: AND DPM.period_type = SOB.accounted_period_type
5222: AND trunc(DPM.accounting_date) = trunc(p_reference_date)