DBA Data[Home] [Help]

APPS.ASO_QUOTE_HEADERS_PVT dependencies on ASO_QUOTE_HEADERS_PVT

Line 1: PACKAGE BODY ASO_QUOTE_HEADERS_PVT as

1: PACKAGE BODY ASO_QUOTE_HEADERS_PVT as
2: /* $Header: asovqhdb.pls 120.45 2006/06/13 21:37:46 skulkarn ship $ */
3: -- Start of Comments
4: -- Package name : ASO_QUOTE_HEADERS_PVT
5: -- Purpose :

Line 4: -- Package name : ASO_QUOTE_HEADERS_PVT

1: PACKAGE BODY ASO_QUOTE_HEADERS_PVT as
2: /* $Header: asovqhdb.pls 120.45 2006/06/13 21:37:46 skulkarn ship $ */
3: -- Start of Comments
4: -- Package name : ASO_QUOTE_HEADERS_PVT
5: -- Purpose :
6: -- History :
7: -- 10/18/2002 hyang - 2633507, performance fix
8: -- 12/06/2002 hyang - 2686076, changed definition of lx_contract_number

Line 20: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_QUOTE_HEADERS_PVT';

16: -- NOTE :
17: -- End of Comments
18:
19:
20: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_QUOTE_HEADERS_PVT';
21: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asovqhdb.pls';
22:
23: G_QUOTE_DURATION CONSTANT NUMBER := 30;
24:

Line 6475: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT.CREATE_QUOTE : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || x_qte_header_rec.quote_number, 1, 'Y');

6471: -- Release 12 TAP Changes
6472: -- Girish Sachdeva 8/30/2005
6473: -- Adding the call to insert record in the ASO_CHANGED_QUOTES
6474: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6475: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT.CREATE_QUOTE : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || x_qte_header_rec.quote_number, 1, 'Y');
6476: END IF;
6477:
6478:
6479: -- Call to insert record in ASO_CHANGED_QUOTES

Line 6794: l_deactivate_instance_tbl aso_quote_headers_pvt.Instance_Tbl_Type := aso_quote_headers_pvt.G_MISS_Instance_Tbl;

6790: and config_rev_nbr = p_config_rev_nbr;
6791:
6792: l_deactivate_qte_header_rec aso_quote_pub.qte_header_rec_type;
6793: l_deactivate_quote_line_tbl aso_quote_pub.qte_line_tbl_type := aso_quote_pub.g_miss_qte_line_tbl;
6794: l_deactivate_instance_tbl aso_quote_headers_pvt.Instance_Tbl_Type := aso_quote_headers_pvt.G_MISS_Instance_Tbl;
6795: l_deactivate_counter number := 0;
6796:
6797: -- End Variable declaration for Batch Validation 05/24/2002
6798:

Line 10509: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT.UPDATE_QUOTE : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || x_qte_header_rec.quote_number, 1, 'Y');

10505: -- Girish Sachdeva 8/30/2005
10506: -- Adding the call to insert record in the ASO_CHANGED_QUOTES
10507:
10508: IF aso_debug_pub.g_debug_flag = 'Y' THEN
10509: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT.UPDATE_QUOTE : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || x_qte_header_rec.quote_number, 1, 'Y');
10510: END IF;
10511:
10512: -- Call to insert record in ASO_CHANGED_QUOTES
10513: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(x_qte_header_rec.quote_number);

Line 12103: l_line_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,

12099: x_qte_header_id IN NUMBER,
12100: qte_header_id IN NUMBER,
12101: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
12102: P_control_rec IN ASO_QUOTE_PUB.control_rec_type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
12103: l_line_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
12104: l_price_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
12105: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
12106: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
12107: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 12104: l_price_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,

12100: qte_header_id IN NUMBER,
12101: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
12102: P_control_rec IN ASO_QUOTE_PUB.control_rec_type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
12103: l_line_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
12104: l_price_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
12105: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
12106: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
12107: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
12108: )

Line 12340: ASO_QUOTE_HEADERS_PVT.service_copy(

12336: aso_debug_pub.add('Copy - l_qte_line_tbl(i).inventory_item_id '|| l_qte_line_rec.inventory_item_id, 1, 'Y');
12337: aso_debug_pub.add('Copy - l_serviceable_product_flag '|| l_serviceable_product_flag, 1, 'Y');
12338: END IF;
12339: IF l_serviceable_product_flag = 'Y' THEN
12340: ASO_QUOTE_HEADERS_PVT.service_copy(
12341: p_qte_line_id => l_quote_line_id,
12342: p_control_rec => p_control_rec,
12343: x_qte_header_id => x_qte_header_id,
12344: qte_header_id => qte_header_id,

Line 12392: l_line_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,

12388: x_qte_header_id IN NUMBER,
12389: qte_header_id IN NUMBER,
12390: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
12391: P_control_rec IN ASO_QUOTE_PUB.control_rec_type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
12392: l_line_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
12393: l_price_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
12394: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
12395: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
12396: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 12393: l_price_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,

12389: qte_header_id IN NUMBER,
12390: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
12391: P_control_rec IN ASO_QUOTE_PUB.control_rec_type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
12392: l_line_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
12393: l_price_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
12394: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
12395: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
12396: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
12397: )

Line 12769: End ASO_QUOTE_HEADERS_PVT;

12765:
12766: End Quote_Security_Check;
12767:
12768:
12769: End ASO_QUOTE_HEADERS_PVT;