APPS.OKC_IMP_TERMS_TEMPLATES_PVT dependencies on OKC_TERMS_TEMPLATES_ALL

Line 475: FROM okc_terms_templates_all

471: SELECT template_id, intent, status_code,
472: start_date, end_date, org_id
473: INTO g_template_id, g_template_intent, g_template_status_code,
474: g_template_start_date, g_template_end_date, g_template_org_id
475: FROM okc_terms_templates_all
476: WHERE template_id = p_template_id;
477:
478: IF g_template_status_code IN ('DRAFT', 'REVISION', 'REJECTED')
479: THEN

Line 533: FROM okc_terms_templates_all

529: l_flag VARCHAR2 (1);
530: BEGIN
531: SELECT 'Y'
532: INTO l_flag
533: FROM okc_terms_templates_all
534: WHERE template_id = p_template_id AND org_id = p_org_id;
535:
536: RETURN NVL (l_flag, 'N');
537: EXCEPTION

Line 1233: OKC_TERMS_TEMPLATES_ALL_S => Sequnce value will derived in the grp package

1229: END;
1230:
1231: -- Call OKC_TERMS_TEMPLATES_GRP Insert
1232: /*
1233: OKC_TERMS_TEMPLATES_ALL_S => Sequnce value will derived in the grp package
1234: WHO columns,Object version numberr also derived in the package.
1235: */
1236: BEGIN
1237: okc_terms_templates_grp.create_template

Line 1315: l_template_db_rec okc_terms_templates_all%ROWTYPE;

1311: PROCEDURE update_template (
1312: p_template_rec IN OUT NOCOPY terms_template_rec_type
1313: )
1314: IS
1315: l_template_db_rec okc_terms_templates_all%ROWTYPE;
1316: l_progress VARCHAR2 (3) := '000';
1317: x_return_status VARCHAR2 (1);
1318: x_msg_count NUMBER;
1319: x_msg_data VARCHAR2 (2000);

Line 1323: p_template_db_rec IN okc_terms_templates_all%ROWTYPE

1319: x_msg_data VARCHAR2 (2000);
1320:
1321: PROCEDURE default_row (
1322: p_template_rec IN OUT NOCOPY terms_template_rec_type,
1323: p_template_db_rec IN okc_terms_templates_all%ROWTYPE
1324: )
1325: IS
1326: BEGIN
1327: IF p_template_rec.template_id = okc_api.g_miss_num

Line 1604: FROM okc_terms_templates_all

1600: l_progress := '010';
1601:
1602: SELECT *
1603: INTO l_template_db_rec
1604: FROM okc_terms_templates_all
1605: WHERE template_id = p_template_rec.template_id;
1606: EXCEPTION
1607: WHEN OTHERS
1608: THEN