eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_XPRT_TMPL_RULE_ASSNS_PVT dependencies on OKC_XPRT_QUESTION_ORDERS

Line 65: FROM okc_xprt_question_orders

61: mandatory_flag,
62: sequence_num,
63: question_rule_status,
64: runtime_available_flag
65: FROM okc_xprt_question_orders
66: WHERE template_id = p_source_template_id;
67:
68: l_api_version CONSTANT NUMBER := 1;
69: l_api_name CONSTANT VARCHAR2(30) := 'copy_template_rule_assns';

Line 75: TYPE questionIdList IS TABLE OF okc_xprt_question_orders.question_id%TYPE INDEX BY BINARY_INTEGER;

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;
79: TYPE runtimeAvailableFlagList IS TABLE OF okc_xprt_question_orders.runtime_available_flag%TYPE INDEX BY BINARY_INTEGER;

Line 76: TYPE mandatoryFlagList IS TABLE OF okc_xprt_question_orders.mandatory_flag%TYPE INDEX BY BINARY_INTEGER;

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;
79: TYPE runtimeAvailableFlagList IS TABLE OF okc_xprt_question_orders.runtime_available_flag%TYPE INDEX BY BINARY_INTEGER;
80:

Line 77: TYPE sequenceNumList IS TABLE OF okc_xprt_question_orders.sequence_num%TYPE INDEX BY BINARY_INTEGER;

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;
79: TYPE runtimeAvailableFlagList IS TABLE OF okc_xprt_question_orders.runtime_available_flag%TYPE INDEX BY BINARY_INTEGER;
80:
81:

Line 78: TYPE questionRuleStatusList IS TABLE OF okc_xprt_question_orders.question_rule_status%TYPE INDEX BY BINARY_INTEGER;

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;
79: TYPE runtimeAvailableFlagList IS TABLE OF okc_xprt_question_orders.runtime_available_flag%TYPE INDEX BY BINARY_INTEGER;
80:
81:
82: rule_id_tbl ruleIdList;

Line 79: TYPE runtimeAvailableFlagList IS TABLE OF okc_xprt_question_orders.runtime_available_flag%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;
79: TYPE runtimeAvailableFlagList IS TABLE OF okc_xprt_question_orders.runtime_available_flag%TYPE INDEX BY BINARY_INTEGER;
80:
81:
82: rule_id_tbl ruleIdList;
83: question_id_tbl questionIdList;

Line 190: INSERT INTO okc_xprt_question_orders

186: IF question_id_tbl.COUNT > 0 THEN
187:
188: FORALL i IN question_id_tbl.FIRST..question_id_tbl.LAST
189:
190: INSERT INTO okc_xprt_question_orders
191: (
192: QUESTION_ORDER_ID,
193: TEMPLATE_ID,
194: QUESTION_ID,

Line 208: okc_xprt_question_orders_s.NEXTVAL,

204: RUNTIME_AVAILABLE_FLAG
205: )
206: VALUES
207: (
208: okc_xprt_question_orders_s.NEXTVAL,
209: p_target_template_id,
210: question_id_tbl(i),
211: mandatory_flag_tbl(i),
212: 1,

Line 327: DELETE FROM okc_xprt_question_orders

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
328: WHERE template_id = p_template_id;
329:
330:
331:

Line 436: DELETE FROM okc_xprt_question_orders

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
437: WHERE template_id = p_parent_template_id;
438:
439: -- Check if the revision template is expert enabled and if not delete the rule data
440:

Line 452: DELETE FROM okc_xprt_question_orders

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
453: WHERE template_id = p_template_id;
454:
455: ELSE
456: -- revision template IS expert enabled

Line 466: -- Update okc_xprt_question_orders for Revision template

462: last_updated_by= FND_GLOBAL.USER_ID,
463: last_update_login= FND_GLOBAL.LOGIN_ID
464: WHERE template_id = p_template_id;
465:
466: -- Update okc_xprt_question_orders for Revision template
467: UPDATE okc_xprt_question_orders
468: SET template_id = p_parent_template_id,
469: last_update_date = SYSDATE,
470: last_updated_by= FND_GLOBAL.USER_ID,

Line 467: UPDATE okc_xprt_question_orders

463: last_update_login= FND_GLOBAL.LOGIN_ID
464: WHERE template_id = p_template_id;
465:
466: -- Update okc_xprt_question_orders for Revision template
467: UPDATE okc_xprt_question_orders
468: SET template_id = p_parent_template_id,
469: last_update_date = SYSDATE,
470: last_updated_by= FND_GLOBAL.USER_ID,
471: last_update_login= FND_GLOBAL.LOGIN_ID