APPS.OKC_XPRT_TMPL_RULE_ASSNS_PVT dependencies on OKC_XPRT_TEMPLATE_RULES

Line 48: FROM okc_xprt_template_rules t,

44:
45: -- get all rules on source template that are Not Inactive
46: CURSOR csr_template_rules IS
47: SELECT t.rule_id
48: FROM okc_xprt_template_rules t,
49: okc_xprt_rule_hdrs_all r
50: WHERE r.rule_id = t.rule_id
51: AND r.status_code <> 'INACTIVE'
52: AND NVL(t.deleted_flag,'N') <> 'Y'

Line 74: TYPE ruleIdList IS TABLE OF okc_xprt_template_rules.rule_id%TYPE INDEX BY BINARY_INTEGER;

70: l_source_template_org_id okc_terms_templates_all.org_id%TYPE;
71: l_target_template_org_id okc_terms_templates_all.org_id%TYPE;
72:
73:
74: TYPE ruleIdList IS TABLE OF okc_xprt_template_rules.rule_id%TYPE INDEX BY BINARY_INTEGER;
75: TYPE questionIdList IS TABLE OF okc_xprt_question_orders.question_id%TYPE INDEX BY BINARY_INTEGER;
76: TYPE mandatoryFlagList IS TABLE OF okc_xprt_question_orders.mandatory_flag%TYPE INDEX BY BINARY_INTEGER;
77: TYPE sequenceNumList IS TABLE OF okc_xprt_question_orders.sequence_num%TYPE INDEX BY BINARY_INTEGER;
78: TYPE questionRuleStatusList IS TABLE OF okc_xprt_question_orders.question_rule_status%TYPE INDEX BY BINARY_INTEGER;

Line 148: INSERT INTO okc_xprt_template_rules

144: IF rule_id_tbl.COUNT > 0 THEN
145:
146: FORALL i IN rule_id_tbl.FIRST..rule_id_tbl.LAST
147:
148: INSERT INTO okc_xprt_template_rules
149: (
150: TEMPLATE_RULE_ID,
151: TEMPLATE_ID,
152: RULE_ID,

Line 163: okc_xprt_template_rules_s.NEXTVAL,

159: DELETED_FLAG
160: )
161: VALUES
162: (
163: okc_xprt_template_rules_s.NEXTVAL,
164: p_target_template_id,
165: rule_id_tbl(i),
166: 1,
167: Fnd_Global.User_Id,

Line 323: DELETE FROM okc_xprt_template_rules

319: END IF;
320: x_return_status := G_RET_STS_SUCCESS;
321:
322: -- delete template rules
323: DELETE FROM okc_xprt_template_rules
324: WHERE template_id = p_template_id;
325:
326: -- delete template questions
327: DELETE FROM okc_xprt_question_orders

Line 432: DELETE FROM okc_xprt_template_rules

428:
429: x_return_status := G_RET_STS_SUCCESS;
430:
431: -- Delete Parent Template Rules
432: DELETE FROM okc_xprt_template_rules
433: WHERE template_id = p_parent_template_id;
434:
435: -- Delete Parent Template Questions
436: DELETE FROM okc_xprt_question_orders

Line 448: DELETE FROM okc_xprt_template_rules

444:
445: IF l_xprt_enabled_flag = 'N' THEN
446:
447: -- Delete Parent Template Rules
448: DELETE FROM okc_xprt_template_rules
449: WHERE template_id = p_template_id;
450:
451: -- Delete Parent Template Questions
452: DELETE FROM okc_xprt_question_orders

Line 458: -- Update okc_xprt_template_rules for Revision template

454:
455: ELSE
456: -- revision template IS expert enabled
457:
458: -- Update okc_xprt_template_rules for Revision template
459: UPDATE okc_xprt_template_rules
460: SET template_id = p_parent_template_id,
461: last_update_date = SYSDATE,
462: last_updated_by= FND_GLOBAL.USER_ID,

Line 459: UPDATE okc_xprt_template_rules

455: ELSE
456: -- revision template IS expert enabled
457:
458: -- Update okc_xprt_template_rules for Revision template
459: UPDATE okc_xprt_template_rules
460: SET template_id = p_parent_template_id,
461: last_update_date = SYSDATE,
462: last_updated_by= FND_GLOBAL.USER_ID,
463: last_update_login= FND_GLOBAL.LOGIN_ID