APPS.ASO_CONC_REQ_INT dependencies on ASO_QUOTE_HEADERS_ALL

Line 484: FROM ASO_QUOTE_HEADERS_ALL a

480: Begin
481:
482: begin
483: SELECT a.quote_name ,a.price_request_id, a.org_id into l_quote_name ,l_request_id, l_org_id
484: FROM ASO_QUOTE_HEADERS_ALL a
485: WHERE a.quote_header_id = p_quote_header_id;
486: end;
487:
488: FND_FILE.PUT_LINE(FND_FILE.LOG,l_quote_name);

Line 497: FROM ASO_QUOTE_HEADERS_ALL a

493: end;
494:
495: begin
496: SELECT a.last_update_date into l_last_update_date
497: FROM ASO_QUOTE_HEADERS_ALL a
498: WHERE a.quote_header_id = p_quote_header_id;
499: end;
500:
501:

Line 702: select a.quote_name,a.price_request_id from aso_quote_headers_all a

698: ) is
699:
700: Cursor find_quote_csr(p_quote_header_id IN Number) is
701:
702: select a.quote_name,a.price_request_id from aso_quote_headers_all a
703: where a.quote_header_id = p_quote_header_id;
704:
705: L_API_VERSION CONSTANT NUMBER := 1.0;
706: l_api_name CONSTANT VARCHAR2(30) := 'Cancel_price_tax_req';

Line 873: Update price_request_id in ASO_QUOTE_HEADERS_ALL

869: END Get_Workflow_Role;
870:
871:
872: /********************************************************
873: Update price_request_id in ASO_QUOTE_HEADERS_ALL
874: ********************************************************/
875:
876: procedure Update_price_req_id(p_quote_header_id IN Number) is
877:

Line 884: Update ASO_QUOTE_HEADERS_ALL

880: l_last_update_date Date := SYSDATE;
881:
882: Begin
883:
884: Update ASO_QUOTE_HEADERS_ALL
885: set price_request_id = null,
886: last_update_date = l_last_update_date,
887: object_version_number = object_version_number + 1,
888: last_updated_by = G_USER_ID,

Line 914: from aso_quote_headers_all

910: l_qte_number number;
911:
912: cursor c_get_qte_number is
913: select quote_number
914: from aso_quote_headers_all
915: where quote_header_id = p_quote_header_id;
916:
917:
918: Begin

Line 1003: Select price_request_id into l_request_id from aso_quote_headers_all

999: l_request_id Number;
1000:
1001: Begin
1002:
1003: Select price_request_id into l_request_id from aso_quote_headers_all
1004: Where quote_header_id =p_quote_header_id;
1005:
1006: If l_request_id is null then
1007: x_status := FND_API.G_FALSE;

Line 1033: FROM aso_quote_headers_all qha,

1029:
1030: CURSOR get_quote_details (p_quote_header_id NUMBER ) IS
1031: SELECT qha.quote_number, hca.account_number,
1032: hp.party_type
1033: FROM aso_quote_headers_all qha,
1034: hz_parties hp,
1035: hz_cust_accounts hca
1036: WHERE qha.cust_account_id = hca.cust_account_id(+)
1037: AND hca.party_id = hp.party_id

Line 1146: FROM aso_quote_headers_all qha,

1142:
1143: CURSOR get_quote_details (p_quote_header_id NUMBER ) IS
1144: SELECT qha.quote_number, hca.account_number,
1145: hp.party_type,qha.org_id
1146: FROM aso_quote_headers_all qha,
1147: hz_parties hp,
1148: hz_cust_accounts hca
1149: WHERE qha.cust_account_id = hca.cust_account_id(+)
1150: AND qha.cust_party_id = hp.party_id