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_QA_PVT dependencies on OKC_XPRT_RULE_HDRS_ALL

Line 296: FROM okc_xprt_rule_hdrs_all

292: insert_cursor circ_rec;
293: -- cursor to retrieve rule name
294: CURSOR csr_rule_dtls IS
295: SELECT rule_name
296: FROM okc_xprt_rule_hdrs_all
297: WHERE rule_id = p_rule_id;
298:
299: -- cursor to retrieve templates associated to the rule
300: CURSOR template_cursor IS

Line 311: okc_xprt_rule_hdrs_all r

307: -- Org Wide Rule templates. Reverted back the changes done for 5019422 by removing
308: -- join to okc_xprt_template_rules
309: SELECT t.template_id, t.org_id, t.intent
310: FROM okc_terms_templates_all t,
311: okc_xprt_rule_hdrs_all r
312: WHERE t.org_id = r.org_id
313: AND t.intent = r.intent
314: AND t.contract_expert_enabled = 'Y'
315: -- AND t.status_code IN ('APPROVED','ON_HOLD')

Line 327: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;

323: from OKC_XPRT_QUESTION_REF_T
324: connect by prior condition_question_id = outcome_question_id ;
325:
326: l_api_name CONSTANT VARCHAR2(30) := 'check_circular_dependency';
327: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
328: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
329:
330: l_Template_Id NUMBER;
331: l_Org_Id NUMBER;

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

398: and outcome.object_type = ''QUESTION''
399: and cond.rule_id = outcome.rule_id
400: and cond.rule_id in (
401:
402: select distinct assoc.rule_id from OKC_XPRT_TEMPLATE_RULES assoc, OKC_XPRT_RULE_HDRS_ALL rules
403: where assoc.rule_id = rules.rule_id
404: and assoc.template_id = ' ||l_Template_Id ||
405: ' and rules.status_code in (''ACTIVE'',''PENDINGPUB'',''REVISION'',''PENDINGDISABLE'')
406:

Line 409: select distinct rule_id from OKC_XPRT_RULE_HDRS_ALL

405: ' and rules.status_code in (''ACTIVE'',''PENDINGPUB'',''REVISION'',''PENDINGDISABLE'')
406:
407: UNION ALL
408:
409: select distinct rule_id from OKC_XPRT_RULE_HDRS_ALL
410: where status_code in (''ACTIVE'',''PENDINGPUB'',''REVISION'',''PENDINGDISABLE'')
411: and org_wide_flag = ''Y''
412: and org_id = ' ||l_Org_Id ||
413: ' and intent = ''' ||l_Intent|| '''' ||

Line 417: select distinct rule_id from OKC_XPRT_RULE_HDRS_ALL

413: ' and intent = ''' ||l_Intent|| '''' ||
414:
415: ' UNION ALL
416:
417: select distinct rule_id from OKC_XPRT_RULE_HDRS_ALL
418: where org_wide_flag = ''Y''
419: and org_id = ' ||l_Org_Id||
420: ' and intent = ''' ||l_Intent|| '''' ||
421: ' and rule_id in '||l_request_rule_ids||

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

421: ' and rule_id in '||l_request_rule_ids||
422:
423: ' UNION ALL
424:
425: select distinct assoc.rule_id from OKC_XPRT_TEMPLATE_RULES assoc, OKC_XPRT_RULE_HDRS_ALL rules
426: where assoc.rule_id = rules.rule_id
427: and assoc.template_id = ' ||l_Template_Id||
428: ' and rules.rule_id in ' ||l_request_rule_ids||
429:

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

436: where cond.object_value_type = ''QUESTION''
437: and outcome.object_type = ''QUESTION''
438: and cond.rule_id = outcome.rule_id
439: and cond.rule_id in (
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 611: FROM okc_xprt_rule_hdrs_all

607: ) IS
608:
609: CURSOR csr_rule_dtls IS
610: SELECT rule_name
611: FROM okc_xprt_rule_hdrs_all
612: WHERE rule_id = p_rule_id;
613:
614: CURSOR csr_clause_options IS
615: SELECT article_id,

Line 624: okc_xprt_rule_hdrs_all r,

620: SELECT v.object_value_code article_id,
621: a.article_title
622: FROM okc_xprt_rule_cond_vals v,
623: okc_xprt_rule_conditions c,
624: okc_xprt_rule_hdrs_all r,
625: okc_articles_all a
626: WHERE v.rule_condition_id = c.rule_condition_id
627: AND c.rule_id = r.rule_id
628: AND a.article_id = to_number(v.object_value_code) -- Fixed for Bug 4935811. Removed to_char on article_id

Line 637: okc_xprt_rule_hdrs_all r,

633: -- All DISTINCT Clauses from Outcome
634: SELECT to_char(o.object_value_id) article_id,
635: a.article_title
636: FROM okc_xprt_rule_outcomes o,
637: okc_xprt_rule_hdrs_all r,
638: okc_articles_all a
639: WHERE o.rule_id = r.rule_id
640: AND a.article_id = o.object_value_id
641: AND o.object_type = 'CLAUSE'

Line 668: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;

664: l_api_name CONSTANT VARCHAR2(30) := 'check_expired_clauses';
665: l_dummy VARCHAR2(1);
666: l_status VARCHAR2(30);
667: l_approved_exists VARCHAR2(1) :=NULL;
668: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
669: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
670:
671: BEGIN
672:

Line 835: FROM okc_xprt_rule_hdrs_all

831: ) IS
832:
833: CURSOR csr_rule_dtls IS
834: SELECT rule_name
835: FROM okc_xprt_rule_hdrs_all
836: WHERE rule_id = p_rule_id;
837:
838: CURSOR csr_clause_options IS
839: SELECT article_id,

Line 848: okc_xprt_rule_hdrs_all r,

844: SELECT v.object_value_code article_id,
845: a.article_title
846: FROM okc_xprt_rule_cond_vals v,
847: okc_xprt_rule_conditions c,
848: okc_xprt_rule_hdrs_all r,
849: okc_articles_all a
850: WHERE v.rule_condition_id = c.rule_condition_id
851: AND c.rule_id = r.rule_id
852: AND to_char(a.article_id) = v.object_value_code

Line 861: okc_xprt_rule_hdrs_all r,

857: -- All DISTINCT Clauses from Outcome
858: SELECT to_char(o.object_value_id) article_id,
859: a.article_title
860: FROM okc_xprt_rule_outcomes o,
861: okc_xprt_rule_hdrs_all r,
862: okc_articles_all a
863: WHERE o.rule_id = r.rule_id
864: AND a.article_id = o.object_value_id
865: AND o.object_type = 'CLAUSE'

Line 891: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;

887: ;
888:
889: l_api_name CONSTANT VARCHAR2(30) := 'check_draft_clauses';
890: l_dummy VARCHAR2(1);
891: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
892: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
893:
894: BEGIN
895:

Line 1016: FROM okc_xprt_rule_hdrs_all

1012: ) IS
1013:
1014: CURSOR csr_rule_dtls IS
1015: SELECT rule_name
1016: FROM okc_xprt_rule_hdrs_all
1017: WHERE rule_id = p_rule_id;
1018:
1019: -- List of questions used in rule
1020: CURSOR csr_rule_questions IS

Line 1084: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;

1080:
1081: l_api_name CONSTANT VARCHAR2(30) := 'check_invalid_vset_qst';
1082: l_validation_type FND_FLEX_VALUE_SETS.validation_type%TYPE;
1083: l_value_set_id FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE;
1084: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
1085: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
1086:
1087: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
1088: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;

Line 1433: FROM okc_xprt_rule_hdrs_all

1429: ) IS
1430:
1431: CURSOR csr_rule_dtls IS
1432: SELECT rule_name
1433: FROM okc_xprt_rule_hdrs_all
1434: WHERE rule_id = p_rule_id;
1435:
1436: -- List of system variables in Rule
1437: CURSOR csr_rule_variables IS

Line 1500: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;

1496:
1497: l_api_name CONSTANT VARCHAR2(30) := 'check_invalid_vset_var';
1498: l_validation_type FND_FLEX_VALUE_SETS.validation_type%TYPE;
1499: l_value_set_id FND_FLEX_VALUE_SETS.flex_value_set_id%TYPE;
1500: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
1501: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
1502:
1503: l_table_name fnd_flex_validation_tables.application_table_name%TYPE;
1504: l_name_col fnd_flex_validation_tables.value_column_name%TYPE;

Line 1916: FROM okc_xprt_rule_hdrs_all

1912: ) IS
1913:
1914: CURSOR csr_rule_dtls IS
1915: SELECT rule_name
1916: FROM okc_xprt_rule_hdrs_all
1917: WHERE rule_id = p_rule_id;
1918:
1919: -- List of questions used in rule
1920: CURSOR csr_rule_questions IS

Line 1950: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;

1946: AND q.disabled_flag = 'Y' ;
1947:
1948: l_api_name CONSTANT VARCHAR2(30) := 'check_invalid_questions';
1949: l_dummy VARCHAR2(1);
1950: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
1951: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
1952:
1953: BEGIN
1954:

Line 2067: FROM okc_xprt_rule_hdrs_all

2063:
2064:
2065: CURSOR csr_rule_dtls IS
2066: SELECT rule_name, NVL(org_wide_flag,'N')
2067: FROM okc_xprt_rule_hdrs_all
2068: WHERE rule_id = p_rule_id;
2069:
2070: CURSOR csr_rule_templates IS
2071: SELECT 'x'

Line 2078: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;

2074: AND NVL(deleted_flag,'N') = 'N' ;
2075:
2076: l_api_name CONSTANT VARCHAR2(30) := 'check_rule_templates';
2077: l_dummy VARCHAR2(1);
2078: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
2079: l_org_wide_flag okc_xprt_rule_hdrs_all.org_wide_flag%TYPE;
2080: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
2081:
2082: BEGIN

Line 2079: l_org_wide_flag okc_xprt_rule_hdrs_all.org_wide_flag%TYPE;

2075:
2076: l_api_name CONSTANT VARCHAR2(30) := 'check_rule_templates';
2077: l_dummy VARCHAR2(1);
2078: l_rule_name okc_xprt_rule_hdrs_all.rule_name%TYPE;
2079: l_org_wide_flag okc_xprt_rule_hdrs_all.org_wide_flag%TYPE;
2080: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
2081:
2082: BEGIN
2083:

Line 2209: FROM okc_xprt_rule_hdrs_all rhdr,

2205: SELECT distinct v.procedure_name procedure_name,
2206: rcon.object_code variable_code, -- LHS of Condition
2207: t.variable_name variable_name,
2208: rhdr.rule_name rule_name
2209: FROM okc_xprt_rule_hdrs_all rhdr,
2210: okc_xprt_rule_conditions rcon,
2211: okc_bus_variables_b v,
2212: okc_bus_variables_tl t
2213: WHERE rhdr.rule_id = rcon.rule_id

Line 2225: FROM okc_xprt_rule_hdrs_all rhdr,

2221: SELECT distinct v.procedure_name procedure_name,
2222: rcon.object_value_code variable_code, -- RHS of Condition
2223: t.variable_name variable_name,
2224: rhdr.rule_name rule_name
2225: FROM okc_xprt_rule_hdrs_all rhdr,
2226: okc_xprt_rule_conditions rcon,
2227: okc_bus_variables_b v,
2228: okc_bus_variables_tl t
2229: WHERE rhdr.rule_id = rcon.rule_id

Line 2481: FROM okc_xprt_rule_hdrs_all rules

2477:
2478: --Added for Bug 4725397
2479: CURSOR c_get_rule_org_id (p_rule_id NUMBER) IS
2480: SELECT rules.org_id
2481: FROM okc_xprt_rule_hdrs_all rules
2482: WHERE rules.rule_id = p_rule_id;
2483:
2484: l_api_name CONSTANT VARCHAR2(30) := 'qa_rules';
2485: l_sequence_id okc_qa_errors_t.sequence_id%TYPE;

Line 2927: UPDATE okc_xprt_rule_hdrs_all

2923:
2924: -- For all rules in p_ruleid_tbl update the rule status to PENDINGPUB or PENDINGDISABLE
2925: FOR i IN NVL(p_ruleid_tbl.FIRST,0)..NVL(p_ruleid_tbl.LAST,-1)
2926: LOOP
2927: UPDATE okc_xprt_rule_hdrs_all
2928: SET status_code = DECODE(p_sync_mode,'PUBLISH','PENDINGPUB',
2929: 'DISABLE','PENDINGDISABLE',
2930: p_sync_mode)
2931: WHERE rule_id = p_ruleid_tbl(i);