APPS.OKC_TERMS_TMPL_APPROVAL_PVT dependencies on OKC_ART_BLK_PVT

Line 405: l_art_validation_results OKC_ART_BLK_PVT.validation_tbl_type;

401: l_deliverables_exist VARCHAR2(100);
402:
403: l_tmpl_org_id NUMBER;
404: l_drafts_present VARCHAR2(1) := 'N';
405: l_art_validation_results OKC_ART_BLK_PVT.validation_tbl_type;
406: l_expert_enabled VARCHAR2(1) := 'N';
407:
408: --modify cursor to fetch org_id also
409: CURSOR tmpl_exists_csr IS

Line 932: l_validation_results OKC_ART_BLK_PVT.validation_tbl_type;

928: l_tmpl_wf_seq_id NUMBER;
929: x_return_status VARCHAR2(1);
930: x_msg_count NUMBER;
931: x_msg_data VARCHAR2(2000);
932: l_validation_results OKC_ART_BLK_PVT.validation_tbl_type;
933: l_parent_template_id NUMBER;
934: l_expert_enabled VARCHAR2(1) := 'N';
935: approval_exception EXCEPTION;
936:

Line 1159: l_validation_results OKC_ART_BLK_PVT.validation_tbl_type;

1155: x_msg_data VARCHAR2(2000);
1156: reject_exception EXCEPTION;
1157: clause_sts_exception_1 EXCEPTION;
1158: clause_sts_exception_2 EXCEPTION;
1159: l_validation_results OKC_ART_BLK_PVT.validation_tbl_type;
1160:
1161: BEGIN
1162:
1163: IF ( funcmode = 'RUN' ) THEN

Line 1526: x_validation_results OUT NOCOPY OKC_ART_BLK_PVT.validation_tbl_type)

1522: p_template_id IN NUMBER,
1523: p_wf_seq_id IN NUMBER DEFAULT NULL,
1524: p_status IN VARCHAR2,
1525: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1526: x_validation_results OUT NOCOPY OKC_ART_BLK_PVT.validation_tbl_type)
1527:
1528: IS
1529:
1530: l_api_version CONSTANT NUMBER := 1;

Line 1533: l_article_version_id_tbl OKC_ART_BLK_PVT.NUM_TBL_TYPE;

1529:
1530: l_api_version CONSTANT NUMBER := 1;
1531: l_api_name CONSTANT VARCHAR2(30) := 'change_clause_status';
1532: l_current_org_id NUMBER;
1533: l_article_version_id_tbl OKC_ART_BLK_PVT.NUM_TBL_TYPE;
1534:
1535: CURSOR l_tmpl_csr (cp_template_id IN NUMBER) IS
1536: SELECT org_id from OKC_TERMS_TEMPLATES_ALL
1537: WHERE template_id = cp_template_id;

Line 1571: l_article_version_id_tbl := OKC_ART_BLK_PVT.NUM_TBL_TYPE();

1567: END IF;
1568:
1569: -- Initialize API return status to success
1570: x_return_status := FND_API.G_RET_STS_SUCCESS;
1571: l_article_version_id_tbl := OKC_ART_BLK_PVT.NUM_TBL_TYPE();
1572:
1573: IF (p_status NOT IN ('PENDING_APPROVAL', 'APPROVED', 'REJECTED')) THEN
1574: x_return_status := FND_API.G_RET_STS_ERROR;
1575: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);

Line 1605: OKC_ART_BLK_PVT.PENDING_APPROVAL_BLK(

1601: EXIT;
1602: END IF;
1603:
1604: IF (p_status = 'PENDING_APPROVAL') THEN
1605: OKC_ART_BLK_PVT.PENDING_APPROVAL_BLK(
1606: p_api_version => 1,
1607: p_init_msg_list => FND_API.G_FALSE,
1608: p_commit => FND_API.G_FALSE,
1609: p_validation_level => p_validation_level,

Line 1619: OKC_ART_BLK_PVT.APPROVE_BLK(

1615: p_org_id => l_current_org_id,
1616: p_art_ver_tbl => l_article_version_id_tbl,
1617: x_validation_results => x_validation_results);
1618: ELSIF(p_status = 'APPROVED') THEN
1619: OKC_ART_BLK_PVT.APPROVE_BLK(
1620: p_api_version => 1,
1621: p_init_msg_list => FND_API.G_FALSE,
1622: p_commit => FND_API.G_FALSE,
1623:

Line 1632: OKC_ART_BLK_PVT.REJECT_BLK(

1628: p_org_id => l_current_org_id,
1629: p_art_ver_tbl => l_article_version_id_tbl,
1630: x_validation_results => x_validation_results);
1631: ELSIF(p_status = 'REJECTED') THEN
1632: OKC_ART_BLK_PVT.REJECT_BLK(
1633: p_api_version => 1,
1634: p_init_msg_list => FND_API.G_FALSE,
1635: p_commit => FND_API.G_FALSE,
1636:

Line 1749: l_validation_results IN OKC_ART_BLK_PVT.validation_tbl_type) RETURN VARCHAR2

1745: ---------------------------------------------------------------------------
1746: -- Function get_error_string
1747: ---------------------------------------------------------------------------
1748: FUNCTION get_error_string(
1749: l_validation_results IN OKC_ART_BLK_PVT.validation_tbl_type) RETURN VARCHAR2
1750: IS
1751: l_error_msg VARCHAR2(4000);
1752:
1753: BEGIN