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.JTF_TASK_RESOURCES_PVT dependencies on DBMS_SQL

Line 841: v_cursor_id := dbms_sql.open_cursor;

837: create_sql_statement;
838:
839: dump_long_line('v_sel:',v_select);
840:
841: v_cursor_id := dbms_sql.open_cursor;
842:
843: dbms_sql.parse(v_cursor_id, v_select, dbms_sql.v7);
844:
845: -- bind variables only if they added to the sql statement

Line 843: dbms_sql.parse(v_cursor_id, v_select, dbms_sql.v7);

839: dump_long_line('v_sel:',v_select);
840:
841: v_cursor_id := dbms_sql.open_cursor;
842:
843: dbms_sql.parse(v_cursor_id, v_select, dbms_sql.v7);
844:
845: -- bind variables only if they added to the sql statement
846: if (P_RESOURCE_REQ_ID is not null) then
847: dbms_sql.bind_variable(v_cursor_id, ':b1', p_resource_req_id);

Line 847: dbms_sql.bind_variable(v_cursor_id, ':b1', p_resource_req_id);

843: dbms_sql.parse(v_cursor_id, v_select, dbms_sql.v7);
844:
845: -- bind variables only if they added to the sql statement
846: if (P_RESOURCE_REQ_ID is not null) then
847: dbms_sql.bind_variable(v_cursor_id, ':b1', p_resource_req_id);
848: end if;
849:
850: if (P_TASK_TYPE_ID is not null) then
851: dbms_sql.bind_variable(v_cursor_id, ':b2', p_task_type_id);

Line 851: dbms_sql.bind_variable(v_cursor_id, ':b2', p_task_type_id);

847: dbms_sql.bind_variable(v_cursor_id, ':b1', p_resource_req_id);
848: end if;
849:
850: if (P_TASK_TYPE_ID is not null) then
851: dbms_sql.bind_variable(v_cursor_id, ':b2', p_task_type_id);
852: end if;
853:
854: if (P_TASK_ID is not null) then
855: dbms_sql.bind_variable(v_cursor_id, ':b3', p_task_id);

Line 855: dbms_sql.bind_variable(v_cursor_id, ':b3', p_task_id);

851: dbms_sql.bind_variable(v_cursor_id, ':b2', p_task_type_id);
852: end if;
853:
854: if (P_TASK_ID is not null) then
855: dbms_sql.bind_variable(v_cursor_id, ':b3', p_task_id);
856: end if;
857:
858: if (P_TASK_TEMPLATE_ID is not null) then
859: dbms_sql.bind_variable(v_cursor_id, ':b4', p_task_template_id);

Line 859: dbms_sql.bind_variable(v_cursor_id, ':b4', p_task_template_id);

855: dbms_sql.bind_variable(v_cursor_id, ':b3', p_task_id);
856: end if;
857:
858: if (P_TASK_TEMPLATE_ID is not null) then
859: dbms_sql.bind_variable(v_cursor_id, ':b4', p_task_template_id);
860: end if;
861:
862: if (P_RESOURCE_TYPE_CODE is not null) then
863: dbms_sql.bind_variable(v_cursor_id, ':b5', p_resource_type_code);

Line 863: dbms_sql.bind_variable(v_cursor_id, ':b5', p_resource_type_code);

859: dbms_sql.bind_variable(v_cursor_id, ':b4', p_task_template_id);
860: end if;
861:
862: if (P_RESOURCE_TYPE_CODE is not null) then
863: dbms_sql.bind_variable(v_cursor_id, ':b5', p_resource_type_code);
864:
865: end if;
866:
867: if (P_REQUIRED_UNITS is not null) then

Line 868: dbms_sql.bind_variable(v_cursor_id, ':b6', p_required_units);

864:
865: end if;
866:
867: if (P_REQUIRED_UNITS is not null) then
868: dbms_sql.bind_variable(v_cursor_id, ':b6', p_required_units);
869: end if;
870:
871: if (P_ENABLED_FLAG is not null) then
872: dbms_sql.bind_variable(v_cursor_id, ':b7',p_enabled_flag );

Line 872: dbms_sql.bind_variable(v_cursor_id, ':b7',p_enabled_flag );

868: dbms_sql.bind_variable(v_cursor_id, ':b6', p_required_units);
869: end if;
870:
871: if (P_ENABLED_FLAG is not null) then
872: dbms_sql.bind_variable(v_cursor_id, ':b7',p_enabled_flag );
873: end if;
874:
875: -- define the output columns
876: dbms_sql.define_column(v_cursor_id, 1, v_type.RESOURCE_REQ_ID );

Line 876: dbms_sql.define_column(v_cursor_id, 1, v_type.RESOURCE_REQ_ID );

872: dbms_sql.bind_variable(v_cursor_id, ':b7',p_enabled_flag );
873: end if;
874:
875: -- define the output columns
876: dbms_sql.define_column(v_cursor_id, 1, v_type.RESOURCE_REQ_ID );
877:
878:
879: dbms_sql.define_column(v_cursor_id, 2, v_type.TASK_TYPE_ID );
880:

Line 879: dbms_sql.define_column(v_cursor_id, 2, v_type.TASK_TYPE_ID );

875: -- define the output columns
876: dbms_sql.define_column(v_cursor_id, 1, v_type.RESOURCE_REQ_ID );
877:
878:
879: dbms_sql.define_column(v_cursor_id, 2, v_type.TASK_TYPE_ID );
880:
881: dbms_sql.define_column(v_cursor_id, 3, v_type.TASK_ID );
882:
883: dbms_sql.define_column(v_cursor_id, 4, v_type.TASK_TEMPLATE_ID );

Line 881: dbms_sql.define_column(v_cursor_id, 3, v_type.TASK_ID );

877:
878:
879: dbms_sql.define_column(v_cursor_id, 2, v_type.TASK_TYPE_ID );
880:
881: dbms_sql.define_column(v_cursor_id, 3, v_type.TASK_ID );
882:
883: dbms_sql.define_column(v_cursor_id, 4, v_type.TASK_TEMPLATE_ID );
884:
885: dbms_sql.define_column(v_cursor_id, 5, v_type.RESOURCE_TYPE_CODE , 30);

Line 883: dbms_sql.define_column(v_cursor_id, 4, v_type.TASK_TEMPLATE_ID );

879: dbms_sql.define_column(v_cursor_id, 2, v_type.TASK_TYPE_ID );
880:
881: dbms_sql.define_column(v_cursor_id, 3, v_type.TASK_ID );
882:
883: dbms_sql.define_column(v_cursor_id, 4, v_type.TASK_TEMPLATE_ID );
884:
885: dbms_sql.define_column(v_cursor_id, 5, v_type.RESOURCE_TYPE_CODE , 30);
886:
887: dbms_sql.define_column(v_cursor_id, 6, v_type.REQUIRED_UNITS );

Line 885: dbms_sql.define_column(v_cursor_id, 5, v_type.RESOURCE_TYPE_CODE , 30);

881: dbms_sql.define_column(v_cursor_id, 3, v_type.TASK_ID );
882:
883: dbms_sql.define_column(v_cursor_id, 4, v_type.TASK_TEMPLATE_ID );
884:
885: dbms_sql.define_column(v_cursor_id, 5, v_type.RESOURCE_TYPE_CODE , 30);
886:
887: dbms_sql.define_column(v_cursor_id, 6, v_type.REQUIRED_UNITS );
888:
889: dbms_sql.define_column(v_cursor_id, 7, v_type.ENABLED_FLAG, 1 );

Line 887: dbms_sql.define_column(v_cursor_id, 6, v_type.REQUIRED_UNITS );

883: dbms_sql.define_column(v_cursor_id, 4, v_type.TASK_TEMPLATE_ID );
884:
885: dbms_sql.define_column(v_cursor_id, 5, v_type.RESOURCE_TYPE_CODE , 30);
886:
887: dbms_sql.define_column(v_cursor_id, 6, v_type.REQUIRED_UNITS );
888:
889: dbms_sql.define_column(v_cursor_id, 7, v_type.ENABLED_FLAG, 1 );
890:
891: dbms_sql.define_column(v_cursor_id, 8, v_type.ATTRIBUTE1, 150);

Line 889: dbms_sql.define_column(v_cursor_id, 7, v_type.ENABLED_FLAG, 1 );

885: dbms_sql.define_column(v_cursor_id, 5, v_type.RESOURCE_TYPE_CODE , 30);
886:
887: dbms_sql.define_column(v_cursor_id, 6, v_type.REQUIRED_UNITS );
888:
889: dbms_sql.define_column(v_cursor_id, 7, v_type.ENABLED_FLAG, 1 );
890:
891: dbms_sql.define_column(v_cursor_id, 8, v_type.ATTRIBUTE1, 150);
892:
893: dbms_sql.define_column(v_cursor_id, 9, v_type.ATTRIBUTE2, 150);

Line 891: dbms_sql.define_column(v_cursor_id, 8, v_type.ATTRIBUTE1, 150);

887: dbms_sql.define_column(v_cursor_id, 6, v_type.REQUIRED_UNITS );
888:
889: dbms_sql.define_column(v_cursor_id, 7, v_type.ENABLED_FLAG, 1 );
890:
891: dbms_sql.define_column(v_cursor_id, 8, v_type.ATTRIBUTE1, 150);
892:
893: dbms_sql.define_column(v_cursor_id, 9, v_type.ATTRIBUTE2, 150);
894:
895: dbms_sql.define_column(v_cursor_id, 10, v_type.ATTRIBUTE3, 150);

Line 893: dbms_sql.define_column(v_cursor_id, 9, v_type.ATTRIBUTE2, 150);

889: dbms_sql.define_column(v_cursor_id, 7, v_type.ENABLED_FLAG, 1 );
890:
891: dbms_sql.define_column(v_cursor_id, 8, v_type.ATTRIBUTE1, 150);
892:
893: dbms_sql.define_column(v_cursor_id, 9, v_type.ATTRIBUTE2, 150);
894:
895: dbms_sql.define_column(v_cursor_id, 10, v_type.ATTRIBUTE3, 150);
896:
897: dbms_sql.define_column(v_cursor_id, 11, v_type.ATTRIBUTE4, 150);

Line 895: dbms_sql.define_column(v_cursor_id, 10, v_type.ATTRIBUTE3, 150);

891: dbms_sql.define_column(v_cursor_id, 8, v_type.ATTRIBUTE1, 150);
892:
893: dbms_sql.define_column(v_cursor_id, 9, v_type.ATTRIBUTE2, 150);
894:
895: dbms_sql.define_column(v_cursor_id, 10, v_type.ATTRIBUTE3, 150);
896:
897: dbms_sql.define_column(v_cursor_id, 11, v_type.ATTRIBUTE4, 150);
898:
899: dbms_sql.define_column(v_cursor_id, 12, v_type.ATTRIBUTE5, 150);

Line 897: dbms_sql.define_column(v_cursor_id, 11, v_type.ATTRIBUTE4, 150);

893: dbms_sql.define_column(v_cursor_id, 9, v_type.ATTRIBUTE2, 150);
894:
895: dbms_sql.define_column(v_cursor_id, 10, v_type.ATTRIBUTE3, 150);
896:
897: dbms_sql.define_column(v_cursor_id, 11, v_type.ATTRIBUTE4, 150);
898:
899: dbms_sql.define_column(v_cursor_id, 12, v_type.ATTRIBUTE5, 150);
900:
901: dbms_sql.define_column(v_cursor_id, 13, v_type.ATTRIBUTE6, 150);

Line 899: dbms_sql.define_column(v_cursor_id, 12, v_type.ATTRIBUTE5, 150);

895: dbms_sql.define_column(v_cursor_id, 10, v_type.ATTRIBUTE3, 150);
896:
897: dbms_sql.define_column(v_cursor_id, 11, v_type.ATTRIBUTE4, 150);
898:
899: dbms_sql.define_column(v_cursor_id, 12, v_type.ATTRIBUTE5, 150);
900:
901: dbms_sql.define_column(v_cursor_id, 13, v_type.ATTRIBUTE6, 150);
902:
903: dbms_sql.define_column(v_cursor_id, 14, v_type.ATTRIBUTE7, 150);

Line 901: dbms_sql.define_column(v_cursor_id, 13, v_type.ATTRIBUTE6, 150);

897: dbms_sql.define_column(v_cursor_id, 11, v_type.ATTRIBUTE4, 150);
898:
899: dbms_sql.define_column(v_cursor_id, 12, v_type.ATTRIBUTE5, 150);
900:
901: dbms_sql.define_column(v_cursor_id, 13, v_type.ATTRIBUTE6, 150);
902:
903: dbms_sql.define_column(v_cursor_id, 14, v_type.ATTRIBUTE7, 150);
904:
905: dbms_sql.define_column(v_cursor_id, 15, v_type.ATTRIBUTE8, 150);

Line 903: dbms_sql.define_column(v_cursor_id, 14, v_type.ATTRIBUTE7, 150);

899: dbms_sql.define_column(v_cursor_id, 12, v_type.ATTRIBUTE5, 150);
900:
901: dbms_sql.define_column(v_cursor_id, 13, v_type.ATTRIBUTE6, 150);
902:
903: dbms_sql.define_column(v_cursor_id, 14, v_type.ATTRIBUTE7, 150);
904:
905: dbms_sql.define_column(v_cursor_id, 15, v_type.ATTRIBUTE8, 150);
906:
907: dbms_sql.define_column(v_cursor_id, 16, v_type.ATTRIBUTE9, 150);

Line 905: dbms_sql.define_column(v_cursor_id, 15, v_type.ATTRIBUTE8, 150);

901: dbms_sql.define_column(v_cursor_id, 13, v_type.ATTRIBUTE6, 150);
902:
903: dbms_sql.define_column(v_cursor_id, 14, v_type.ATTRIBUTE7, 150);
904:
905: dbms_sql.define_column(v_cursor_id, 15, v_type.ATTRIBUTE8, 150);
906:
907: dbms_sql.define_column(v_cursor_id, 16, v_type.ATTRIBUTE9, 150);
908:
909: dbms_sql.define_column(v_cursor_id, 17, v_type.ATTRIBUTE10, 150);

Line 907: dbms_sql.define_column(v_cursor_id, 16, v_type.ATTRIBUTE9, 150);

903: dbms_sql.define_column(v_cursor_id, 14, v_type.ATTRIBUTE7, 150);
904:
905: dbms_sql.define_column(v_cursor_id, 15, v_type.ATTRIBUTE8, 150);
906:
907: dbms_sql.define_column(v_cursor_id, 16, v_type.ATTRIBUTE9, 150);
908:
909: dbms_sql.define_column(v_cursor_id, 17, v_type.ATTRIBUTE10, 150);
910:
911: dbms_sql.define_column(v_cursor_id, 18, v_type.ATTRIBUTE11, 150);

Line 909: dbms_sql.define_column(v_cursor_id, 17, v_type.ATTRIBUTE10, 150);

905: dbms_sql.define_column(v_cursor_id, 15, v_type.ATTRIBUTE8, 150);
906:
907: dbms_sql.define_column(v_cursor_id, 16, v_type.ATTRIBUTE9, 150);
908:
909: dbms_sql.define_column(v_cursor_id, 17, v_type.ATTRIBUTE10, 150);
910:
911: dbms_sql.define_column(v_cursor_id, 18, v_type.ATTRIBUTE11, 150);
912:
913: dbms_sql.define_column(v_cursor_id, 19, v_type.ATTRIBUTE12, 150);

Line 911: dbms_sql.define_column(v_cursor_id, 18, v_type.ATTRIBUTE11, 150);

907: dbms_sql.define_column(v_cursor_id, 16, v_type.ATTRIBUTE9, 150);
908:
909: dbms_sql.define_column(v_cursor_id, 17, v_type.ATTRIBUTE10, 150);
910:
911: dbms_sql.define_column(v_cursor_id, 18, v_type.ATTRIBUTE11, 150);
912:
913: dbms_sql.define_column(v_cursor_id, 19, v_type.ATTRIBUTE12, 150);
914:
915:

Line 913: dbms_sql.define_column(v_cursor_id, 19, v_type.ATTRIBUTE12, 150);

909: dbms_sql.define_column(v_cursor_id, 17, v_type.ATTRIBUTE10, 150);
910:
911: dbms_sql.define_column(v_cursor_id, 18, v_type.ATTRIBUTE11, 150);
912:
913: dbms_sql.define_column(v_cursor_id, 19, v_type.ATTRIBUTE12, 150);
914:
915:
916: dbms_sql.define_column(v_cursor_id, 20, v_type.ATTRIBUTE13, 150);
917:

Line 916: dbms_sql.define_column(v_cursor_id, 20, v_type.ATTRIBUTE13, 150);

912:
913: dbms_sql.define_column(v_cursor_id, 19, v_type.ATTRIBUTE12, 150);
914:
915:
916: dbms_sql.define_column(v_cursor_id, 20, v_type.ATTRIBUTE13, 150);
917:
918: dbms_sql.define_column(v_cursor_id, 21, v_type.ATTRIBUTE14, 150);
919:
920: dbms_sql.define_column(v_cursor_id, 22, v_type.ATTRIBUTE15, 150);

Line 918: dbms_sql.define_column(v_cursor_id, 21, v_type.ATTRIBUTE14, 150);

914:
915:
916: dbms_sql.define_column(v_cursor_id, 20, v_type.ATTRIBUTE13, 150);
917:
918: dbms_sql.define_column(v_cursor_id, 21, v_type.ATTRIBUTE14, 150);
919:
920: dbms_sql.define_column(v_cursor_id, 22, v_type.ATTRIBUTE15, 150);
921:
922: dbms_sql.define_column(v_cursor_id, 23, v_type.ATTRIBUTE_CATEGORY, 30);

Line 920: dbms_sql.define_column(v_cursor_id, 22, v_type.ATTRIBUTE15, 150);

916: dbms_sql.define_column(v_cursor_id, 20, v_type.ATTRIBUTE13, 150);
917:
918: dbms_sql.define_column(v_cursor_id, 21, v_type.ATTRIBUTE14, 150);
919:
920: dbms_sql.define_column(v_cursor_id, 22, v_type.ATTRIBUTE15, 150);
921:
922: dbms_sql.define_column(v_cursor_id, 23, v_type.ATTRIBUTE_CATEGORY, 30);
923:
924:

Line 922: dbms_sql.define_column(v_cursor_id, 23, v_type.ATTRIBUTE_CATEGORY, 30);

918: dbms_sql.define_column(v_cursor_id, 21, v_type.ATTRIBUTE14, 150);
919:
920: dbms_sql.define_column(v_cursor_id, 22, v_type.ATTRIBUTE15, 150);
921:
922: dbms_sql.define_column(v_cursor_id, 23, v_type.ATTRIBUTE_CATEGORY, 30);
923:
924:
925:
926: v_dummy := dbms_sql.execute(v_cursor_id);

Line 926: v_dummy := dbms_sql.execute(v_cursor_id);

922: dbms_sql.define_column(v_cursor_id, 23, v_type.ATTRIBUTE_CATEGORY, 30);
923:
924:
925:
926: v_dummy := dbms_sql.execute(v_cursor_id);
927:
928:
929:
930: v_cnt := 0;

Line 934: exit when (dbms_sql.fetch_rows(v_cursor_id) = 0);

930: v_cnt := 0;
931:
932: loop
933:
934: exit when (dbms_sql.fetch_rows(v_cursor_id) = 0);
935:
936: v_cnt := v_cnt + 1;
937:
938: -- retrieve the rows from the buffer

Line 940: dbms_sql.column_value(v_cursor_id, 1, v_type.RESOURCE_REQ_ID);

936: v_cnt := v_cnt + 1;
937:
938: -- retrieve the rows from the buffer
939:
940: dbms_sql.column_value(v_cursor_id, 1, v_type.RESOURCE_REQ_ID);
941: dbms_sql.column_value(v_cursor_id, 2, v_type.TASK_TYPE_ID);
942: dbms_sql.column_value(v_cursor_id, 3, v_type.TASK_ID);
943: dbms_sql.column_value(v_cursor_id, 4, v_type.TASK_TEMPLATE_ID);
944: dbms_sql.column_value(v_cursor_id, 5, v_type.RESOURCE_TYPE_CODE);

Line 941: dbms_sql.column_value(v_cursor_id, 2, v_type.TASK_TYPE_ID);

937:
938: -- retrieve the rows from the buffer
939:
940: dbms_sql.column_value(v_cursor_id, 1, v_type.RESOURCE_REQ_ID);
941: dbms_sql.column_value(v_cursor_id, 2, v_type.TASK_TYPE_ID);
942: dbms_sql.column_value(v_cursor_id, 3, v_type.TASK_ID);
943: dbms_sql.column_value(v_cursor_id, 4, v_type.TASK_TEMPLATE_ID);
944: dbms_sql.column_value(v_cursor_id, 5, v_type.RESOURCE_TYPE_CODE);
945: dbms_sql.column_value(v_cursor_id, 6, v_type.REQUIRED_UNITS);

Line 942: dbms_sql.column_value(v_cursor_id, 3, v_type.TASK_ID);

938: -- retrieve the rows from the buffer
939:
940: dbms_sql.column_value(v_cursor_id, 1, v_type.RESOURCE_REQ_ID);
941: dbms_sql.column_value(v_cursor_id, 2, v_type.TASK_TYPE_ID);
942: dbms_sql.column_value(v_cursor_id, 3, v_type.TASK_ID);
943: dbms_sql.column_value(v_cursor_id, 4, v_type.TASK_TEMPLATE_ID);
944: dbms_sql.column_value(v_cursor_id, 5, v_type.RESOURCE_TYPE_CODE);
945: dbms_sql.column_value(v_cursor_id, 6, v_type.REQUIRED_UNITS);
946: dbms_sql.column_value(v_cursor_id, 7, v_type.ENABLED_FLAG);

Line 943: dbms_sql.column_value(v_cursor_id, 4, v_type.TASK_TEMPLATE_ID);

939:
940: dbms_sql.column_value(v_cursor_id, 1, v_type.RESOURCE_REQ_ID);
941: dbms_sql.column_value(v_cursor_id, 2, v_type.TASK_TYPE_ID);
942: dbms_sql.column_value(v_cursor_id, 3, v_type.TASK_ID);
943: dbms_sql.column_value(v_cursor_id, 4, v_type.TASK_TEMPLATE_ID);
944: dbms_sql.column_value(v_cursor_id, 5, v_type.RESOURCE_TYPE_CODE);
945: dbms_sql.column_value(v_cursor_id, 6, v_type.REQUIRED_UNITS);
946: dbms_sql.column_value(v_cursor_id, 7, v_type.ENABLED_FLAG);
947: dbms_sql.column_value(v_cursor_id, 8, v_type.ATTRIBUTE1);

Line 944: dbms_sql.column_value(v_cursor_id, 5, v_type.RESOURCE_TYPE_CODE);

940: dbms_sql.column_value(v_cursor_id, 1, v_type.RESOURCE_REQ_ID);
941: dbms_sql.column_value(v_cursor_id, 2, v_type.TASK_TYPE_ID);
942: dbms_sql.column_value(v_cursor_id, 3, v_type.TASK_ID);
943: dbms_sql.column_value(v_cursor_id, 4, v_type.TASK_TEMPLATE_ID);
944: dbms_sql.column_value(v_cursor_id, 5, v_type.RESOURCE_TYPE_CODE);
945: dbms_sql.column_value(v_cursor_id, 6, v_type.REQUIRED_UNITS);
946: dbms_sql.column_value(v_cursor_id, 7, v_type.ENABLED_FLAG);
947: dbms_sql.column_value(v_cursor_id, 8, v_type.ATTRIBUTE1);
948: dbms_sql.column_value(v_cursor_id, 9, v_type.ATTRIBUTE2);

Line 945: dbms_sql.column_value(v_cursor_id, 6, v_type.REQUIRED_UNITS);

941: dbms_sql.column_value(v_cursor_id, 2, v_type.TASK_TYPE_ID);
942: dbms_sql.column_value(v_cursor_id, 3, v_type.TASK_ID);
943: dbms_sql.column_value(v_cursor_id, 4, v_type.TASK_TEMPLATE_ID);
944: dbms_sql.column_value(v_cursor_id, 5, v_type.RESOURCE_TYPE_CODE);
945: dbms_sql.column_value(v_cursor_id, 6, v_type.REQUIRED_UNITS);
946: dbms_sql.column_value(v_cursor_id, 7, v_type.ENABLED_FLAG);
947: dbms_sql.column_value(v_cursor_id, 8, v_type.ATTRIBUTE1);
948: dbms_sql.column_value(v_cursor_id, 9, v_type.ATTRIBUTE2);
949: dbms_sql.column_value(v_cursor_id, 10, v_type.ATTRIBUTE3);

Line 946: dbms_sql.column_value(v_cursor_id, 7, v_type.ENABLED_FLAG);

942: dbms_sql.column_value(v_cursor_id, 3, v_type.TASK_ID);
943: dbms_sql.column_value(v_cursor_id, 4, v_type.TASK_TEMPLATE_ID);
944: dbms_sql.column_value(v_cursor_id, 5, v_type.RESOURCE_TYPE_CODE);
945: dbms_sql.column_value(v_cursor_id, 6, v_type.REQUIRED_UNITS);
946: dbms_sql.column_value(v_cursor_id, 7, v_type.ENABLED_FLAG);
947: dbms_sql.column_value(v_cursor_id, 8, v_type.ATTRIBUTE1);
948: dbms_sql.column_value(v_cursor_id, 9, v_type.ATTRIBUTE2);
949: dbms_sql.column_value(v_cursor_id, 10, v_type.ATTRIBUTE3);
950: dbms_sql.column_value(v_cursor_id, 11, v_type.ATTRIBUTE4);

Line 947: dbms_sql.column_value(v_cursor_id, 8, v_type.ATTRIBUTE1);

943: dbms_sql.column_value(v_cursor_id, 4, v_type.TASK_TEMPLATE_ID);
944: dbms_sql.column_value(v_cursor_id, 5, v_type.RESOURCE_TYPE_CODE);
945: dbms_sql.column_value(v_cursor_id, 6, v_type.REQUIRED_UNITS);
946: dbms_sql.column_value(v_cursor_id, 7, v_type.ENABLED_FLAG);
947: dbms_sql.column_value(v_cursor_id, 8, v_type.ATTRIBUTE1);
948: dbms_sql.column_value(v_cursor_id, 9, v_type.ATTRIBUTE2);
949: dbms_sql.column_value(v_cursor_id, 10, v_type.ATTRIBUTE3);
950: dbms_sql.column_value(v_cursor_id, 11, v_type.ATTRIBUTE4);
951: dbms_sql.column_value(v_cursor_id, 12, v_type.ATTRIBUTE5);

Line 948: dbms_sql.column_value(v_cursor_id, 9, v_type.ATTRIBUTE2);

944: dbms_sql.column_value(v_cursor_id, 5, v_type.RESOURCE_TYPE_CODE);
945: dbms_sql.column_value(v_cursor_id, 6, v_type.REQUIRED_UNITS);
946: dbms_sql.column_value(v_cursor_id, 7, v_type.ENABLED_FLAG);
947: dbms_sql.column_value(v_cursor_id, 8, v_type.ATTRIBUTE1);
948: dbms_sql.column_value(v_cursor_id, 9, v_type.ATTRIBUTE2);
949: dbms_sql.column_value(v_cursor_id, 10, v_type.ATTRIBUTE3);
950: dbms_sql.column_value(v_cursor_id, 11, v_type.ATTRIBUTE4);
951: dbms_sql.column_value(v_cursor_id, 12, v_type.ATTRIBUTE5);
952: dbms_sql.column_value(v_cursor_id, 13, v_type.ATTRIBUTE6);

Line 949: dbms_sql.column_value(v_cursor_id, 10, v_type.ATTRIBUTE3);

945: dbms_sql.column_value(v_cursor_id, 6, v_type.REQUIRED_UNITS);
946: dbms_sql.column_value(v_cursor_id, 7, v_type.ENABLED_FLAG);
947: dbms_sql.column_value(v_cursor_id, 8, v_type.ATTRIBUTE1);
948: dbms_sql.column_value(v_cursor_id, 9, v_type.ATTRIBUTE2);
949: dbms_sql.column_value(v_cursor_id, 10, v_type.ATTRIBUTE3);
950: dbms_sql.column_value(v_cursor_id, 11, v_type.ATTRIBUTE4);
951: dbms_sql.column_value(v_cursor_id, 12, v_type.ATTRIBUTE5);
952: dbms_sql.column_value(v_cursor_id, 13, v_type.ATTRIBUTE6);
953: dbms_sql.column_value(v_cursor_id, 14, v_type.ATTRIBUTE7);

Line 950: dbms_sql.column_value(v_cursor_id, 11, v_type.ATTRIBUTE4);

946: dbms_sql.column_value(v_cursor_id, 7, v_type.ENABLED_FLAG);
947: dbms_sql.column_value(v_cursor_id, 8, v_type.ATTRIBUTE1);
948: dbms_sql.column_value(v_cursor_id, 9, v_type.ATTRIBUTE2);
949: dbms_sql.column_value(v_cursor_id, 10, v_type.ATTRIBUTE3);
950: dbms_sql.column_value(v_cursor_id, 11, v_type.ATTRIBUTE4);
951: dbms_sql.column_value(v_cursor_id, 12, v_type.ATTRIBUTE5);
952: dbms_sql.column_value(v_cursor_id, 13, v_type.ATTRIBUTE6);
953: dbms_sql.column_value(v_cursor_id, 14, v_type.ATTRIBUTE7);
954:

Line 951: dbms_sql.column_value(v_cursor_id, 12, v_type.ATTRIBUTE5);

947: dbms_sql.column_value(v_cursor_id, 8, v_type.ATTRIBUTE1);
948: dbms_sql.column_value(v_cursor_id, 9, v_type.ATTRIBUTE2);
949: dbms_sql.column_value(v_cursor_id, 10, v_type.ATTRIBUTE3);
950: dbms_sql.column_value(v_cursor_id, 11, v_type.ATTRIBUTE4);
951: dbms_sql.column_value(v_cursor_id, 12, v_type.ATTRIBUTE5);
952: dbms_sql.column_value(v_cursor_id, 13, v_type.ATTRIBUTE6);
953: dbms_sql.column_value(v_cursor_id, 14, v_type.ATTRIBUTE7);
954:
955: dbms_sql.column_value(v_cursor_id, 15, v_type.ATTRIBUTE8);

Line 952: dbms_sql.column_value(v_cursor_id, 13, v_type.ATTRIBUTE6);

948: dbms_sql.column_value(v_cursor_id, 9, v_type.ATTRIBUTE2);
949: dbms_sql.column_value(v_cursor_id, 10, v_type.ATTRIBUTE3);
950: dbms_sql.column_value(v_cursor_id, 11, v_type.ATTRIBUTE4);
951: dbms_sql.column_value(v_cursor_id, 12, v_type.ATTRIBUTE5);
952: dbms_sql.column_value(v_cursor_id, 13, v_type.ATTRIBUTE6);
953: dbms_sql.column_value(v_cursor_id, 14, v_type.ATTRIBUTE7);
954:
955: dbms_sql.column_value(v_cursor_id, 15, v_type.ATTRIBUTE8);
956: dbms_sql.column_value(v_cursor_id, 16, v_type.ATTRIBUTE9);

Line 953: dbms_sql.column_value(v_cursor_id, 14, v_type.ATTRIBUTE7);

949: dbms_sql.column_value(v_cursor_id, 10, v_type.ATTRIBUTE3);
950: dbms_sql.column_value(v_cursor_id, 11, v_type.ATTRIBUTE4);
951: dbms_sql.column_value(v_cursor_id, 12, v_type.ATTRIBUTE5);
952: dbms_sql.column_value(v_cursor_id, 13, v_type.ATTRIBUTE6);
953: dbms_sql.column_value(v_cursor_id, 14, v_type.ATTRIBUTE7);
954:
955: dbms_sql.column_value(v_cursor_id, 15, v_type.ATTRIBUTE8);
956: dbms_sql.column_value(v_cursor_id, 16, v_type.ATTRIBUTE9);
957: dbms_sql.column_value(v_cursor_id, 17, v_type.ATTRIBUTE10);

Line 955: dbms_sql.column_value(v_cursor_id, 15, v_type.ATTRIBUTE8);

951: dbms_sql.column_value(v_cursor_id, 12, v_type.ATTRIBUTE5);
952: dbms_sql.column_value(v_cursor_id, 13, v_type.ATTRIBUTE6);
953: dbms_sql.column_value(v_cursor_id, 14, v_type.ATTRIBUTE7);
954:
955: dbms_sql.column_value(v_cursor_id, 15, v_type.ATTRIBUTE8);
956: dbms_sql.column_value(v_cursor_id, 16, v_type.ATTRIBUTE9);
957: dbms_sql.column_value(v_cursor_id, 17, v_type.ATTRIBUTE10);
958: dbms_sql.column_value(v_cursor_id, 18, v_type.ATTRIBUTE11);
959: dbms_sql.column_value(v_cursor_id, 19, v_type.ATTRIBUTE12);

Line 956: dbms_sql.column_value(v_cursor_id, 16, v_type.ATTRIBUTE9);

952: dbms_sql.column_value(v_cursor_id, 13, v_type.ATTRIBUTE6);
953: dbms_sql.column_value(v_cursor_id, 14, v_type.ATTRIBUTE7);
954:
955: dbms_sql.column_value(v_cursor_id, 15, v_type.ATTRIBUTE8);
956: dbms_sql.column_value(v_cursor_id, 16, v_type.ATTRIBUTE9);
957: dbms_sql.column_value(v_cursor_id, 17, v_type.ATTRIBUTE10);
958: dbms_sql.column_value(v_cursor_id, 18, v_type.ATTRIBUTE11);
959: dbms_sql.column_value(v_cursor_id, 19, v_type.ATTRIBUTE12);
960: dbms_sql.column_value(v_cursor_id, 20, v_type.ATTRIBUTE13);

Line 957: dbms_sql.column_value(v_cursor_id, 17, v_type.ATTRIBUTE10);

953: dbms_sql.column_value(v_cursor_id, 14, v_type.ATTRIBUTE7);
954:
955: dbms_sql.column_value(v_cursor_id, 15, v_type.ATTRIBUTE8);
956: dbms_sql.column_value(v_cursor_id, 16, v_type.ATTRIBUTE9);
957: dbms_sql.column_value(v_cursor_id, 17, v_type.ATTRIBUTE10);
958: dbms_sql.column_value(v_cursor_id, 18, v_type.ATTRIBUTE11);
959: dbms_sql.column_value(v_cursor_id, 19, v_type.ATTRIBUTE12);
960: dbms_sql.column_value(v_cursor_id, 20, v_type.ATTRIBUTE13);
961: dbms_sql.column_value(v_cursor_id, 21, v_type.ATTRIBUTE14);

Line 958: dbms_sql.column_value(v_cursor_id, 18, v_type.ATTRIBUTE11);

954:
955: dbms_sql.column_value(v_cursor_id, 15, v_type.ATTRIBUTE8);
956: dbms_sql.column_value(v_cursor_id, 16, v_type.ATTRIBUTE9);
957: dbms_sql.column_value(v_cursor_id, 17, v_type.ATTRIBUTE10);
958: dbms_sql.column_value(v_cursor_id, 18, v_type.ATTRIBUTE11);
959: dbms_sql.column_value(v_cursor_id, 19, v_type.ATTRIBUTE12);
960: dbms_sql.column_value(v_cursor_id, 20, v_type.ATTRIBUTE13);
961: dbms_sql.column_value(v_cursor_id, 21, v_type.ATTRIBUTE14);
962: dbms_sql.column_value(v_cursor_id, 22, v_type.ATTRIBUTE15);

Line 959: dbms_sql.column_value(v_cursor_id, 19, v_type.ATTRIBUTE12);

955: dbms_sql.column_value(v_cursor_id, 15, v_type.ATTRIBUTE8);
956: dbms_sql.column_value(v_cursor_id, 16, v_type.ATTRIBUTE9);
957: dbms_sql.column_value(v_cursor_id, 17, v_type.ATTRIBUTE10);
958: dbms_sql.column_value(v_cursor_id, 18, v_type.ATTRIBUTE11);
959: dbms_sql.column_value(v_cursor_id, 19, v_type.ATTRIBUTE12);
960: dbms_sql.column_value(v_cursor_id, 20, v_type.ATTRIBUTE13);
961: dbms_sql.column_value(v_cursor_id, 21, v_type.ATTRIBUTE14);
962: dbms_sql.column_value(v_cursor_id, 22, v_type.ATTRIBUTE15);
963: dbms_sql.column_value(v_cursor_id, 23, v_type.ATTRIBUTE_CATEGORY);

Line 960: dbms_sql.column_value(v_cursor_id, 20, v_type.ATTRIBUTE13);

956: dbms_sql.column_value(v_cursor_id, 16, v_type.ATTRIBUTE9);
957: dbms_sql.column_value(v_cursor_id, 17, v_type.ATTRIBUTE10);
958: dbms_sql.column_value(v_cursor_id, 18, v_type.ATTRIBUTE11);
959: dbms_sql.column_value(v_cursor_id, 19, v_type.ATTRIBUTE12);
960: dbms_sql.column_value(v_cursor_id, 20, v_type.ATTRIBUTE13);
961: dbms_sql.column_value(v_cursor_id, 21, v_type.ATTRIBUTE14);
962: dbms_sql.column_value(v_cursor_id, 22, v_type.ATTRIBUTE15);
963: dbms_sql.column_value(v_cursor_id, 23, v_type.ATTRIBUTE_CATEGORY);
964:

Line 961: dbms_sql.column_value(v_cursor_id, 21, v_type.ATTRIBUTE14);

957: dbms_sql.column_value(v_cursor_id, 17, v_type.ATTRIBUTE10);
958: dbms_sql.column_value(v_cursor_id, 18, v_type.ATTRIBUTE11);
959: dbms_sql.column_value(v_cursor_id, 19, v_type.ATTRIBUTE12);
960: dbms_sql.column_value(v_cursor_id, 20, v_type.ATTRIBUTE13);
961: dbms_sql.column_value(v_cursor_id, 21, v_type.ATTRIBUTE14);
962: dbms_sql.column_value(v_cursor_id, 22, v_type.ATTRIBUTE15);
963: dbms_sql.column_value(v_cursor_id, 23, v_type.ATTRIBUTE_CATEGORY);
964:
965:

Line 962: dbms_sql.column_value(v_cursor_id, 22, v_type.ATTRIBUTE15);

958: dbms_sql.column_value(v_cursor_id, 18, v_type.ATTRIBUTE11);
959: dbms_sql.column_value(v_cursor_id, 19, v_type.ATTRIBUTE12);
960: dbms_sql.column_value(v_cursor_id, 20, v_type.ATTRIBUTE13);
961: dbms_sql.column_value(v_cursor_id, 21, v_type.ATTRIBUTE14);
962: dbms_sql.column_value(v_cursor_id, 22, v_type.ATTRIBUTE15);
963: dbms_sql.column_value(v_cursor_id, 23, v_type.ATTRIBUTE_CATEGORY);
964:
965:
966: -- 'v_type.resource_req_id:'||

Line 963: dbms_sql.column_value(v_cursor_id, 23, v_type.ATTRIBUTE_CATEGORY);

959: dbms_sql.column_value(v_cursor_id, 19, v_type.ATTRIBUTE12);
960: dbms_sql.column_value(v_cursor_id, 20, v_type.ATTRIBUTE13);
961: dbms_sql.column_value(v_cursor_id, 21, v_type.ATTRIBUTE14);
962: dbms_sql.column_value(v_cursor_id, 22, v_type.ATTRIBUTE15);
963: dbms_sql.column_value(v_cursor_id, 23, v_type.ATTRIBUTE_CATEGORY);
964:
965:
966: -- 'v_type.resource_req_id:'||
967: -- to_char(v_type.resource_req_id));

Line 974: dbms_sql.close_cursor(v_cursor_id);

970: v_tbl(v_cnt) := v_type;
971:
972: end loop;
973:
974: dbms_sql.close_cursor(v_cursor_id);
975:
976: end if;
977: --p_query_or_next_code;
978: