[Home] [Help]
PACKAGE BODY: APPS.ASO_QUOTE_LINE_DEP_HDLR_W
Source
1 PACKAGE BODY ASO_QUOTE_LINE_DEP_HDLR_W AS
2 /* $Header: asovqwlb.pls 120.2 2006/05/19 11:34:52 gkeshava noship $ */
3 -- Start of Comments
4 -- Package name : ASO_QUOTE_LINE_DEP_HDLR_W
5
6
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_QUOTE_LINE_DEP_HDLR_W';
8 G_FILE_NAME CONSTANT VARCHAR2(12) := 'asovqwlb.pls';
9
10 PROCEDURE Get_Dependent_Attributes_Sets
11 (
12 X_L_AGREEMENT_ID OUT NOCOPY jtf_number_table
13 , X_L_INV_TO_CUST_ACCT_ID OUT NOCOPY jtf_number_table
14 , X_L_INV_TO_PTY_SITE_ID OUT NOCOPY jtf_number_table
15 , X_L_ORDER_LINE_TYPE_ID OUT NOCOPY jtf_number_table
16 , X_L_PRICE_LIST_ID OUT NOCOPY jtf_number_table
17 , X_L_SHIP_TO_CUST_ACCT_ID OUT NOCOPY jtf_number_table
18 , X_L_SHIP_TO_PARTY_SITE_ID OUT NOCOPY jtf_number_table
19 , X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2
20 , X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER
21 , X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2
22 )
23 IS
24 X_L_AGREEMENT_ID_tbl ASO_DEFAULTING_INT.ATTRIBUTE_IDS_TBL_TYPE;
25 X_L_INV_TO_CUST_ACCT_ID_TBL ASO_DEFAULTING_INT.ATTRIBUTE_IDS_TBL_TYPE;
26 X_L_INV_TO_PTY_SITE_ID_TBL ASO_DEFAULTING_INT.ATTRIBUTE_IDS_TBL_TYPE;
27 X_L_ORDER_LINE_TYPE_ID_TBL ASO_DEFAULTING_INT.ATTRIBUTE_IDS_TBL_TYPE;
28 X_L_PRICE_LIST_ID_TBL ASO_DEFAULTING_INT.ATTRIBUTE_IDS_TBL_TYPE;
29 X_L_SHIP_TO_CUST_ACCT_ID_TBL ASO_DEFAULTING_INT.ATTRIBUTE_IDS_TBL_TYPE;
30 X_L_SHIP_TO_PARTY_SITE_ID_TBL ASO_DEFAULTING_INT.ATTRIBUTE_IDS_TBL_TYPE;
31
32 Begin
33
34 ASO_QUOTE_LINE_DEP_HDLR.Get_Dependent_Attributes_Sets
35 ( P_INIT_MSG_LIST => fnd_api.g_false
36 , X_L_AGREEMENT_ID_TBL => X_L_AGREEMENT_ID_tbl
37 , X_L_INV_TO_CUST_ACCT_ID_TBL => X_L_INV_TO_CUST_ACCT_ID_TBL
38 , X_L_INV_TO_PTY_SITE_ID_TBL => X_L_INV_TO_PTY_SITE_ID_TBL
39 , X_L_ORDER_LINE_TYPE_ID_TBL => X_L_ORDER_LINE_TYPE_ID_TBL
40 , X_L_PRICE_LIST_ID_TBL => X_L_PRICE_LIST_ID_TBL
41 , X_L_SHIP_TO_CUST_ACCT_ID_TBL => X_L_SHIP_TO_CUST_ACCT_ID_TBL
42 , X_L_SHIP_TO_PARTY_SITE_ID_TBL => X_L_SHIP_TO_PARTY_SITE_ID_TBL
43 , X_RETURN_STATUS => X_RETURN_STATUS
44 , X_MSG_COUNT => X_MSG_COUNT
45 , X_MSG_DATA => X_MSG_DATA
46 );
47
48
49 ASO_QUOTE_UTIL_PVT.Set_num_Tbl_Out
50 (
51 p_num_tbl => X_L_AGREEMENT_ID_tbl,
52 x_num_id => X_L_AGREEMENT_ID
53 );
54
55 ASO_QUOTE_UTIL_PVT.Set_num_Tbl_Out
56 (
57 p_num_tbl => X_L_INV_TO_CUST_ACCT_ID_TBL,
58 x_num_id => X_L_INV_TO_CUST_ACCT_ID
59 );
60
61 ASO_QUOTE_UTIL_PVT.Set_num_Tbl_Out
62 (
63 p_num_tbl => X_L_INV_TO_PTY_SITE_ID_TBL,
64 x_num_id => X_L_INV_TO_PTY_SITE_ID
65 );
66
67
68 ASO_QUOTE_UTIL_PVT.Set_num_Tbl_Out
69 (
70 p_num_tbl => X_L_ORDER_LINE_TYPE_ID_TBL,
71 x_num_id => X_L_ORDER_LINE_TYPE_ID
72 );
73
74
75 ASO_QUOTE_UTIL_PVT.Set_num_Tbl_Out
76 (
77 p_num_tbl => X_L_PRICE_LIST_ID_TBL,
78 x_num_id => X_L_PRICE_LIST_ID
79 );
80
81
82 ASO_QUOTE_UTIL_PVT.Set_num_Tbl_Out
83 (
84 p_num_tbl => X_L_SHIP_TO_CUST_ACCT_ID_TBL,
85 x_num_id => X_L_SHIP_TO_CUST_ACCT_ID
86 );
87
88 ASO_QUOTE_UTIL_PVT.Set_num_Tbl_Out
89 (
90 p_num_tbl => X_L_SHIP_TO_PARTY_SITE_ID_TBL,
91 x_num_id => X_L_SHIP_TO_PARTY_SITE_ID
92 );
93
94
95
96 END Get_Dependent_Attributes_Sets;
97
98
99 END ASO_QUOTE_LINE_DEP_HDLR_W;
100
101