DBA Data[Home] [Help]

PACKAGE: APPS.MSC_ACTIONS

Source


1 PACKAGE MSC_ACTIONS AUTHID CURRENT_USER AS
2 /* $Header: MSCPACTS.pls 120.1 2011/02/25 04:47:40 skathera ship $ */
3 
4    FUNCTION save_as(plan NUMBER) RETURN NUMBER;
5    PROCEDURE group_by(
6         l_plan_node NUMBER,
7 	var_exception_id NUMBER,
8 	count_list VARCHAR2, count_list_mfq VARCHAR2,
9  	where_clause VARCHAR2,
10 	p_plan_id NUMBER,
11 	p_inst_id NUMBER,
12 	p_org_id NUMBER,
13 	p_item_id NUMBER,
14 	p_planning_grp VARCHAR2,
15 	p_project_id NUMBER,
16 	p_task_id NUMBER,
17 	p_category_name VARCHAR2,
18 	p_pf_id NUMBER,
19 	p_dept_id NUMBER,
20 	p_resource_id NUMBER,
21 	p_supplier_id NUMBER,
22 	p_version NUMBER,
23 	p_exc_grp_id NUMBER,
24 	p_exception_id NUMBER,
25 	p_dept_class VARCHAR2,
26 	p_res_group VARCHAR2,
27 	p_supplier_site_id NUMBER);
28    PROCEDURE insert_exc_groups(
29 	var_exception_id NUMBER);
30    PROCEDURE update_row(p_exception_id number,
31                         p_omit_list VARCHAR2,
32                         p_row_id VARCHAR2,
33                         p_last_update_login NUMBER,
34                         p_last_updated_by NUMBER);
35    FUNCTION lock_row(p_exception_id number, p_omit_list VARCHAR2)
36                                              RETURN NUMBER;
37 
38 END MSC_ACTIONS;