APPS.CS_CONTRACT_TPL_PUB dependencies on CS_CONTRACTS

Line 18: FROM cs_contracts

14: x_template_id OUT NUMBER
15: ) IS
16: CURSOR l_Contract_csr IS
17: SELECT *
18: FROM cs_contracts
19: WHERE contract_id = p_contract_id;
20: CURSOR l_Service_Csr IS
21: SELECT *
22: FROM cs_cp_services

Line 107: -- Call insert API for cs_contracts_template

103: l_ContractTmpl_Rec.context := l_Contract_Rec.context;
104: l_ContractTmpl_Rec.object_version_number := 1;
105:
106: --dbms_output.put_line('Before inserting template');
107: -- Call insert API for cs_contracts_template
108: CS_ContractTmpl_Pvt.Insert_Row
109: (
110: p_api_version => 1.0,
111: p_init_msg_list => TAPI_DEV_KIT.G_FALSE,

Line 299: l_contract_rec.contract_status_id := FND_PROFILE.Value('CS_CONTRACTS_DEFAULT_HDR_STATUS');

295: l_contract_rec.renewal_rule := l_Contract_Tmpl_Rec.renewal_rule;
296: l_contract_rec.termination_rule := l_Contract_Tmpl_Rec.termination_rule;
297: l_contract_rec.bill_to_site_use_id := p_bill_to_site_use_id;
298: l_contract_rec.contract_type_id := l_Contract_Tmpl_Rec.contract_type_id;
299: l_contract_rec.contract_status_id := FND_PROFILE.Value('CS_CONTRACTS_DEFAULT_HDR_STATUS');
300: l_contract_rec.contract_template_id := p_template_id;
301: l_contract_rec.contract_group_id := NULL;
302: l_contract_rec.customer_id := p_customer_id;
303: l_contract_rec.duration := l_Contract_Tmpl_Rec.duration;

Line 376: p_contract_line_status_id => FND_PROFILE.VALUE('CS_CONTRACTS_DEFAULT_LINE_STATUS'),

372: x_msg_count => l_msg_count,
373: x_msg_data => l_msg_data,
374: p_contract_line_template_id => l_Tmpl_Rec.contract_line_template_id,
375: p_contract_id => l_contract_id,
376: p_contract_line_status_id => FND_PROFILE.VALUE('CS_CONTRACTS_DEFAULT_LINE_STATUS'),
377: p_service_inventory_item_id => l_Tmpl_Rec.service_inventory_item_id,
378: p_service_manufacturing_org_id => l_Tmpl_Rec.service_manufacturing_org_id,
379: p_original_start_date => l_Tmpl_Rec.start_date_active,
380: p_original_end_date => l_Tmpl_Rec.end_date_active,