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_IMPORT_PVT dependencies on CZ_IMP_RULES

Line 509: CURSOR csr_cz_imp_rules_cnt IS

505: INSTR(req_data,':',1) + 1
506: ) run_id
507: FROM dual;
508:
509: CURSOR csr_cz_imp_rules_cnt IS
510: SELECT COUNT(*)
511: FROM cz_imp_rules
512: WHERE run_id = G_RUN_ID;
513:

Line 511: FROM cz_imp_rules

507: FROM dual;
508:
509: CURSOR csr_cz_imp_rules_cnt IS
510: SELECT COUNT(*)
511: FROM cz_imp_rules
512: WHERE run_id = G_RUN_ID;
513:
514: -- Added for 4103931
515: CURSOR csr_pub_rule_list IS

Line 843: Step 5: Populate cz_imp_rules

839: END IF;
840:
841:
842: /*
843: Step 5: Populate cz_imp_rules
844: */
845:
846: fnd_file.put_line(FND_FILE.LOG,' ');
847: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 848: fnd_file.put_line(FND_FILE.LOG,'Step 5: Populating cz_imp_rules ');

844: */
845:
846: fnd_file.put_line(FND_FILE.LOG,' ');
847: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
848: fnd_file.put_line(FND_FILE.LOG,'Step 5: Populating cz_imp_rules ');
849: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
850: fnd_file.put_line(FND_FILE.LOG,' ');
851:
852: OKC_XPRT_IMPORT_RULES_PVT.import_rules_publish

Line 861: fnd_file.put_line(FND_FILE.LOG,'After Populating cz_imp_rules');

857: x_msg_count => x_msg_count
858: );
859:
860: fnd_file.put_line(FND_FILE.LOG,' ');
861: fnd_file.put_line(FND_FILE.LOG,'After Populating cz_imp_rules');
862: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
863: fnd_file.put_line(FND_FILE.LOG,'Rule Import Run Id : '||G_RUN_ID);
864: fnd_file.put_line(FND_FILE.LOG,' ');
865:

Line 900: Check if there are any records in cz_imp_rules

896: END IF;
897:
898: /*
899: Step 5.1: Count Rules to be imported
900: Check if there are any records in cz_imp_rules
901: If there are no records in cz_imp_rules then there were no expert enabled templates
902: attached to the rule. Just change the status of the rule to ACTIVE
903: */
904:

Line 901: If there are no records in cz_imp_rules then there were no expert enabled templates

897:
898: /*
899: Step 5.1: Count Rules to be imported
900: Check if there are any records in cz_imp_rules
901: If there are no records in cz_imp_rules then there were no expert enabled templates
902: attached to the rule. Just change the status of the rule to ACTIVE
903: */
904:
905: fnd_file.put_line(FND_FILE.LOG,' ');

Line 911: OPEN csr_cz_imp_rules_cnt;

907: fnd_file.put_line(FND_FILE.LOG,'Step 5.1:Count Rules to be imported');
908: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
909: fnd_file.put_line(FND_FILE.LOG,' ');
910:
911: OPEN csr_cz_imp_rules_cnt;
912: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;
913: CLOSE csr_cz_imp_rules_cnt;
914:
915: fnd_file.put_line(FND_FILE.LOG,' ');

Line 912: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;

908: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
909: fnd_file.put_line(FND_FILE.LOG,' ');
910:
911: OPEN csr_cz_imp_rules_cnt;
912: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;
913: CLOSE csr_cz_imp_rules_cnt;
914:
915: fnd_file.put_line(FND_FILE.LOG,' ');
916: fnd_file.put_line(FND_FILE.LOG,'Total Rules to be Imported to CZ: '||l_rules_cnt);

Line 913: CLOSE csr_cz_imp_rules_cnt;

909: fnd_file.put_line(FND_FILE.LOG,' ');
910:
911: OPEN csr_cz_imp_rules_cnt;
912: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;
913: CLOSE csr_cz_imp_rules_cnt;
914:
915: fnd_file.put_line(FND_FILE.LOG,' ');
916: fnd_file.put_line(FND_FILE.LOG,'Total Rules to be Imported to CZ: '||l_rules_cnt);
917: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1587: CURSOR csr_cz_imp_rules_cnt IS

1583: INSTR(req_data,':',1) + 1
1584: ) run_id
1585: FROM dual;
1586:
1587: CURSOR csr_cz_imp_rules_cnt IS
1588: SELECT COUNT(*)
1589: FROM cz_imp_rules
1590: WHERE run_id = G_RUN_ID;
1591:

Line 1589: FROM cz_imp_rules

1585: FROM dual;
1586:
1587: CURSOR csr_cz_imp_rules_cnt IS
1588: SELECT COUNT(*)
1589: FROM cz_imp_rules
1590: WHERE run_id = G_RUN_ID;
1591:
1592: -- Added for 4757731
1593: CURSOR csr_dis_rule_list IS

Line 1739: Step 3: Populate cz_imp_rules

1735: END IF;
1736:
1737:
1738: /*
1739: Step 3: Populate cz_imp_rules
1740: */
1741:
1742: fnd_file.put_line(FND_FILE.LOG,' ');
1743: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 1744: fnd_file.put_line(FND_FILE.LOG,'Step 3: Populating cz_imp_rules ');

1740: */
1741:
1742: fnd_file.put_line(FND_FILE.LOG,' ');
1743: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1744: fnd_file.put_line(FND_FILE.LOG,'Step 3: Populating cz_imp_rules ');
1745: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1746: fnd_file.put_line(FND_FILE.LOG,' ');
1747:
1748: OKC_XPRT_IMPORT_RULES_PVT.import_rules_disable

Line 1757: fnd_file.put_line(FND_FILE.LOG,'After Populating cz_imp_rules');

1753: x_msg_count => x_msg_count
1754: );
1755:
1756: fnd_file.put_line(FND_FILE.LOG,' ');
1757: fnd_file.put_line(FND_FILE.LOG,'After Populating cz_imp_rules');
1758: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
1759: fnd_file.put_line(FND_FILE.LOG,'Rule Import Run Id : '||G_RUN_ID);
1760: fnd_file.put_line(FND_FILE.LOG,' ');
1761:

Line 1795: Check if there are any records in cz_imp_rules

1791: RAISE FND_API.G_EXC_ERROR;
1792: END IF;
1793: /*
1794: Step 3.1: Count Rules to be imported
1795: Check if there are any records in cz_imp_rules
1796: If there are no records in cz_imp_rules then there were no expert enabled templates
1797: attached to the rule. Just change the status of the rule to INACTIVE
1798: */
1799:

Line 1796: If there are no records in cz_imp_rules then there were no expert enabled templates

1792: END IF;
1793: /*
1794: Step 3.1: Count Rules to be imported
1795: Check if there are any records in cz_imp_rules
1796: If there are no records in cz_imp_rules then there were no expert enabled templates
1797: attached to the rule. Just change the status of the rule to INACTIVE
1798: */
1799:
1800: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1806: OPEN csr_cz_imp_rules_cnt;

1802: fnd_file.put_line(FND_FILE.LOG,'Step 3.1:Count Rules to be imported');
1803: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1804: fnd_file.put_line(FND_FILE.LOG,' ');
1805:
1806: OPEN csr_cz_imp_rules_cnt;
1807: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;
1808: CLOSE csr_cz_imp_rules_cnt;
1809:
1810: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1807: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;

1803: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
1804: fnd_file.put_line(FND_FILE.LOG,' ');
1805:
1806: OPEN csr_cz_imp_rules_cnt;
1807: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;
1808: CLOSE csr_cz_imp_rules_cnt;
1809:
1810: fnd_file.put_line(FND_FILE.LOG,' ');
1811: fnd_file.put_line(FND_FILE.LOG,'Total Rules to be Imported to CZ: '||l_rules_cnt);

Line 1808: CLOSE csr_cz_imp_rules_cnt;

1804: fnd_file.put_line(FND_FILE.LOG,' ');
1805:
1806: OPEN csr_cz_imp_rules_cnt;
1807: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;
1808: CLOSE csr_cz_imp_rules_cnt;
1809:
1810: fnd_file.put_line(FND_FILE.LOG,' ');
1811: fnd_file.put_line(FND_FILE.LOG,'Total Rules to be Imported to CZ: '||l_rules_cnt);
1812: fnd_file.put_line(FND_FILE.LOG,' ');

Line 2622: CURSOR csr_cz_imp_rules_cnt IS

2618: INSTR(req_data,':',1) + 1
2619: ) run_id
2620: FROM dual;
2621:
2622: CURSOR csr_cz_imp_rules_cnt IS
2623: SELECT COUNT(*)
2624: FROM cz_imp_rules
2625: WHERE run_id = G_RUN_ID;
2626:

Line 2624: FROM cz_imp_rules

2620: FROM dual;
2621:
2622: CURSOR csr_cz_imp_rules_cnt IS
2623: SELECT COUNT(*)
2624: FROM cz_imp_rules
2625: WHERE run_id = G_RUN_ID;
2626:
2627:
2628: l_okc_rules_engine VARCHAR2(1);

Line 2746: Step 2: Populate cz_imp_rules

2742: END IF;
2743:
2744:
2745: /*
2746: Step 2: Populate cz_imp_rules
2747: */
2748:
2749: fnd_file.put_line(FND_FILE.LOG,' ');
2750: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');

Line 2751: fnd_file.put_line(FND_FILE.LOG,'Step 2: Populating cz_imp_rules ');

2747: */
2748:
2749: fnd_file.put_line(FND_FILE.LOG,' ');
2750: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2751: fnd_file.put_line(FND_FILE.LOG,'Step 2: Populating cz_imp_rules ');
2752: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2753: fnd_file.put_line(FND_FILE.LOG,' ');
2754:
2755: OKC_XPRT_IMPORT_RULES_PVT.import_rule_temp_approval

Line 2765: fnd_file.put_line(FND_FILE.LOG,'After Populating cz_imp_rules');

2761: x_msg_count => x_msg_count
2762: );
2763:
2764: fnd_file.put_line(FND_FILE.LOG,' ');
2765: fnd_file.put_line(FND_FILE.LOG,'After Populating cz_imp_rules');
2766: fnd_file.put_line(FND_FILE.LOG,'x_return_status: '||x_return_status);
2767: fnd_file.put_line(FND_FILE.LOG,'x_msg_data: '||x_msg_data);
2768: fnd_file.put_line(FND_FILE.LOG,'Rule Import Run Id : '||G_RUN_ID);
2769: fnd_file.put_line(FND_FILE.LOG,' ');

Line 2781: Check if there are any records in cz_imp_rules

2777:
2778:
2779: /*
2780: Step 2.1: Count Rules to be imported
2781: Check if there are any records in cz_imp_rules
2782: If there are no records in cz_imp_rules then Template has no rules attached
2783: Skip the rule import process
2784: */
2785:

Line 2782: If there are no records in cz_imp_rules then Template has no rules attached

2778:
2779: /*
2780: Step 2.1: Count Rules to be imported
2781: Check if there are any records in cz_imp_rules
2782: If there are no records in cz_imp_rules then Template has no rules attached
2783: Skip the rule import process
2784: */
2785:
2786: fnd_file.put_line(FND_FILE.LOG,' ');

Line 2792: OPEN csr_cz_imp_rules_cnt;

2788: fnd_file.put_line(FND_FILE.LOG,'Step 2.1:Count Rules to be imported');
2789: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2790: fnd_file.put_line(FND_FILE.LOG,' ');
2791:
2792: OPEN csr_cz_imp_rules_cnt;
2793: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;
2794: CLOSE csr_cz_imp_rules_cnt;
2795:
2796: fnd_file.put_line(FND_FILE.LOG,' ');

Line 2793: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;

2789: fnd_file.put_line(FND_FILE.LOG,'---------------------------------------------------------- ');
2790: fnd_file.put_line(FND_FILE.LOG,' ');
2791:
2792: OPEN csr_cz_imp_rules_cnt;
2793: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;
2794: CLOSE csr_cz_imp_rules_cnt;
2795:
2796: fnd_file.put_line(FND_FILE.LOG,' ');
2797: fnd_file.put_line(FND_FILE.LOG,'Total Rules to be Imported to CZ: '||l_rules_cnt);

Line 2794: CLOSE csr_cz_imp_rules_cnt;

2790: fnd_file.put_line(FND_FILE.LOG,' ');
2791:
2792: OPEN csr_cz_imp_rules_cnt;
2793: FETCH csr_cz_imp_rules_cnt INTO l_rules_cnt;
2794: CLOSE csr_cz_imp_rules_cnt;
2795:
2796: fnd_file.put_line(FND_FILE.LOG,' ');
2797: fnd_file.put_line(FND_FILE.LOG,'Total Rules to be Imported to CZ: '||l_rules_cnt);
2798: fnd_file.put_line(FND_FILE.LOG,' ');