PACKAGE: APPS.BOMPOPIF

Source

1 package BOMPOPIF AUTHID CURRENT_USER as
2 /*  $Header: BOMOPIFS.pls 120.1 2005/06/20 01:20:01 appldev ship $ */
3 /*==========================================================================+
4 |   Copyright (c) 1993 Oracle Corporation Belmont, California, USA          |
5 |                          All rights reserved.                             |
6 +===========================================================================+
7 |                                                                           |
8 | File Name    : BOMPOPIF.pls                                               |
9 | DESCRIPTION  : This is the main package used to validate and process
10 | 		 open interface item/bil.routing/eco data.
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 |		val_rtg_flag	validate routings
16 |		val_bom_flag	validate boms
17 |		pro_rtg_flag	process routings
18 |		pro_bom_flag	process boms
19 |		del_rec_flag	delete processed rows
20 |    		prog_appid      program application_id
21 |    		prog_id  	program id
22 |    		request_id      request_id
23 |    		user_id		user id
24 |    		login_id	login id
25 | Return:	1 if success
26 |		SQLCODE if failure
27 | History:
28 |    09/26/93   Shreyas Shah	creation date
29 |    01/15/05   Bhavnesh Patel  Added Batch Id
30 |                                                                           |
31 +==========================================================================*/
32 
33 --Open Interface Import for null batch id
34 FUNCTION bmopinp_open_interface_process (
35     org_id		NUMBER,
36     all_org		NUMBER		:= 1,
37     val_rtg_flag	NUMBER		:= 1,
38     val_bom_flag	NUMBER		:= 1,
39     pro_rtg_flag	NUMBER		:= 1,
40     pro_bom_flag	NUMBER		:= 1,
41     del_rec_flag	NUMBER		:= 1,
42     prog_appid		NUMBER		:= -1,
43     prog_id		NUMBER		:= -1,
44     request_id		NUMBER		:= -1,
45     user_id		NUMBER		:= -1,
46     login_id		NUMBER		:= -1,
47     err_text	 IN OUT NOCOPY 	VARCHAR2
48 )
49     return INTEGER;
50 
51 --Open Interface Import for given batch id
52 FUNCTION bmopinp_open_interface_process (
53     org_id		NUMBER,
54     all_org		NUMBER		:= 1,
55     val_rtg_flag	NUMBER		:= 1,
56     val_bom_flag	NUMBER		:= 1,
57     pro_rtg_flag	NUMBER		:= 1,
58     pro_bom_flag	NUMBER		:= 1,
59     del_rec_flag	NUMBER		:= 1,
60     prog_appid		NUMBER		:= -1,
61     prog_id		NUMBER		:= -1,
62     request_id		NUMBER		:= -1,
63     user_id		NUMBER		:= -1,
64     login_id		NUMBER		:= -1,
65     err_text	 IN OUT NOCOPY 	VARCHAR2,
66     p_batch_id  IN  NUMBER
67 )
68     return INTEGER;
69 
70 /*
71 FUNCTION bmdelbom_delete_bom_oi (
72 	err_text    OUT	VARCHAR2
73 )
74     return INTEGER;
75 
76 FUNCTION bmdelrtg_delete_rtg_oi (
77 	err_text    OUT	VARCHAR2
78 )
79     return INTEGER;
80 */
81 
82 END BOMPOPIF;