[Home] [Help]
1968: MAX(DECODE(NVL(gl_transfer_status_code,'N'), 'Y', 'Y', 'N')) gl_transfer_status_code /*bug 13911650*/
1969: FROM xla_transaction_entities_upg xte,
1970: xla_events xe,
1971: xla_ae_headers xah,
1972: ap_system_parameters_all asp
1973: WHERE xte.entity_id = xe.entity_id
1974: AND xe.application_id = 200
1975: AND xte.entity_code = p_Source_Table
1976: AND nvl(source_id_int_1,-99) = p_Check_Or_Invoice_Id --nvl added by bug 7655892
1995: CURSOR Check_period_Status(p_Date DATE,
1996: p_org_id NUMBER) IS
1997: SELECT DISTINCT gps.Period_Name
1998: FROM gl_Period_Statuses gps,
1999: ap_System_Parameters_All Asp
2000: WHERE gps.Application_Id = 200
2001: AND gps.Set_Of_Books_Id = Asp.Set_Of_Books_Id
2002: AND Nvl(gps.Adjustment_Period_Flag,'N') = 'N'
2003: AND p_Date BETWEEN Trunc(gps.Start_Date)
2006: AND gps.closing_Status in ('O', 'F')
2007: INTERSECT
2008: SELECT DISTINCT gps.Period_Name
2009: FROM gl_Period_Statuses gps,
2010: ap_System_Parameters_All Asp
2011: WHERE gps.Application_Id = 101
2012: AND gps.Set_Of_Books_Id = Asp.Set_Of_Books_Id
2013: AND Nvl(gps.Adjustment_Period_Flag,'N') = 'N'
2014: AND p_Date BETWEEN Trunc(gps.Start_Date)
2027: SELECT Period_Name, End_Date
2028: FROM (
2029: SELECT DISTINCT gps.Period_Name, trunc(gps.End_Date) End_date
2030: FROM gl_Period_Statuses gps,
2031: ap_System_Parameters_All Asp
2032: WHERE gps.Application_Id = 200
2033: AND gps.Set_Of_Books_Id = Asp.Set_Of_Books_Id
2034: AND Nvl(gps.Adjustment_Period_Flag,'N') = 'N'
2035: AND Nvl(Asp.Org_Id,- 99) = Nvl(p_org_id,- 99)
2036: AND gps.closing_Status in ('O', 'F')
2037: INTERSECT
2038: SELECT DISTINCT gps.Period_Name, trunc(gps.End_Date) End_date
2039: FROM gl_Period_Statuses gps,
2040: ap_System_Parameters_All Asp
2041: WHERE gps.Application_Id = 101
2042: AND gps.Set_Of_Books_Id = Asp.Set_Of_Books_Id
2043: AND Nvl(gps.Adjustment_Period_Flag,'N') = 'N'
2044: AND Nvl(Asp.Org_Id,- 99) = Nvl(p_org_id,- 99)
2049:
2050: CURSOR Check_Entered_Gl_date(p_org_id NUMBER) IS
2051: SELECT DISTINCT gps.Period_Name
2052: FROM gl_Period_Statuses gps,
2053: ap_System_Parameters_All Asp
2054: WHERE gps.Application_Id = 200
2055: AND p_Gl_Date between trunc(gps.start_date) and trunc(gps.end_date)
2056: AND gps.Set_Of_Books_Id = Asp.Set_Of_Books_Id
2057: AND Nvl(gps.Adjustment_Period_Flag,'N') = 'N'
2059: AND gps.closing_Status in ('O', 'F')
2060: INTERSECT
2061: SELECT DISTINCT gps.Period_Name
2062: FROM gl_Period_Statuses gps,
2063: ap_System_Parameters_All Asp
2064: WHERE gps.Application_Id = 101
2065: AND p_Gl_Date between trunc(gps.start_date) and trunc(gps.end_date)
2066: AND gps.Set_Of_Books_Id = Asp.Set_Of_Books_Id
2067: AND Nvl(gps.Adjustment_Period_Flag,'N') = 'N'
3376: asp.rounding_error_ccid
3377: ) write_off_code_combination
3378: FROM ap_payment_hist_dists aphd,
3379: ap_payment_history_all aph,
3380: ap_system_parameters_all asp,
3381: ap_invoice_distributions_all aid
3382: WHERE aphd.accounting_event_id = p_event_id
3383: AND aph.payment_history_id = aphd.payment_history_id
3384: AND aph.org_id = asp.org_id
3437: asp.rounding_error_ccid
3438: ) write_off_code_combination
3439: FROM ap_prepay_app_dists apad,
3440: ap_prepay_history_all apph,
3441: ap_system_parameters_all asp,
3442: ap_invoice_distributions_all aid
3443: WHERE apad.accounting_event_id = P_Event_Id
3444: AND apad.prepay_history_id = apph.prepay_history_id
3445: AND apph.org_id = asp.org_id
4127: Begin
4128: SELECT period_name
4129: Into l_period_name
4130: FROM gl_period_statuses GLPS,
4131: ap_system_parameters_all SP
4132: WHERE application_id = 200
4133: AND sp.org_id = P_Org_Id
4134: AND GLPS.set_of_books_id = SP.set_of_books_id
4135: AND trunc(P_Date) BETWEEN start_date AND end_date
4153: Into l_start_date
4154: FROM (
4155: SELECT DISTINCT gps.Period_Name, trunc(gps.Start_Date) Start_date
4156: FROM gl_Period_Statuses gps,
4157: ap_System_Parameters_All Asp
4158: WHERE gps.Application_Id = 200
4159: AND gps.Set_Of_Books_Id = Asp.Set_Of_Books_Id
4160: AND Nvl(gps.Adjustment_Period_Flag,'N') = 'N'
4161: AND Nvl(Asp.Org_Id,- 99) = Nvl(p_org_id,- 99)
4162: AND gps.closing_Status in ('O', 'F')
4163: INTERSECT
4164: SELECT DISTINCT gps.Period_Name, trunc(gps.start_Date) start_date
4165: FROM gl_Period_Statuses gps,
4166: ap_System_Parameters_All Asp
4167: WHERE gps.Application_Id = 101
4168: AND gps.Set_Of_Books_Id = Asp.Set_Of_Books_Id
4169: AND Nvl(gps.Adjustment_Period_Flag,'N') = 'N'
4170: AND Nvl(Asp.Org_Id,- 99) = Nvl(P_Org_Id,- 99)
4850: ' FROM '||l_driver_table||' dr, '||
4851: ' ap_invoices_all ai, '||
4852: ' ap_suppliers av, '||
4853: ' ap_supplier_sites_all avs, '||
4854: ' ap_system_parameters_all aps '||
4855: ' WHERE ai.invoice_id = dr.invoice_id'||
4856: ' AND ai.org_id = aps.org_id'||
4857: ' AND ai.vendor_id = av.vendor_id'||
4858: ' AND ai.vendor_site_id = avs.vendor_site_id'||
4939: ' FROM '||l_driver_table||' dr, '||
4940: ' ap_invoices_all ai, '||
4941: ' ap_suppliers av, '||
4942: ' ap_supplier_sites_all avs, '||
4943: ' ap_system_parameters_all aps '||
4944: ' WHERE ai.invoice_id = dr.invoice_id'||
4945: ' AND ai.org_id = aps.org_id'||
4946: ' AND ai.vendor_id = av.vendor_id'||
4947: ' AND ai.vendor_site_id = avs.vendor_site_id'||
5410: , MAX(DECODE(NVL(gl_transfer_status_code,'N'), 'Y', 'Y', 'N')) gl_transfer_status_code /* bug 13911650*/
5411: FROM xla_transaction_entities_upg xte
5412: , xla_events xe
5413: , xla_ae_headers xah
5414: , ap_system_parameters_all asp
5415: WHERE xte.entity_id = xe.entity_id
5416: AND xe.application_id = 200
5417: AND xte.entity_code = 'AP_INVOICES'
5418: AND NVL( source_id_int_1, - 99 ) = p_invoice_id
5438: CURSOR check_period_status( p_date DATE, p_org_id NUMBER )
5439: IS
5440: SELECT DISTINCT gps.period_name
5441: FROM gl_period_statuses gps
5442: , ap_system_parameters_all asp
5443: WHERE gps.application_id = 200
5444: AND gps.set_of_books_id = asp.set_of_books_id
5445: AND NVL( gps.adjustment_period_flag, 'N' ) = 'N'
5446: AND p_date BETWEEN TRUNC( gps.start_date ) AND TRUNC( gps.end_date )
5448: AND gps.closing_status IN( 'O', 'F' )
5449: INTERSECT
5450: SELECT DISTINCT gps.period_name
5451: FROM gl_period_statuses gps
5452: , ap_system_parameters_all asp
5453: WHERE gps.application_id = 101
5454: AND gps.set_of_books_id = asp.set_of_books_id
5455: AND NVL( gps.adjustment_period_flag, 'N' ) = 'N'
5456: AND p_date BETWEEN TRUNC( gps.start_date ) AND TRUNC( gps.end_date )
5464: FROM
5465: ( SELECT DISTINCT gps.period_name
5466: , TRUNC( gps.end_date ) end_date
5467: FROM gl_period_statuses gps
5468: , ap_system_parameters_all asp
5469: WHERE gps.application_id = 200
5470: AND gps.set_of_books_id = asp.set_of_books_id
5471: AND NVL( gps.adjustment_period_flag, 'N' ) = 'N'
5472: AND NVL( asp.org_id, - 99 ) = NVL( p_org_id, - 99 )
5474: INTERSECT
5475: SELECT DISTINCT gps.period_name
5476: , TRUNC( gps.end_date ) end_date
5477: FROM gl_period_statuses gps
5478: , ap_system_parameters_all asp
5479: WHERE gps.application_id = 101
5480: AND gps.set_of_books_id = asp.set_of_books_id
5481: AND NVL( gps.adjustment_period_flag, 'N' ) = 'N'
5482: AND NVL( asp.org_id, - 99 ) = NVL( p_org_id, - 99 )
5489: CURSOR check_entered_gl_date( p_org_id NUMBER )
5490: IS
5491: SELECT DISTINCT gps.period_name
5492: FROM gl_period_statuses gps
5493: , ap_system_parameters_all asp
5494: WHERE gps.application_id = 200
5495: AND p_gl_date BETWEEN TRUNC( gps.start_date ) AND TRUNC( gps.end_date )
5496: AND gps.set_of_books_id = asp.set_of_books_id
5497: AND NVL( gps.adjustment_period_flag, 'N' ) = 'N'
5499: AND gps.closing_status IN( 'O', 'F' )
5500: INTERSECT
5501: SELECT DISTINCT gps.period_name
5502: FROM gl_period_statuses gps
5503: , ap_system_parameters_all asp
5504: WHERE gps.application_id = 101
5505: AND p_gl_date BETWEEN TRUNC( gps.start_date ) AND TRUNC( gps.end_date )
5506: AND gps.set_of_books_id = asp.set_of_books_id
5507: AND NVL( gps.adjustment_period_flag, 'N' ) = 'N'