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.INL_RULE_PVT dependencies on AD_DDL

Line 718: ad_ddl.build_package('CREATE OR REPLACE PACKAGE ' || l_package_name || ' AS ', l_count);

714: WHERE r.package_name IS NOT NULL
715: AND r.rule_id = p_rule_id;
716:
717: -- First line to create package specification
718: ad_ddl.build_package('CREATE OR REPLACE PACKAGE ' || l_package_name || ' AS ', l_count);
719:
720: IF l_package_name IS NOT NULL THEN
721: l_count := l_count+1;
722: ad_ddl.build_package('FUNCTION Get_Value(p_ship_header_id IN NUMBER)', l_count);

Line 722: ad_ddl.build_package('FUNCTION Get_Value(p_ship_header_id IN NUMBER)', l_count);

718: ad_ddl.build_package('CREATE OR REPLACE PACKAGE ' || l_package_name || ' AS ', l_count);
719:
720: IF l_package_name IS NOT NULL THEN
721: l_count := l_count+1;
722: ad_ddl.build_package('FUNCTION Get_Value(p_ship_header_id IN NUMBER)', l_count);
723: l_count := l_count+1;
724: ad_ddl.build_package('RETURN VARCHAR2; ', l_count);
725: l_count := l_count+1;
726: ad_ddl.build_package(' ', l_count);

Line 724: ad_ddl.build_package('RETURN VARCHAR2; ', l_count);

720: IF l_package_name IS NOT NULL THEN
721: l_count := l_count+1;
722: ad_ddl.build_package('FUNCTION Get_Value(p_ship_header_id IN NUMBER)', l_count);
723: l_count := l_count+1;
724: ad_ddl.build_package('RETURN VARCHAR2; ', l_count);
725: l_count := l_count+1;
726: ad_ddl.build_package(' ', l_count);
727: END IF;
728: l_count := l_count+1;

Line 726: ad_ddl.build_package(' ', l_count);

722: ad_ddl.build_package('FUNCTION Get_Value(p_ship_header_id IN NUMBER)', l_count);
723: l_count := l_count+1;
724: ad_ddl.build_package('RETURN VARCHAR2; ', l_count);
725: l_count := l_count+1;
726: ad_ddl.build_package(' ', l_count);
727: END IF;
728: l_count := l_count+1;
729: ad_ddl.build_package('END ' || l_package_name || ';', l_count);
730: ad_ddl.create_package(l_applsys_schema, 'INL', l_package_name, 'FALSE', 1, l_count);

Line 729: ad_ddl.build_package('END ' || l_package_name || ';', l_count);

725: l_count := l_count+1;
726: ad_ddl.build_package(' ', l_count);
727: END IF;
728: l_count := l_count+1;
729: ad_ddl.build_package('END ' || l_package_name || ';', l_count);
730: ad_ddl.create_package(l_applsys_schema, 'INL', l_package_name, 'FALSE', 1, l_count);
731:
732: -- Check status, return error if the package that was created is invalid
733: OPEN c_package_status(l_package_name);

Line 730: ad_ddl.create_package(l_applsys_schema, 'INL', l_package_name, 'FALSE', 1, l_count);

726: ad_ddl.build_package(' ', l_count);
727: END IF;
728: l_count := l_count+1;
729: ad_ddl.build_package('END ' || l_package_name || ';', l_count);
730: ad_ddl.create_package(l_applsys_schema, 'INL', l_package_name, 'FALSE', 1, l_count);
731:
732: -- Check status, return error if the package that was created is invalid
733: OPEN c_package_status(l_package_name);
734: FETCH c_package_status INTO l_error;

Line 846: ad_ddl.build_package('CREATE OR REPLACE PACKAGE BODY ' || l_package_name || ' AS ', l_count);

842: WHERE irb.package_name IS NOT NULL
843: AND rule_id = p_rule_id;
844:
845: -- First line to create package specification
846: ad_ddl.build_package('CREATE OR REPLACE PACKAGE BODY ' || l_package_name || ' AS ', l_count);
847:
848: IF l_package_name IS NOT NULL THEN
849: -- This function will return the query which is built
850: -- based on the conditions from a given rule

Line 868: ad_ddl.build_package('FUNCTION Get_Value(p_ship_header_id IN NUMBER)' || ' RETURN VARCHAR2 IS ', l_count);

864: buildpackage(l_query);
865:
866: -- Build function
867: l_count := l_count+1;
868: ad_ddl.build_package('FUNCTION Get_Value(p_ship_header_id IN NUMBER)' || ' RETURN VARCHAR2 IS ', l_count);
869: l_count := l_count+1;
870: ad_ddl.build_package('l_count NUMBER; ', l_count);
871: l_count := l_count+1;
872: ad_ddl.build_package('sql_stmt VARCHAR2(4000); ', l_count);

Line 870: ad_ddl.build_package('l_count NUMBER; ', l_count);

866: -- Build function
867: l_count := l_count+1;
868: ad_ddl.build_package('FUNCTION Get_Value(p_ship_header_id IN NUMBER)' || ' RETURN VARCHAR2 IS ', l_count);
869: l_count := l_count+1;
870: ad_ddl.build_package('l_count NUMBER; ', l_count);
871: l_count := l_count+1;
872: ad_ddl.build_package('sql_stmt VARCHAR2(4000); ', l_count);
873: l_count := l_count+1;
874:

Line 872: ad_ddl.build_package('sql_stmt VARCHAR2(4000); ', l_count);

868: ad_ddl.build_package('FUNCTION Get_Value(p_ship_header_id IN NUMBER)' || ' RETURN VARCHAR2 IS ', l_count);
869: l_count := l_count+1;
870: ad_ddl.build_package('l_count NUMBER; ', l_count);
871: l_count := l_count+1;
872: ad_ddl.build_package('sql_stmt VARCHAR2(4000); ', l_count);
873: l_count := l_count+1;
874:
875: OPEN c_conditions(p_rule_id);
876: FETCH c_conditions BULK COLLECT INTO l_cond;

Line 884: ad_ddl.build_package('l_right_attr' || l_cond(i).user_sequence || ' ' ||

880: IF NVL(l_cond.LAST, 0) > 0 THEN
881: FOR i IN NVL(l_cond.FIRST, 0)..NVL(l_cond.LAST, 0)
882: LOOP
883: IF l_cond(i).right_entity_code = 'CONS_CHAR' THEN
884: ad_ddl.build_package('l_right_attr' || l_cond(i).user_sequence || ' ' ||
885: l_cond(i).datatype || ' := ''' || l_cond(i).attribute_constant_character ||''';', l_count);
886: ELSIF l_cond(i).right_entity_code = 'CONS_NUMBER' THEN
887: ad_ddl.build_package('l_right_attr' || l_cond(i).user_sequence || ' ' ||
888: l_cond(i).datatype || ' := ' || l_cond(i).attribute_constant_number || ';', l_count);

Line 887: ad_ddl.build_package('l_right_attr' || l_cond(i).user_sequence || ' ' ||

883: IF l_cond(i).right_entity_code = 'CONS_CHAR' THEN
884: ad_ddl.build_package('l_right_attr' || l_cond(i).user_sequence || ' ' ||
885: l_cond(i).datatype || ' := ''' || l_cond(i).attribute_constant_character ||''';', l_count);
886: ELSIF l_cond(i).right_entity_code = 'CONS_NUMBER' THEN
887: ad_ddl.build_package('l_right_attr' || l_cond(i).user_sequence || ' ' ||
888: l_cond(i).datatype || ' := ' || l_cond(i).attribute_constant_number || ';', l_count);
889: ELSIF l_cond(i).right_entity_code = 'CONS_DATE' THEN
890: ad_ddl.build_package('l_right_attr' || l_cond(i).user_sequence || ' ' ||
891: l_cond(i).datatype || ' := ''' || l_cond(i).attribute_constant_date ||''';', l_count);

Line 890: ad_ddl.build_package('l_right_attr' || l_cond(i).user_sequence || ' ' ||

886: ELSIF l_cond(i).right_entity_code = 'CONS_NUMBER' THEN
887: ad_ddl.build_package('l_right_attr' || l_cond(i).user_sequence || ' ' ||
888: l_cond(i).datatype || ' := ' || l_cond(i).attribute_constant_number || ';', l_count);
889: ELSIF l_cond(i).right_entity_code = 'CONS_DATE' THEN
890: ad_ddl.build_package('l_right_attr' || l_cond(i).user_sequence || ' ' ||
891: l_cond(i).datatype || ' := ''' || l_cond(i).attribute_constant_date ||''';', l_count);
892: END IF;
893:
894: IF l_cond(i).right_entity_code IN ('CONS_CHAR', 'CONS_NUMBER', 'CONS_DATE') THEN

Line 911: ad_ddl.build_package('l_complete_ship VARCHAR2(1) := ''Y''; ', l_count);

907: IF l_using_param IS NULL THEN
908: l_using_param := ' p_ship_header_id';
909: END IF;
910:
911: ad_ddl.build_package('l_complete_ship VARCHAR2(1) := ''Y''; ', l_count);
912: l_count := l_count+1;
913:
914: ad_ddl.build_package('BEGIN ', l_count);
915: l_count := l_count+1;

Line 914: ad_ddl.build_package('BEGIN ', l_count);

910:
911: ad_ddl.build_package('l_complete_ship VARCHAR2(1) := ''Y''; ', l_count);
912: l_count := l_count+1;
913:
914: ad_ddl.build_package('BEGIN ', l_count);
915: l_count := l_count+1;
916:
917: ad_ddl.build_package('sql_stmt := '' ', l_count);
918: l_count := l_count+1;

Line 917: ad_ddl.build_package('sql_stmt := '' ', l_count);

913:
914: ad_ddl.build_package('BEGIN ', l_count);
915: l_count := l_count+1;
916:
917: ad_ddl.build_package('sql_stmt := '' ', l_count);
918: l_count := l_count+1;
919:
920: -- Parse the global variable to concatenate
921: -- all the mounted pieces of the query

Line 925: ad_ddl.build_package(TO_CHAR(g_build_package_tbl(j)), l_count);

921: -- all the mounted pieces of the query
922: IF NVL(g_build_package_tbl.COUNT,0) > 0 THEN
923: FOR j IN 1 .. g_build_package_tbl.COUNT
924: LOOP
925: ad_ddl.build_package(TO_CHAR(g_build_package_tbl(j)), l_count);
926: l_count := l_count+1;
927: END LOOP;
928:
929: ad_ddl.build_package('''; ', l_count);

Line 929: ad_ddl.build_package('''; ', l_count);

925: ad_ddl.build_package(TO_CHAR(g_build_package_tbl(j)), l_count);
926: l_count := l_count+1;
927: END LOOP;
928:
929: ad_ddl.build_package('''; ', l_count);
930: END IF;
931:
932: l_count := l_count+1;
933:

Line 934: ad_ddl.build_package('EXECUTE IMMEDIATE sql_stmt INTO l_count USING ' || l_using_param || ';', l_count);

930: END IF;
931:
932: l_count := l_count+1;
933:
934: ad_ddl.build_package('EXECUTE IMMEDIATE sql_stmt INTO l_count USING ' || l_using_param || ';', l_count);
935: l_count := l_count+1;
936:
937: ad_ddl.build_package(' IF NVL(l_count,0) > 0 THEN ', l_count);
938: l_count := l_count+1;

Line 937: ad_ddl.build_package(' IF NVL(l_count,0) > 0 THEN ', l_count);

933:
934: ad_ddl.build_package('EXECUTE IMMEDIATE sql_stmt INTO l_count USING ' || l_using_param || ';', l_count);
935: l_count := l_count+1;
936:
937: ad_ddl.build_package(' IF NVL(l_count,0) > 0 THEN ', l_count);
938: l_count := l_count+1;
939: ad_ddl.build_package(' l_complete_ship := ''N''; ', l_count);
940: l_count := l_count+1;
941: ad_ddl.build_package(' END IF; ', l_count);

Line 939: ad_ddl.build_package(' l_complete_ship := ''N''; ', l_count);

935: l_count := l_count+1;
936:
937: ad_ddl.build_package(' IF NVL(l_count,0) > 0 THEN ', l_count);
938: l_count := l_count+1;
939: ad_ddl.build_package(' l_complete_ship := ''N''; ', l_count);
940: l_count := l_count+1;
941: ad_ddl.build_package(' END IF; ', l_count);
942: l_count := l_count+1;
943: ad_ddl.build_package('RETURN l_complete_ship; ', l_count);

Line 941: ad_ddl.build_package(' END IF; ', l_count);

937: ad_ddl.build_package(' IF NVL(l_count,0) > 0 THEN ', l_count);
938: l_count := l_count+1;
939: ad_ddl.build_package(' l_complete_ship := ''N''; ', l_count);
940: l_count := l_count+1;
941: ad_ddl.build_package(' END IF; ', l_count);
942: l_count := l_count+1;
943: ad_ddl.build_package('RETURN l_complete_ship; ', l_count);
944: l_count := l_count+1;
945: ad_ddl.build_package('END Get_Value; ', l_count);

Line 943: ad_ddl.build_package('RETURN l_complete_ship; ', l_count);

939: ad_ddl.build_package(' l_complete_ship := ''N''; ', l_count);
940: l_count := l_count+1;
941: ad_ddl.build_package(' END IF; ', l_count);
942: l_count := l_count+1;
943: ad_ddl.build_package('RETURN l_complete_ship; ', l_count);
944: l_count := l_count+1;
945: ad_ddl.build_package('END Get_Value; ', l_count);
946: END IF;
947:

Line 945: ad_ddl.build_package('END Get_Value; ', l_count);

941: ad_ddl.build_package(' END IF; ', l_count);
942: l_count := l_count+1;
943: ad_ddl.build_package('RETURN l_complete_ship; ', l_count);
944: l_count := l_count+1;
945: ad_ddl.build_package('END Get_Value; ', l_count);
946: END IF;
947:
948: l_count := l_count+1;
949: ad_ddl.build_package('END ' || l_package_name || '; ', l_count);

Line 949: ad_ddl.build_package('END ' || l_package_name || '; ', l_count);

945: ad_ddl.build_package('END Get_Value; ', l_count);
946: END IF;
947:
948: l_count := l_count+1;
949: ad_ddl.build_package('END ' || l_package_name || '; ', l_count);
950: ad_ddl.create_package(l_applsys_schema, 'INL', l_package_name, 'TRUE', 1, l_count);
951:
952: -- Check status, return error if the package that was created is invalid
953: OPEN c_package_body_status(l_package_name);

Line 950: ad_ddl.create_package(l_applsys_schema, 'INL', l_package_name, 'TRUE', 1, l_count);

946: END IF;
947:
948: l_count := l_count+1;
949: ad_ddl.build_package('END ' || l_package_name || '; ', l_count);
950: ad_ddl.create_package(l_applsys_schema, 'INL', l_package_name, 'TRUE', 1, l_count);
951:
952: -- Check status, return error if the package that was created is invalid
953: OPEN c_package_body_status(l_package_name);
954: FETCH c_package_body_status INTO l_error;