6224:
6225: /* Check if the given date is in current open period */
6226:
6227: /* Bug 4559756. Added by Lakshmi Gopalsami
6228: Added org_id to ap_utilities_pkg
6229: */
6230: lv_open_period:= ap_utilities_pkg.get_current_gl_date
6231: (pd_accounting_date,
6232: r_ap_invoices_all.org_id
6226:
6227: /* Bug 4559756. Added by Lakshmi Gopalsami
6228: Added org_id to ap_utilities_pkg
6229: */
6230: lv_open_period:= ap_utilities_pkg.get_current_gl_date
6231: (pd_accounting_date,
6232: r_ap_invoices_all.org_id
6233: );
6234:
6232: r_ap_invoices_all.org_id
6233: );
6234:
6235: /* Bug 4559756. Added by Lakshmi Gopalsami
6236: Added org_id to ap_utilities_pkg
6237: */
6238:
6239: if lv_open_period is null then
6240:
6237: */
6238:
6239: if lv_open_period is null then
6240:
6241: ap_utilities_pkg.get_open_gl_date
6242: (
6243: pd_accounting_date,
6244: lv_open_period,
6245: ld_accounting_date,
7232:
7233: /* Check if the given date is in current open period */
7234:
7235: /* Bug 4559756. Added by Lakshmi Gopalsami
7236: Added org_id to ap_utilities_pkg
7237: */
7238: lv_open_period:= ap_utilities_pkg.get_current_gl_date
7239: (pd_accounting_date,
7240: r_ap_invoices_all.org_id
7234:
7235: /* Bug 4559756. Added by Lakshmi Gopalsami
7236: Added org_id to ap_utilities_pkg
7237: */
7238: lv_open_period:= ap_utilities_pkg.get_current_gl_date
7239: (pd_accounting_date,
7240: r_ap_invoices_all.org_id
7241: );
7242:
7240: r_ap_invoices_all.org_id
7241: );
7242:
7243: /* Bug 4559756. Added by Lakshmi Gopalsami
7244: Added org_id to ap_utilities_pkg
7245: */
7246:
7247: if lv_open_period is null then
7248:
7245: */
7246:
7247: if lv_open_period is null then
7248:
7249: ap_utilities_pkg.get_open_gl_date
7250: (
7251: pd_accounting_date,
7252: lv_open_period,
7253: ld_accounting_date,
9840: | so that the same will be passed for reversal line which will get
9841: | created for cancellation.
9842: */
9843: --Check if the given date is in current open period
9844: lv_open_period := ap_utilities_pkg.get_current_gl_date(P_Date => ld_accounting_date,
9845: P_Org_Id => r_ap_invoices_all_au.org_id);
9846: if lv_open_period is null then
9847:
9848: lv_codepath := jai_general_pkg.plot_codepath(1.1, lv_codepath); /* 1.1 */
9846: if lv_open_period is null then
9847:
9848: lv_codepath := jai_general_pkg.plot_codepath(1.1, lv_codepath); /* 1.1 */
9849:
9850: ap_utilities_pkg.get_open_gl_date(p_date => ld_accounting_date, /* In date */
9851: p_period_name => lv_open_period, /* out Period */
9852: p_gl_date => ld_accounting_date, /* out date */
9853: P_Org_Id => r_ap_invoices_all_au.org_id);
9854:
9971: | so that the same will be passed for reversal line which will get
9972: | created for cancellation.
9973: */
9974: --Check if the given date is in current open period
9975: lv_open_period := ap_utilities_pkg.get_current_gl_date(P_Date => ld_accounting_date,
9976: P_Org_Id => r_ap_invoices_all_cm.org_id);
9977: if lv_open_period is null then
9978:
9979: lv_codepath := jai_general_pkg.plot_codepath(1.1, lv_codepath); /* 1.1 */
9977: if lv_open_period is null then
9978:
9979: lv_codepath := jai_general_pkg.plot_codepath(1.1, lv_codepath); /* 1.1 */
9980:
9981: ap_utilities_pkg.get_open_gl_date(p_date => ld_accounting_date, /* In date */
9982: p_period_name => lv_open_period, /* out Period */
9983: p_gl_date => ld_accounting_date, /* out date */
9984: P_Org_Id => r_ap_invoices_all_cm.org_id);
9985:
10560:
10561: /* Check if the given date is in current open period */
10562:
10563: /* Bug 4559756. Added by Lakshmi Gopalsami
10564: Added org_id to ap_utilities_pkg
10565: */
10566: lv_open_period:= ap_utilities_pkg.get_current_gl_date
10567: (pd_accounting_date,
10568: r_ap_invoices_all.org_id
10562:
10563: /* Bug 4559756. Added by Lakshmi Gopalsami
10564: Added org_id to ap_utilities_pkg
10565: */
10566: lv_open_period:= ap_utilities_pkg.get_current_gl_date
10567: (pd_accounting_date,
10568: r_ap_invoices_all.org_id
10569: );
10570:
10568: r_ap_invoices_all.org_id
10569: );
10570:
10571: /* Bug 4559756. Added by Lakshmi Gopalsami
10572: Added org_id to ap_utilities_pkg
10573: */
10574:
10575: if lv_open_period is null then
10576:
10573: */
10574:
10575: if lv_open_period is null then
10576:
10577: ap_utilities_pkg.get_open_gl_date
10578: (
10579: pd_accounting_date,
10580: lv_open_period,
10581: ld_accounting_date,