DBA Data[Home] [Help]

PACKAGE: APPS.BOMPAVRT

Source


1 package BOMPAVRT AUTHID CURRENT_USER as
2 /* $Header: BOMAVRTS.pls 115.1 99/07/16 05:09:46 porting ship $ */
3 /*==========================================================================+
4 |   Copyright (c) 1993 Oracle Corporation Belmont, California, USA          |
5 |                          All rights reserved.                             |
6 +===========================================================================+
7 |                                                                           |
8 | File Name    : BOMAVRTS.pls                                               |
9 | DESCRIPTION  : This package contains functions used to validate routing   |
10 | 		 data in the interface tables                               |
11 | Parameters:	org_id		organization_id                             |
12 |		all_org		process all orgs or just current org        |
13 |				1 - all orgs                                |
14 |				2 - only org_id                             |
15 |    		prog_appid      program application_id                      |
16 |    		prog_id  	program id                                  |
17 |    		request_id      request_id                                  |
18 |    		user_id		user id                                     |
19 |    		login_id	login id                                    |
20 | History:	                                                            |
21 |    09/28/93   Shreyas Shah	creation date                               |
22 |                                                                           |
23 +==========================================================================*/
24 FUNCTION bmasrtg_assign_rtg_data (
25     org_id		NUMBER,
26     all_org		NUMBER		:= 1,
27     prog_appid		NUMBER		:= -1,
28     prog_id		NUMBER		:= -1,
29     request_id		NUMBER		:= -1,
30     user_id		NUMBER		:= -1,
31     login_id		NUMBER		:= -1,
32     err_text     OUT 	VARCHAR2
33 )
34     return INTEGER;
35 
36 FUNCTION bmvrrtg_verify_rtg_data (
37     org_id              NUMBER,
38     all_org             NUMBER          := 1,
39     prog_appid          NUMBER          := -1,
40     prog_id             NUMBER          := -1,
41     request_id          NUMBER          := -1,
42     user_id             NUMBER          := -1,
43     login_id            NUMBER          := -1,
44     err_text     OUT    VARCHAR2
45 )
46     return INTEGER;
47 
48 END BOMPAVRT;