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.

[Home] [Help]

APPS.OKC_XPRT_QA_PVT dependencies on OKC_XPRT_RULE_HDRS_ALL

Line 334: FROM okc_xprt_rule_hdrs_all

330: insert_cursor circ_rec;
331: -- cursor to retrieve rule name
332: CURSOR csr_rule_dtls IS
333: SELECT rule_name
334: FROM okc_xprt_rule_hdrs_all
335: WHERE rule_id = p_rule_id;
336:
337: -- cursor to retrieve templates associated to the rule
338: CURSOR template_cursor IS

Line 349: okc_xprt_rule_hdrs_all r

345: -- Org Wide Rule templates. Reverted back the changes done for 5019422 by removing
346: -- join to okc_xprt_template_rules
347: SELECT t.template_id, t.org_id, t.intent
348: FROM okc_terms_templates_all t,
349: okc_xprt_rule_hdrs_all r
350: WHERE t.org_id = r.org_id
351: AND t.intent = r.intent
352: AND t.contract_expert_enabled = 'Y'
353: -- AND t.status_code IN ('APPROVED','ON_HOLD')

Line 365: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;

361: from OKC_XPRT_QUESTION_REF_T
362: connect by prior condition_question_id = outcome_question_id ;
363:
364: l_api_name CONSTANT VARCHAR2(30) := 'check_circular_dependency';
365: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
366: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
367:
368: l_Template_Id NUMBER;
369: l_Org_Id NUMBER;

Line 440: select distinct assoc.rule_id from OKC_XPRT_TEMPLATE_RULES assoc, OKC_XPRT_RULE_HDRS_ALL rules

436: and outcome.object_type = ''QUESTION''
437: and cond.rule_id = outcome.rule_id
438: and cond.rule_id in (
439:
440: select distinct assoc.rule_id from OKC_XPRT_TEMPLATE_RULES assoc, OKC_XPRT_RULE_HDRS_ALL rules
441: where assoc.rule_id = rules.rule_id
442: and assoc.template_id = ' ||l_Template_Id ||
443: ' and rules.status_code in (''ACTIVE'',''PENDINGPUB'',''REVISION'',''PENDINGDISABLE'')
444:

Line 447: select distinct rule_id from OKC_XPRT_RULE_HDRS_ALL

443: ' and rules.status_code in (''ACTIVE'',''PENDINGPUB'',''REVISION'',''PENDINGDISABLE'')
444:
445: UNION ALL
446:
447: select distinct rule_id from OKC_XPRT_RULE_HDRS_ALL
448: where status_code in (''ACTIVE'',''PENDINGPUB'',''REVISION'',''PENDINGDISABLE'')
449: and org_wide_flag = ''Y''
450: and org_id = ' ||l_Org_Id ||
451: ' and intent = ''' ||l_Intent|| '''' ||

Line 455: select distinct rule_id from OKC_XPRT_RULE_HDRS_ALL

451: ' and intent = ''' ||l_Intent|| '''' ||
452:
453: ' UNION ALL
454:
455: select distinct rule_id from OKC_XPRT_RULE_HDRS_ALL
456: where org_wide_flag = ''Y''
457: and org_id = ' ||l_Org_Id||
458: ' and intent = ''' ||l_Intent|| '''' ||
459: ' and rule_id in '||l_request_rule_ids||

Line 463: select distinct assoc.rule_id from OKC_XPRT_TEMPLATE_RULES assoc, OKC_XPRT_RULE_HDRS_ALL rules

459: ' and rule_id in '||l_request_rule_ids||
460:
461: ' UNION ALL
462:
463: select distinct assoc.rule_id from OKC_XPRT_TEMPLATE_RULES assoc, OKC_XPRT_RULE_HDRS_ALL rules
464: where assoc.rule_id = rules.rule_id
465: and assoc.template_id = ' ||l_Template_Id||
466: ' and rules.rule_id in ' ||l_request_rule_ids||
467:

Line 478: select distinct assoc.rule_id from OKC_XPRT_TEMPLATE_RULES assoc, OKC_XPRT_RULE_HDRS_ALL rules

474: where cond.object_value_type = ''QUESTION''
475: and outcome.object_type = ''QUESTION''
476: and cond.rule_id = outcome.rule_id
477: and cond.rule_id in (
478: select distinct assoc.rule_id from OKC_XPRT_TEMPLATE_RULES assoc, OKC_XPRT_RULE_HDRS_ALL rules
479: where assoc.rule_id = rules.rule_id
480: and assoc.template_id = ' ||l_Template_Id||
481: ' and rules.status_code in (''ACTIVE'',''PENDINGPUB'',''REVISION'',''PENDINGDISABLE'')
482:

Line 485: select distinct rule_id from OKC_XPRT_RULE_HDRS_ALL

481: ' and rules.status_code in (''ACTIVE'',''PENDINGPUB'',''REVISION'',''PENDINGDISABLE'')
482:
483: UNION ALL
484:
485: select distinct rule_id from OKC_XPRT_RULE_HDRS_ALL
486: where status_code in (''ACTIVE'',''PENDINGPUB'',''REVISION'',''PENDINGDISABLE'')
487: and org_wide_flag = ''Y''
488: and org_id = ' ||l_Org_Id||
489: ' and intent = ''' ||l_Intent|| '''' ||

Line 493: select distinct rule_id from OKC_XPRT_RULE_HDRS_ALL

489: ' and intent = ''' ||l_Intent|| '''' ||
490:
491: ' UNION ALL
492:
493: select distinct rule_id from OKC_XPRT_RULE_HDRS_ALL
494: where org_wide_flag = ''Y''
495: and org_id = ' ||l_Org_Id||
496: ' and intent = ''' ||l_Intent|| '''' ||
497: ' and rule_id in ' ||l_request_rule_ids||

Line 501: select distinct assoc.rule_id from OKC_XPRT_TEMPLATE_RULES assoc, OKC_XPRT_RULE_HDRS_ALL rules

497: ' and rule_id in ' ||l_request_rule_ids||
498:
499: ' UNION ALL
500:
501: select distinct assoc.rule_id from OKC_XPRT_TEMPLATE_RULES assoc, OKC_XPRT_RULE_HDRS_ALL rules
502: where assoc.rule_id = rules.rule_id
503: and assoc.template_id = ' ||l_Template_Id||
504: ' and rules.rule_id in ' ||l_request_rule_ids||
505:

Line 649: FROM okc_xprt_rule_hdrs_all

645: ) IS
646:
647: CURSOR csr_rule_dtls IS
648: SELECT rule_name
649: FROM okc_xprt_rule_hdrs_all
650: WHERE rule_id = p_rule_id;
651:
652: CURSOR csr_clause_options IS
653: SELECT article_id,

Line 662: okc_xprt_rule_hdrs_all r,

658: SELECT v.object_value_code article_id,
659: a.article_title
660: FROM okc_xprt_rule_cond_vals v,
661: okc_xprt_rule_conditions c,
662: okc_xprt_rule_hdrs_all r,
663: okc_articles_all a
664: WHERE v.rule_condition_id = c.rule_condition_id
665: AND c.rule_id = r.rule_id
666: AND a.article_id = to_number(v.object_value_code) -- Fixed for Bug 4935811. Removed to_char on article_id

Line 675: okc_xprt_rule_hdrs_all r,

671: -- All DISTINCT Clauses from Outcome
672: SELECT to_char(o.object_value_id) article_id,
673: a.article_title
674: FROM okc_xprt_rule_outcomes o,
675: okc_xprt_rule_hdrs_all r,
676: okc_articles_all a
677: WHERE o.rule_id = r.rule_id
678: AND a.article_id = o.object_value_id
679: AND o.object_type = 'CLAUSE'

Line 709: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;

705: l_api_name CONSTANT VARCHAR2(30) := 'check_expired_clauses';
706: l_dummy VARCHAR2(1);
707: l_status VARCHAR2(30);
708: l_approved_exists VARCHAR2(1) :=NULL;
709: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
710: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
711:
712: BEGIN
713:

Line 894: FROM okc_xprt_rule_hdrs_all

890: ) IS
891:
892: CURSOR csr_rule_dtls IS
893: SELECT rule_name
894: FROM okc_xprt_rule_hdrs_all
895: WHERE rule_id = p_rule_id;
896:
897: CURSOR csr_clause_options IS
898: SELECT article_id,

Line 907: okc_xprt_rule_hdrs_all r,

903: SELECT v.object_value_code article_id,
904: a.article_title
905: FROM okc_xprt_rule_cond_vals v,
906: okc_xprt_rule_conditions c,
907: okc_xprt_rule_hdrs_all r,
908: okc_articles_all a
909: WHERE v.rule_condition_id = c.rule_condition_id
910: AND c.rule_id = r.rule_id
911: AND to_char(a.article_id) = v.object_value_code

Line 920: okc_xprt_rule_hdrs_all r,

916: -- All DISTINCT Clauses from Outcome
917: SELECT to_char(o.object_value_id) article_id,
918: a.article_title
919: FROM okc_xprt_rule_outcomes o,
920: okc_xprt_rule_hdrs_all r,
921: okc_articles_all a
922: WHERE o.rule_id = r.rule_id
923: AND a.article_id = o.object_value_id
924: AND o.object_type = 'CLAUSE'

Line 950: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;

946: ;
947:
948: l_api_name CONSTANT VARCHAR2(30) := 'check_draft_clauses';
949: l_dummy VARCHAR2(1);
950: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
951: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
952:
953: l_clause_title VARCHAR2(2000);
954:

Line 1087: FROM okc_xprt_rule_hdrs_all

1083: ) IS
1084:
1085: CURSOR csr_rule_dtls IS
1086: SELECT rule_name
1087: FROM okc_xprt_rule_hdrs_all
1088: WHERE rule_id = p_rule_id;
1089:
1090: -- List of questions used in rule
1091: CURSOR csr_rule_questions IS

Line 1155: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;

1151:
1152: l_api_name CONSTANT VARCHAR2(30) := 'check_invalid_vset_qst';
1153: l_validation_type FND_FLEX_VALUE_SETS.validation_type%TYPE;
1154: l_value_set_id FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE;
1155: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
1156: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
1157:
1158: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
1159: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;

Line 1504: FROM okc_xprt_rule_hdrs_all

1500: ) IS
1501:
1502: CURSOR csr_rule_dtls IS
1503: SELECT rule_name
1504: FROM okc_xprt_rule_hdrs_all
1505: WHERE rule_id = p_rule_id;
1506:
1507: -- List of system variables in Rule
1508: CURSOR csr_rule_variables IS

Line 1571: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;

1567:
1568: l_api_name CONSTANT VARCHAR2(30) := 'check_invalid_vset_var';
1569: l_validation_type FND_FLEX_VALUE_SETS.validation_type%TYPE;
1570: l_value_set_id FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE;
1571: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
1572: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
1573:
1574: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
1575: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;

Line 1987: FROM okc_xprt_rule_hdrs_all

1983: ) IS
1984:
1985: CURSOR csr_rule_dtls IS
1986: SELECT rule_name
1987: FROM okc_xprt_rule_hdrs_all
1988: WHERE rule_id = p_rule_id;
1989:
1990: -- List of questions used in rule
1991: CURSOR csr_rule_questions IS

Line 2021: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;

2017: AND q.disabled_flag = 'Y' ;
2018:
2019: l_api_name CONSTANT VARCHAR2(30) := 'check_invalid_questions';
2020: l_dummy VARCHAR2(1);
2021: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
2022: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
2023:
2024: BEGIN
2025:

Line 2138: FROM okc_xprt_rule_hdrs_all

2134:
2135:
2136: CURSOR csr_rule_dtls IS
2137: SELECT rule_name, NVL(org_wide_flag,'N')
2138: FROM okc_xprt_rule_hdrs_all
2139: WHERE rule_id = p_rule_id;
2140:
2141: CURSOR csr_rule_templates IS
2142: SELECT 'x'

Line 2149: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;

2145: AND NVL(deleted_flag,'N') = 'N' ;
2146:
2147: l_api_name CONSTANT VARCHAR2(30) := 'check_rule_templates';
2148: l_dummy VARCHAR2(1);
2149: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
2150: l_org_wide_flag okc_xprt_rule_hdrs_all.org_wide_flag%TYPE;
2151: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
2152:
2153: BEGIN

Line 2150: l_org_wide_flag okc_xprt_rule_hdrs_all.org_wide_flag%TYPE;

2146:
2147: l_api_name CONSTANT VARCHAR2(30) := 'check_rule_templates';
2148: l_dummy VARCHAR2(1);
2149: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
2150: l_org_wide_flag okc_xprt_rule_hdrs_all.org_wide_flag%TYPE;
2151: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
2152:
2153: BEGIN
2154:

Line 2280: FROM okc_xprt_rule_hdrs_all rhdr,

2276: SELECT distinct v.procedure_name procedure_name,
2277: rcon.object_code variable_code, -- LHS of Condition
2278: t.variable_name variable_name,
2279: rhdr.rule_name rule_name
2280: FROM okc_xprt_rule_hdrs_all rhdr,
2281: okc_xprt_rule_conditions rcon,
2282: okc_bus_variables_b v,
2283: okc_bus_variables_tl t
2284: WHERE rhdr.rule_id = rcon.rule_id

Line 2296: FROM okc_xprt_rule_hdrs_all rhdr,

2292: SELECT distinct v.procedure_name procedure_name,
2293: rcon.object_value_code variable_code, -- RHS of Condition
2294: t.variable_name variable_name,
2295: rhdr.rule_name rule_name
2296: FROM okc_xprt_rule_hdrs_all rhdr,
2297: okc_xprt_rule_conditions rcon,
2298: okc_bus_variables_b v,
2299: okc_bus_variables_tl t
2300: WHERE rhdr.rule_id = rcon.rule_id

Line 2552: FROM okc_xprt_rule_hdrs_all rules

2548:
2549: --Added for Bug 4725397
2550: CURSOR c_get_rule_org_id (p_rule_id NUMBER) IS
2551: SELECT rules.org_id
2552: FROM okc_xprt_rule_hdrs_all rules
2553: WHERE rules.rule_id = p_rule_id;
2554:
2555: l_api_name CONSTANT VARCHAR2(30) := 'qa_rules';
2556: l_sequence_id okc_qa_errors_t.sequence_id%TYPE;

Line 3007: UPDATE okc_xprt_rule_hdrs_all

3003:
3004: -- For all rules in p_ruleid_tbl update the rule status to PENDINGPUB or PENDINGDISABLE
3005: FOR i IN NVL(p_ruleid_tbl.FIRST,0)..NVL(p_ruleid_tbl.LAST,-1)
3006: LOOP
3007: UPDATE okc_xprt_rule_hdrs_all
3008: SET status_code = DECODE(p_sync_mode,'PUBLISH','PENDINGPUB',
3009: 'DISABLE','PENDINGDISABLE',
3010: p_sync_mode)
3011: WHERE rule_id = p_ruleid_tbl(i);