APPS.CS_CONTRACTLTMPL_PVT dependencies on CS_CONTRACT_TEMPLATES

Line 90: CURSOR cs_contract_templates_pk_csr (p_contract_template_id IN NUMBER) IS

86: SELECT *
87: FROM Cs_Coverages
88: WHERE cs_coverages.coverage_id = p_coverage_id;
89: l_cc_pk cc_pk_csr%ROWTYPE;
90: CURSOR cs_contract_templates_pk_csr (p_contract_template_id IN NUMBER) IS
91: SELECT *
92: FROM Cs_Contract_Templates
93: WHERE cs_contract_templates.contract_template_id = p_contract_template_id;
94: l_cs_contract_templates_pk cs_contract_templates_pk_csr%ROWTYPE;

Line 92: FROM Cs_Contract_Templates

88: WHERE cs_coverages.coverage_id = p_coverage_id;
89: l_cc_pk cc_pk_csr%ROWTYPE;
90: CURSOR cs_contract_templates_pk_csr (p_contract_template_id IN NUMBER) IS
91: SELECT *
92: FROM Cs_Contract_Templates
93: WHERE cs_contract_templates.contract_template_id = p_contract_template_id;
94: l_cs_contract_templates_pk cs_contract_templates_pk_csr%ROWTYPE;
95: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
96: l_row_notfound BOOLEAN := TRUE;

Line 93: WHERE cs_contract_templates.contract_template_id = p_contract_template_id;

89: l_cc_pk cc_pk_csr%ROWTYPE;
90: CURSOR cs_contract_templates_pk_csr (p_contract_template_id IN NUMBER) IS
91: SELECT *
92: FROM Cs_Contract_Templates
93: WHERE cs_contract_templates.contract_template_id = p_contract_template_id;
94: l_cs_contract_templates_pk cs_contract_templates_pk_csr%ROWTYPE;
95: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
96: l_row_notfound BOOLEAN := TRUE;
97: BEGIN

Line 94: l_cs_contract_templates_pk cs_contract_templates_pk_csr%ROWTYPE;

90: CURSOR cs_contract_templates_pk_csr (p_contract_template_id IN NUMBER) IS
91: SELECT *
92: FROM Cs_Contract_Templates
93: WHERE cs_contract_templates.contract_template_id = p_contract_template_id;
94: l_cs_contract_templates_pk cs_contract_templates_pk_csr%ROWTYPE;
95: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
96: l_row_notfound BOOLEAN := TRUE;
97: BEGIN
98: IF (p_contractltmpl_rec.COVERAGE_ID IS NOT NULL)

Line 111: OPEN cs_contract_templates_pk_csr(p_contractltmpl_rec.CONTRACT_TEMPLATE_ID);

107: END IF;
108: END IF;
109: IF (p_contractltmpl_rec.CONTRACT_TEMPLATE_ID IS NOT NULL)
110: THEN
111: OPEN cs_contract_templates_pk_csr(p_contractltmpl_rec.CONTRACT_TEMPLATE_ID);
112: FETCH cs_contract_templates_pk_csr INTO l_cs_contract_templates_pk;
113: l_row_notfound := cs_contract_templates_pk_csr%NOTFOUND;
114: CLOSE cs_contract_templates_pk_csr;
115: IF (l_row_notfound) THEN

Line 112: FETCH cs_contract_templates_pk_csr INTO l_cs_contract_templates_pk;

108: END IF;
109: IF (p_contractltmpl_rec.CONTRACT_TEMPLATE_ID IS NOT NULL)
110: THEN
111: OPEN cs_contract_templates_pk_csr(p_contractltmpl_rec.CONTRACT_TEMPLATE_ID);
112: FETCH cs_contract_templates_pk_csr INTO l_cs_contract_templates_pk;
113: l_row_notfound := cs_contract_templates_pk_csr%NOTFOUND;
114: CLOSE cs_contract_templates_pk_csr;
115: IF (l_row_notfound) THEN
116: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CONTRACT_TEMPLATE_ID');

Line 113: l_row_notfound := cs_contract_templates_pk_csr%NOTFOUND;

109: IF (p_contractltmpl_rec.CONTRACT_TEMPLATE_ID IS NOT NULL)
110: THEN
111: OPEN cs_contract_templates_pk_csr(p_contractltmpl_rec.CONTRACT_TEMPLATE_ID);
112: FETCH cs_contract_templates_pk_csr INTO l_cs_contract_templates_pk;
113: l_row_notfound := cs_contract_templates_pk_csr%NOTFOUND;
114: CLOSE cs_contract_templates_pk_csr;
115: IF (l_row_notfound) THEN
116: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CONTRACT_TEMPLATE_ID');
117: RAISE item_not_found_error;

Line 114: CLOSE cs_contract_templates_pk_csr;

110: THEN
111: OPEN cs_contract_templates_pk_csr(p_contractltmpl_rec.CONTRACT_TEMPLATE_ID);
112: FETCH cs_contract_templates_pk_csr INTO l_cs_contract_templates_pk;
113: l_row_notfound := cs_contract_templates_pk_csr%NOTFOUND;
114: CLOSE cs_contract_templates_pk_csr;
115: IF (l_row_notfound) THEN
116: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CONTRACT_TEMPLATE_ID');
117: RAISE item_not_found_error;
118: END IF;