eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

PACKAGE: APPS.PA_OBJECT_RELATIONSHIPS_PKG

Source


1 package PA_OBJECT_RELATIONSHIPS_PKG as
2 /* $Header: PAOBRPKS.pls 120.1 2005/08/19 16:36:28 mwasowic noship $ */
3 
4 procedure INSERT_ROW
5 (                       p_user_id               IN      NUMBER,
6                   	p_object_type_from	IN	VARCHAR2,
7 			p_object_id_from1	IN	NUMBER,
8 			p_object_id_from2	IN	NUMBER,
9 			p_object_id_from3	IN	NUMBER,
10 			p_object_id_from4	IN	NUMBER,
11 			p_object_id_from5	IN	NUMBER,
12 			p_object_type_to	IN	VARCHAR2,
13 			p_object_id_to1		IN	NUMBER,
14 			p_object_id_to2 	IN	NUMBER,
15 			p_object_id_to3		IN	NUMBER,
16 			p_object_id_to4		IN	NUMBER,
17 			p_object_id_to5		IN	NUMBER,
18 			p_relationship_type	IN	VARCHAR2,
19 			p_relationship_subtype	IN	VARCHAR2,
20 			p_lag_day 		IN	NUMBER,
21 			p_imported_lag		IN	VARCHAR2,
22 			p_priority		IN	VARCHAR2,
23                         p_pm_product_code       IN      VARCHAR2,
24                         p_weighting_percentage  IN      NUMBER := 0,
25                    --FPM bug 3301192
26                         p_comments              IN      VARCHAR2 := NULL,
27                         p_status_code           IN      VARCHAR2 := NULL,
28                    --end FPM bug 3301192
29 			x_object_relationship_id OUT	NOCOPY NUMBER, --File.Sql.39 bug 4440895
30 			x_return_status		 OUT	NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
31 
32 procedure UPDATE_ROW
33 (       p_user_id               IN      NUMBER,
34         p_object_relationship_id        IN      NUMBER,
35         p_relationship_type     IN      VARCHAR2,
36         p_relationship_subtype  IN      VARCHAR2,
37         p_lag_day               IN      NUMBER,
38         p_priority              IN      VARCHAR2,
39         p_pm_product_code       IN      VARCHAR2,
40 	p_weighting_percentage  IN      NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
41   --FPM bug 3301192
42         p_comments              IN      VARCHAR2 := NULL,
43         p_status_code           IN      VARCHAR2 := NULL,
44   --end FPM bug 3301192
45         p_record_version_number IN      NUMBER,
46         x_return_status         OUT     NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
47 
48 
49 procedure DELETE_ROW
50 (	p_object_relationship_id	IN	NUMBER,
51         p_object_type_from      IN      VARCHAR2,
52         p_object_id_from1       IN      NUMBER,
53         p_object_id_from2       IN      NUMBER,
54         p_object_id_from3       IN      NUMBER,
55         p_object_id_from4       IN      NUMBER,
56         p_object_id_from5       IN      NUMBER,
57         p_object_type_to        IN      VARCHAR2,
58         p_object_id_to1         IN      NUMBER,
59         p_object_id_to2         IN      NUMBER,
60         p_object_id_to3         IN      NUMBER,
61         p_object_id_to4         IN      NUMBER,
62         p_object_id_to5         IN      NUMBER,
63 	p_record_version_number	IN	NUMBER,
64         p_pm_product_code       IN      VARCHAR2,
65 	x_return_status	        OUT	NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
66 
67 END PA_OBJECT_RELATIONSHIPS_PKG;
68