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_ATP_INT dependencies on ASO_QUOTE_PUB

Line 386: p_qte_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,

382:
383: PROCEDURE Do_Check_ATP(
384: P_Api_Version_Number IN NUMBER,
385: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
386: p_qte_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
387: p_qte_line_tbl IN ASO_QUOTE_PUB.qte_line_tbl_type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
388: p_shipment_tbl IN ASO_QUOTE_PUB.shipment_tbl_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
389: p_entire_quote_flag IN VARCHAR2 :='N',
390: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 387: p_qte_line_tbl IN ASO_QUOTE_PUB.qte_line_tbl_type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,

383: PROCEDURE Do_Check_ATP(
384: P_Api_Version_Number IN NUMBER,
385: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
386: p_qte_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
387: p_qte_line_tbl IN ASO_QUOTE_PUB.qte_line_tbl_type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
388: p_shipment_tbl IN ASO_QUOTE_PUB.shipment_tbl_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
389: p_entire_quote_flag IN VARCHAR2 :='N',
390: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
391: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 388: p_shipment_tbl IN ASO_QUOTE_PUB.shipment_tbl_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,

384: P_Api_Version_Number IN NUMBER,
385: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
386: p_qte_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
387: p_qte_line_tbl IN ASO_QUOTE_PUB.qte_line_tbl_type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
388: p_shipment_tbl IN ASO_QUOTE_PUB.shipment_tbl_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
389: p_entire_quote_flag IN VARCHAR2 :='N',
390: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
391: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
392: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 418: l_qte_line_tbl aso_quote_pub.qte_line_tbl_type := p_qte_line_tbl;

414: l_mrp_ship_site_id NUMBER;
415: l_use_sourcing_rule VARCHAR2(10);
416: l_file VARCHAR2(200);
417:
418: l_qte_line_tbl aso_quote_pub.qte_line_tbl_type := p_qte_line_tbl;
419: l_shipment_tbl aso_quote_pub.shipment_tbl_type := p_shipment_tbl;
420: l_qte_line_rec aso_quote_pub.qte_line_rec_type;
421: l_shipment_rec aso_quote_pub.shipment_rec_type;
422: --l_aso_atp_tbl aso_atp_int.atp_tbl_typ;

Line 419: l_shipment_tbl aso_quote_pub.shipment_tbl_type := p_shipment_tbl;

415: l_use_sourcing_rule VARCHAR2(10);
416: l_file VARCHAR2(200);
417:
418: l_qte_line_tbl aso_quote_pub.qte_line_tbl_type := p_qte_line_tbl;
419: l_shipment_tbl aso_quote_pub.shipment_tbl_type := p_shipment_tbl;
420: l_qte_line_rec aso_quote_pub.qte_line_rec_type;
421: l_shipment_rec aso_quote_pub.shipment_rec_type;
422: --l_aso_atp_tbl aso_atp_int.atp_tbl_typ;
423:

Line 420: l_qte_line_rec aso_quote_pub.qte_line_rec_type;

416: l_file VARCHAR2(200);
417:
418: l_qte_line_tbl aso_quote_pub.qte_line_tbl_type := p_qte_line_tbl;
419: l_shipment_tbl aso_quote_pub.shipment_tbl_type := p_shipment_tbl;
420: l_qte_line_rec aso_quote_pub.qte_line_rec_type;
421: l_shipment_rec aso_quote_pub.shipment_rec_type;
422: --l_aso_atp_tbl aso_atp_int.atp_tbl_typ;
423:
424: cursor c_description(p_inventory_item_id number,p_organization_id number) is

Line 421: l_shipment_rec aso_quote_pub.shipment_rec_type;

417:
418: l_qte_line_tbl aso_quote_pub.qte_line_tbl_type := p_qte_line_tbl;
419: l_shipment_tbl aso_quote_pub.shipment_tbl_type := p_shipment_tbl;
420: l_qte_line_rec aso_quote_pub.qte_line_rec_type;
421: l_shipment_rec aso_quote_pub.shipment_rec_type;
422: --l_aso_atp_tbl aso_atp_int.atp_tbl_typ;
423:
424: cursor c_description(p_inventory_item_id number,p_organization_id number) is
425: -- this cursor has been modified to select segment1 instead of description, see bug 3604265

Line 553: l_db_shipment_rec aso_quote_pub.shipment_rec_type;

549: l_shipment_search_tbl Number_Search_Tbl_Type;
550: l_config_hdr_search_tbl Number_Search_Tbl_Type;
551: l_ato_tbl Number_Search_Tbl_Type;
552: l_ato_line_id_tbl Number_Search_Tbl_Type;
553: l_db_shipment_rec aso_quote_pub.shipment_rec_type;
554: l_db_qte_line_rec aso_quote_pub.qte_line_rec_type;
555: l_check_atp_for_whole_quote varchar2(1) := fnd_api.g_false;
556: l_ship_to_party_site_id number;
557: l_ship_to_cust_account_id number;

Line 554: l_db_qte_line_rec aso_quote_pub.qte_line_rec_type;

550: l_config_hdr_search_tbl Number_Search_Tbl_Type;
551: l_ato_tbl Number_Search_Tbl_Type;
552: l_ato_line_id_tbl Number_Search_Tbl_Type;
553: l_db_shipment_rec aso_quote_pub.shipment_rec_type;
554: l_db_qte_line_rec aso_quote_pub.qte_line_rec_type;
555: l_check_atp_for_whole_quote varchar2(1) := fnd_api.g_false;
556: l_ship_to_party_site_id number;
557: l_ship_to_cust_account_id number;
558: lx_cust_acct_site_use_id number;

Line 565: l_new_qte_line_tbl aso_quote_pub.qte_line_tbl_type ;

561:
562: l_search_tbl Number_Search_Tbl_Type;
563: l_qte_line_id_from_bali number;
564: l_no_of_lines number;
565: l_new_qte_line_tbl aso_quote_pub.qte_line_tbl_type ;
566: l_new_shipment_tbl aso_quote_pub.shipment_tbl_type ;
567:
568: l_cascade_ship_from_org_id number;
569: l_cascade_request_date date;

Line 566: l_new_shipment_tbl aso_quote_pub.shipment_tbl_type ;

562: l_search_tbl Number_Search_Tbl_Type;
563: l_qte_line_id_from_bali number;
564: l_no_of_lines number;
565: l_new_qte_line_tbl aso_quote_pub.qte_line_tbl_type ;
566: l_new_shipment_tbl aso_quote_pub.shipment_tbl_type ;
567:
568: l_cascade_ship_from_org_id number;
569: l_cascade_request_date date;
570: l_cascade_ship_method_code varchar2(30);

Line 577: l_hdr_shipment_rec aso_quote_pub.shipment_rec_type;

573: l_model_line_id number;
574: l_shipment_id number;
575: x_new_msg_data varchar2(3000);
576: m integer;
577: l_hdr_shipment_rec aso_quote_pub.shipment_rec_type;
578: l_hdr_shipment_tbl aso_quote_pub.shipment_tbl_type ;
579: BEGIN
580: -- Standard Start of API savepoint
581: SAVEPOINT DO_CHECK_ATP_INT;

Line 578: l_hdr_shipment_tbl aso_quote_pub.shipment_tbl_type ;

574: l_shipment_id number;
575: x_new_msg_data varchar2(3000);
576: m integer;
577: l_hdr_shipment_rec aso_quote_pub.shipment_rec_type;
578: l_hdr_shipment_tbl aso_quote_pub.shipment_tbl_type ;
579: BEGIN
580: -- Standard Start of API savepoint
581: SAVEPOINT DO_CHECK_ATP_INT;
582:

Line 1966: p_qte_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,

1962:
1963: PROCEDURE Check_ATP(
1964: P_Api_Version_Number IN NUMBER,
1965: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1966: p_qte_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
1967: p_qte_line_tbl IN ASO_QUOTE_PUB.qte_line_tbl_type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
1968: p_shipment_tbl IN ASO_QUOTE_PUB.shipment_tbl_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
1969: p_entire_quote_flag IN VARCHAR2 := 'N',
1970: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 1967: p_qte_line_tbl IN ASO_QUOTE_PUB.qte_line_tbl_type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,

1963: PROCEDURE Check_ATP(
1964: P_Api_Version_Number IN NUMBER,
1965: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1966: p_qte_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
1967: p_qte_line_tbl IN ASO_QUOTE_PUB.qte_line_tbl_type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
1968: p_shipment_tbl IN ASO_QUOTE_PUB.shipment_tbl_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
1969: p_entire_quote_flag IN VARCHAR2 := 'N',
1970: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1971: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 1968: p_shipment_tbl IN ASO_QUOTE_PUB.shipment_tbl_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,

1964: P_Api_Version_Number IN NUMBER,
1965: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1966: p_qte_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
1967: p_qte_line_tbl IN ASO_QUOTE_PUB.qte_line_tbl_type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL,
1968: p_shipment_tbl IN ASO_QUOTE_PUB.shipment_tbl_type := ASO_QUOTE_PUB.G_MISS_SHIPMENT_TBL,
1969: p_entire_quote_flag IN VARCHAR2 := 'N',
1970: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1971: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1972: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 2362: p_qte_line_tbl IN ASO_QUOTE_PUB.qte_line_tbl_type,

2358:
2359: PROCEDURE Check_ATP(
2360: P_Api_Version_Number IN NUMBER,
2361: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2362: p_qte_line_tbl IN ASO_QUOTE_PUB.qte_line_tbl_type,
2363: p_shipment_tbl IN ASO_QUOTE_PUB.shipment_tbl_type,
2364: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2365: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2366: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 2363: p_shipment_tbl IN ASO_QUOTE_PUB.shipment_tbl_type,

2359: PROCEDURE Check_ATP(
2360: P_Api_Version_Number IN NUMBER,
2361: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2362: p_qte_line_tbl IN ASO_QUOTE_PUB.qte_line_tbl_type,
2363: p_shipment_tbl IN ASO_QUOTE_PUB.shipment_tbl_type,
2364: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2365: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2366: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2367: X_atp_tbl OUT NOCOPY /* file.sql.39 change */ aso_atp_int.atp_tbl_typ

Line 2371: l_qte_header_rec aso_quote_pub.qte_header_rec_type;

2367: X_atp_tbl OUT NOCOPY /* file.sql.39 change */ aso_atp_int.atp_tbl_typ
2368: )
2369: IS
2370:
2371: l_qte_header_rec aso_quote_pub.qte_header_rec_type;
2372:
2373: Begin
2374: x_return_status := fnd_api.g_ret_sts_success;
2375: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');

Line 2420: p_qte_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,

2416: PROCEDURE update_configuration(
2417: P_Api_Version_Number IN NUMBER,
2418: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2419: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2420: p_qte_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
2421: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.qte_line_dtl_tbl_type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
2422: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2423: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2424: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 2421: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.qte_line_dtl_tbl_type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,

2417: P_Api_Version_Number IN NUMBER,
2418: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
2419: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2420: p_qte_header_rec IN ASO_QUOTE_PUB.QTE_HEADER_REC_TYPE,
2421: p_qte_line_dtl_tbl IN ASO_QUOTE_PUB.qte_line_dtl_tbl_type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL,
2422: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2423: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2424: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2425: )

Line 2430: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;

2426: IS
2427:
2428: l_api_name CONSTANT VARCHAR2(30) := 'update_configuration' ;
2429: l_api_version_number CONSTANT NUMBER := 1.0;
2430: l_qte_line_dtl_tbl ASO_QUOTE_PUB.qte_line_dtl_tbl_type := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
2431:
2432: Cursor get_line_details(l_qte_header_id NUMBER) IS
2433: SELECT b.config_header_id,b.config_revision_num,b.quote_line_id
2434: from aso_quote_lines_all a, aso_quote_line_details b