APPS.ASO_CHECK_TCA_PVT dependencies on ASO_QUOTE_PUB

Line 17: P_Qte_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type,

13:
14: PROCEDURE check_tca(
15: p_api_version IN NUMBER,
16: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
17: P_Qte_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type,
18: P_Header_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
19: P_Operation_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: p_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
21: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 18: P_Header_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,

14: PROCEDURE check_tca(
15: p_api_version IN NUMBER,
16: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
17: P_Qte_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type,
18: P_Header_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
19: P_Operation_Code IN VARCHAR2 := FND_API.G_MISS_CHAR,
20: p_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
21: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
22: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 54: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;

50: l_sold_to_contact_id NUMBER;
51: lx_cust_account_id NUMBER;
52: l_party_type VARCHAR2(30);
53:
54: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
55: l_shipment_rec ASO_QUOTE_PUB.shipment_rec_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
56:
57: BEGIN
58:

Line 55: l_shipment_rec ASO_QUOTE_PUB.shipment_rec_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;

51: lx_cust_account_id NUMBER;
52: l_party_type VARCHAR2(30);
53:
54: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
55: l_shipment_rec ASO_QUOTE_PUB.shipment_rec_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
56:
57: BEGIN
58:
59: SAVEPOINT CHECK_TCA_PVT;

Line 418: P_Qte_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type,

414: PROCEDURE check_header_account_info(
415: p_api_version IN NUMBER,
416: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
417: p_cust_account_id IN NUMBER,
418: P_Qte_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type,
419: P_Header_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
420: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
421: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
422: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 419: P_Header_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,

415: p_api_version IN NUMBER,
416: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
417: p_cust_account_id IN NUMBER,
418: P_Qte_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type,
419: P_Header_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
420: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
421: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
422: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
423: IS

Line 970: P_Qte_Line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,

966: PROCEDURE check_line_account_info(
967: p_api_version IN NUMBER,
968: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
969: p_cust_account_id IN NUMBER,
970: P_Qte_Line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,
971: P_Line_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
972: p_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
973: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
974: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 971: P_Line_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,

967: p_api_version IN NUMBER,
968: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
969: p_cust_account_id IN NUMBER,
970: P_Qte_Line_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Line_Rec_Type,
971: P_Line_Shipment_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Shipment_Tbl_Type,
972: p_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
973: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
974: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
975: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 1001: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec;

997: l_cust_party_id NUMBER := NULL;
998: l_cust_acct_id NUMBER := NULL;
999: j NUMBER := 1;
1000:
1001: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec;
1002: l_shipment_rec ASO_QUOTE_PUB.shipment_rec_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
1003:
1004: CURSOR get_cust_acct_site_id(l_site_use_id number) IS
1005: select cust_acct_site_id from hz_cust_site_uses

Line 1002: l_shipment_rec ASO_QUOTE_PUB.shipment_rec_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;

998: l_cust_acct_id NUMBER := NULL;
999: j NUMBER := 1;
1000:
1001: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Rec;
1002: l_shipment_rec ASO_QUOTE_PUB.shipment_rec_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_REC;
1003:
1004: CURSOR get_cust_acct_site_id(l_site_use_id number) IS
1005: select cust_acct_site_id from hz_cust_site_uses
1006: where site_use_id = l_site_use_id;

Line 2610: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

2606: l_inv_cust_acct NUMBER;
2607: l_cust_party NUMBER;
2608: l_inv_cust_party NUMBER;
2609: l_account_id NUMBER;
2610: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
2611: l_header_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2612: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2613: l_line_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2614: l_header_check_tca_flag VARCHAR(1) := 'N';

Line 2611: l_header_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

2607: l_cust_party NUMBER;
2608: l_inv_cust_party NUMBER;
2609: l_account_id NUMBER;
2610: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
2611: l_header_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2612: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2613: l_line_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2614: l_header_check_tca_flag VARCHAR(1) := 'N';
2615: l_dummy VARCHAR2(1) := NULL;

Line 2612: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

2608: l_inv_cust_party NUMBER;
2609: l_account_id NUMBER;
2610: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
2611: l_header_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2612: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2613: l_line_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2614: l_header_check_tca_flag VARCHAR(1) := 'N';
2615: l_dummy VARCHAR2(1) := NULL;
2616: l_last_update_date date := SYSDATE;

Line 2613: l_line_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

2609: l_account_id NUMBER;
2610: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
2611: l_header_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2612: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2613: l_line_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2614: l_header_check_tca_flag VARCHAR(1) := 'N';
2615: l_dummy VARCHAR2(1) := NULL;
2616: l_last_update_date date := SYSDATE;
2617: l_g_user_id number := fnd_global.user_id;

Line 2940: l_qte_line_rec := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;

2936: end if;
2937:
2938: FOR Line_Acct IN C_Get_Line_Acct(p_qte_header_id) LOOP
2939:
2940: l_qte_line_rec := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;
2941: l_line_shipment_tbl := ASO_QUOTE_PUB.G_MISS_Shipment_TBL;
2942:
2943: l_qte_line_rec.quote_header_id := p_qte_header_id;
2944: l_qte_line_rec.invoice_to_cust_account_id := Line_Acct.invoice_to_cust_account_id;

Line 2941: l_line_shipment_tbl := ASO_QUOTE_PUB.G_MISS_Shipment_TBL;

2937:
2938: FOR Line_Acct IN C_Get_Line_Acct(p_qte_header_id) LOOP
2939:
2940: l_qte_line_rec := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;
2941: l_line_shipment_tbl := ASO_QUOTE_PUB.G_MISS_Shipment_TBL;
2942:
2943: l_qte_line_rec.quote_header_id := p_qte_header_id;
2944: l_qte_line_rec.invoice_to_cust_account_id := Line_Acct.invoice_to_cust_account_id;
2945: l_qte_line_rec.invoice_to_party_site_id := Line_Acct.invoice_to_party_site_id;