PACKAGE: APPS.MRP_REL_WF

Source

1 PACKAGE mrp_rel_wf AUTHID CURRENT_USER AS
2 /*$Header: MRPRLWFS.pls 120.1 2007/11/29 22:56:57 cnazarma ship $ */
3 
4 TYPE NumTblTyp IS TABLE OF NUMBER;
5 TYPE date_arr IS TABLE OF date;
6 
7 TYPE supply_project_rec  IS  RECORD(
8             transaction_id  number,
9             organization_id number,
10             start_date      date,
11             project_id      number,
12             task_id         number);
13 
14 TYPE supply_project_tbl IS TABLE OF supply_project_rec INDEX BY BINARY_INTEGER;
15 
16 PROCEDURE init_source(p_user_name varchar2,p_resp_name VARCHAR2);
17 
18 PROCEDURE launch_po_program
19 (
20 p_old_need_by_date IN DATE,
21 p_new_need_by_date IN DATE,
22 p_po_header_id IN NUMBER,
23 p_po_line_id IN NUMBER,
24 p_po_number IN VARCHAR2,
25 p_user IN VARCHAR2,
26 p_resp IN VARCHAR2,
27 p_qty IN NUMBER,
28 p_out OUT NOCOPY NUMBER
29 );
30 
31  PROCEDURE validate_pjm_selectAll(p_server_dblink IN varchar2,
32                                  p_user_name     IN varchar2,
33                                  p_plan_id       IN number,
34                                  p_query_id      IN number);
35 
36  PROCEDURE   validate_pjm ( p_org             NUMBER,
37                          p_project_id         NUMBER,
38                          p_task_id            NUMBER,
39                          p_start_date         DATE,
40                          p_completion_date    DATE,
41                          p_user_name          VARCHAR2,
42                          p_valid OUT NOCOPY   VARCHAR2,
43                          p_error OUT NOCOPY   VARCHAR2);
44 
45 
46 
47 PROCEDURE launch_so_program
48 (
49 p_batch_id in number,
50 p_dblink in varchar2,
51 p_instance_id in number,
52 p_user IN VARCHAR2,
53 p_resp IN VARCHAR2,
54 p_out OUT NOCOPY NUMBER
55 );
56 
57 function get_profile_value ( p_prof_name in varchar2
58                            , p_user_name in varchar2
59                            , p_resp_name in varchar2
60                            , p_appl_name in varchar2
61                            ) return varchar2;
62 
63 
64 END mrp_rel_wf;