[Home] [Help]
PACKAGE BODY: APPS.ASO_QUOTE_HEADER_DEP_HDLR_W
Source
1 PACKAGE BODY ASO_QUOTE_HEADER_DEP_HDLR_W AS
2 /* $Header: asovqwhb.pls 120.2 2005/08/10 18:26:20 appldev noship $ */
3 -- Start of Comments
4 -- Package name : ASO_QUOTE_HEADER_DEP_HDLR_W
5
6
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_QUOTE_HEADER_DEP_HDLR_W';
8 G_FILE_NAME CONSTANT VARCHAR2(12) := 'asovqwhb.pls';
9
10
11 PROCEDURE Get_Dependent_Attributes_Sets
12 (
13 X_Q_CONTRACT_ID OUT NOCOPY jtf_number_table
14 , X_Q_CUST_ACCOUNT_ID OUT NOCOPY jtf_number_table
15 , X_Q_CUST_PARTY_ID OUT NOCOPY jtf_number_table
16 , X_Q_INV_TO_CUST_ACCT_ID OUT NOCOPY jtf_number_table
17 , X_Q_INV_TO_PTY_SITE_ID OUT NOCOPY jtf_number_table
18 , X_Q_ORDER_TYPE_ID OUT NOCOPY jtf_number_table
19 , X_Q_ORG_ID OUT NOCOPY jtf_number_table
20 , X_Q_PRICE_LIST_ID OUT NOCOPY jtf_number_table
21 , X_Q_RESOURCE_ID OUT NOCOPY jtf_number_table
22 , X_Q_SHIP_TO_CUST_ACCT_ID OUT NOCOPY jtf_number_table
23 , X_Q_SHIP_TO_PARTY_SITE_ID OUT NOCOPY jtf_number_table
24 , X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25 , X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER
26 , X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2
27 )
28 IS
29
30 l_api_name CONSTANT VARCHAR2 ( 50 ) := 'Get_Dependent_Attributes_Sets';
31
32 X_Q_CONTRACT_ID_TBL ASO_DEFAULTING_INT.ATTRIBUTE_IDS_TBL_TYPE;
33 X_Q_CUST_ACCOUNT_ID_TBL ASO_DEFAULTING_INT.ATTRIBUTE_IDS_TBL_TYPE;
34 X_Q_CUST_PARTY_ID_TBL ASO_DEFAULTING_INT.ATTRIBUTE_IDS_TBL_TYPE;
35 X_Q_INV_TO_CUST_ACCT_ID_TBL ASO_DEFAULTING_INT.ATTRIBUTE_IDS_TBL_TYPE;
36 X_Q_INV_TO_PTY_SITE_ID_TBL ASO_DEFAULTING_INT.ATTRIBUTE_IDS_TBL_TYPE;
37 X_Q_ORDER_TYPE_ID_TBL ASO_DEFAULTING_INT.ATTRIBUTE_IDS_TBL_TYPE;
38 X_Q_ORG_ID_TBL ASO_DEFAULTING_INT.ATTRIBUTE_IDS_TBL_TYPE;
39 X_Q_PRICE_LIST_ID_TBL ASO_DEFAULTING_INT.ATTRIBUTE_IDS_TBL_TYPE;
40 X_Q_RESOURCE_ID_TBL ASO_DEFAULTING_INT.ATTRIBUTE_IDS_TBL_TYPE;
41 X_Q_SHIP_TO_CUST_ACCT_ID_TBL ASO_DEFAULTING_INT.ATTRIBUTE_IDS_TBL_TYPE;
42 X_Q_SHIP_TO_PARTY_SITE_ID_TBL ASO_DEFAULTING_INT.ATTRIBUTE_IDS_TBL_TYPE;
43
44 Begin
45
46 ASO_QUOTE_HEADER_DEP_HDLR.Get_Dependent_Attributes_Sets
47 ( P_INIT_MSG_LIST => fnd_api.g_false
48 , X_Q_CONTRACT_ID_TBL => X_Q_CONTRACT_ID_TBL
49 , X_Q_CUST_ACCOUNT_ID_TBL => X_Q_CUST_ACCOUNT_ID_TBL
50 , X_Q_CUST_PARTY_ID_TBL => X_Q_CUST_PARTY_ID_TBL
51 , X_Q_INV_TO_CUST_ACCT_ID_TBL => X_Q_INV_TO_CUST_ACCT_ID_TBL
52 , X_Q_INV_TO_PTY_SITE_ID_TBL => X_Q_INV_TO_PTY_SITE_ID_TBL
53 , X_Q_ORDER_TYPE_ID_TBL => X_Q_ORDER_TYPE_ID_TBL
54 , X_Q_ORG_ID_TBL => X_Q_ORG_ID_TBL
55 , X_Q_PRICE_LIST_ID_TBL => X_Q_PRICE_LIST_ID_TBL
56 , X_Q_RESOURCE_ID_TBL => X_Q_RESOURCE_ID_TBL
57 , X_Q_SHIP_TO_CUST_ACCT_ID_TBL => X_Q_SHIP_TO_CUST_ACCT_ID_TBL
58 , X_Q_SHIP_TO_PARTY_SITE_ID_TBL => X_Q_SHIP_TO_PARTY_SITE_ID_TBL
59 , X_RETURN_STATUS => X_RETURN_STATUS
60 , X_MSG_COUNT => X_MSG_COUNT
61 , X_MSG_DATA => X_MSG_DATA
62 );
63
64
65 ASO_QUOTE_UTIL_PVT.Set_num_Tbl_Out
66 (
67 p_num_tbl => X_Q_CONTRACT_ID_TBL,
68 x_num_id => X_Q_CONTRACT_ID
69 );
70
71 ASO_QUOTE_UTIL_PVT.Set_num_Tbl_Out
72 (
73 p_num_tbl => X_Q_CUST_ACCOUNT_ID_TBL,
74 x_num_id => X_Q_CUST_ACCOUNT_ID
75 );
76
77 ASO_QUOTE_UTIL_PVT.Set_num_Tbl_Out
78 (
79 p_num_tbl => X_Q_CUST_PARTY_ID_TBL,
80 x_num_id => X_Q_CUST_PARTY_ID
81 );
82
83
84 ASO_QUOTE_UTIL_PVT.Set_num_Tbl_Out
85 (
86 p_num_tbl => X_Q_INV_TO_CUST_ACCT_ID_TBL,
87 x_num_id => X_Q_INV_TO_CUST_ACCT_ID
88 );
89
90 ASO_QUOTE_UTIL_PVT.Set_num_Tbl_Out
91 (
92 p_num_tbl => X_Q_INV_TO_PTY_SITE_ID_TBL,
93 x_num_id => X_Q_INV_TO_PTY_SITE_ID
94 );
95
96 ASO_QUOTE_UTIL_PVT.Set_num_Tbl_Out
97 (
98 p_num_tbl => X_Q_ORDER_TYPE_ID_TBL,
99 x_num_id => X_Q_ORDER_TYPE_ID
100 );
101
102 ASO_QUOTE_UTIL_PVT.Set_num_Tbl_Out
103 (
104 p_num_tbl => X_Q_ORG_ID_TBL,
105 x_num_id => X_Q_ORG_ID
106 );
107
108 ASO_QUOTE_UTIL_PVT.Set_num_Tbl_Out
109 (
110 p_num_tbl => X_Q_PRICE_LIST_ID_TBL,
111 x_num_id => X_Q_PRICE_LIST_ID
112 );
113
114 ASO_QUOTE_UTIL_PVT.Set_num_Tbl_Out
115 (
116 p_num_tbl => X_Q_RESOURCE_ID_TBL,
117 x_num_id => X_Q_RESOURCE_ID
118 );
119
120 ASO_QUOTE_UTIL_PVT.Set_num_Tbl_Out
121 (
122 p_num_tbl => X_Q_SHIP_TO_CUST_ACCT_ID_TBL,
123 x_num_id => X_Q_SHIP_TO_CUST_ACCT_ID
124 );
128 (
125
126
127 ASO_QUOTE_UTIL_PVT.Set_num_Tbl_Out
129 p_num_tbl => X_Q_SHIP_TO_PARTY_SITE_ID_TBL,
130 x_num_id => X_Q_SHIP_TO_PARTY_SITE_ID
131 );
132
133
134 END Get_Dependent_Attributes_Sets;
135
136
137 END ASO_QUOTE_HEADER_DEP_HDLR_W;
138
139