PACKAGE: APPS.MSC_RELEASE_PK

Source

1 PACKAGE msc_release_pk AUTHID CURRENT_USER AS
2 /* $Header: MSCARELS.pls 120.2 2010/07/28 14:20:11 rgurugub ship $ */
3 
4    TYPE ReqRecTyp
5       IS RECORD (
6       instanceCode       varchar2(50),
7       ReqID              varchar2(50),
8       ReqType            varchar2(50)
9    );
10 
11     TYPE ReqTblTyp IS TABLE OF ReqRecTyp index by BINARY_INTEGER;
12 TYPE V_TAB_TYPE IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;
13 
14 PROCEDURE msc_auto_release
15                 (errbuf			OUT NOCOPY VARCHAR2,
16                  retcode		OUT NOCOPY NUMBER,
17                  arg_plan_id            IN  NUMBER,
18                  arg_org_id             IN  NUMBER,
19                  arg_instance_id        IN  NUMBER,
20                  arg_use_start_date     IN  VARCHAR2);
21 
22 PROCEDURE msc_web_service_release (
23                 pPlan_id 			            Number,
24             	Use_Plan_start_date    	        Varchar2,
25             	RETCODE		        OUT  NOCOPY Number,
26             	ERRMSG		        OUT  NOCOPY Varchar2,
27             	REQ_ID		        OUT  NOCOPY ReqTblTyp
28                 );
29 
30 
31 
32 PROCEDURE QueryBasedAutoRelease (
33                         pPlan_id                                    Number,
34                         RETCODE                 OUT  NOCOPY Number,
35                         ERRMSG                  OUT  NOCOPY Varchar2);
36 END msc_release_pk;