APPS.ASO_PUBLISH_MISC_INT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 8

SELECT	Party_Name,Person_First_Name,Person_Middle_Name,Person_Last_name,party_type,Person_title
FROM	hz_parties
WHERE	party_id = p_party_id;

Line: 13

SELECT org_id,party_id, quote_name, quote_number, quote_version, quote_password,
cust_account_id,invoice_to_party_id, invoice_to_party_site_id, quote_header_id,
ordered_date, order_id, total_list_price,total_shipping_charge,total_tax,
total_quote_price,invoice_to_cust_account_id,total_adjusted_amount,
currency_code,resource_id,quote_status_id,minisite_id
FROM aso_quote_headers_all
WHERE  quote_header_id = p_quote_id;

Line: 24

SELECT quote_status_id
FROM aso_quote_statuses_b
WHERE status_code = p_status_code;

Line: 31

select LOOKUP_CODE
from fnd_lookups
where lookup_type = 'IBE_WF_NOTIFICATION'
and LOOKUP_CODE = p_message_name
and ENABLED_FLAG = 'Y';

Line: 40

select display_name
from ibe_msite_resps_vl
where msite_id = to_number(p_msite_id)
and responsibility_id = to_number(p_resp_id);

Line: 99

	Select USR.person_party_id Name
	From   FND_USER USR
	Where  USR.EMPLOYEE_ID     is null
	and    user_name = c_login_name;

Line: 105

    Select SOURCE_FIRST_NAME, SOURCE_LAST_NAME, SOURCE_EMAIL
    From   JTF_RS_RESOURCE_EXTNS
    Where  RESOURCE_ID = c_resource_id;

Line: 120

     l_last_updated_by number;

Line: 121

     l_last_update_date date;

Line: 122

     l_last_update_login number;

Line: 126

     Select display_name, description, start_date, expiration_date,
            fax,orig_system, orig_system_id, partition_id ,last_updated_by,
            last_update_date, last_update_login
     From wf_local_roles
     Where name= c_role_name;

Line: 234

                                     l_orig_system, l_orig_system_id, l_partition, l_last_updated_by,
                                     l_last_update_date, l_last_update_login;

Line: 248

		ASO_QUOTE_UTIL_PVT.Debug('l_last_updated_by : '||l_last_updated_by);

Line: 249

		ASO_QUOTE_UTIL_PVT.Debug('l_last_update_date : '||l_last_update_date);

Line: 250

		ASO_QUOTE_UTIL_PVT.Debug('l_last_update_login : '||l_last_update_login);

Line: 270

       wf_event.AddParameterToList('LAST_UPDATED_BY',l_last_updated_by,wf_parameters);

Line: 271

       wf_event.AddParameterToList('LAST_UPDATE_DATE',
                              l_last_update_date,wf_parameters);

Line: 273

       wf_event.AddParameterToList('LAST_UPDATE_LOGIN',l_last_update_login
                              ,wf_parameters);

Line: 483

	Select USR.person_party_id Name
	From   FND_USER USR
	Where  USR.EMPLOYEE_ID     is null
	and    user_name = c_login_name;

Line: 489

    Select SOURCE_FIRST_NAME, SOURCE_LAST_NAME, SOURCE_EMAIL
    From   JTF_RS_RESOURCE_EXTNS
    Where  RESOURCE_ID = c_resource_id;

Line: 494

    select nls_language from wf_languages
    where code = USERENV('LANG');

Line: 508

     l_last_updated_by number;

Line: 509

     l_last_update_date date;

Line: 510

     l_last_update_login number;

Line: 514

     Select display_name, description, start_date, expiration_date,
            fax,orig_system, orig_system_id, partition_id ,last_updated_by,
            last_update_date, last_update_login
     From wf_local_roles
     Where name= c_role_name;

Line: 840

                                     l_orig_system, l_orig_system_id, l_partition, l_last_updated_by,
                                     l_last_update_date, l_last_update_login;

Line: 854

          ASO_QUOTE_UTIL_PVT.Debug('l_last_updated_by : '||l_last_updated_by);

Line: 855

          ASO_QUOTE_UTIL_PVT.Debug('l_last_update_date : '||l_last_update_date);

Line: 856

          ASO_QUOTE_UTIL_PVT.Debug('l_last_update_login : '||l_last_update_login);

Line: 873

       wf_event.AddParameterToList('LAST_UPDATED_BY',l_last_updated_by,wf_parameters);

Line: 874

       wf_event.AddParameterToList('LAST_UPDATE_DATE',
                              l_last_update_date,wf_parameters);

Line: 876

       wf_event.AddParameterToList('LAST_UPDATE_LOGIN',l_last_update_login
                              ,wf_parameters);

Line: 957

Select p.party_id Person_Party_id,l.party_id contact_party_id,p.person_first_name,p.person_last_name,p.party_type
from hz_relationships l,hz_parties p
where l.party_id = pPartyId
and l.subject_id = p.party_id
and l.subject_type = 'PERSON'
and l.subject_table_name = 'HZ_PARTIES';

Line: 1004

Select p.party_id Person_Party_id,l.party_id contact_party_id,p.person_first_name,p.person_last_name,p.party_type
from hz_relationships l,hz_parties p
where l.party_id = pPartyId
and l.subject_id = p.party_id
and l.subject_type = 'PERSON'
and l.subject_table_name = 'HZ_PARTIES';

Line: 1049

Select p.party_id Person_Party_id,l.party_id contact_party_id,p.person_first_name,p.person_last_name,p.party_type,p.person_title
from hz_relationships l,hz_parties p
where l.party_id = pPartyId
and l.subject_id = p.party_id
and l.subject_table_name = 'HZ_PARTIES'
and l.subject_type = 'PERSON';

Line: 1163

    p_last_update_date  IN  DATE
    ) IS


    P_Api_Version_Number        NUMBER          := 1.0;

Line: 1280

p_qte_header_rec.last_update_date   := p_last_update_date;

Line: 1282

 ASO_QUOTE_PUB.Update_Quote(
    	P_Api_Version_Number => p_api_version_number,
    	P_Init_Msg_List => p_init_msg_list,
    	P_Commit => p_commit,
    	P_Validation_Level => p_validation_level,
        p_qte_header_rec => p_qte_header_rec,
        p_qte_line_tbl => p_qte_line_tbl,
        p_ln_shipment_tbl => p_ln_shipment_tbl,
    	X_Qte_Header_Rec => x_qte_header_rec,
    	X_Qte_Line_Tbl => x_qte_line_tbl,
    	X_Qte_Line_Dtl_Tbl => x_qte_line_dtl_tbl,
    	X_Hd_Price_Attributes_Tbl => x_hd_price_attributes_tbl,
    	X_Hd_Payment_Tbl => x_hd_payment_tbl,
    	X_Hd_Shipment_Tbl => x_hd_shipment_tbl,
    	X_Hd_Freight_Charge_Tbl => x_hd_freight_charge_tbl,
    	X_Hd_Tax_Detail_Tbl	=> x_hd_tax_detail_tbl,
    	X_hd_Attr_Ext_Tbl => x_hd_attr_ext_tbl,
    	X_hd_Sales_Credit_Tbl => x_hd_sales_credit_tbl,
    	X_hd_Quote_Party_Tbl => x_hd_quote_party_tbl,
    	X_Line_Attr_Ext_Tbl	=> x_line_attr_ext_tbl,
    	X_line_rltship_tbl	=> x_line_rltship_tbl,
    	X_Price_Adjustment_Tbl => x_price_adjustment_tbl,
    	X_Price_Adj_Attr_Tbl => x_price_adj_attr_tbl,
    	X_Price_Adj_Rltship_Tbl => x_price_adj_rltship_tbl,
    	X_Ln_Price_Attributes_Tbl => x_ln_price_attributes_tbl,
    	X_Ln_Payment_Tbl => x_ln_payment_tbl,
    	X_Ln_Shipment_Tbl => x_ln_shipment_tbl,
    	X_Ln_Freight_Charge_Tbl => x_ln_freight_charge_tbl,
    	X_Ln_Tax_Detail_Tbl => x_ln_tax_detail_tbl,
    	X_Ln_Sales_Credit_Tbl => x_ln_sales_credit_tbl,
    	X_Ln_Quote_Party_Tbl => x_ln_quote_party_tbl,
        X_return_status => x_return_status,
	    X_msg_count => x_msg_count,
	    X_msg_data => x_msg_data );

Line: 1355

    SELECT language_use_reference_id, object_version_number
    FROM   hz_person_language
    WHERE  party_id=l_party_id and primary_language_indicator='Y';

Line: 1360

    SELECT language_use_reference_id, object_version_number
    FROM   hz_person_language
    WHERE  party_id=l_party_id
    AND    language_name=l_language_name
    AND   nvl(status,'A') = 'A';

Line: 1367

    Select p.party_id Person_Party_id
    from hz_relationships l,hz_parties p
    where l.party_id = l_party_id
    and l.subject_id = p.party_id
    and l.subject_table_name = 'HZ_PARTIES'
    and l.subject_type = 'PERSON';

Line: 1420

   /* UPDATE FND_USER
    SET CUSTOMER_ID = p_party_id
    WHERE USER_NAME = p_user_name;

Line: 1462

    hz_person_info_v2pub.update_person_language(
            p_init_msg_list       => FND_API.G_FALSE,
            p_person_language_rec => l_lang_rec1,
            p_object_version_number => l_object_version_number,
            x_return_status => l_return_status,
            x_msg_count => l_msg_count,
            x_msg_data => l_msg_data);

Line: 1472

        ASO_QUOTE_UTIL_PVT.Debug('successful completion of hz_person_info_v2pub.update_person_language - unset Primary Language Indicator');

Line: 1525

	hz_person_info_v2pub.update_person_language(
            p_person_language_rec => l_lang_rec2,
            p_object_version_number => l_object_version_number,
            x_return_status => x_return_status,
            x_msg_count => x_msg_count,
            x_msg_data => x_msg_data);