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.

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.66.12020000.3 2012/07/19 14:41:12 akushwah 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.66.12020000.3 2012/07/19 14:41:12 akushwah 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 6613: 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');

6609: -- Release 12 TAP Changes
6610: -- Girish Sachdeva 8/30/2005
6611: -- Adding the call to insert record in the ASO_CHANGED_QUOTES
6612: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6613: 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');
6614: END IF;
6615:
6616:
6617: -- Call to insert record in ASO_CHANGED_QUOTES

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

6930: and config_rev_nbr = p_config_rev_nbr;
6931:
6932: l_deactivate_qte_header_rec aso_quote_pub.qte_header_rec_type;
6933: l_deactivate_quote_line_tbl aso_quote_pub.qte_line_tbl_type := aso_quote_pub.g_miss_qte_line_tbl;
6934: l_deactivate_instance_tbl aso_quote_headers_pvt.Instance_Tbl_Type := aso_quote_headers_pvt.G_MISS_Instance_Tbl;
6935: l_deactivate_counter number := 0;
6936:
6937: -- End Variable declaration for Batch Validation 05/24/2002
6938:

Line 8018: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT UPDATE_QUOTE: header_id'||l_qte_header_rec.quote_header_id);

8014: -- Fetching the value from DB for end customer and sold to for validation
8015: OPEN C_get_cust(l_qte_header_rec.quote_header_id);
8016: FETCH C_get_cust INTO ls_end_cust_account_id,ls_cust_account_id;
8017: IF aso_debug_pub.g_debug_flag = 'Y' THEN
8018: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT UPDATE_QUOTE: header_id'||l_qte_header_rec.quote_header_id);
8019: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT UPDATE_QUOTE: cust Acct id'||ls_cust_account_id);
8020: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT UPDATE_QUOTE: end cust Acct id'||ls_end_cust_account_id);
8021: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT UPDATE_QUOTE: record end cust Acct id'||p_qte_header_rec.END_CUSTOMER_CUST_ACCOUNT_ID);
8022: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT UPDATE_QUOTE: record end LAST_UPDATED_BY'||p_qte_header_rec.LAST_UPDATED_BY);

Line 8019: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT UPDATE_QUOTE: cust Acct id'||ls_cust_account_id);

8015: OPEN C_get_cust(l_qte_header_rec.quote_header_id);
8016: FETCH C_get_cust INTO ls_end_cust_account_id,ls_cust_account_id;
8017: IF aso_debug_pub.g_debug_flag = 'Y' THEN
8018: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT UPDATE_QUOTE: header_id'||l_qte_header_rec.quote_header_id);
8019: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT UPDATE_QUOTE: cust Acct id'||ls_cust_account_id);
8020: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT UPDATE_QUOTE: end cust Acct id'||ls_end_cust_account_id);
8021: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT UPDATE_QUOTE: record end cust Acct id'||p_qte_header_rec.END_CUSTOMER_CUST_ACCOUNT_ID);
8022: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT UPDATE_QUOTE: record end LAST_UPDATED_BY'||p_qte_header_rec.LAST_UPDATED_BY);
8023: END IF;

Line 8020: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT UPDATE_QUOTE: end cust Acct id'||ls_end_cust_account_id);

8016: FETCH C_get_cust INTO ls_end_cust_account_id,ls_cust_account_id;
8017: IF aso_debug_pub.g_debug_flag = 'Y' THEN
8018: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT UPDATE_QUOTE: header_id'||l_qte_header_rec.quote_header_id);
8019: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT UPDATE_QUOTE: cust Acct id'||ls_cust_account_id);
8020: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT UPDATE_QUOTE: end cust Acct id'||ls_end_cust_account_id);
8021: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT UPDATE_QUOTE: record end cust Acct id'||p_qte_header_rec.END_CUSTOMER_CUST_ACCOUNT_ID);
8022: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT UPDATE_QUOTE: record end LAST_UPDATED_BY'||p_qte_header_rec.LAST_UPDATED_BY);
8023: END IF;
8024: IF C_get_cust%NOTFOUND THEN

Line 8021: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT UPDATE_QUOTE: record end cust Acct id'||p_qte_header_rec.END_CUSTOMER_CUST_ACCOUNT_ID);

8017: IF aso_debug_pub.g_debug_flag = 'Y' THEN
8018: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT UPDATE_QUOTE: header_id'||l_qte_header_rec.quote_header_id);
8019: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT UPDATE_QUOTE: cust Acct id'||ls_cust_account_id);
8020: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT UPDATE_QUOTE: end cust Acct id'||ls_end_cust_account_id);
8021: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT UPDATE_QUOTE: record end cust Acct id'||p_qte_header_rec.END_CUSTOMER_CUST_ACCOUNT_ID);
8022: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT UPDATE_QUOTE: record end LAST_UPDATED_BY'||p_qte_header_rec.LAST_UPDATED_BY);
8023: END IF;
8024: IF C_get_cust%NOTFOUND THEN
8025: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 8022: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT UPDATE_QUOTE: record end LAST_UPDATED_BY'||p_qte_header_rec.LAST_UPDATED_BY);

8018: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT UPDATE_QUOTE: header_id'||l_qte_header_rec.quote_header_id);
8019: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT UPDATE_QUOTE: cust Acct id'||ls_cust_account_id);
8020: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT UPDATE_QUOTE: end cust Acct id'||ls_end_cust_account_id);
8021: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT UPDATE_QUOTE: record end cust Acct id'||p_qte_header_rec.END_CUSTOMER_CUST_ACCOUNT_ID);
8022: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT UPDATE_QUOTE: record end LAST_UPDATED_BY'||p_qte_header_rec.LAST_UPDATED_BY);
8023: END IF;
8024: IF C_get_cust%NOTFOUND THEN
8025: IF aso_debug_pub.g_debug_flag = 'Y' THEN
8026: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT END CUST NOT FOUND');

Line 8026: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT END CUST NOT FOUND');

8022: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT UPDATE_QUOTE: record end LAST_UPDATED_BY'||p_qte_header_rec.LAST_UPDATED_BY);
8023: END IF;
8024: IF C_get_cust%NOTFOUND THEN
8025: IF aso_debug_pub.g_debug_flag = 'Y' THEN
8026: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT END CUST NOT FOUND');
8027: END IF;
8028: ls_cust_account_id := NULL;
8029: ls_end_cust_account_id:= NULL;
8030: END IF;

Line 11580: 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');

11576: -- Girish Sachdeva 8/30/2005
11577: -- Adding the call to insert record in the ASO_CHANGED_QUOTES
11578:
11579: IF aso_debug_pub.g_debug_flag = 'Y' THEN
11580: 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');
11581: END IF;
11582:
11583: -- Call to insert record in ASO_CHANGED_QUOTES
11584: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(x_qte_header_rec.quote_number);

Line 13174: l_line_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,

13170: x_qte_header_id IN NUMBER,
13171: qte_header_id IN NUMBER,
13172: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
13173: P_control_rec IN ASO_QUOTE_PUB.control_rec_type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
13174: l_line_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
13175: l_price_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
13176: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
13177: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
13178: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 13175: l_price_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,

13171: qte_header_id IN NUMBER,
13172: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
13173: P_control_rec IN ASO_QUOTE_PUB.control_rec_type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
13174: l_line_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
13175: l_price_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
13176: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
13177: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
13178: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
13179: )

Line 13411: ASO_QUOTE_HEADERS_PVT.service_copy(

13407: aso_debug_pub.add('Copy - l_qte_line_tbl(i).inventory_item_id '|| l_qte_line_rec.inventory_item_id, 1, 'Y');
13408: aso_debug_pub.add('Copy - l_serviceable_product_flag '|| l_serviceable_product_flag, 1, 'Y');
13409: END IF;
13410: IF l_serviceable_product_flag = 'Y' THEN
13411: ASO_QUOTE_HEADERS_PVT.service_copy(
13412: p_qte_line_id => l_quote_line_id,
13413: p_control_rec => p_control_rec,
13414: x_qte_header_id => x_qte_header_id,
13415: qte_header_id => qte_header_id,

Line 13463: l_line_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,

13459: x_qte_header_id IN NUMBER,
13460: qte_header_id IN NUMBER,
13461: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
13462: P_control_rec IN ASO_QUOTE_PUB.control_rec_type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
13463: l_line_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
13464: l_price_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
13465: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
13466: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
13467: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 13464: l_price_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,

13460: qte_header_id IN NUMBER,
13461: p_qte_line_rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
13462: P_control_rec IN ASO_QUOTE_PUB.control_rec_type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
13463: l_line_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
13464: l_price_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
13465: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
13466: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
13467: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
13468: )

Line 13840: End ASO_QUOTE_HEADERS_PVT;

13836:
13837: End Quote_Security_Check;
13838:
13839:
13840: End ASO_QUOTE_HEADERS_PVT;