APPS.CS_CONTRACTS_PUB dependencies on CS_CONTRACTS_ALL

Line 69: p_contract_id IN CS_CONTRACTS_ALL.CONTRACT_ID%TYPE

65: --------------------------------------------------------------------------------
66: -- FUNCTION populate_contract_rec
67: --------------------------------------------------------------------------------
68: FUNCTION populate_contract_rec (
69: p_contract_id IN CS_CONTRACTS_ALL.CONTRACT_ID%TYPE
70: ) RETURN Contract_Rec_Type IS
71: CURSOR get_contract_rec (p_contract_id IN CS_CONTRACTS_ALL.CONTRACT_ID%TYPE) IS
72: SELECT *
73: FROM cs_contracts_all

Line 71: CURSOR get_contract_rec (p_contract_id IN CS_CONTRACTS_ALL.CONTRACT_ID%TYPE) IS

67: --------------------------------------------------------------------------------
68: FUNCTION populate_contract_rec (
69: p_contract_id IN CS_CONTRACTS_ALL.CONTRACT_ID%TYPE
70: ) RETURN Contract_Rec_Type IS
71: CURSOR get_contract_rec (p_contract_id IN CS_CONTRACTS_ALL.CONTRACT_ID%TYPE) IS
72: SELECT *
73: FROM cs_contracts_all
74: WHERE contract_id = p_contract_id;
75:

Line 73: FROM cs_contracts_all

69: p_contract_id IN CS_CONTRACTS_ALL.CONTRACT_ID%TYPE
70: ) RETURN Contract_Rec_Type IS
71: CURSOR get_contract_rec (p_contract_id IN CS_CONTRACTS_ALL.CONTRACT_ID%TYPE) IS
72: SELECT *
73: FROM cs_contracts_all
74: WHERE contract_id = p_contract_id;
75:
76: l_contract_rec Contract_Rec_Type;
77: l_no_data_found BOOLEAN := TRUE;

Line 418: CURSOR chk_csr (p_contract_id IN CS_CONTRACTS_ALL.CONTRACT_ID%TYPE) IS

414: l_index NUMBER := 0;
415: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
416: l_return_error_exc EXCEPTION;
417:
418: CURSOR chk_csr (p_contract_id IN CS_CONTRACTS_ALL.CONTRACT_ID%TYPE) IS
419: SELECT *
420: FROM cs_cp_services_all
421: WHERE contract_id = p_contract_id;
422:

Line 438: -- CS_CONTRACTS_ALL then give a warning.

434: -- Check FIRST_BILL_DATE and BILLING_FREQUENCY_PERIOD are NOT NULL.
435: -- While the 2 columns are allowed to be NULL in CS_CP_SERVICES_ALL,
436: -- the columns should not be NULL for a contract.
437: -- If the fields are null in CS_CP_SERVICES_ALL, as well as
438: -- CS_CONTRACTS_ALL then give a warning.
439: ----------------------------------------------------------------------
440: IF ((p_services_all_rec.FIRST_BILL_DATE IS NULL)
441: AND (p_contract_rec.FIRST_BILL_DATE IS NULL)) THEN
442: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN,

Line 538: set_msg_no_children('CS_CONTRACTS_ALL', 'CS_CP_SERVICES_ALL');

534: FOR l_csr_rec IN chk_csr(p_contract_rec.contract_id) LOOP
535: l_services_all_tbl(chk_csr%ROWCOUNT) := l_csr_rec;
536: END LOOP;
537: IF (l_services_all_tbl.COUNT = 0) THEN
538: set_msg_no_children('CS_CONTRACTS_ALL', 'CS_CP_SERVICES_ALL');
539: l_return_status := FND_API.G_RET_STS_ERROR;
540: RAISE l_return_error_exc;
541: END IF;
542: