DBA Data[Home] [Help]

PACKAGE: APPS.MRP_EXCEPTION_SC

Source


1 PACKAGE MRP_EXCEPTION_SC AUTHID CURRENT_USER AS
2 /* $Header: MRPXSUMS.pls 115.8 2002/02/15 16:44:17 pkm ship      $ */
3 
4    FUNCTION save_as(org_id number, plan VARCHAR2) RETURN NUMBER;
5    FUNCTION group_by(
6 	var_exception_id NUMBER,
7 	planning_org NUMBER, planned_org NUMBER,
8 	count_list VARCHAR2, count_list_mfq VARCHAR2,
9  	compile_designator VARCHAR2, where_clause_segment VARCHAR2,                all_orgs number default null)
10 	       RETURN NUMBER;
11    PROCEDURE update_row(p_exception_id number,
12                         p_omit_list VARCHAR2,
13                         p_row_id VARCHAR2,
14                         p_last_update_login NUMBER,
15                         p_last_updated_by NUMBER);
16    FUNCTION lock_row(p_exception_id number, p_omit_list VARCHAR2)
17                                              RETURN NUMBER;
18 
19    FUNCTION item_number(p_org_id number, p_inventory_item_id NUMBER) RETURN VARCHAR2;
20 
21   FUNCTION supplier(arg_supplier_id IN NUMBER) return varchar2;
22 
23   FUNCTION supplier_site(arg_supplier_site_id IN NUMBER) return varchar2;
24 
25 END MRP_EXCEPTION_SC;