PACKAGE: APPS.CRP_FORM_PK

Source

1 PACKAGE crp_form_pk AUTHID CURRENT_USER AS
2      /* $Header: CRPSELES.pls 115.3 2002/07/12 21:15:01 jhegde ship $ */
3 
4    /*------Declaring Procedures-------*/
5     PROCEDURE crp_selection_criteria(
6           	       	       	  arg_query_id        NUMBER,
7        	       	       	       	  arg_type            NUMBER,
8        	       	       	       	  arg_org_id          NUMBER,
9                                   arg_owning_dept_id  NUMBER DEFAULT NULL,
10        	       	       	       	  arg_dept_id         NUMBER DEFAULT NULL,
11        	       	       	       	  arg_res_id          NUMBER DEFAULT NULL,
12        	       	       	       	  arg_line_id         NUMBER DEFAULT NULL,
13        	       	       	       	  arg_res_type        NUMBER DEFAULT NULL,
14        	       	       	       	  arg_dept_class      VARCHAR2 DEFAULT NULL,
15                                   arg_res_grp         VARCHAR2 DEFAULT NULL);
16 
17    PROCEDURE crp_update_util(
18 				arg_query_id1		NUMBER,
19 				arg_query_id2		NUMBER,
20 				arg_line_capacity	NUMBER);
21 
22    PROCEDURE crp_upd_dept_class(arg_query_id       NUMBER);
23 
24    FUNCTION crp_resource_list(
25                                 arg_session_id  NUMBER,
26                                 arg_type        NUMBER,
27                                 arg_query_id1   NUMBER,
28                                 arg_query_id2   NUMBER) RETURN NUMBER;
29 
30    /*--------Defining Constants-------*/
31    ROUTING_BASED       CONSTANT    NUMBER :=1;
32    RATE_BASED          CONSTANT    NUMBER :=2;
33    insufficient_args   EXCEPTION;
34 
35 END crp_form_pk;