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_QA_ERRORS_T

Line 26: G_ERROR_RECORD_TYPE CONSTANT okc_qa_errors_t.error_record_type%TYPE := 'RULE';

22: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
23: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
24: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
25:
26: G_ERROR_RECORD_TYPE CONSTANT okc_qa_errors_t.error_record_type%TYPE := 'RULE';
27: G_RULE_QA_SEVERITY CONSTANT okc_qa_errors_t.error_severity%TYPE := 'E';
28: G_RULE_QA_SUCCESS CONSTANT okc_qa_errors_t.error_severity%TYPE := 'S';
29: G_CREATION_DATE CONSTANT DATE := SYSDATE;
30:

Line 27: G_RULE_QA_SEVERITY CONSTANT okc_qa_errors_t.error_severity%TYPE := 'E';

23: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
24: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
25:
26: G_ERROR_RECORD_TYPE CONSTANT okc_qa_errors_t.error_record_type%TYPE := 'RULE';
27: G_RULE_QA_SEVERITY CONSTANT okc_qa_errors_t.error_severity%TYPE := 'E';
28: G_RULE_QA_SUCCESS CONSTANT okc_qa_errors_t.error_severity%TYPE := 'S';
29: G_CREATION_DATE CONSTANT DATE := SYSDATE;
30:
31: --

Line 28: G_RULE_QA_SUCCESS CONSTANT okc_qa_errors_t.error_severity%TYPE := 'S';

24: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
25:
26: G_ERROR_RECORD_TYPE CONSTANT okc_qa_errors_t.error_record_type%TYPE := 'RULE';
27: G_RULE_QA_SEVERITY CONSTANT okc_qa_errors_t.error_severity%TYPE := 'E';
28: G_RULE_QA_SUCCESS CONSTANT okc_qa_errors_t.error_severity%TYPE := 'S';
29: G_CREATION_DATE CONSTANT DATE := SYSDATE;
30:
31: --
32: -- Rules QA Codes (lookup_type = OKC_XPRT_RULES_QA_LIST)

Line 168: p_qa_errors_t_rec IN OKC_QA_ERRORS_T%ROWTYPE,

164: -- Procedure
165: ---------------------------------------------------
166: PROCEDURE insert_qa_errors_t
167: (
168: p_qa_errors_t_rec IN OKC_QA_ERRORS_T%ROWTYPE,
169: x_return_status OUT NOCOPY VARCHAR2,
170: x_msg_count OUT NOCOPY NUMBER,
171: x_msg_data OUT NOCOPY VARCHAR2
172: ) IS

Line 188: INSERT INTO OKC_QA_ERRORS_T

184: END IF;
185:
186: x_return_status := G_RET_STS_SUCCESS;
187:
188: INSERT INTO OKC_QA_ERRORS_T
189: (
190: DOCUMENT_TYPE,
191: DOCUMENT_ID,
192: SEQUENCE_ID,

Line 328: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;

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;
332: l_Intent VARCHAR2(1);

Line 562: -- insert into okc_qa_errors_t

558: G_OKC_CIRCULAR_DEPENDENCY_S);
559: l_qa_errors_t_rec.CREATION_DATE := G_CREATION_DATE;
560: l_qa_errors_t_rec.RULE_ID := p_rule_id;
561:
562: -- insert into okc_qa_errors_t
563: insert_qa_errors_t
564: (
565: p_qa_errors_t_rec => l_qa_errors_t_rec,
566: x_return_status => x_return_status,

Line 669: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;

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:
673: -- start debug log

Line 723: -- insert into okc_qa_errors_t

719: );
720: l_qa_errors_t_rec.CREATION_DATE := G_CREATION_DATE;
721: l_qa_errors_t_rec.RULE_ID := p_rule_id;
722:
723: -- insert into okc_qa_errors_t
724: insert_qa_errors_t
725: (
726: p_qa_errors_t_rec => l_qa_errors_t_rec,
727: x_return_status => x_return_status,

Line 758: -- insert into okc_qa_errors_t

754: );
755: l_qa_errors_t_rec.CREATION_DATE := G_CREATION_DATE;
756: l_qa_errors_t_rec.RULE_ID := p_rule_id;
757:
758: -- insert into okc_qa_errors_t
759: insert_qa_errors_t
760: (
761: p_qa_errors_t_rec => l_qa_errors_t_rec,
762: x_return_status => x_return_status,

Line 892: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;

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:
896: -- start debug log

Line 939: -- insert into okc_qa_errors_t

935: );
936: l_qa_errors_t_rec.CREATION_DATE := G_CREATION_DATE;
937: l_qa_errors_t_rec.RULE_ID := p_rule_id;
938:
939: -- insert into okc_qa_errors_t
940: insert_qa_errors_t
941: (
942: p_qa_errors_t_rec => l_qa_errors_t_rec,
943: x_return_status => x_return_status,

Line 1085: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;

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;
1089: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;

Line 1152: -- insert into okc_qa_errors_t

1148: );
1149: l_qa_errors_t_rec.CREATION_DATE := G_CREATION_DATE;
1150: l_qa_errors_t_rec.RULE_ID := p_rule_id;
1151:
1152: -- insert into okc_qa_errors_t
1153: insert_qa_errors_t
1154: (
1155: p_qa_errors_t_rec => l_qa_errors_t_rec,
1156: x_return_status => x_return_status,

Line 1238: -- insert into okc_qa_errors_t

1234: );
1235: l_qa_errors_t_rec.CREATION_DATE := G_CREATION_DATE;
1236: l_qa_errors_t_rec.RULE_ID := p_rule_id;
1237:
1238: -- insert into okc_qa_errors_t
1239: insert_qa_errors_t
1240: (
1241: p_qa_errors_t_rec => l_qa_errors_t_rec,
1242: x_return_status => x_return_status,

Line 1290: -- insert into okc_qa_errors_t

1286: );
1287: l_qa_errors_t_rec.CREATION_DATE := G_CREATION_DATE;
1288: l_qa_errors_t_rec.RULE_ID := p_rule_id;
1289:
1290: -- insert into okc_qa_errors_t
1291: insert_qa_errors_t
1292: (
1293: p_qa_errors_t_rec => l_qa_errors_t_rec,
1294: x_return_status => x_return_status,

Line 1342: -- insert into okc_qa_errors_t

1338: );
1339: l_qa_errors_t_rec.CREATION_DATE := G_CREATION_DATE;
1340: l_qa_errors_t_rec.RULE_ID := p_rule_id;
1341:
1342: -- insert into okc_qa_errors_t
1343: insert_qa_errors_t
1344: (
1345: p_qa_errors_t_rec => l_qa_errors_t_rec,
1346: x_return_status => x_return_status,

Line 1501: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;

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;
1505: l_id_col fnd_flex_validation_tables.id_column_name%TYPE;

Line 1570: -- insert into okc_qa_errors_t

1566: );
1567: l_qa_errors_t_rec.CREATION_DATE := G_CREATION_DATE;
1568: l_qa_errors_t_rec.RULE_ID := p_rule_id;
1569:
1570: -- insert into okc_qa_errors_t
1571: insert_qa_errors_t
1572: (
1573: p_qa_errors_t_rec => l_qa_errors_t_rec,
1574: x_return_status => x_return_status,

Line 1623: -- insert into okc_qa_errors_t

1619: );
1620: l_qa_errors_t_rec.CREATION_DATE := G_CREATION_DATE;
1621: l_qa_errors_t_rec.RULE_ID := p_rule_id;
1622:
1623: -- insert into okc_qa_errors_t
1624: insert_qa_errors_t
1625: (
1626: p_qa_errors_t_rec => l_qa_errors_t_rec,
1627: x_return_status => x_return_status,

Line 1724: -- insert into okc_qa_errors_t

1720: );
1721: l_qa_errors_t_rec.CREATION_DATE := G_CREATION_DATE;
1722: l_qa_errors_t_rec.RULE_ID := p_rule_id;
1723:
1724: -- insert into okc_qa_errors_t
1725: insert_qa_errors_t
1726: (
1727: p_qa_errors_t_rec => l_qa_errors_t_rec,
1728: x_return_status => x_return_status,

Line 1778: -- insert into okc_qa_errors_t

1774: );
1775: l_qa_errors_t_rec.CREATION_DATE := G_CREATION_DATE;
1776: l_qa_errors_t_rec.RULE_ID := p_rule_id;
1777:
1778: -- insert into okc_qa_errors_t
1779: insert_qa_errors_t
1780: (
1781: p_qa_errors_t_rec => l_qa_errors_t_rec,
1782: x_return_status => x_return_status,

Line 1828: -- insert into okc_qa_errors_t

1824: );
1825: l_qa_errors_t_rec.CREATION_DATE := G_CREATION_DATE;
1826: l_qa_errors_t_rec.RULE_ID := p_rule_id;
1827:
1828: -- insert into okc_qa_errors_t
1829: insert_qa_errors_t
1830: (
1831: p_qa_errors_t_rec => l_qa_errors_t_rec,
1832: x_return_status => x_return_status,

Line 1951: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;

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:
1955: -- start debug log

Line 1993: -- insert into okc_qa_errors_t

1989: );
1990: l_qa_errors_t_rec.CREATION_DATE := G_CREATION_DATE;
1991: l_qa_errors_t_rec.RULE_ID := p_rule_id;
1992:
1993: -- insert into okc_qa_errors_t
1994: insert_qa_errors_t
1995: (
1996: p_qa_errors_t_rec => l_qa_errors_t_rec,
1997: x_return_status => x_return_status,

Line 2080: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;

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:
2084: -- start debug log

Line 2126: -- insert into okc_qa_errors_t

2122: );
2123: l_qa_errors_t_rec.CREATION_DATE := G_CREATION_DATE;
2124: l_qa_errors_t_rec.RULE_ID := p_rule_id;
2125:
2126: -- insert into okc_qa_errors_t
2127: insert_qa_errors_t
2128: (
2129: p_qa_errors_t_rec => l_qa_errors_t_rec,
2130: x_return_status => x_return_status,

Line 2277: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;

2273: l_api_name CONSTANT VARCHAR2(30) := 'check_invalid_udv_procedure';
2274: l_dummy VARCHAR2(1);
2275: l_procedure_spec_status ALL_OBJECTS.status%TYPE;
2276: l_procedure_body_status ALL_OBJECTS.status%TYPE;
2277: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
2278:
2279: BEGIN
2280:
2281: -- start debug log

Line 2337: -- INSERT INTO OKC_QA_ERRORS_T

2333: rec_rule_variables_w_proc.procedure_name);
2334: L_QA_ERRORS_T_REC.CREATION_DATE := G_CREATION_DATE;
2335: L_QA_ERRORS_T_REC.RULE_ID := P_RULE_ID;
2336:
2337: -- INSERT INTO OKC_QA_ERRORS_T
2338: INSERT_QA_ERRORS_T
2339: (
2340: P_QA_ERRORS_T_REC => L_QA_ERRORS_T_REC,
2341: X_RETURN_STATUS => X_RETURN_STATUS,

Line 2388: -- INSERT INTO OKC_QA_ERRORS_T

2384: rec_rule_variables_w_proc.procedure_name);
2385: L_QA_ERRORS_T_REC.CREATION_DATE := G_CREATION_DATE;
2386: L_QA_ERRORS_T_REC.RULE_ID := P_RULE_ID;
2387:
2388: -- INSERT INTO OKC_QA_ERRORS_T
2389: INSERT_QA_ERRORS_T
2390: (
2391: P_QA_ERRORS_T_REC => L_QA_ERRORS_T_REC,
2392: X_RETURN_STATUS => X_RETURN_STATUS,

Line 2475: SELECT OKC_QA_ERRORS_T_S.NEXTVAL

2471: x_msg_data OUT NOCOPY VARCHAR2
2472: ) IS
2473:
2474: CURSOR l_seq_csr IS
2475: SELECT OKC_QA_ERRORS_T_S.NEXTVAL
2476: FROM DUAL;
2477:
2478: --Added for Bug 4725397
2479: CURSOR c_get_rule_org_id (p_rule_id NUMBER) IS

Line 2485: l_sequence_id okc_qa_errors_t.sequence_id%TYPE;

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;
2486: l_qa_status VARCHAR2(1);
2487: l_rule_qa_status VARCHAR2(1);
2488: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
2489: l_rule_org_id NUMBER;

Line 2488: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;

2484: l_api_name CONSTANT VARCHAR2(30) := 'qa_rules';
2485: l_sequence_id okc_qa_errors_t.sequence_id%TYPE;
2486: l_qa_status VARCHAR2(1);
2487: l_rule_qa_status VARCHAR2(1);
2488: l_qa_errors_t_rec OKC_QA_ERRORS_T%ROWTYPE;
2489: l_rule_org_id NUMBER;
2490:
2491:
2492: BEGIN

Line 2797: -- If the rule passed all QAs successfully then insert into okc_qa_errors_t as success

2793: END IF;
2794:
2795: END IF; -- p_qa_mode IN ('PUBLISH','APPROVAL')
2796:
2797: -- If the rule passed all QAs successfully then insert into okc_qa_errors_t as success
2798: IF l_rule_qa_status = 'S' THEN
2799:
2800: l_qa_errors_t_rec.SEQUENCE_ID := l_sequence_id;
2801: l_qa_errors_t_rec.ERROR_RECORD_TYPE := G_ERROR_RECORD_TYPE;

Line 2806: -- insert into okc_qa_errors_t

2802: l_qa_errors_t_rec.ERROR_SEVERITY := G_RULE_QA_SUCCESS;
2803: l_qa_errors_t_rec.CREATION_DATE := G_CREATION_DATE;
2804: l_qa_errors_t_rec.RULE_ID := p_ruleid_tbl(i);
2805:
2806: -- insert into okc_qa_errors_t
2807: insert_qa_errors_t
2808: (
2809: p_qa_errors_t_rec => l_qa_errors_t_rec,
2810: x_return_status => x_return_status,