[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
x_ent_contracts.DELETE;
SELECT business_process_id
INTO l_business_process
FROM cs_business_processes
WHERE NAME = 'Depot Repair'
AND ROWNUM < 2;
SELECT parameter_id
INTO l_param_id
FROM csd_parameters
WHERE param_code = p_param_code;
SELECT txn_billing_type_id
INTO l_txn_billing_type_id
FROM csd_repair_types_sar_vl
WHERE repair_type_id = p_repair_type_ids(i)
AND billing_type = 'M';
SELECT site_use_id
INTO l_payer_context_rec.account_site_id
FROM hz_cust_site_uses_all u,
hz_cust_acct_sites_all s
WHERE s.cust_account_id = p_account_id
AND u.cust_acct_site_id = s.cust_acct_site_id
AND NVL(u.primary_flag,'N') = 'Y'
AND ROWNUM < 2;
SELECT party_site_id
INTO l_cust_acct_site_rec.party_site_id
FROM hz_party_site_uses
WHERE party_site_use_id = p_bill_to_site_use_id;
INSERT INTO csd_cc_trxn_xref(instrument_id,transaction_id,creation_date,created_by,last_updated_by,last_update_date,last_update_login)
VALUES
(x_instr_id,
x_transaction_id,
sysdate,
fnd_global.user_id,
fnd_global.user_id,
sysdate,
fnd_global.login_id
);
SELECT party_type
INTO l_party_type
FROM hz_parties
WHERE party_id = p_party_id;
SELECT contacts.contact_point_id,contacts.owner_table_id
INTO l_contact_point_id,l_contact_party_id
FROM hz_contact_points contacts,hz_parties parties
WHERE contacts.owner_table_name = 'HZ_PARTIES'
AND contacts.email_address = p_email
AND parties.party_id = p_party_id
AND contacts.owner_table_id = parties.party_id
AND contacts.status = 'A'
AND ROWNUM < 2;
SELECT contacts.contact_point_id,contacts.owner_table_id
INTO l_contact_point_id,l_contact_party_id
FROM hz_contact_points contacts,hz_parties parties,fnd_user usr
WHERE contacts.owner_table_name = 'HZ_PARTIES'
AND contacts.email_address = p_email
AND usr.user_id = fnd_global.user_id
AND parties.party_id = usr.customer_id
AND contacts.owner_table_id = parties.party_id
AND contacts.status = 'A'
AND ROWNUM < 2;
SELECT customer_id
INTO l_contact_party_id
FROM fnd_user
WHERE user_id = fnd_global.user_id;
SELECT party.party_type,party.party_id
INTO l_service_request_rec.contact_type,l_service_request_rec.party_id
FROM hz_parties party
WHERE party.party_id = p_party_id;
SELECT party.party_type,party.party_id
INTO l_service_request_rec.contact_type,l_service_request_rec.party_id
FROM hz_parties party,fnd_user usr
WHERE usr.user_id = fnd_global.user_id
AND usr.customer_id = party.party_id;
SELECT serial_number_control_code,comms_nl_trackable_flag,inventory_item_id
BULK COLLECT INTO
l_serial_flag,l_ib_control_flag,l_item_ids_tbl
FROM mtl_system_items_b
WHERE inventory_item_id IN
(SELECT * FROM TABLE(CAST(p_item_ids AS JTF_NUMBER_TABLE))
)
AND organization_id = fnd_profile.value('CSD_DEF_REP_INV_ORG');
SELECT 'Y',instance_id,owner_party_id
INTO l_ib_exists,x_instance_id,l_current_party_id
FROM csi_item_instances
WHERE inventory_item_id = p_item_ids(i)
AND serial_number = p_serial_nums(i);
SELECT 'Y',instance_id,owner_party_id
INTO l_ib_exists,x_instance_id,l_current_party_id
FROM csi_item_instances
WHERE inventory_item_id = p_item_ids(i)
AND external_reference = p_external_refs(i);
SELECT relationship_type_code
INTO l_relationship
FROM csi_i_parties
WHERE instance_id = x_instance_id
AND party_id = p_party_id
AND SYSDATE BETWEEN NVL(active_start_date, SYSDATE - 1) AND NVL(active_end_date,SYSDATE+1)
AND relationship_type_code = NVL(l_crt_inst_party_relation,relationship_type_code)
AND ROWNUM < 2;
SELECT NVL(auto_process_rma,'N'),repair_mode
INTO l_repln_rec.auto_process_rma,l_repln_rec.repair_mode
FROM csd_repair_types_b
WHERE repair_type_id = l_repln_rec.repair_type_id;
l_repair_line_id_tbl.DELETE(1);
l_estimate_rec.last_update_date := sysdate;
l_estimate_rec.last_updated_by := NULL;
l_estimate_rec.last_update_login := NULL;
SELECT service.txn_billing_type_id,service.transaction_type_id,types.business_process_id
INTO G_ESTIMATE_CONSTANTS_CACHE(p_item_ids(i)).txn_billing_type_id,
G_ESTIMATE_CONSTANTS_CACHE(p_item_ids(i)).transaction_type_id,G_ESTIMATE_CONSTANTS_CACHE(p_item_ids(i)).business_process_id
FROM csd_repair_types_sar_vl service,csd_repair_types_b types
WHERE service.repair_type_id = p_repair_type_ids(i)
AND service.repair_type_id = types.repair_type_id
AND service.billing_type = 'M';
l_estimate_lines_rec.last_update_date := SYSDATE;
l_estimate_lines_rec.last_updated_by := fnd_global.user_id;
l_estimate_lines_rec.last_update_login := fnd_global.login_id;
UPDATE csd_cc_trxn_xref SET incident_id = x_incident_id
WHERE transaction_id = p_cc_trxn_id;
SELECT bill.party_site_id, ship.party_site_id
INTO l_bill_to_site_id, l_ship_to_site_id
FROM hz_party_site_uses bill, hz_party_site_uses ship
WHERE bill.party_site_use_id = p_bill_to_addr_use_id
AND ship.party_site_use_id = p_ship_to_addr_use_id;
SELECT masked_cc_number
INTO l_cc_number
FROM iby_creditcard cc, csd_cc_trxn_xref cctrxn
WHERE cc.instrid = cctrxn.instrument_id
AND cctrxn.incident_id = p_incident_id;
SELECT repair_line_id
BULK COLLECT INTO l_repair_line_ids
FROM csd_repairs
WHERE incident_id = p_incident_id;