APPS.OKC_TERMS_TMPL_APPROVAL_PVT dependencies on OKC_ART_BLK_PVT

Line 390: l_art_validation_results OKC_ART_BLK_PVT.validation_tbl_type;

386: l_deliverables_exist VARCHAR2(100);
387:
388: l_tmpl_org_id NUMBER;
389: l_drafts_present VARCHAR2(1) := 'N';
390: l_art_validation_results OKC_ART_BLK_PVT.validation_tbl_type;
391: l_expert_enabled VARCHAR2(1) := 'N';
392:
393: --modify cursor to fetch org_id also
394: CURSOR tmpl_exists_csr IS

Line 917: l_validation_results OKC_ART_BLK_PVT.validation_tbl_type;

913: l_tmpl_wf_seq_id NUMBER;
914: x_return_status VARCHAR2(1);
915: x_msg_count NUMBER;
916: x_msg_data VARCHAR2(2000);
917: l_validation_results OKC_ART_BLK_PVT.validation_tbl_type;
918: l_parent_template_id NUMBER;
919: l_expert_enabled VARCHAR2(1) := 'N';
920: approval_exception EXCEPTION;
921:

Line 1110: l_validation_results OKC_ART_BLK_PVT.validation_tbl_type;

1106: x_msg_data VARCHAR2(2000);
1107: reject_exception EXCEPTION;
1108: clause_sts_exception_1 EXCEPTION;
1109: clause_sts_exception_2 EXCEPTION;
1110: l_validation_results OKC_ART_BLK_PVT.validation_tbl_type;
1111:
1112: BEGIN
1113:
1114: IF ( funcmode = 'RUN' ) THEN

Line 1477: x_validation_results OUT NOCOPY OKC_ART_BLK_PVT.validation_tbl_type)

1473: p_template_id IN NUMBER,
1474: p_wf_seq_id IN NUMBER DEFAULT NULL,
1475: p_status IN VARCHAR2,
1476: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1477: x_validation_results OUT NOCOPY OKC_ART_BLK_PVT.validation_tbl_type)
1478:
1479: IS
1480:
1481: l_api_version CONSTANT NUMBER := 1;

Line 1484: l_article_version_id_tbl OKC_ART_BLK_PVT.NUM_TBL_TYPE;

1480:
1481: l_api_version CONSTANT NUMBER := 1;
1482: l_api_name CONSTANT VARCHAR2(30) := 'change_clause_status';
1483: l_current_org_id NUMBER;
1484: l_article_version_id_tbl OKC_ART_BLK_PVT.NUM_TBL_TYPE;
1485:
1486: CURSOR l_tmpl_csr (cp_template_id IN NUMBER) IS
1487: SELECT org_id from OKC_TERMS_TEMPLATES_ALL
1488: WHERE template_id = cp_template_id;

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

1518: END IF;
1519:
1520: -- Initialize API return status to success
1521: x_return_status := FND_API.G_RET_STS_SUCCESS;
1522: l_article_version_id_tbl := OKC_ART_BLK_PVT.NUM_TBL_TYPE();
1523:
1524: IF (p_status NOT IN ('PENDING_APPROVAL', 'APPROVED', 'REJECTED')) THEN
1525: x_return_status := FND_API.G_RET_STS_ERROR;
1526: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);

Line 1556: OKC_ART_BLK_PVT.PENDING_APPROVAL_BLK(

1552: EXIT;
1553: END IF;
1554:
1555: IF (p_status = 'PENDING_APPROVAL') THEN
1556: OKC_ART_BLK_PVT.PENDING_APPROVAL_BLK(
1557: p_api_version => 1,
1558: p_init_msg_list => FND_API.G_FALSE,
1559: p_commit => FND_API.G_FALSE,
1560: p_validation_level => p_validation_level,

Line 1570: OKC_ART_BLK_PVT.APPROVE_BLK(

1566: p_org_id => l_current_org_id,
1567: p_art_ver_tbl => l_article_version_id_tbl,
1568: x_validation_results => x_validation_results);
1569: ELSIF(p_status = 'APPROVED') THEN
1570: OKC_ART_BLK_PVT.APPROVE_BLK(
1571: p_api_version => 1,
1572: p_init_msg_list => FND_API.G_FALSE,
1573: p_commit => FND_API.G_FALSE,
1574:

Line 1583: OKC_ART_BLK_PVT.REJECT_BLK(

1579: p_org_id => l_current_org_id,
1580: p_art_ver_tbl => l_article_version_id_tbl,
1581: x_validation_results => x_validation_results);
1582: ELSIF(p_status = 'REJECTED') THEN
1583: OKC_ART_BLK_PVT.REJECT_BLK(
1584: p_api_version => 1,
1585: p_init_msg_list => FND_API.G_FALSE,
1586: p_commit => FND_API.G_FALSE,
1587:

Line 1700: l_validation_results IN OKC_ART_BLK_PVT.validation_tbl_type) RETURN VARCHAR2

1696: ---------------------------------------------------------------------------
1697: -- Function get_error_string
1698: ---------------------------------------------------------------------------
1699: FUNCTION get_error_string(
1700: l_validation_results IN OKC_ART_BLK_PVT.validation_tbl_type) RETURN VARCHAR2
1701: IS
1702: l_error_msg VARCHAR2(4000);
1703:
1704: BEGIN