1: PACKAGE BODY CST_MGD_MSTR_BOOK_RPT AS
2: -- $Header: CSTGMBKB.pls 120.21.12020000.3 2012/10/01 10:44:21 nmogili ship $
3: --+=======================================================================+
4: --| Copyright (c) 1999 Oracle Corporation |
5: --| Redwood Shores, CA, USA |
220:
221: --===================
222: -- CONSTANTS
223: --===================
224: G_PKG_NAME CONSTANT VARCHAR2 (30) := 'CST_MGD_MSTR_BOOK_RPT';
225: GC_TXT_ISSUE VARCHAR2 (10) := 'Issue';
226: GC_TXT_RECEIPT VARCHAR2 (10) := 'Receipt';
227: --G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_MGD_INV_MASTER_BOOK';
228:
508: OPEN lcu_sub_inv_org (ln_inv_org);
509: FETCH lcu_sub_inv_org INTO lc_sub_inv_min, lc_sub_inv_max;
510: CLOSE lcu_sub_inv_org;
511:
512: CST_MGD_MSTR_BOOK_RPT.create_inv_msbk_rpt (
513: p_org_id => ln_inv_org
514: ,p_category_set_id_from => p_category_set_id_from
515: ,p_category_set_id_to => p_category_set_id_to
516: ,p_category_from => p_category_from
531: fnd_file.put_line(fnd_file.LOG, 'NOTE** The current responsibility does not have access to any Inventory Orgs under the given Legal Entity');
532: END IF;
533:
534: ELSE
535: CST_MGD_MSTR_BOOK_RPT.create_inv_msbk_rpt (
536: p_org_id => p_inventory_org
537: ,p_category_set_id_from => p_category_set_id_from
538: ,p_category_set_id_to => p_category_set_id_to
539: ,p_category_from => p_category_from
3106: RAISE;
3107:
3108: END create_inv_msbk_rpt;
3109:
3110: END CST_MGD_MSTR_BOOK_RPT;