APPS.CSD_REPAIR_HISTORY_PVT dependencies on DBMS_SQL

Line 904: dbms_sql.define_column(p_cur_get_REPH, 1, P_REPH_Rec.REPAIR_HISTORY_ID);

900: -- Debug Message
901: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Define Columns Begins');
902:
903: -- define all columns for CSD_REPAIR_HISTORY_V view
904: dbms_sql.define_column(p_cur_get_REPH, 1, P_REPH_Rec.REPAIR_HISTORY_ID);
905: dbms_sql.define_column(p_cur_get_REPH, 2, P_REPH_Rec.REQUEST_ID);
906: dbms_sql.define_column(p_cur_get_REPH, 3, P_REPH_Rec.REPAIR_LINE_ID);
907: dbms_sql.define_column(p_cur_get_REPH, 4, P_REPH_Rec.EVENT_CODE, 30);
908: dbms_sql.define_column(p_cur_get_REPH, 5, P_REPH_Rec.EVENT_MEANING, 80);

Line 905: dbms_sql.define_column(p_cur_get_REPH, 2, P_REPH_Rec.REQUEST_ID);

901: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Define Columns Begins');
902:
903: -- define all columns for CSD_REPAIR_HISTORY_V view
904: dbms_sql.define_column(p_cur_get_REPH, 1, P_REPH_Rec.REPAIR_HISTORY_ID);
905: dbms_sql.define_column(p_cur_get_REPH, 2, P_REPH_Rec.REQUEST_ID);
906: dbms_sql.define_column(p_cur_get_REPH, 3, P_REPH_Rec.REPAIR_LINE_ID);
907: dbms_sql.define_column(p_cur_get_REPH, 4, P_REPH_Rec.EVENT_CODE, 30);
908: dbms_sql.define_column(p_cur_get_REPH, 5, P_REPH_Rec.EVENT_MEANING, 80);
909: dbms_sql.define_column(p_cur_get_REPH, 6, P_REPH_Rec.EVENT_DATE);

Line 906: dbms_sql.define_column(p_cur_get_REPH, 3, P_REPH_Rec.REPAIR_LINE_ID);

902:
903: -- define all columns for CSD_REPAIR_HISTORY_V view
904: dbms_sql.define_column(p_cur_get_REPH, 1, P_REPH_Rec.REPAIR_HISTORY_ID);
905: dbms_sql.define_column(p_cur_get_REPH, 2, P_REPH_Rec.REQUEST_ID);
906: dbms_sql.define_column(p_cur_get_REPH, 3, P_REPH_Rec.REPAIR_LINE_ID);
907: dbms_sql.define_column(p_cur_get_REPH, 4, P_REPH_Rec.EVENT_CODE, 30);
908: dbms_sql.define_column(p_cur_get_REPH, 5, P_REPH_Rec.EVENT_MEANING, 80);
909: dbms_sql.define_column(p_cur_get_REPH, 6, P_REPH_Rec.EVENT_DATE);
910: dbms_sql.define_column(p_cur_get_REPH, 7, P_REPH_Rec.QUANTITY);

Line 907: dbms_sql.define_column(p_cur_get_REPH, 4, P_REPH_Rec.EVENT_CODE, 30);

903: -- define all columns for CSD_REPAIR_HISTORY_V view
904: dbms_sql.define_column(p_cur_get_REPH, 1, P_REPH_Rec.REPAIR_HISTORY_ID);
905: dbms_sql.define_column(p_cur_get_REPH, 2, P_REPH_Rec.REQUEST_ID);
906: dbms_sql.define_column(p_cur_get_REPH, 3, P_REPH_Rec.REPAIR_LINE_ID);
907: dbms_sql.define_column(p_cur_get_REPH, 4, P_REPH_Rec.EVENT_CODE, 30);
908: dbms_sql.define_column(p_cur_get_REPH, 5, P_REPH_Rec.EVENT_MEANING, 80);
909: dbms_sql.define_column(p_cur_get_REPH, 6, P_REPH_Rec.EVENT_DATE);
910: dbms_sql.define_column(p_cur_get_REPH, 7, P_REPH_Rec.QUANTITY);
911: dbms_sql.define_column(p_cur_get_REPH, 8, P_REPH_Rec.PARAMN1);

Line 908: dbms_sql.define_column(p_cur_get_REPH, 5, P_REPH_Rec.EVENT_MEANING, 80);

904: dbms_sql.define_column(p_cur_get_REPH, 1, P_REPH_Rec.REPAIR_HISTORY_ID);
905: dbms_sql.define_column(p_cur_get_REPH, 2, P_REPH_Rec.REQUEST_ID);
906: dbms_sql.define_column(p_cur_get_REPH, 3, P_REPH_Rec.REPAIR_LINE_ID);
907: dbms_sql.define_column(p_cur_get_REPH, 4, P_REPH_Rec.EVENT_CODE, 30);
908: dbms_sql.define_column(p_cur_get_REPH, 5, P_REPH_Rec.EVENT_MEANING, 80);
909: dbms_sql.define_column(p_cur_get_REPH, 6, P_REPH_Rec.EVENT_DATE);
910: dbms_sql.define_column(p_cur_get_REPH, 7, P_REPH_Rec.QUANTITY);
911: dbms_sql.define_column(p_cur_get_REPH, 8, P_REPH_Rec.PARAMN1);
912: dbms_sql.define_column(p_cur_get_REPH, 9, P_REPH_Rec.PARAMN2);

Line 909: dbms_sql.define_column(p_cur_get_REPH, 6, P_REPH_Rec.EVENT_DATE);

905: dbms_sql.define_column(p_cur_get_REPH, 2, P_REPH_Rec.REQUEST_ID);
906: dbms_sql.define_column(p_cur_get_REPH, 3, P_REPH_Rec.REPAIR_LINE_ID);
907: dbms_sql.define_column(p_cur_get_REPH, 4, P_REPH_Rec.EVENT_CODE, 30);
908: dbms_sql.define_column(p_cur_get_REPH, 5, P_REPH_Rec.EVENT_MEANING, 80);
909: dbms_sql.define_column(p_cur_get_REPH, 6, P_REPH_Rec.EVENT_DATE);
910: dbms_sql.define_column(p_cur_get_REPH, 7, P_REPH_Rec.QUANTITY);
911: dbms_sql.define_column(p_cur_get_REPH, 8, P_REPH_Rec.PARAMN1);
912: dbms_sql.define_column(p_cur_get_REPH, 9, P_REPH_Rec.PARAMN2);
913: dbms_sql.define_column(p_cur_get_REPH, 10, P_REPH_Rec.PARAMN3);

Line 910: dbms_sql.define_column(p_cur_get_REPH, 7, P_REPH_Rec.QUANTITY);

906: dbms_sql.define_column(p_cur_get_REPH, 3, P_REPH_Rec.REPAIR_LINE_ID);
907: dbms_sql.define_column(p_cur_get_REPH, 4, P_REPH_Rec.EVENT_CODE, 30);
908: dbms_sql.define_column(p_cur_get_REPH, 5, P_REPH_Rec.EVENT_MEANING, 80);
909: dbms_sql.define_column(p_cur_get_REPH, 6, P_REPH_Rec.EVENT_DATE);
910: dbms_sql.define_column(p_cur_get_REPH, 7, P_REPH_Rec.QUANTITY);
911: dbms_sql.define_column(p_cur_get_REPH, 8, P_REPH_Rec.PARAMN1);
912: dbms_sql.define_column(p_cur_get_REPH, 9, P_REPH_Rec.PARAMN2);
913: dbms_sql.define_column(p_cur_get_REPH, 10, P_REPH_Rec.PARAMN3);
914: dbms_sql.define_column(p_cur_get_REPH, 11, P_REPH_Rec.PARAMN4);

Line 911: dbms_sql.define_column(p_cur_get_REPH, 8, P_REPH_Rec.PARAMN1);

907: dbms_sql.define_column(p_cur_get_REPH, 4, P_REPH_Rec.EVENT_CODE, 30);
908: dbms_sql.define_column(p_cur_get_REPH, 5, P_REPH_Rec.EVENT_MEANING, 80);
909: dbms_sql.define_column(p_cur_get_REPH, 6, P_REPH_Rec.EVENT_DATE);
910: dbms_sql.define_column(p_cur_get_REPH, 7, P_REPH_Rec.QUANTITY);
911: dbms_sql.define_column(p_cur_get_REPH, 8, P_REPH_Rec.PARAMN1);
912: dbms_sql.define_column(p_cur_get_REPH, 9, P_REPH_Rec.PARAMN2);
913: dbms_sql.define_column(p_cur_get_REPH, 10, P_REPH_Rec.PARAMN3);
914: dbms_sql.define_column(p_cur_get_REPH, 11, P_REPH_Rec.PARAMN4);
915: dbms_sql.define_column(p_cur_get_REPH, 12, P_REPH_Rec.PARAMN5);

Line 912: dbms_sql.define_column(p_cur_get_REPH, 9, P_REPH_Rec.PARAMN2);

908: dbms_sql.define_column(p_cur_get_REPH, 5, P_REPH_Rec.EVENT_MEANING, 80);
909: dbms_sql.define_column(p_cur_get_REPH, 6, P_REPH_Rec.EVENT_DATE);
910: dbms_sql.define_column(p_cur_get_REPH, 7, P_REPH_Rec.QUANTITY);
911: dbms_sql.define_column(p_cur_get_REPH, 8, P_REPH_Rec.PARAMN1);
912: dbms_sql.define_column(p_cur_get_REPH, 9, P_REPH_Rec.PARAMN2);
913: dbms_sql.define_column(p_cur_get_REPH, 10, P_REPH_Rec.PARAMN3);
914: dbms_sql.define_column(p_cur_get_REPH, 11, P_REPH_Rec.PARAMN4);
915: dbms_sql.define_column(p_cur_get_REPH, 12, P_REPH_Rec.PARAMN5);
916: dbms_sql.define_column(p_cur_get_REPH, 13, P_REPH_Rec.PARAMN6);

Line 913: dbms_sql.define_column(p_cur_get_REPH, 10, P_REPH_Rec.PARAMN3);

909: dbms_sql.define_column(p_cur_get_REPH, 6, P_REPH_Rec.EVENT_DATE);
910: dbms_sql.define_column(p_cur_get_REPH, 7, P_REPH_Rec.QUANTITY);
911: dbms_sql.define_column(p_cur_get_REPH, 8, P_REPH_Rec.PARAMN1);
912: dbms_sql.define_column(p_cur_get_REPH, 9, P_REPH_Rec.PARAMN2);
913: dbms_sql.define_column(p_cur_get_REPH, 10, P_REPH_Rec.PARAMN3);
914: dbms_sql.define_column(p_cur_get_REPH, 11, P_REPH_Rec.PARAMN4);
915: dbms_sql.define_column(p_cur_get_REPH, 12, P_REPH_Rec.PARAMN5);
916: dbms_sql.define_column(p_cur_get_REPH, 13, P_REPH_Rec.PARAMN6);
917: dbms_sql.define_column(p_cur_get_REPH, 14, P_REPH_Rec.PARAMN7);

Line 914: dbms_sql.define_column(p_cur_get_REPH, 11, P_REPH_Rec.PARAMN4);

910: dbms_sql.define_column(p_cur_get_REPH, 7, P_REPH_Rec.QUANTITY);
911: dbms_sql.define_column(p_cur_get_REPH, 8, P_REPH_Rec.PARAMN1);
912: dbms_sql.define_column(p_cur_get_REPH, 9, P_REPH_Rec.PARAMN2);
913: dbms_sql.define_column(p_cur_get_REPH, 10, P_REPH_Rec.PARAMN3);
914: dbms_sql.define_column(p_cur_get_REPH, 11, P_REPH_Rec.PARAMN4);
915: dbms_sql.define_column(p_cur_get_REPH, 12, P_REPH_Rec.PARAMN5);
916: dbms_sql.define_column(p_cur_get_REPH, 13, P_REPH_Rec.PARAMN6);
917: dbms_sql.define_column(p_cur_get_REPH, 14, P_REPH_Rec.PARAMN7);
918: dbms_sql.define_column(p_cur_get_REPH, 15, P_REPH_Rec.PARAMN8);

Line 915: dbms_sql.define_column(p_cur_get_REPH, 12, P_REPH_Rec.PARAMN5);

911: dbms_sql.define_column(p_cur_get_REPH, 8, P_REPH_Rec.PARAMN1);
912: dbms_sql.define_column(p_cur_get_REPH, 9, P_REPH_Rec.PARAMN2);
913: dbms_sql.define_column(p_cur_get_REPH, 10, P_REPH_Rec.PARAMN3);
914: dbms_sql.define_column(p_cur_get_REPH, 11, P_REPH_Rec.PARAMN4);
915: dbms_sql.define_column(p_cur_get_REPH, 12, P_REPH_Rec.PARAMN5);
916: dbms_sql.define_column(p_cur_get_REPH, 13, P_REPH_Rec.PARAMN6);
917: dbms_sql.define_column(p_cur_get_REPH, 14, P_REPH_Rec.PARAMN7);
918: dbms_sql.define_column(p_cur_get_REPH, 15, P_REPH_Rec.PARAMN8);
919: dbms_sql.define_column(p_cur_get_REPH, 16, P_REPH_Rec.PARAMN9);

Line 916: dbms_sql.define_column(p_cur_get_REPH, 13, P_REPH_Rec.PARAMN6);

912: dbms_sql.define_column(p_cur_get_REPH, 9, P_REPH_Rec.PARAMN2);
913: dbms_sql.define_column(p_cur_get_REPH, 10, P_REPH_Rec.PARAMN3);
914: dbms_sql.define_column(p_cur_get_REPH, 11, P_REPH_Rec.PARAMN4);
915: dbms_sql.define_column(p_cur_get_REPH, 12, P_REPH_Rec.PARAMN5);
916: dbms_sql.define_column(p_cur_get_REPH, 13, P_REPH_Rec.PARAMN6);
917: dbms_sql.define_column(p_cur_get_REPH, 14, P_REPH_Rec.PARAMN7);
918: dbms_sql.define_column(p_cur_get_REPH, 15, P_REPH_Rec.PARAMN8);
919: dbms_sql.define_column(p_cur_get_REPH, 16, P_REPH_Rec.PARAMN9);
920: dbms_sql.define_column(p_cur_get_REPH, 17, P_REPH_Rec.PARAMN10);

Line 917: dbms_sql.define_column(p_cur_get_REPH, 14, P_REPH_Rec.PARAMN7);

913: dbms_sql.define_column(p_cur_get_REPH, 10, P_REPH_Rec.PARAMN3);
914: dbms_sql.define_column(p_cur_get_REPH, 11, P_REPH_Rec.PARAMN4);
915: dbms_sql.define_column(p_cur_get_REPH, 12, P_REPH_Rec.PARAMN5);
916: dbms_sql.define_column(p_cur_get_REPH, 13, P_REPH_Rec.PARAMN6);
917: dbms_sql.define_column(p_cur_get_REPH, 14, P_REPH_Rec.PARAMN7);
918: dbms_sql.define_column(p_cur_get_REPH, 15, P_REPH_Rec.PARAMN8);
919: dbms_sql.define_column(p_cur_get_REPH, 16, P_REPH_Rec.PARAMN9);
920: dbms_sql.define_column(p_cur_get_REPH, 17, P_REPH_Rec.PARAMN10);
921: dbms_sql.define_column(p_cur_get_REPH, 18, P_REPH_Rec.PARAMC1, 240);

Line 918: dbms_sql.define_column(p_cur_get_REPH, 15, P_REPH_Rec.PARAMN8);

914: dbms_sql.define_column(p_cur_get_REPH, 11, P_REPH_Rec.PARAMN4);
915: dbms_sql.define_column(p_cur_get_REPH, 12, P_REPH_Rec.PARAMN5);
916: dbms_sql.define_column(p_cur_get_REPH, 13, P_REPH_Rec.PARAMN6);
917: dbms_sql.define_column(p_cur_get_REPH, 14, P_REPH_Rec.PARAMN7);
918: dbms_sql.define_column(p_cur_get_REPH, 15, P_REPH_Rec.PARAMN8);
919: dbms_sql.define_column(p_cur_get_REPH, 16, P_REPH_Rec.PARAMN9);
920: dbms_sql.define_column(p_cur_get_REPH, 17, P_REPH_Rec.PARAMN10);
921: dbms_sql.define_column(p_cur_get_REPH, 18, P_REPH_Rec.PARAMC1, 240);
922: dbms_sql.define_column(p_cur_get_REPH, 19, P_REPH_Rec.PARAMC2, 240);

Line 919: dbms_sql.define_column(p_cur_get_REPH, 16, P_REPH_Rec.PARAMN9);

915: dbms_sql.define_column(p_cur_get_REPH, 12, P_REPH_Rec.PARAMN5);
916: dbms_sql.define_column(p_cur_get_REPH, 13, P_REPH_Rec.PARAMN6);
917: dbms_sql.define_column(p_cur_get_REPH, 14, P_REPH_Rec.PARAMN7);
918: dbms_sql.define_column(p_cur_get_REPH, 15, P_REPH_Rec.PARAMN8);
919: dbms_sql.define_column(p_cur_get_REPH, 16, P_REPH_Rec.PARAMN9);
920: dbms_sql.define_column(p_cur_get_REPH, 17, P_REPH_Rec.PARAMN10);
921: dbms_sql.define_column(p_cur_get_REPH, 18, P_REPH_Rec.PARAMC1, 240);
922: dbms_sql.define_column(p_cur_get_REPH, 19, P_REPH_Rec.PARAMC2, 240);
923: dbms_sql.define_column(p_cur_get_REPH, 20, P_REPH_Rec.PARAMC3, 240);

Line 920: dbms_sql.define_column(p_cur_get_REPH, 17, P_REPH_Rec.PARAMN10);

916: dbms_sql.define_column(p_cur_get_REPH, 13, P_REPH_Rec.PARAMN6);
917: dbms_sql.define_column(p_cur_get_REPH, 14, P_REPH_Rec.PARAMN7);
918: dbms_sql.define_column(p_cur_get_REPH, 15, P_REPH_Rec.PARAMN8);
919: dbms_sql.define_column(p_cur_get_REPH, 16, P_REPH_Rec.PARAMN9);
920: dbms_sql.define_column(p_cur_get_REPH, 17, P_REPH_Rec.PARAMN10);
921: dbms_sql.define_column(p_cur_get_REPH, 18, P_REPH_Rec.PARAMC1, 240);
922: dbms_sql.define_column(p_cur_get_REPH, 19, P_REPH_Rec.PARAMC2, 240);
923: dbms_sql.define_column(p_cur_get_REPH, 20, P_REPH_Rec.PARAMC3, 240);
924: dbms_sql.define_column(p_cur_get_REPH, 21, P_REPH_Rec.PARAMC4, 240);

Line 921: dbms_sql.define_column(p_cur_get_REPH, 18, P_REPH_Rec.PARAMC1, 240);

917: dbms_sql.define_column(p_cur_get_REPH, 14, P_REPH_Rec.PARAMN7);
918: dbms_sql.define_column(p_cur_get_REPH, 15, P_REPH_Rec.PARAMN8);
919: dbms_sql.define_column(p_cur_get_REPH, 16, P_REPH_Rec.PARAMN9);
920: dbms_sql.define_column(p_cur_get_REPH, 17, P_REPH_Rec.PARAMN10);
921: dbms_sql.define_column(p_cur_get_REPH, 18, P_REPH_Rec.PARAMC1, 240);
922: dbms_sql.define_column(p_cur_get_REPH, 19, P_REPH_Rec.PARAMC2, 240);
923: dbms_sql.define_column(p_cur_get_REPH, 20, P_REPH_Rec.PARAMC3, 240);
924: dbms_sql.define_column(p_cur_get_REPH, 21, P_REPH_Rec.PARAMC4, 240);
925: dbms_sql.define_column(p_cur_get_REPH, 22, P_REPH_Rec.PARAMC5, 240);

Line 922: dbms_sql.define_column(p_cur_get_REPH, 19, P_REPH_Rec.PARAMC2, 240);

918: dbms_sql.define_column(p_cur_get_REPH, 15, P_REPH_Rec.PARAMN8);
919: dbms_sql.define_column(p_cur_get_REPH, 16, P_REPH_Rec.PARAMN9);
920: dbms_sql.define_column(p_cur_get_REPH, 17, P_REPH_Rec.PARAMN10);
921: dbms_sql.define_column(p_cur_get_REPH, 18, P_REPH_Rec.PARAMC1, 240);
922: dbms_sql.define_column(p_cur_get_REPH, 19, P_REPH_Rec.PARAMC2, 240);
923: dbms_sql.define_column(p_cur_get_REPH, 20, P_REPH_Rec.PARAMC3, 240);
924: dbms_sql.define_column(p_cur_get_REPH, 21, P_REPH_Rec.PARAMC4, 240);
925: dbms_sql.define_column(p_cur_get_REPH, 22, P_REPH_Rec.PARAMC5, 240);
926: dbms_sql.define_column(p_cur_get_REPH, 23, P_REPH_Rec.PARAMC6, 240);

Line 923: dbms_sql.define_column(p_cur_get_REPH, 20, P_REPH_Rec.PARAMC3, 240);

919: dbms_sql.define_column(p_cur_get_REPH, 16, P_REPH_Rec.PARAMN9);
920: dbms_sql.define_column(p_cur_get_REPH, 17, P_REPH_Rec.PARAMN10);
921: dbms_sql.define_column(p_cur_get_REPH, 18, P_REPH_Rec.PARAMC1, 240);
922: dbms_sql.define_column(p_cur_get_REPH, 19, P_REPH_Rec.PARAMC2, 240);
923: dbms_sql.define_column(p_cur_get_REPH, 20, P_REPH_Rec.PARAMC3, 240);
924: dbms_sql.define_column(p_cur_get_REPH, 21, P_REPH_Rec.PARAMC4, 240);
925: dbms_sql.define_column(p_cur_get_REPH, 22, P_REPH_Rec.PARAMC5, 240);
926: dbms_sql.define_column(p_cur_get_REPH, 23, P_REPH_Rec.PARAMC6, 240);
927: dbms_sql.define_column(p_cur_get_REPH, 24, P_REPH_Rec.PARAMC7, 240);

Line 924: dbms_sql.define_column(p_cur_get_REPH, 21, P_REPH_Rec.PARAMC4, 240);

920: dbms_sql.define_column(p_cur_get_REPH, 17, P_REPH_Rec.PARAMN10);
921: dbms_sql.define_column(p_cur_get_REPH, 18, P_REPH_Rec.PARAMC1, 240);
922: dbms_sql.define_column(p_cur_get_REPH, 19, P_REPH_Rec.PARAMC2, 240);
923: dbms_sql.define_column(p_cur_get_REPH, 20, P_REPH_Rec.PARAMC3, 240);
924: dbms_sql.define_column(p_cur_get_REPH, 21, P_REPH_Rec.PARAMC4, 240);
925: dbms_sql.define_column(p_cur_get_REPH, 22, P_REPH_Rec.PARAMC5, 240);
926: dbms_sql.define_column(p_cur_get_REPH, 23, P_REPH_Rec.PARAMC6, 240);
927: dbms_sql.define_column(p_cur_get_REPH, 24, P_REPH_Rec.PARAMC7, 240);
928: dbms_sql.define_column(p_cur_get_REPH, 25, P_REPH_Rec.PARAMC8, 240);

Line 925: dbms_sql.define_column(p_cur_get_REPH, 22, P_REPH_Rec.PARAMC5, 240);

921: dbms_sql.define_column(p_cur_get_REPH, 18, P_REPH_Rec.PARAMC1, 240);
922: dbms_sql.define_column(p_cur_get_REPH, 19, P_REPH_Rec.PARAMC2, 240);
923: dbms_sql.define_column(p_cur_get_REPH, 20, P_REPH_Rec.PARAMC3, 240);
924: dbms_sql.define_column(p_cur_get_REPH, 21, P_REPH_Rec.PARAMC4, 240);
925: dbms_sql.define_column(p_cur_get_REPH, 22, P_REPH_Rec.PARAMC5, 240);
926: dbms_sql.define_column(p_cur_get_REPH, 23, P_REPH_Rec.PARAMC6, 240);
927: dbms_sql.define_column(p_cur_get_REPH, 24, P_REPH_Rec.PARAMC7, 240);
928: dbms_sql.define_column(p_cur_get_REPH, 25, P_REPH_Rec.PARAMC8, 240);
929: dbms_sql.define_column(p_cur_get_REPH, 26, P_REPH_Rec.PARAMC9, 240);

Line 926: dbms_sql.define_column(p_cur_get_REPH, 23, P_REPH_Rec.PARAMC6, 240);

922: dbms_sql.define_column(p_cur_get_REPH, 19, P_REPH_Rec.PARAMC2, 240);
923: dbms_sql.define_column(p_cur_get_REPH, 20, P_REPH_Rec.PARAMC3, 240);
924: dbms_sql.define_column(p_cur_get_REPH, 21, P_REPH_Rec.PARAMC4, 240);
925: dbms_sql.define_column(p_cur_get_REPH, 22, P_REPH_Rec.PARAMC5, 240);
926: dbms_sql.define_column(p_cur_get_REPH, 23, P_REPH_Rec.PARAMC6, 240);
927: dbms_sql.define_column(p_cur_get_REPH, 24, P_REPH_Rec.PARAMC7, 240);
928: dbms_sql.define_column(p_cur_get_REPH, 25, P_REPH_Rec.PARAMC8, 240);
929: dbms_sql.define_column(p_cur_get_REPH, 26, P_REPH_Rec.PARAMC9, 240);
930: dbms_sql.define_column(p_cur_get_REPH, 27, P_REPH_Rec.PARAMC10, 240);

Line 927: dbms_sql.define_column(p_cur_get_REPH, 24, P_REPH_Rec.PARAMC7, 240);

923: dbms_sql.define_column(p_cur_get_REPH, 20, P_REPH_Rec.PARAMC3, 240);
924: dbms_sql.define_column(p_cur_get_REPH, 21, P_REPH_Rec.PARAMC4, 240);
925: dbms_sql.define_column(p_cur_get_REPH, 22, P_REPH_Rec.PARAMC5, 240);
926: dbms_sql.define_column(p_cur_get_REPH, 23, P_REPH_Rec.PARAMC6, 240);
927: dbms_sql.define_column(p_cur_get_REPH, 24, P_REPH_Rec.PARAMC7, 240);
928: dbms_sql.define_column(p_cur_get_REPH, 25, P_REPH_Rec.PARAMC8, 240);
929: dbms_sql.define_column(p_cur_get_REPH, 26, P_REPH_Rec.PARAMC9, 240);
930: dbms_sql.define_column(p_cur_get_REPH, 27, P_REPH_Rec.PARAMC10, 240);
931: dbms_sql.define_column(p_cur_get_REPH, 28, P_REPH_Rec.PARAMD1);

Line 928: dbms_sql.define_column(p_cur_get_REPH, 25, P_REPH_Rec.PARAMC8, 240);

924: dbms_sql.define_column(p_cur_get_REPH, 21, P_REPH_Rec.PARAMC4, 240);
925: dbms_sql.define_column(p_cur_get_REPH, 22, P_REPH_Rec.PARAMC5, 240);
926: dbms_sql.define_column(p_cur_get_REPH, 23, P_REPH_Rec.PARAMC6, 240);
927: dbms_sql.define_column(p_cur_get_REPH, 24, P_REPH_Rec.PARAMC7, 240);
928: dbms_sql.define_column(p_cur_get_REPH, 25, P_REPH_Rec.PARAMC8, 240);
929: dbms_sql.define_column(p_cur_get_REPH, 26, P_REPH_Rec.PARAMC9, 240);
930: dbms_sql.define_column(p_cur_get_REPH, 27, P_REPH_Rec.PARAMC10, 240);
931: dbms_sql.define_column(p_cur_get_REPH, 28, P_REPH_Rec.PARAMD1);
932: dbms_sql.define_column(p_cur_get_REPH, 29, P_REPH_Rec.PARAMD2);

Line 929: dbms_sql.define_column(p_cur_get_REPH, 26, P_REPH_Rec.PARAMC9, 240);

925: dbms_sql.define_column(p_cur_get_REPH, 22, P_REPH_Rec.PARAMC5, 240);
926: dbms_sql.define_column(p_cur_get_REPH, 23, P_REPH_Rec.PARAMC6, 240);
927: dbms_sql.define_column(p_cur_get_REPH, 24, P_REPH_Rec.PARAMC7, 240);
928: dbms_sql.define_column(p_cur_get_REPH, 25, P_REPH_Rec.PARAMC8, 240);
929: dbms_sql.define_column(p_cur_get_REPH, 26, P_REPH_Rec.PARAMC9, 240);
930: dbms_sql.define_column(p_cur_get_REPH, 27, P_REPH_Rec.PARAMC10, 240);
931: dbms_sql.define_column(p_cur_get_REPH, 28, P_REPH_Rec.PARAMD1);
932: dbms_sql.define_column(p_cur_get_REPH, 29, P_REPH_Rec.PARAMD2);
933: dbms_sql.define_column(p_cur_get_REPH, 30, P_REPH_Rec.PARAMD3);

Line 930: dbms_sql.define_column(p_cur_get_REPH, 27, P_REPH_Rec.PARAMC10, 240);

926: dbms_sql.define_column(p_cur_get_REPH, 23, P_REPH_Rec.PARAMC6, 240);
927: dbms_sql.define_column(p_cur_get_REPH, 24, P_REPH_Rec.PARAMC7, 240);
928: dbms_sql.define_column(p_cur_get_REPH, 25, P_REPH_Rec.PARAMC8, 240);
929: dbms_sql.define_column(p_cur_get_REPH, 26, P_REPH_Rec.PARAMC9, 240);
930: dbms_sql.define_column(p_cur_get_REPH, 27, P_REPH_Rec.PARAMC10, 240);
931: dbms_sql.define_column(p_cur_get_REPH, 28, P_REPH_Rec.PARAMD1);
932: dbms_sql.define_column(p_cur_get_REPH, 29, P_REPH_Rec.PARAMD2);
933: dbms_sql.define_column(p_cur_get_REPH, 30, P_REPH_Rec.PARAMD3);
934: dbms_sql.define_column(p_cur_get_REPH, 31, P_REPH_Rec.PARAMD4);

Line 931: dbms_sql.define_column(p_cur_get_REPH, 28, P_REPH_Rec.PARAMD1);

927: dbms_sql.define_column(p_cur_get_REPH, 24, P_REPH_Rec.PARAMC7, 240);
928: dbms_sql.define_column(p_cur_get_REPH, 25, P_REPH_Rec.PARAMC8, 240);
929: dbms_sql.define_column(p_cur_get_REPH, 26, P_REPH_Rec.PARAMC9, 240);
930: dbms_sql.define_column(p_cur_get_REPH, 27, P_REPH_Rec.PARAMC10, 240);
931: dbms_sql.define_column(p_cur_get_REPH, 28, P_REPH_Rec.PARAMD1);
932: dbms_sql.define_column(p_cur_get_REPH, 29, P_REPH_Rec.PARAMD2);
933: dbms_sql.define_column(p_cur_get_REPH, 30, P_REPH_Rec.PARAMD3);
934: dbms_sql.define_column(p_cur_get_REPH, 31, P_REPH_Rec.PARAMD4);
935: dbms_sql.define_column(p_cur_get_REPH, 32, P_REPH_Rec.PARAMD5);

Line 932: dbms_sql.define_column(p_cur_get_REPH, 29, P_REPH_Rec.PARAMD2);

928: dbms_sql.define_column(p_cur_get_REPH, 25, P_REPH_Rec.PARAMC8, 240);
929: dbms_sql.define_column(p_cur_get_REPH, 26, P_REPH_Rec.PARAMC9, 240);
930: dbms_sql.define_column(p_cur_get_REPH, 27, P_REPH_Rec.PARAMC10, 240);
931: dbms_sql.define_column(p_cur_get_REPH, 28, P_REPH_Rec.PARAMD1);
932: dbms_sql.define_column(p_cur_get_REPH, 29, P_REPH_Rec.PARAMD2);
933: dbms_sql.define_column(p_cur_get_REPH, 30, P_REPH_Rec.PARAMD3);
934: dbms_sql.define_column(p_cur_get_REPH, 31, P_REPH_Rec.PARAMD4);
935: dbms_sql.define_column(p_cur_get_REPH, 32, P_REPH_Rec.PARAMD5);
936: dbms_sql.define_column(p_cur_get_REPH, 33, P_REPH_Rec.PARAMD6);

Line 933: dbms_sql.define_column(p_cur_get_REPH, 30, P_REPH_Rec.PARAMD3);

929: dbms_sql.define_column(p_cur_get_REPH, 26, P_REPH_Rec.PARAMC9, 240);
930: dbms_sql.define_column(p_cur_get_REPH, 27, P_REPH_Rec.PARAMC10, 240);
931: dbms_sql.define_column(p_cur_get_REPH, 28, P_REPH_Rec.PARAMD1);
932: dbms_sql.define_column(p_cur_get_REPH, 29, P_REPH_Rec.PARAMD2);
933: dbms_sql.define_column(p_cur_get_REPH, 30, P_REPH_Rec.PARAMD3);
934: dbms_sql.define_column(p_cur_get_REPH, 31, P_REPH_Rec.PARAMD4);
935: dbms_sql.define_column(p_cur_get_REPH, 32, P_REPH_Rec.PARAMD5);
936: dbms_sql.define_column(p_cur_get_REPH, 33, P_REPH_Rec.PARAMD6);
937: dbms_sql.define_column(p_cur_get_REPH, 34, P_REPH_Rec.PARAMD7);

Line 934: dbms_sql.define_column(p_cur_get_REPH, 31, P_REPH_Rec.PARAMD4);

930: dbms_sql.define_column(p_cur_get_REPH, 27, P_REPH_Rec.PARAMC10, 240);
931: dbms_sql.define_column(p_cur_get_REPH, 28, P_REPH_Rec.PARAMD1);
932: dbms_sql.define_column(p_cur_get_REPH, 29, P_REPH_Rec.PARAMD2);
933: dbms_sql.define_column(p_cur_get_REPH, 30, P_REPH_Rec.PARAMD3);
934: dbms_sql.define_column(p_cur_get_REPH, 31, P_REPH_Rec.PARAMD4);
935: dbms_sql.define_column(p_cur_get_REPH, 32, P_REPH_Rec.PARAMD5);
936: dbms_sql.define_column(p_cur_get_REPH, 33, P_REPH_Rec.PARAMD6);
937: dbms_sql.define_column(p_cur_get_REPH, 34, P_REPH_Rec.PARAMD7);
938: dbms_sql.define_column(p_cur_get_REPH, 35, P_REPH_Rec.PARAMD8);

Line 935: dbms_sql.define_column(p_cur_get_REPH, 32, P_REPH_Rec.PARAMD5);

931: dbms_sql.define_column(p_cur_get_REPH, 28, P_REPH_Rec.PARAMD1);
932: dbms_sql.define_column(p_cur_get_REPH, 29, P_REPH_Rec.PARAMD2);
933: dbms_sql.define_column(p_cur_get_REPH, 30, P_REPH_Rec.PARAMD3);
934: dbms_sql.define_column(p_cur_get_REPH, 31, P_REPH_Rec.PARAMD4);
935: dbms_sql.define_column(p_cur_get_REPH, 32, P_REPH_Rec.PARAMD5);
936: dbms_sql.define_column(p_cur_get_REPH, 33, P_REPH_Rec.PARAMD6);
937: dbms_sql.define_column(p_cur_get_REPH, 34, P_REPH_Rec.PARAMD7);
938: dbms_sql.define_column(p_cur_get_REPH, 35, P_REPH_Rec.PARAMD8);
939: dbms_sql.define_column(p_cur_get_REPH, 36, P_REPH_Rec.PARAMD9);

Line 936: dbms_sql.define_column(p_cur_get_REPH, 33, P_REPH_Rec.PARAMD6);

932: dbms_sql.define_column(p_cur_get_REPH, 29, P_REPH_Rec.PARAMD2);
933: dbms_sql.define_column(p_cur_get_REPH, 30, P_REPH_Rec.PARAMD3);
934: dbms_sql.define_column(p_cur_get_REPH, 31, P_REPH_Rec.PARAMD4);
935: dbms_sql.define_column(p_cur_get_REPH, 32, P_REPH_Rec.PARAMD5);
936: dbms_sql.define_column(p_cur_get_REPH, 33, P_REPH_Rec.PARAMD6);
937: dbms_sql.define_column(p_cur_get_REPH, 34, P_REPH_Rec.PARAMD7);
938: dbms_sql.define_column(p_cur_get_REPH, 35, P_REPH_Rec.PARAMD8);
939: dbms_sql.define_column(p_cur_get_REPH, 36, P_REPH_Rec.PARAMD9);
940: dbms_sql.define_column(p_cur_get_REPH, 37, P_REPH_Rec.PARAMD10);

Line 937: dbms_sql.define_column(p_cur_get_REPH, 34, P_REPH_Rec.PARAMD7);

933: dbms_sql.define_column(p_cur_get_REPH, 30, P_REPH_Rec.PARAMD3);
934: dbms_sql.define_column(p_cur_get_REPH, 31, P_REPH_Rec.PARAMD4);
935: dbms_sql.define_column(p_cur_get_REPH, 32, P_REPH_Rec.PARAMD5);
936: dbms_sql.define_column(p_cur_get_REPH, 33, P_REPH_Rec.PARAMD6);
937: dbms_sql.define_column(p_cur_get_REPH, 34, P_REPH_Rec.PARAMD7);
938: dbms_sql.define_column(p_cur_get_REPH, 35, P_REPH_Rec.PARAMD8);
939: dbms_sql.define_column(p_cur_get_REPH, 36, P_REPH_Rec.PARAMD9);
940: dbms_sql.define_column(p_cur_get_REPH, 37, P_REPH_Rec.PARAMD10);
941: dbms_sql.define_column(p_cur_get_REPH, 38, P_REPH_Rec.ATTRIBUTE_CATEGORY, 30);

Line 938: dbms_sql.define_column(p_cur_get_REPH, 35, P_REPH_Rec.PARAMD8);

934: dbms_sql.define_column(p_cur_get_REPH, 31, P_REPH_Rec.PARAMD4);
935: dbms_sql.define_column(p_cur_get_REPH, 32, P_REPH_Rec.PARAMD5);
936: dbms_sql.define_column(p_cur_get_REPH, 33, P_REPH_Rec.PARAMD6);
937: dbms_sql.define_column(p_cur_get_REPH, 34, P_REPH_Rec.PARAMD7);
938: dbms_sql.define_column(p_cur_get_REPH, 35, P_REPH_Rec.PARAMD8);
939: dbms_sql.define_column(p_cur_get_REPH, 36, P_REPH_Rec.PARAMD9);
940: dbms_sql.define_column(p_cur_get_REPH, 37, P_REPH_Rec.PARAMD10);
941: dbms_sql.define_column(p_cur_get_REPH, 38, P_REPH_Rec.ATTRIBUTE_CATEGORY, 30);
942: dbms_sql.define_column(p_cur_get_REPH, 39, P_REPH_Rec.ATTRIBUTE1, 150);

Line 939: dbms_sql.define_column(p_cur_get_REPH, 36, P_REPH_Rec.PARAMD9);

935: dbms_sql.define_column(p_cur_get_REPH, 32, P_REPH_Rec.PARAMD5);
936: dbms_sql.define_column(p_cur_get_REPH, 33, P_REPH_Rec.PARAMD6);
937: dbms_sql.define_column(p_cur_get_REPH, 34, P_REPH_Rec.PARAMD7);
938: dbms_sql.define_column(p_cur_get_REPH, 35, P_REPH_Rec.PARAMD8);
939: dbms_sql.define_column(p_cur_get_REPH, 36, P_REPH_Rec.PARAMD9);
940: dbms_sql.define_column(p_cur_get_REPH, 37, P_REPH_Rec.PARAMD10);
941: dbms_sql.define_column(p_cur_get_REPH, 38, P_REPH_Rec.ATTRIBUTE_CATEGORY, 30);
942: dbms_sql.define_column(p_cur_get_REPH, 39, P_REPH_Rec.ATTRIBUTE1, 150);
943: dbms_sql.define_column(p_cur_get_REPH, 40, P_REPH_Rec.ATTRIBUTE2, 150);

Line 940: dbms_sql.define_column(p_cur_get_REPH, 37, P_REPH_Rec.PARAMD10);

936: dbms_sql.define_column(p_cur_get_REPH, 33, P_REPH_Rec.PARAMD6);
937: dbms_sql.define_column(p_cur_get_REPH, 34, P_REPH_Rec.PARAMD7);
938: dbms_sql.define_column(p_cur_get_REPH, 35, P_REPH_Rec.PARAMD8);
939: dbms_sql.define_column(p_cur_get_REPH, 36, P_REPH_Rec.PARAMD9);
940: dbms_sql.define_column(p_cur_get_REPH, 37, P_REPH_Rec.PARAMD10);
941: dbms_sql.define_column(p_cur_get_REPH, 38, P_REPH_Rec.ATTRIBUTE_CATEGORY, 30);
942: dbms_sql.define_column(p_cur_get_REPH, 39, P_REPH_Rec.ATTRIBUTE1, 150);
943: dbms_sql.define_column(p_cur_get_REPH, 40, P_REPH_Rec.ATTRIBUTE2, 150);
944: dbms_sql.define_column(p_cur_get_REPH, 41, P_REPH_Rec.ATTRIBUTE3, 150);

Line 941: dbms_sql.define_column(p_cur_get_REPH, 38, P_REPH_Rec.ATTRIBUTE_CATEGORY, 30);

937: dbms_sql.define_column(p_cur_get_REPH, 34, P_REPH_Rec.PARAMD7);
938: dbms_sql.define_column(p_cur_get_REPH, 35, P_REPH_Rec.PARAMD8);
939: dbms_sql.define_column(p_cur_get_REPH, 36, P_REPH_Rec.PARAMD9);
940: dbms_sql.define_column(p_cur_get_REPH, 37, P_REPH_Rec.PARAMD10);
941: dbms_sql.define_column(p_cur_get_REPH, 38, P_REPH_Rec.ATTRIBUTE_CATEGORY, 30);
942: dbms_sql.define_column(p_cur_get_REPH, 39, P_REPH_Rec.ATTRIBUTE1, 150);
943: dbms_sql.define_column(p_cur_get_REPH, 40, P_REPH_Rec.ATTRIBUTE2, 150);
944: dbms_sql.define_column(p_cur_get_REPH, 41, P_REPH_Rec.ATTRIBUTE3, 150);
945: dbms_sql.define_column(p_cur_get_REPH, 42, P_REPH_Rec.ATTRIBUTE4, 150);

Line 942: dbms_sql.define_column(p_cur_get_REPH, 39, P_REPH_Rec.ATTRIBUTE1, 150);

938: dbms_sql.define_column(p_cur_get_REPH, 35, P_REPH_Rec.PARAMD8);
939: dbms_sql.define_column(p_cur_get_REPH, 36, P_REPH_Rec.PARAMD9);
940: dbms_sql.define_column(p_cur_get_REPH, 37, P_REPH_Rec.PARAMD10);
941: dbms_sql.define_column(p_cur_get_REPH, 38, P_REPH_Rec.ATTRIBUTE_CATEGORY, 30);
942: dbms_sql.define_column(p_cur_get_REPH, 39, P_REPH_Rec.ATTRIBUTE1, 150);
943: dbms_sql.define_column(p_cur_get_REPH, 40, P_REPH_Rec.ATTRIBUTE2, 150);
944: dbms_sql.define_column(p_cur_get_REPH, 41, P_REPH_Rec.ATTRIBUTE3, 150);
945: dbms_sql.define_column(p_cur_get_REPH, 42, P_REPH_Rec.ATTRIBUTE4, 150);
946: dbms_sql.define_column(p_cur_get_REPH, 43, P_REPH_Rec.ATTRIBUTE5, 150);

Line 943: dbms_sql.define_column(p_cur_get_REPH, 40, P_REPH_Rec.ATTRIBUTE2, 150);

939: dbms_sql.define_column(p_cur_get_REPH, 36, P_REPH_Rec.PARAMD9);
940: dbms_sql.define_column(p_cur_get_REPH, 37, P_REPH_Rec.PARAMD10);
941: dbms_sql.define_column(p_cur_get_REPH, 38, P_REPH_Rec.ATTRIBUTE_CATEGORY, 30);
942: dbms_sql.define_column(p_cur_get_REPH, 39, P_REPH_Rec.ATTRIBUTE1, 150);
943: dbms_sql.define_column(p_cur_get_REPH, 40, P_REPH_Rec.ATTRIBUTE2, 150);
944: dbms_sql.define_column(p_cur_get_REPH, 41, P_REPH_Rec.ATTRIBUTE3, 150);
945: dbms_sql.define_column(p_cur_get_REPH, 42, P_REPH_Rec.ATTRIBUTE4, 150);
946: dbms_sql.define_column(p_cur_get_REPH, 43, P_REPH_Rec.ATTRIBUTE5, 150);
947: dbms_sql.define_column(p_cur_get_REPH, 44, P_REPH_Rec.ATTRIBUTE6, 150);

Line 944: dbms_sql.define_column(p_cur_get_REPH, 41, P_REPH_Rec.ATTRIBUTE3, 150);

940: dbms_sql.define_column(p_cur_get_REPH, 37, P_REPH_Rec.PARAMD10);
941: dbms_sql.define_column(p_cur_get_REPH, 38, P_REPH_Rec.ATTRIBUTE_CATEGORY, 30);
942: dbms_sql.define_column(p_cur_get_REPH, 39, P_REPH_Rec.ATTRIBUTE1, 150);
943: dbms_sql.define_column(p_cur_get_REPH, 40, P_REPH_Rec.ATTRIBUTE2, 150);
944: dbms_sql.define_column(p_cur_get_REPH, 41, P_REPH_Rec.ATTRIBUTE3, 150);
945: dbms_sql.define_column(p_cur_get_REPH, 42, P_REPH_Rec.ATTRIBUTE4, 150);
946: dbms_sql.define_column(p_cur_get_REPH, 43, P_REPH_Rec.ATTRIBUTE5, 150);
947: dbms_sql.define_column(p_cur_get_REPH, 44, P_REPH_Rec.ATTRIBUTE6, 150);
948: dbms_sql.define_column(p_cur_get_REPH, 45, P_REPH_Rec.ATTRIBUTE7, 150);

Line 945: dbms_sql.define_column(p_cur_get_REPH, 42, P_REPH_Rec.ATTRIBUTE4, 150);

941: dbms_sql.define_column(p_cur_get_REPH, 38, P_REPH_Rec.ATTRIBUTE_CATEGORY, 30);
942: dbms_sql.define_column(p_cur_get_REPH, 39, P_REPH_Rec.ATTRIBUTE1, 150);
943: dbms_sql.define_column(p_cur_get_REPH, 40, P_REPH_Rec.ATTRIBUTE2, 150);
944: dbms_sql.define_column(p_cur_get_REPH, 41, P_REPH_Rec.ATTRIBUTE3, 150);
945: dbms_sql.define_column(p_cur_get_REPH, 42, P_REPH_Rec.ATTRIBUTE4, 150);
946: dbms_sql.define_column(p_cur_get_REPH, 43, P_REPH_Rec.ATTRIBUTE5, 150);
947: dbms_sql.define_column(p_cur_get_REPH, 44, P_REPH_Rec.ATTRIBUTE6, 150);
948: dbms_sql.define_column(p_cur_get_REPH, 45, P_REPH_Rec.ATTRIBUTE7, 150);
949: dbms_sql.define_column(p_cur_get_REPH, 46, P_REPH_Rec.ATTRIBUTE8, 150);

Line 946: dbms_sql.define_column(p_cur_get_REPH, 43, P_REPH_Rec.ATTRIBUTE5, 150);

942: dbms_sql.define_column(p_cur_get_REPH, 39, P_REPH_Rec.ATTRIBUTE1, 150);
943: dbms_sql.define_column(p_cur_get_REPH, 40, P_REPH_Rec.ATTRIBUTE2, 150);
944: dbms_sql.define_column(p_cur_get_REPH, 41, P_REPH_Rec.ATTRIBUTE3, 150);
945: dbms_sql.define_column(p_cur_get_REPH, 42, P_REPH_Rec.ATTRIBUTE4, 150);
946: dbms_sql.define_column(p_cur_get_REPH, 43, P_REPH_Rec.ATTRIBUTE5, 150);
947: dbms_sql.define_column(p_cur_get_REPH, 44, P_REPH_Rec.ATTRIBUTE6, 150);
948: dbms_sql.define_column(p_cur_get_REPH, 45, P_REPH_Rec.ATTRIBUTE7, 150);
949: dbms_sql.define_column(p_cur_get_REPH, 46, P_REPH_Rec.ATTRIBUTE8, 150);
950: dbms_sql.define_column(p_cur_get_REPH, 47, P_REPH_Rec.ATTRIBUTE9, 150);

Line 947: dbms_sql.define_column(p_cur_get_REPH, 44, P_REPH_Rec.ATTRIBUTE6, 150);

943: dbms_sql.define_column(p_cur_get_REPH, 40, P_REPH_Rec.ATTRIBUTE2, 150);
944: dbms_sql.define_column(p_cur_get_REPH, 41, P_REPH_Rec.ATTRIBUTE3, 150);
945: dbms_sql.define_column(p_cur_get_REPH, 42, P_REPH_Rec.ATTRIBUTE4, 150);
946: dbms_sql.define_column(p_cur_get_REPH, 43, P_REPH_Rec.ATTRIBUTE5, 150);
947: dbms_sql.define_column(p_cur_get_REPH, 44, P_REPH_Rec.ATTRIBUTE6, 150);
948: dbms_sql.define_column(p_cur_get_REPH, 45, P_REPH_Rec.ATTRIBUTE7, 150);
949: dbms_sql.define_column(p_cur_get_REPH, 46, P_REPH_Rec.ATTRIBUTE8, 150);
950: dbms_sql.define_column(p_cur_get_REPH, 47, P_REPH_Rec.ATTRIBUTE9, 150);
951: dbms_sql.define_column(p_cur_get_REPH, 48, P_REPH_Rec.ATTRIBUTE10, 150);

Line 948: dbms_sql.define_column(p_cur_get_REPH, 45, P_REPH_Rec.ATTRIBUTE7, 150);

944: dbms_sql.define_column(p_cur_get_REPH, 41, P_REPH_Rec.ATTRIBUTE3, 150);
945: dbms_sql.define_column(p_cur_get_REPH, 42, P_REPH_Rec.ATTRIBUTE4, 150);
946: dbms_sql.define_column(p_cur_get_REPH, 43, P_REPH_Rec.ATTRIBUTE5, 150);
947: dbms_sql.define_column(p_cur_get_REPH, 44, P_REPH_Rec.ATTRIBUTE6, 150);
948: dbms_sql.define_column(p_cur_get_REPH, 45, P_REPH_Rec.ATTRIBUTE7, 150);
949: dbms_sql.define_column(p_cur_get_REPH, 46, P_REPH_Rec.ATTRIBUTE8, 150);
950: dbms_sql.define_column(p_cur_get_REPH, 47, P_REPH_Rec.ATTRIBUTE9, 150);
951: dbms_sql.define_column(p_cur_get_REPH, 48, P_REPH_Rec.ATTRIBUTE10, 150);
952: dbms_sql.define_column(p_cur_get_REPH, 49, P_REPH_Rec.ATTRIBUTE11, 150);

Line 949: dbms_sql.define_column(p_cur_get_REPH, 46, P_REPH_Rec.ATTRIBUTE8, 150);

945: dbms_sql.define_column(p_cur_get_REPH, 42, P_REPH_Rec.ATTRIBUTE4, 150);
946: dbms_sql.define_column(p_cur_get_REPH, 43, P_REPH_Rec.ATTRIBUTE5, 150);
947: dbms_sql.define_column(p_cur_get_REPH, 44, P_REPH_Rec.ATTRIBUTE6, 150);
948: dbms_sql.define_column(p_cur_get_REPH, 45, P_REPH_Rec.ATTRIBUTE7, 150);
949: dbms_sql.define_column(p_cur_get_REPH, 46, P_REPH_Rec.ATTRIBUTE8, 150);
950: dbms_sql.define_column(p_cur_get_REPH, 47, P_REPH_Rec.ATTRIBUTE9, 150);
951: dbms_sql.define_column(p_cur_get_REPH, 48, P_REPH_Rec.ATTRIBUTE10, 150);
952: dbms_sql.define_column(p_cur_get_REPH, 49, P_REPH_Rec.ATTRIBUTE11, 150);
953: dbms_sql.define_column(p_cur_get_REPH, 50, P_REPH_Rec.ATTRIBUTE12, 150);

Line 950: dbms_sql.define_column(p_cur_get_REPH, 47, P_REPH_Rec.ATTRIBUTE9, 150);

946: dbms_sql.define_column(p_cur_get_REPH, 43, P_REPH_Rec.ATTRIBUTE5, 150);
947: dbms_sql.define_column(p_cur_get_REPH, 44, P_REPH_Rec.ATTRIBUTE6, 150);
948: dbms_sql.define_column(p_cur_get_REPH, 45, P_REPH_Rec.ATTRIBUTE7, 150);
949: dbms_sql.define_column(p_cur_get_REPH, 46, P_REPH_Rec.ATTRIBUTE8, 150);
950: dbms_sql.define_column(p_cur_get_REPH, 47, P_REPH_Rec.ATTRIBUTE9, 150);
951: dbms_sql.define_column(p_cur_get_REPH, 48, P_REPH_Rec.ATTRIBUTE10, 150);
952: dbms_sql.define_column(p_cur_get_REPH, 49, P_REPH_Rec.ATTRIBUTE11, 150);
953: dbms_sql.define_column(p_cur_get_REPH, 50, P_REPH_Rec.ATTRIBUTE12, 150);
954: dbms_sql.define_column(p_cur_get_REPH, 51, P_REPH_Rec.ATTRIBUTE13, 150);

Line 951: dbms_sql.define_column(p_cur_get_REPH, 48, P_REPH_Rec.ATTRIBUTE10, 150);

947: dbms_sql.define_column(p_cur_get_REPH, 44, P_REPH_Rec.ATTRIBUTE6, 150);
948: dbms_sql.define_column(p_cur_get_REPH, 45, P_REPH_Rec.ATTRIBUTE7, 150);
949: dbms_sql.define_column(p_cur_get_REPH, 46, P_REPH_Rec.ATTRIBUTE8, 150);
950: dbms_sql.define_column(p_cur_get_REPH, 47, P_REPH_Rec.ATTRIBUTE9, 150);
951: dbms_sql.define_column(p_cur_get_REPH, 48, P_REPH_Rec.ATTRIBUTE10, 150);
952: dbms_sql.define_column(p_cur_get_REPH, 49, P_REPH_Rec.ATTRIBUTE11, 150);
953: dbms_sql.define_column(p_cur_get_REPH, 50, P_REPH_Rec.ATTRIBUTE12, 150);
954: dbms_sql.define_column(p_cur_get_REPH, 51, P_REPH_Rec.ATTRIBUTE13, 150);
955: dbms_sql.define_column(p_cur_get_REPH, 52, P_REPH_Rec.ATTRIBUTE14, 150);

Line 952: dbms_sql.define_column(p_cur_get_REPH, 49, P_REPH_Rec.ATTRIBUTE11, 150);

948: dbms_sql.define_column(p_cur_get_REPH, 45, P_REPH_Rec.ATTRIBUTE7, 150);
949: dbms_sql.define_column(p_cur_get_REPH, 46, P_REPH_Rec.ATTRIBUTE8, 150);
950: dbms_sql.define_column(p_cur_get_REPH, 47, P_REPH_Rec.ATTRIBUTE9, 150);
951: dbms_sql.define_column(p_cur_get_REPH, 48, P_REPH_Rec.ATTRIBUTE10, 150);
952: dbms_sql.define_column(p_cur_get_REPH, 49, P_REPH_Rec.ATTRIBUTE11, 150);
953: dbms_sql.define_column(p_cur_get_REPH, 50, P_REPH_Rec.ATTRIBUTE12, 150);
954: dbms_sql.define_column(p_cur_get_REPH, 51, P_REPH_Rec.ATTRIBUTE13, 150);
955: dbms_sql.define_column(p_cur_get_REPH, 52, P_REPH_Rec.ATTRIBUTE14, 150);
956: dbms_sql.define_column(p_cur_get_REPH, 53, P_REPH_Rec.ATTRIBUTE15, 150);

Line 953: dbms_sql.define_column(p_cur_get_REPH, 50, P_REPH_Rec.ATTRIBUTE12, 150);

949: dbms_sql.define_column(p_cur_get_REPH, 46, P_REPH_Rec.ATTRIBUTE8, 150);
950: dbms_sql.define_column(p_cur_get_REPH, 47, P_REPH_Rec.ATTRIBUTE9, 150);
951: dbms_sql.define_column(p_cur_get_REPH, 48, P_REPH_Rec.ATTRIBUTE10, 150);
952: dbms_sql.define_column(p_cur_get_REPH, 49, P_REPH_Rec.ATTRIBUTE11, 150);
953: dbms_sql.define_column(p_cur_get_REPH, 50, P_REPH_Rec.ATTRIBUTE12, 150);
954: dbms_sql.define_column(p_cur_get_REPH, 51, P_REPH_Rec.ATTRIBUTE13, 150);
955: dbms_sql.define_column(p_cur_get_REPH, 52, P_REPH_Rec.ATTRIBUTE14, 150);
956: dbms_sql.define_column(p_cur_get_REPH, 53, P_REPH_Rec.ATTRIBUTE15, 150);
957: dbms_sql.define_column(p_cur_get_REPH, 54, P_REPH_Rec.OBJECT_VERSION_NUMBER);

Line 954: dbms_sql.define_column(p_cur_get_REPH, 51, P_REPH_Rec.ATTRIBUTE13, 150);

950: dbms_sql.define_column(p_cur_get_REPH, 47, P_REPH_Rec.ATTRIBUTE9, 150);
951: dbms_sql.define_column(p_cur_get_REPH, 48, P_REPH_Rec.ATTRIBUTE10, 150);
952: dbms_sql.define_column(p_cur_get_REPH, 49, P_REPH_Rec.ATTRIBUTE11, 150);
953: dbms_sql.define_column(p_cur_get_REPH, 50, P_REPH_Rec.ATTRIBUTE12, 150);
954: dbms_sql.define_column(p_cur_get_REPH, 51, P_REPH_Rec.ATTRIBUTE13, 150);
955: dbms_sql.define_column(p_cur_get_REPH, 52, P_REPH_Rec.ATTRIBUTE14, 150);
956: dbms_sql.define_column(p_cur_get_REPH, 53, P_REPH_Rec.ATTRIBUTE15, 150);
957: dbms_sql.define_column(p_cur_get_REPH, 54, P_REPH_Rec.OBJECT_VERSION_NUMBER);
958:

Line 955: dbms_sql.define_column(p_cur_get_REPH, 52, P_REPH_Rec.ATTRIBUTE14, 150);

951: dbms_sql.define_column(p_cur_get_REPH, 48, P_REPH_Rec.ATTRIBUTE10, 150);
952: dbms_sql.define_column(p_cur_get_REPH, 49, P_REPH_Rec.ATTRIBUTE11, 150);
953: dbms_sql.define_column(p_cur_get_REPH, 50, P_REPH_Rec.ATTRIBUTE12, 150);
954: dbms_sql.define_column(p_cur_get_REPH, 51, P_REPH_Rec.ATTRIBUTE13, 150);
955: dbms_sql.define_column(p_cur_get_REPH, 52, P_REPH_Rec.ATTRIBUTE14, 150);
956: dbms_sql.define_column(p_cur_get_REPH, 53, P_REPH_Rec.ATTRIBUTE15, 150);
957: dbms_sql.define_column(p_cur_get_REPH, 54, P_REPH_Rec.OBJECT_VERSION_NUMBER);
958:
959: -- Debug Message

Line 956: dbms_sql.define_column(p_cur_get_REPH, 53, P_REPH_Rec.ATTRIBUTE15, 150);

952: dbms_sql.define_column(p_cur_get_REPH, 49, P_REPH_Rec.ATTRIBUTE11, 150);
953: dbms_sql.define_column(p_cur_get_REPH, 50, P_REPH_Rec.ATTRIBUTE12, 150);
954: dbms_sql.define_column(p_cur_get_REPH, 51, P_REPH_Rec.ATTRIBUTE13, 150);
955: dbms_sql.define_column(p_cur_get_REPH, 52, P_REPH_Rec.ATTRIBUTE14, 150);
956: dbms_sql.define_column(p_cur_get_REPH, 53, P_REPH_Rec.ATTRIBUTE15, 150);
957: dbms_sql.define_column(p_cur_get_REPH, 54, P_REPH_Rec.OBJECT_VERSION_NUMBER);
958:
959: -- Debug Message
960: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Define Columns Ends');

Line 957: dbms_sql.define_column(p_cur_get_REPH, 54, P_REPH_Rec.OBJECT_VERSION_NUMBER);

953: dbms_sql.define_column(p_cur_get_REPH, 50, P_REPH_Rec.ATTRIBUTE12, 150);
954: dbms_sql.define_column(p_cur_get_REPH, 51, P_REPH_Rec.ATTRIBUTE13, 150);
955: dbms_sql.define_column(p_cur_get_REPH, 52, P_REPH_Rec.ATTRIBUTE14, 150);
956: dbms_sql.define_column(p_cur_get_REPH, 53, P_REPH_Rec.ATTRIBUTE15, 150);
957: dbms_sql.define_column(p_cur_get_REPH, 54, P_REPH_Rec.OBJECT_VERSION_NUMBER);
958:
959: -- Debug Message
960: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Define Columns Ends');
961: END Define_Columns;

Line 974: dbms_sql.column_value(p_cur_get_REPH, 1, X_REPH_Rec.REPAIR_HISTORY_ID);

970: -- Debug Message
971: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Get Column Values Begins');
972:
973: -- get all column values for CSD_REPAIR_HISTORY_V table
974: dbms_sql.column_value(p_cur_get_REPH, 1, X_REPH_Rec.REPAIR_HISTORY_ID);
975: dbms_sql.column_value(p_cur_get_REPH, 2, X_REPH_Rec.REQUEST_ID);
976: dbms_sql.column_value(p_cur_get_REPH, 3, X_REPH_Rec.REPAIR_LINE_ID);
977: dbms_sql.column_value(p_cur_get_REPH, 4, X_REPH_Rec.EVENT_CODE);
978: dbms_sql.column_value(p_cur_get_REPH, 5, X_REPH_Rec.EVENT_MEANING);

Line 975: dbms_sql.column_value(p_cur_get_REPH, 2, X_REPH_Rec.REQUEST_ID);

971: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Get Column Values Begins');
972:
973: -- get all column values for CSD_REPAIR_HISTORY_V table
974: dbms_sql.column_value(p_cur_get_REPH, 1, X_REPH_Rec.REPAIR_HISTORY_ID);
975: dbms_sql.column_value(p_cur_get_REPH, 2, X_REPH_Rec.REQUEST_ID);
976: dbms_sql.column_value(p_cur_get_REPH, 3, X_REPH_Rec.REPAIR_LINE_ID);
977: dbms_sql.column_value(p_cur_get_REPH, 4, X_REPH_Rec.EVENT_CODE);
978: dbms_sql.column_value(p_cur_get_REPH, 5, X_REPH_Rec.EVENT_MEANING);
979: dbms_sql.column_value(p_cur_get_REPH, 6, X_REPH_Rec.EVENT_DATE);

Line 976: dbms_sql.column_value(p_cur_get_REPH, 3, X_REPH_Rec.REPAIR_LINE_ID);

972:
973: -- get all column values for CSD_REPAIR_HISTORY_V table
974: dbms_sql.column_value(p_cur_get_REPH, 1, X_REPH_Rec.REPAIR_HISTORY_ID);
975: dbms_sql.column_value(p_cur_get_REPH, 2, X_REPH_Rec.REQUEST_ID);
976: dbms_sql.column_value(p_cur_get_REPH, 3, X_REPH_Rec.REPAIR_LINE_ID);
977: dbms_sql.column_value(p_cur_get_REPH, 4, X_REPH_Rec.EVENT_CODE);
978: dbms_sql.column_value(p_cur_get_REPH, 5, X_REPH_Rec.EVENT_MEANING);
979: dbms_sql.column_value(p_cur_get_REPH, 6, X_REPH_Rec.EVENT_DATE);
980: dbms_sql.column_value(p_cur_get_REPH, 7, X_REPH_Rec.QUANTITY);

Line 977: dbms_sql.column_value(p_cur_get_REPH, 4, X_REPH_Rec.EVENT_CODE);

973: -- get all column values for CSD_REPAIR_HISTORY_V table
974: dbms_sql.column_value(p_cur_get_REPH, 1, X_REPH_Rec.REPAIR_HISTORY_ID);
975: dbms_sql.column_value(p_cur_get_REPH, 2, X_REPH_Rec.REQUEST_ID);
976: dbms_sql.column_value(p_cur_get_REPH, 3, X_REPH_Rec.REPAIR_LINE_ID);
977: dbms_sql.column_value(p_cur_get_REPH, 4, X_REPH_Rec.EVENT_CODE);
978: dbms_sql.column_value(p_cur_get_REPH, 5, X_REPH_Rec.EVENT_MEANING);
979: dbms_sql.column_value(p_cur_get_REPH, 6, X_REPH_Rec.EVENT_DATE);
980: dbms_sql.column_value(p_cur_get_REPH, 7, X_REPH_Rec.QUANTITY);
981: dbms_sql.column_value(p_cur_get_REPH, 8, X_REPH_Rec.PARAMN1);

Line 978: dbms_sql.column_value(p_cur_get_REPH, 5, X_REPH_Rec.EVENT_MEANING);

974: dbms_sql.column_value(p_cur_get_REPH, 1, X_REPH_Rec.REPAIR_HISTORY_ID);
975: dbms_sql.column_value(p_cur_get_REPH, 2, X_REPH_Rec.REQUEST_ID);
976: dbms_sql.column_value(p_cur_get_REPH, 3, X_REPH_Rec.REPAIR_LINE_ID);
977: dbms_sql.column_value(p_cur_get_REPH, 4, X_REPH_Rec.EVENT_CODE);
978: dbms_sql.column_value(p_cur_get_REPH, 5, X_REPH_Rec.EVENT_MEANING);
979: dbms_sql.column_value(p_cur_get_REPH, 6, X_REPH_Rec.EVENT_DATE);
980: dbms_sql.column_value(p_cur_get_REPH, 7, X_REPH_Rec.QUANTITY);
981: dbms_sql.column_value(p_cur_get_REPH, 8, X_REPH_Rec.PARAMN1);
982: dbms_sql.column_value(p_cur_get_REPH, 9, X_REPH_Rec.PARAMN2);

Line 979: dbms_sql.column_value(p_cur_get_REPH, 6, X_REPH_Rec.EVENT_DATE);

975: dbms_sql.column_value(p_cur_get_REPH, 2, X_REPH_Rec.REQUEST_ID);
976: dbms_sql.column_value(p_cur_get_REPH, 3, X_REPH_Rec.REPAIR_LINE_ID);
977: dbms_sql.column_value(p_cur_get_REPH, 4, X_REPH_Rec.EVENT_CODE);
978: dbms_sql.column_value(p_cur_get_REPH, 5, X_REPH_Rec.EVENT_MEANING);
979: dbms_sql.column_value(p_cur_get_REPH, 6, X_REPH_Rec.EVENT_DATE);
980: dbms_sql.column_value(p_cur_get_REPH, 7, X_REPH_Rec.QUANTITY);
981: dbms_sql.column_value(p_cur_get_REPH, 8, X_REPH_Rec.PARAMN1);
982: dbms_sql.column_value(p_cur_get_REPH, 9, X_REPH_Rec.PARAMN2);
983: dbms_sql.column_value(p_cur_get_REPH, 10, X_REPH_Rec.PARAMN3);

Line 980: dbms_sql.column_value(p_cur_get_REPH, 7, X_REPH_Rec.QUANTITY);

976: dbms_sql.column_value(p_cur_get_REPH, 3, X_REPH_Rec.REPAIR_LINE_ID);
977: dbms_sql.column_value(p_cur_get_REPH, 4, X_REPH_Rec.EVENT_CODE);
978: dbms_sql.column_value(p_cur_get_REPH, 5, X_REPH_Rec.EVENT_MEANING);
979: dbms_sql.column_value(p_cur_get_REPH, 6, X_REPH_Rec.EVENT_DATE);
980: dbms_sql.column_value(p_cur_get_REPH, 7, X_REPH_Rec.QUANTITY);
981: dbms_sql.column_value(p_cur_get_REPH, 8, X_REPH_Rec.PARAMN1);
982: dbms_sql.column_value(p_cur_get_REPH, 9, X_REPH_Rec.PARAMN2);
983: dbms_sql.column_value(p_cur_get_REPH, 10, X_REPH_Rec.PARAMN3);
984: dbms_sql.column_value(p_cur_get_REPH, 11, X_REPH_Rec.PARAMN4);

Line 981: dbms_sql.column_value(p_cur_get_REPH, 8, X_REPH_Rec.PARAMN1);

977: dbms_sql.column_value(p_cur_get_REPH, 4, X_REPH_Rec.EVENT_CODE);
978: dbms_sql.column_value(p_cur_get_REPH, 5, X_REPH_Rec.EVENT_MEANING);
979: dbms_sql.column_value(p_cur_get_REPH, 6, X_REPH_Rec.EVENT_DATE);
980: dbms_sql.column_value(p_cur_get_REPH, 7, X_REPH_Rec.QUANTITY);
981: dbms_sql.column_value(p_cur_get_REPH, 8, X_REPH_Rec.PARAMN1);
982: dbms_sql.column_value(p_cur_get_REPH, 9, X_REPH_Rec.PARAMN2);
983: dbms_sql.column_value(p_cur_get_REPH, 10, X_REPH_Rec.PARAMN3);
984: dbms_sql.column_value(p_cur_get_REPH, 11, X_REPH_Rec.PARAMN4);
985: dbms_sql.column_value(p_cur_get_REPH, 12, X_REPH_Rec.PARAMN5);

Line 982: dbms_sql.column_value(p_cur_get_REPH, 9, X_REPH_Rec.PARAMN2);

978: dbms_sql.column_value(p_cur_get_REPH, 5, X_REPH_Rec.EVENT_MEANING);
979: dbms_sql.column_value(p_cur_get_REPH, 6, X_REPH_Rec.EVENT_DATE);
980: dbms_sql.column_value(p_cur_get_REPH, 7, X_REPH_Rec.QUANTITY);
981: dbms_sql.column_value(p_cur_get_REPH, 8, X_REPH_Rec.PARAMN1);
982: dbms_sql.column_value(p_cur_get_REPH, 9, X_REPH_Rec.PARAMN2);
983: dbms_sql.column_value(p_cur_get_REPH, 10, X_REPH_Rec.PARAMN3);
984: dbms_sql.column_value(p_cur_get_REPH, 11, X_REPH_Rec.PARAMN4);
985: dbms_sql.column_value(p_cur_get_REPH, 12, X_REPH_Rec.PARAMN5);
986: dbms_sql.column_value(p_cur_get_REPH, 13, X_REPH_Rec.PARAMN6);

Line 983: dbms_sql.column_value(p_cur_get_REPH, 10, X_REPH_Rec.PARAMN3);

979: dbms_sql.column_value(p_cur_get_REPH, 6, X_REPH_Rec.EVENT_DATE);
980: dbms_sql.column_value(p_cur_get_REPH, 7, X_REPH_Rec.QUANTITY);
981: dbms_sql.column_value(p_cur_get_REPH, 8, X_REPH_Rec.PARAMN1);
982: dbms_sql.column_value(p_cur_get_REPH, 9, X_REPH_Rec.PARAMN2);
983: dbms_sql.column_value(p_cur_get_REPH, 10, X_REPH_Rec.PARAMN3);
984: dbms_sql.column_value(p_cur_get_REPH, 11, X_REPH_Rec.PARAMN4);
985: dbms_sql.column_value(p_cur_get_REPH, 12, X_REPH_Rec.PARAMN5);
986: dbms_sql.column_value(p_cur_get_REPH, 13, X_REPH_Rec.PARAMN6);
987: dbms_sql.column_value(p_cur_get_REPH, 14, X_REPH_Rec.PARAMN7);

Line 984: dbms_sql.column_value(p_cur_get_REPH, 11, X_REPH_Rec.PARAMN4);

980: dbms_sql.column_value(p_cur_get_REPH, 7, X_REPH_Rec.QUANTITY);
981: dbms_sql.column_value(p_cur_get_REPH, 8, X_REPH_Rec.PARAMN1);
982: dbms_sql.column_value(p_cur_get_REPH, 9, X_REPH_Rec.PARAMN2);
983: dbms_sql.column_value(p_cur_get_REPH, 10, X_REPH_Rec.PARAMN3);
984: dbms_sql.column_value(p_cur_get_REPH, 11, X_REPH_Rec.PARAMN4);
985: dbms_sql.column_value(p_cur_get_REPH, 12, X_REPH_Rec.PARAMN5);
986: dbms_sql.column_value(p_cur_get_REPH, 13, X_REPH_Rec.PARAMN6);
987: dbms_sql.column_value(p_cur_get_REPH, 14, X_REPH_Rec.PARAMN7);
988: dbms_sql.column_value(p_cur_get_REPH, 15, X_REPH_Rec.PARAMN8);

Line 985: dbms_sql.column_value(p_cur_get_REPH, 12, X_REPH_Rec.PARAMN5);

981: dbms_sql.column_value(p_cur_get_REPH, 8, X_REPH_Rec.PARAMN1);
982: dbms_sql.column_value(p_cur_get_REPH, 9, X_REPH_Rec.PARAMN2);
983: dbms_sql.column_value(p_cur_get_REPH, 10, X_REPH_Rec.PARAMN3);
984: dbms_sql.column_value(p_cur_get_REPH, 11, X_REPH_Rec.PARAMN4);
985: dbms_sql.column_value(p_cur_get_REPH, 12, X_REPH_Rec.PARAMN5);
986: dbms_sql.column_value(p_cur_get_REPH, 13, X_REPH_Rec.PARAMN6);
987: dbms_sql.column_value(p_cur_get_REPH, 14, X_REPH_Rec.PARAMN7);
988: dbms_sql.column_value(p_cur_get_REPH, 15, X_REPH_Rec.PARAMN8);
989: dbms_sql.column_value(p_cur_get_REPH, 16, X_REPH_Rec.PARAMN9);

Line 986: dbms_sql.column_value(p_cur_get_REPH, 13, X_REPH_Rec.PARAMN6);

982: dbms_sql.column_value(p_cur_get_REPH, 9, X_REPH_Rec.PARAMN2);
983: dbms_sql.column_value(p_cur_get_REPH, 10, X_REPH_Rec.PARAMN3);
984: dbms_sql.column_value(p_cur_get_REPH, 11, X_REPH_Rec.PARAMN4);
985: dbms_sql.column_value(p_cur_get_REPH, 12, X_REPH_Rec.PARAMN5);
986: dbms_sql.column_value(p_cur_get_REPH, 13, X_REPH_Rec.PARAMN6);
987: dbms_sql.column_value(p_cur_get_REPH, 14, X_REPH_Rec.PARAMN7);
988: dbms_sql.column_value(p_cur_get_REPH, 15, X_REPH_Rec.PARAMN8);
989: dbms_sql.column_value(p_cur_get_REPH, 16, X_REPH_Rec.PARAMN9);
990: dbms_sql.column_value(p_cur_get_REPH, 17, X_REPH_Rec.PARAMN10);

Line 987: dbms_sql.column_value(p_cur_get_REPH, 14, X_REPH_Rec.PARAMN7);

983: dbms_sql.column_value(p_cur_get_REPH, 10, X_REPH_Rec.PARAMN3);
984: dbms_sql.column_value(p_cur_get_REPH, 11, X_REPH_Rec.PARAMN4);
985: dbms_sql.column_value(p_cur_get_REPH, 12, X_REPH_Rec.PARAMN5);
986: dbms_sql.column_value(p_cur_get_REPH, 13, X_REPH_Rec.PARAMN6);
987: dbms_sql.column_value(p_cur_get_REPH, 14, X_REPH_Rec.PARAMN7);
988: dbms_sql.column_value(p_cur_get_REPH, 15, X_REPH_Rec.PARAMN8);
989: dbms_sql.column_value(p_cur_get_REPH, 16, X_REPH_Rec.PARAMN9);
990: dbms_sql.column_value(p_cur_get_REPH, 17, X_REPH_Rec.PARAMN10);
991: dbms_sql.column_value(p_cur_get_REPH, 18, X_REPH_Rec.PARAMC1);

Line 988: dbms_sql.column_value(p_cur_get_REPH, 15, X_REPH_Rec.PARAMN8);

984: dbms_sql.column_value(p_cur_get_REPH, 11, X_REPH_Rec.PARAMN4);
985: dbms_sql.column_value(p_cur_get_REPH, 12, X_REPH_Rec.PARAMN5);
986: dbms_sql.column_value(p_cur_get_REPH, 13, X_REPH_Rec.PARAMN6);
987: dbms_sql.column_value(p_cur_get_REPH, 14, X_REPH_Rec.PARAMN7);
988: dbms_sql.column_value(p_cur_get_REPH, 15, X_REPH_Rec.PARAMN8);
989: dbms_sql.column_value(p_cur_get_REPH, 16, X_REPH_Rec.PARAMN9);
990: dbms_sql.column_value(p_cur_get_REPH, 17, X_REPH_Rec.PARAMN10);
991: dbms_sql.column_value(p_cur_get_REPH, 18, X_REPH_Rec.PARAMC1);
992: dbms_sql.column_value(p_cur_get_REPH, 19, X_REPH_Rec.PARAMC2);

Line 989: dbms_sql.column_value(p_cur_get_REPH, 16, X_REPH_Rec.PARAMN9);

985: dbms_sql.column_value(p_cur_get_REPH, 12, X_REPH_Rec.PARAMN5);
986: dbms_sql.column_value(p_cur_get_REPH, 13, X_REPH_Rec.PARAMN6);
987: dbms_sql.column_value(p_cur_get_REPH, 14, X_REPH_Rec.PARAMN7);
988: dbms_sql.column_value(p_cur_get_REPH, 15, X_REPH_Rec.PARAMN8);
989: dbms_sql.column_value(p_cur_get_REPH, 16, X_REPH_Rec.PARAMN9);
990: dbms_sql.column_value(p_cur_get_REPH, 17, X_REPH_Rec.PARAMN10);
991: dbms_sql.column_value(p_cur_get_REPH, 18, X_REPH_Rec.PARAMC1);
992: dbms_sql.column_value(p_cur_get_REPH, 19, X_REPH_Rec.PARAMC2);
993: dbms_sql.column_value(p_cur_get_REPH, 20, X_REPH_Rec.PARAMC3);

Line 990: dbms_sql.column_value(p_cur_get_REPH, 17, X_REPH_Rec.PARAMN10);

986: dbms_sql.column_value(p_cur_get_REPH, 13, X_REPH_Rec.PARAMN6);
987: dbms_sql.column_value(p_cur_get_REPH, 14, X_REPH_Rec.PARAMN7);
988: dbms_sql.column_value(p_cur_get_REPH, 15, X_REPH_Rec.PARAMN8);
989: dbms_sql.column_value(p_cur_get_REPH, 16, X_REPH_Rec.PARAMN9);
990: dbms_sql.column_value(p_cur_get_REPH, 17, X_REPH_Rec.PARAMN10);
991: dbms_sql.column_value(p_cur_get_REPH, 18, X_REPH_Rec.PARAMC1);
992: dbms_sql.column_value(p_cur_get_REPH, 19, X_REPH_Rec.PARAMC2);
993: dbms_sql.column_value(p_cur_get_REPH, 20, X_REPH_Rec.PARAMC3);
994: dbms_sql.column_value(p_cur_get_REPH, 21, X_REPH_Rec.PARAMC4);

Line 991: dbms_sql.column_value(p_cur_get_REPH, 18, X_REPH_Rec.PARAMC1);

987: dbms_sql.column_value(p_cur_get_REPH, 14, X_REPH_Rec.PARAMN7);
988: dbms_sql.column_value(p_cur_get_REPH, 15, X_REPH_Rec.PARAMN8);
989: dbms_sql.column_value(p_cur_get_REPH, 16, X_REPH_Rec.PARAMN9);
990: dbms_sql.column_value(p_cur_get_REPH, 17, X_REPH_Rec.PARAMN10);
991: dbms_sql.column_value(p_cur_get_REPH, 18, X_REPH_Rec.PARAMC1);
992: dbms_sql.column_value(p_cur_get_REPH, 19, X_REPH_Rec.PARAMC2);
993: dbms_sql.column_value(p_cur_get_REPH, 20, X_REPH_Rec.PARAMC3);
994: dbms_sql.column_value(p_cur_get_REPH, 21, X_REPH_Rec.PARAMC4);
995: dbms_sql.column_value(p_cur_get_REPH, 22, X_REPH_Rec.PARAMC5);

Line 992: dbms_sql.column_value(p_cur_get_REPH, 19, X_REPH_Rec.PARAMC2);

988: dbms_sql.column_value(p_cur_get_REPH, 15, X_REPH_Rec.PARAMN8);
989: dbms_sql.column_value(p_cur_get_REPH, 16, X_REPH_Rec.PARAMN9);
990: dbms_sql.column_value(p_cur_get_REPH, 17, X_REPH_Rec.PARAMN10);
991: dbms_sql.column_value(p_cur_get_REPH, 18, X_REPH_Rec.PARAMC1);
992: dbms_sql.column_value(p_cur_get_REPH, 19, X_REPH_Rec.PARAMC2);
993: dbms_sql.column_value(p_cur_get_REPH, 20, X_REPH_Rec.PARAMC3);
994: dbms_sql.column_value(p_cur_get_REPH, 21, X_REPH_Rec.PARAMC4);
995: dbms_sql.column_value(p_cur_get_REPH, 22, X_REPH_Rec.PARAMC5);
996: dbms_sql.column_value(p_cur_get_REPH, 23, X_REPH_Rec.PARAMC6);

Line 993: dbms_sql.column_value(p_cur_get_REPH, 20, X_REPH_Rec.PARAMC3);

989: dbms_sql.column_value(p_cur_get_REPH, 16, X_REPH_Rec.PARAMN9);
990: dbms_sql.column_value(p_cur_get_REPH, 17, X_REPH_Rec.PARAMN10);
991: dbms_sql.column_value(p_cur_get_REPH, 18, X_REPH_Rec.PARAMC1);
992: dbms_sql.column_value(p_cur_get_REPH, 19, X_REPH_Rec.PARAMC2);
993: dbms_sql.column_value(p_cur_get_REPH, 20, X_REPH_Rec.PARAMC3);
994: dbms_sql.column_value(p_cur_get_REPH, 21, X_REPH_Rec.PARAMC4);
995: dbms_sql.column_value(p_cur_get_REPH, 22, X_REPH_Rec.PARAMC5);
996: dbms_sql.column_value(p_cur_get_REPH, 23, X_REPH_Rec.PARAMC6);
997: dbms_sql.column_value(p_cur_get_REPH, 24, X_REPH_Rec.PARAMC7);

Line 994: dbms_sql.column_value(p_cur_get_REPH, 21, X_REPH_Rec.PARAMC4);

990: dbms_sql.column_value(p_cur_get_REPH, 17, X_REPH_Rec.PARAMN10);
991: dbms_sql.column_value(p_cur_get_REPH, 18, X_REPH_Rec.PARAMC1);
992: dbms_sql.column_value(p_cur_get_REPH, 19, X_REPH_Rec.PARAMC2);
993: dbms_sql.column_value(p_cur_get_REPH, 20, X_REPH_Rec.PARAMC3);
994: dbms_sql.column_value(p_cur_get_REPH, 21, X_REPH_Rec.PARAMC4);
995: dbms_sql.column_value(p_cur_get_REPH, 22, X_REPH_Rec.PARAMC5);
996: dbms_sql.column_value(p_cur_get_REPH, 23, X_REPH_Rec.PARAMC6);
997: dbms_sql.column_value(p_cur_get_REPH, 24, X_REPH_Rec.PARAMC7);
998: dbms_sql.column_value(p_cur_get_REPH, 25, X_REPH_Rec.PARAMC8);

Line 995: dbms_sql.column_value(p_cur_get_REPH, 22, X_REPH_Rec.PARAMC5);

991: dbms_sql.column_value(p_cur_get_REPH, 18, X_REPH_Rec.PARAMC1);
992: dbms_sql.column_value(p_cur_get_REPH, 19, X_REPH_Rec.PARAMC2);
993: dbms_sql.column_value(p_cur_get_REPH, 20, X_REPH_Rec.PARAMC3);
994: dbms_sql.column_value(p_cur_get_REPH, 21, X_REPH_Rec.PARAMC4);
995: dbms_sql.column_value(p_cur_get_REPH, 22, X_REPH_Rec.PARAMC5);
996: dbms_sql.column_value(p_cur_get_REPH, 23, X_REPH_Rec.PARAMC6);
997: dbms_sql.column_value(p_cur_get_REPH, 24, X_REPH_Rec.PARAMC7);
998: dbms_sql.column_value(p_cur_get_REPH, 25, X_REPH_Rec.PARAMC8);
999: dbms_sql.column_value(p_cur_get_REPH, 26, X_REPH_Rec.PARAMC9);

Line 996: dbms_sql.column_value(p_cur_get_REPH, 23, X_REPH_Rec.PARAMC6);

992: dbms_sql.column_value(p_cur_get_REPH, 19, X_REPH_Rec.PARAMC2);
993: dbms_sql.column_value(p_cur_get_REPH, 20, X_REPH_Rec.PARAMC3);
994: dbms_sql.column_value(p_cur_get_REPH, 21, X_REPH_Rec.PARAMC4);
995: dbms_sql.column_value(p_cur_get_REPH, 22, X_REPH_Rec.PARAMC5);
996: dbms_sql.column_value(p_cur_get_REPH, 23, X_REPH_Rec.PARAMC6);
997: dbms_sql.column_value(p_cur_get_REPH, 24, X_REPH_Rec.PARAMC7);
998: dbms_sql.column_value(p_cur_get_REPH, 25, X_REPH_Rec.PARAMC8);
999: dbms_sql.column_value(p_cur_get_REPH, 26, X_REPH_Rec.PARAMC9);
1000: dbms_sql.column_value(p_cur_get_REPH, 27, X_REPH_Rec.PARAMC10);

Line 997: dbms_sql.column_value(p_cur_get_REPH, 24, X_REPH_Rec.PARAMC7);

993: dbms_sql.column_value(p_cur_get_REPH, 20, X_REPH_Rec.PARAMC3);
994: dbms_sql.column_value(p_cur_get_REPH, 21, X_REPH_Rec.PARAMC4);
995: dbms_sql.column_value(p_cur_get_REPH, 22, X_REPH_Rec.PARAMC5);
996: dbms_sql.column_value(p_cur_get_REPH, 23, X_REPH_Rec.PARAMC6);
997: dbms_sql.column_value(p_cur_get_REPH, 24, X_REPH_Rec.PARAMC7);
998: dbms_sql.column_value(p_cur_get_REPH, 25, X_REPH_Rec.PARAMC8);
999: dbms_sql.column_value(p_cur_get_REPH, 26, X_REPH_Rec.PARAMC9);
1000: dbms_sql.column_value(p_cur_get_REPH, 27, X_REPH_Rec.PARAMC10);
1001: dbms_sql.column_value(p_cur_get_REPH, 28, X_REPH_Rec.PARAMD1);

Line 998: dbms_sql.column_value(p_cur_get_REPH, 25, X_REPH_Rec.PARAMC8);

994: dbms_sql.column_value(p_cur_get_REPH, 21, X_REPH_Rec.PARAMC4);
995: dbms_sql.column_value(p_cur_get_REPH, 22, X_REPH_Rec.PARAMC5);
996: dbms_sql.column_value(p_cur_get_REPH, 23, X_REPH_Rec.PARAMC6);
997: dbms_sql.column_value(p_cur_get_REPH, 24, X_REPH_Rec.PARAMC7);
998: dbms_sql.column_value(p_cur_get_REPH, 25, X_REPH_Rec.PARAMC8);
999: dbms_sql.column_value(p_cur_get_REPH, 26, X_REPH_Rec.PARAMC9);
1000: dbms_sql.column_value(p_cur_get_REPH, 27, X_REPH_Rec.PARAMC10);
1001: dbms_sql.column_value(p_cur_get_REPH, 28, X_REPH_Rec.PARAMD1);
1002: dbms_sql.column_value(p_cur_get_REPH, 29, X_REPH_Rec.PARAMD2);

Line 999: dbms_sql.column_value(p_cur_get_REPH, 26, X_REPH_Rec.PARAMC9);

995: dbms_sql.column_value(p_cur_get_REPH, 22, X_REPH_Rec.PARAMC5);
996: dbms_sql.column_value(p_cur_get_REPH, 23, X_REPH_Rec.PARAMC6);
997: dbms_sql.column_value(p_cur_get_REPH, 24, X_REPH_Rec.PARAMC7);
998: dbms_sql.column_value(p_cur_get_REPH, 25, X_REPH_Rec.PARAMC8);
999: dbms_sql.column_value(p_cur_get_REPH, 26, X_REPH_Rec.PARAMC9);
1000: dbms_sql.column_value(p_cur_get_REPH, 27, X_REPH_Rec.PARAMC10);
1001: dbms_sql.column_value(p_cur_get_REPH, 28, X_REPH_Rec.PARAMD1);
1002: dbms_sql.column_value(p_cur_get_REPH, 29, X_REPH_Rec.PARAMD2);
1003: dbms_sql.column_value(p_cur_get_REPH, 30, X_REPH_Rec.PARAMD3);

Line 1000: dbms_sql.column_value(p_cur_get_REPH, 27, X_REPH_Rec.PARAMC10);

996: dbms_sql.column_value(p_cur_get_REPH, 23, X_REPH_Rec.PARAMC6);
997: dbms_sql.column_value(p_cur_get_REPH, 24, X_REPH_Rec.PARAMC7);
998: dbms_sql.column_value(p_cur_get_REPH, 25, X_REPH_Rec.PARAMC8);
999: dbms_sql.column_value(p_cur_get_REPH, 26, X_REPH_Rec.PARAMC9);
1000: dbms_sql.column_value(p_cur_get_REPH, 27, X_REPH_Rec.PARAMC10);
1001: dbms_sql.column_value(p_cur_get_REPH, 28, X_REPH_Rec.PARAMD1);
1002: dbms_sql.column_value(p_cur_get_REPH, 29, X_REPH_Rec.PARAMD2);
1003: dbms_sql.column_value(p_cur_get_REPH, 30, X_REPH_Rec.PARAMD3);
1004: dbms_sql.column_value(p_cur_get_REPH, 31, X_REPH_Rec.PARAMD4);

Line 1001: dbms_sql.column_value(p_cur_get_REPH, 28, X_REPH_Rec.PARAMD1);

997: dbms_sql.column_value(p_cur_get_REPH, 24, X_REPH_Rec.PARAMC7);
998: dbms_sql.column_value(p_cur_get_REPH, 25, X_REPH_Rec.PARAMC8);
999: dbms_sql.column_value(p_cur_get_REPH, 26, X_REPH_Rec.PARAMC9);
1000: dbms_sql.column_value(p_cur_get_REPH, 27, X_REPH_Rec.PARAMC10);
1001: dbms_sql.column_value(p_cur_get_REPH, 28, X_REPH_Rec.PARAMD1);
1002: dbms_sql.column_value(p_cur_get_REPH, 29, X_REPH_Rec.PARAMD2);
1003: dbms_sql.column_value(p_cur_get_REPH, 30, X_REPH_Rec.PARAMD3);
1004: dbms_sql.column_value(p_cur_get_REPH, 31, X_REPH_Rec.PARAMD4);
1005: dbms_sql.column_value(p_cur_get_REPH, 32, X_REPH_Rec.PARAMD5);

Line 1002: dbms_sql.column_value(p_cur_get_REPH, 29, X_REPH_Rec.PARAMD2);

998: dbms_sql.column_value(p_cur_get_REPH, 25, X_REPH_Rec.PARAMC8);
999: dbms_sql.column_value(p_cur_get_REPH, 26, X_REPH_Rec.PARAMC9);
1000: dbms_sql.column_value(p_cur_get_REPH, 27, X_REPH_Rec.PARAMC10);
1001: dbms_sql.column_value(p_cur_get_REPH, 28, X_REPH_Rec.PARAMD1);
1002: dbms_sql.column_value(p_cur_get_REPH, 29, X_REPH_Rec.PARAMD2);
1003: dbms_sql.column_value(p_cur_get_REPH, 30, X_REPH_Rec.PARAMD3);
1004: dbms_sql.column_value(p_cur_get_REPH, 31, X_REPH_Rec.PARAMD4);
1005: dbms_sql.column_value(p_cur_get_REPH, 32, X_REPH_Rec.PARAMD5);
1006: dbms_sql.column_value(p_cur_get_REPH, 33, X_REPH_Rec.PARAMD6);

Line 1003: dbms_sql.column_value(p_cur_get_REPH, 30, X_REPH_Rec.PARAMD3);

999: dbms_sql.column_value(p_cur_get_REPH, 26, X_REPH_Rec.PARAMC9);
1000: dbms_sql.column_value(p_cur_get_REPH, 27, X_REPH_Rec.PARAMC10);
1001: dbms_sql.column_value(p_cur_get_REPH, 28, X_REPH_Rec.PARAMD1);
1002: dbms_sql.column_value(p_cur_get_REPH, 29, X_REPH_Rec.PARAMD2);
1003: dbms_sql.column_value(p_cur_get_REPH, 30, X_REPH_Rec.PARAMD3);
1004: dbms_sql.column_value(p_cur_get_REPH, 31, X_REPH_Rec.PARAMD4);
1005: dbms_sql.column_value(p_cur_get_REPH, 32, X_REPH_Rec.PARAMD5);
1006: dbms_sql.column_value(p_cur_get_REPH, 33, X_REPH_Rec.PARAMD6);
1007: dbms_sql.column_value(p_cur_get_REPH, 34, X_REPH_Rec.PARAMD7);

Line 1004: dbms_sql.column_value(p_cur_get_REPH, 31, X_REPH_Rec.PARAMD4);

1000: dbms_sql.column_value(p_cur_get_REPH, 27, X_REPH_Rec.PARAMC10);
1001: dbms_sql.column_value(p_cur_get_REPH, 28, X_REPH_Rec.PARAMD1);
1002: dbms_sql.column_value(p_cur_get_REPH, 29, X_REPH_Rec.PARAMD2);
1003: dbms_sql.column_value(p_cur_get_REPH, 30, X_REPH_Rec.PARAMD3);
1004: dbms_sql.column_value(p_cur_get_REPH, 31, X_REPH_Rec.PARAMD4);
1005: dbms_sql.column_value(p_cur_get_REPH, 32, X_REPH_Rec.PARAMD5);
1006: dbms_sql.column_value(p_cur_get_REPH, 33, X_REPH_Rec.PARAMD6);
1007: dbms_sql.column_value(p_cur_get_REPH, 34, X_REPH_Rec.PARAMD7);
1008: dbms_sql.column_value(p_cur_get_REPH, 35, X_REPH_Rec.PARAMD8);

Line 1005: dbms_sql.column_value(p_cur_get_REPH, 32, X_REPH_Rec.PARAMD5);

1001: dbms_sql.column_value(p_cur_get_REPH, 28, X_REPH_Rec.PARAMD1);
1002: dbms_sql.column_value(p_cur_get_REPH, 29, X_REPH_Rec.PARAMD2);
1003: dbms_sql.column_value(p_cur_get_REPH, 30, X_REPH_Rec.PARAMD3);
1004: dbms_sql.column_value(p_cur_get_REPH, 31, X_REPH_Rec.PARAMD4);
1005: dbms_sql.column_value(p_cur_get_REPH, 32, X_REPH_Rec.PARAMD5);
1006: dbms_sql.column_value(p_cur_get_REPH, 33, X_REPH_Rec.PARAMD6);
1007: dbms_sql.column_value(p_cur_get_REPH, 34, X_REPH_Rec.PARAMD7);
1008: dbms_sql.column_value(p_cur_get_REPH, 35, X_REPH_Rec.PARAMD8);
1009: dbms_sql.column_value(p_cur_get_REPH, 36, X_REPH_Rec.PARAMD9);

Line 1006: dbms_sql.column_value(p_cur_get_REPH, 33, X_REPH_Rec.PARAMD6);

1002: dbms_sql.column_value(p_cur_get_REPH, 29, X_REPH_Rec.PARAMD2);
1003: dbms_sql.column_value(p_cur_get_REPH, 30, X_REPH_Rec.PARAMD3);
1004: dbms_sql.column_value(p_cur_get_REPH, 31, X_REPH_Rec.PARAMD4);
1005: dbms_sql.column_value(p_cur_get_REPH, 32, X_REPH_Rec.PARAMD5);
1006: dbms_sql.column_value(p_cur_get_REPH, 33, X_REPH_Rec.PARAMD6);
1007: dbms_sql.column_value(p_cur_get_REPH, 34, X_REPH_Rec.PARAMD7);
1008: dbms_sql.column_value(p_cur_get_REPH, 35, X_REPH_Rec.PARAMD8);
1009: dbms_sql.column_value(p_cur_get_REPH, 36, X_REPH_Rec.PARAMD9);
1010: dbms_sql.column_value(p_cur_get_REPH, 37, X_REPH_Rec.PARAMD10);

Line 1007: dbms_sql.column_value(p_cur_get_REPH, 34, X_REPH_Rec.PARAMD7);

1003: dbms_sql.column_value(p_cur_get_REPH, 30, X_REPH_Rec.PARAMD3);
1004: dbms_sql.column_value(p_cur_get_REPH, 31, X_REPH_Rec.PARAMD4);
1005: dbms_sql.column_value(p_cur_get_REPH, 32, X_REPH_Rec.PARAMD5);
1006: dbms_sql.column_value(p_cur_get_REPH, 33, X_REPH_Rec.PARAMD6);
1007: dbms_sql.column_value(p_cur_get_REPH, 34, X_REPH_Rec.PARAMD7);
1008: dbms_sql.column_value(p_cur_get_REPH, 35, X_REPH_Rec.PARAMD8);
1009: dbms_sql.column_value(p_cur_get_REPH, 36, X_REPH_Rec.PARAMD9);
1010: dbms_sql.column_value(p_cur_get_REPH, 37, X_REPH_Rec.PARAMD10);
1011: dbms_sql.column_value(p_cur_get_REPH, 38, X_REPH_Rec.ATTRIBUTE_CATEGORY);

Line 1008: dbms_sql.column_value(p_cur_get_REPH, 35, X_REPH_Rec.PARAMD8);

1004: dbms_sql.column_value(p_cur_get_REPH, 31, X_REPH_Rec.PARAMD4);
1005: dbms_sql.column_value(p_cur_get_REPH, 32, X_REPH_Rec.PARAMD5);
1006: dbms_sql.column_value(p_cur_get_REPH, 33, X_REPH_Rec.PARAMD6);
1007: dbms_sql.column_value(p_cur_get_REPH, 34, X_REPH_Rec.PARAMD7);
1008: dbms_sql.column_value(p_cur_get_REPH, 35, X_REPH_Rec.PARAMD8);
1009: dbms_sql.column_value(p_cur_get_REPH, 36, X_REPH_Rec.PARAMD9);
1010: dbms_sql.column_value(p_cur_get_REPH, 37, X_REPH_Rec.PARAMD10);
1011: dbms_sql.column_value(p_cur_get_REPH, 38, X_REPH_Rec.ATTRIBUTE_CATEGORY);
1012: dbms_sql.column_value(p_cur_get_REPH, 39, X_REPH_Rec.ATTRIBUTE1);

Line 1009: dbms_sql.column_value(p_cur_get_REPH, 36, X_REPH_Rec.PARAMD9);

1005: dbms_sql.column_value(p_cur_get_REPH, 32, X_REPH_Rec.PARAMD5);
1006: dbms_sql.column_value(p_cur_get_REPH, 33, X_REPH_Rec.PARAMD6);
1007: dbms_sql.column_value(p_cur_get_REPH, 34, X_REPH_Rec.PARAMD7);
1008: dbms_sql.column_value(p_cur_get_REPH, 35, X_REPH_Rec.PARAMD8);
1009: dbms_sql.column_value(p_cur_get_REPH, 36, X_REPH_Rec.PARAMD9);
1010: dbms_sql.column_value(p_cur_get_REPH, 37, X_REPH_Rec.PARAMD10);
1011: dbms_sql.column_value(p_cur_get_REPH, 38, X_REPH_Rec.ATTRIBUTE_CATEGORY);
1012: dbms_sql.column_value(p_cur_get_REPH, 39, X_REPH_Rec.ATTRIBUTE1);
1013: dbms_sql.column_value(p_cur_get_REPH, 40, X_REPH_Rec.ATTRIBUTE2);

Line 1010: dbms_sql.column_value(p_cur_get_REPH, 37, X_REPH_Rec.PARAMD10);

1006: dbms_sql.column_value(p_cur_get_REPH, 33, X_REPH_Rec.PARAMD6);
1007: dbms_sql.column_value(p_cur_get_REPH, 34, X_REPH_Rec.PARAMD7);
1008: dbms_sql.column_value(p_cur_get_REPH, 35, X_REPH_Rec.PARAMD8);
1009: dbms_sql.column_value(p_cur_get_REPH, 36, X_REPH_Rec.PARAMD9);
1010: dbms_sql.column_value(p_cur_get_REPH, 37, X_REPH_Rec.PARAMD10);
1011: dbms_sql.column_value(p_cur_get_REPH, 38, X_REPH_Rec.ATTRIBUTE_CATEGORY);
1012: dbms_sql.column_value(p_cur_get_REPH, 39, X_REPH_Rec.ATTRIBUTE1);
1013: dbms_sql.column_value(p_cur_get_REPH, 40, X_REPH_Rec.ATTRIBUTE2);
1014: dbms_sql.column_value(p_cur_get_REPH, 41, X_REPH_Rec.ATTRIBUTE3);

Line 1011: dbms_sql.column_value(p_cur_get_REPH, 38, X_REPH_Rec.ATTRIBUTE_CATEGORY);

1007: dbms_sql.column_value(p_cur_get_REPH, 34, X_REPH_Rec.PARAMD7);
1008: dbms_sql.column_value(p_cur_get_REPH, 35, X_REPH_Rec.PARAMD8);
1009: dbms_sql.column_value(p_cur_get_REPH, 36, X_REPH_Rec.PARAMD9);
1010: dbms_sql.column_value(p_cur_get_REPH, 37, X_REPH_Rec.PARAMD10);
1011: dbms_sql.column_value(p_cur_get_REPH, 38, X_REPH_Rec.ATTRIBUTE_CATEGORY);
1012: dbms_sql.column_value(p_cur_get_REPH, 39, X_REPH_Rec.ATTRIBUTE1);
1013: dbms_sql.column_value(p_cur_get_REPH, 40, X_REPH_Rec.ATTRIBUTE2);
1014: dbms_sql.column_value(p_cur_get_REPH, 41, X_REPH_Rec.ATTRIBUTE3);
1015: dbms_sql.column_value(p_cur_get_REPH, 42, X_REPH_Rec.ATTRIBUTE4);

Line 1012: dbms_sql.column_value(p_cur_get_REPH, 39, X_REPH_Rec.ATTRIBUTE1);

1008: dbms_sql.column_value(p_cur_get_REPH, 35, X_REPH_Rec.PARAMD8);
1009: dbms_sql.column_value(p_cur_get_REPH, 36, X_REPH_Rec.PARAMD9);
1010: dbms_sql.column_value(p_cur_get_REPH, 37, X_REPH_Rec.PARAMD10);
1011: dbms_sql.column_value(p_cur_get_REPH, 38, X_REPH_Rec.ATTRIBUTE_CATEGORY);
1012: dbms_sql.column_value(p_cur_get_REPH, 39, X_REPH_Rec.ATTRIBUTE1);
1013: dbms_sql.column_value(p_cur_get_REPH, 40, X_REPH_Rec.ATTRIBUTE2);
1014: dbms_sql.column_value(p_cur_get_REPH, 41, X_REPH_Rec.ATTRIBUTE3);
1015: dbms_sql.column_value(p_cur_get_REPH, 42, X_REPH_Rec.ATTRIBUTE4);
1016: dbms_sql.column_value(p_cur_get_REPH, 43, X_REPH_Rec.ATTRIBUTE5);

Line 1013: dbms_sql.column_value(p_cur_get_REPH, 40, X_REPH_Rec.ATTRIBUTE2);

1009: dbms_sql.column_value(p_cur_get_REPH, 36, X_REPH_Rec.PARAMD9);
1010: dbms_sql.column_value(p_cur_get_REPH, 37, X_REPH_Rec.PARAMD10);
1011: dbms_sql.column_value(p_cur_get_REPH, 38, X_REPH_Rec.ATTRIBUTE_CATEGORY);
1012: dbms_sql.column_value(p_cur_get_REPH, 39, X_REPH_Rec.ATTRIBUTE1);
1013: dbms_sql.column_value(p_cur_get_REPH, 40, X_REPH_Rec.ATTRIBUTE2);
1014: dbms_sql.column_value(p_cur_get_REPH, 41, X_REPH_Rec.ATTRIBUTE3);
1015: dbms_sql.column_value(p_cur_get_REPH, 42, X_REPH_Rec.ATTRIBUTE4);
1016: dbms_sql.column_value(p_cur_get_REPH, 43, X_REPH_Rec.ATTRIBUTE5);
1017: dbms_sql.column_value(p_cur_get_REPH, 44, X_REPH_Rec.ATTRIBUTE6);

Line 1014: dbms_sql.column_value(p_cur_get_REPH, 41, X_REPH_Rec.ATTRIBUTE3);

1010: dbms_sql.column_value(p_cur_get_REPH, 37, X_REPH_Rec.PARAMD10);
1011: dbms_sql.column_value(p_cur_get_REPH, 38, X_REPH_Rec.ATTRIBUTE_CATEGORY);
1012: dbms_sql.column_value(p_cur_get_REPH, 39, X_REPH_Rec.ATTRIBUTE1);
1013: dbms_sql.column_value(p_cur_get_REPH, 40, X_REPH_Rec.ATTRIBUTE2);
1014: dbms_sql.column_value(p_cur_get_REPH, 41, X_REPH_Rec.ATTRIBUTE3);
1015: dbms_sql.column_value(p_cur_get_REPH, 42, X_REPH_Rec.ATTRIBUTE4);
1016: dbms_sql.column_value(p_cur_get_REPH, 43, X_REPH_Rec.ATTRIBUTE5);
1017: dbms_sql.column_value(p_cur_get_REPH, 44, X_REPH_Rec.ATTRIBUTE6);
1018: dbms_sql.column_value(p_cur_get_REPH, 45, X_REPH_Rec.ATTRIBUTE7);

Line 1015: dbms_sql.column_value(p_cur_get_REPH, 42, X_REPH_Rec.ATTRIBUTE4);

1011: dbms_sql.column_value(p_cur_get_REPH, 38, X_REPH_Rec.ATTRIBUTE_CATEGORY);
1012: dbms_sql.column_value(p_cur_get_REPH, 39, X_REPH_Rec.ATTRIBUTE1);
1013: dbms_sql.column_value(p_cur_get_REPH, 40, X_REPH_Rec.ATTRIBUTE2);
1014: dbms_sql.column_value(p_cur_get_REPH, 41, X_REPH_Rec.ATTRIBUTE3);
1015: dbms_sql.column_value(p_cur_get_REPH, 42, X_REPH_Rec.ATTRIBUTE4);
1016: dbms_sql.column_value(p_cur_get_REPH, 43, X_REPH_Rec.ATTRIBUTE5);
1017: dbms_sql.column_value(p_cur_get_REPH, 44, X_REPH_Rec.ATTRIBUTE6);
1018: dbms_sql.column_value(p_cur_get_REPH, 45, X_REPH_Rec.ATTRIBUTE7);
1019: dbms_sql.column_value(p_cur_get_REPH, 46, X_REPH_Rec.ATTRIBUTE8);

Line 1016: dbms_sql.column_value(p_cur_get_REPH, 43, X_REPH_Rec.ATTRIBUTE5);

1012: dbms_sql.column_value(p_cur_get_REPH, 39, X_REPH_Rec.ATTRIBUTE1);
1013: dbms_sql.column_value(p_cur_get_REPH, 40, X_REPH_Rec.ATTRIBUTE2);
1014: dbms_sql.column_value(p_cur_get_REPH, 41, X_REPH_Rec.ATTRIBUTE3);
1015: dbms_sql.column_value(p_cur_get_REPH, 42, X_REPH_Rec.ATTRIBUTE4);
1016: dbms_sql.column_value(p_cur_get_REPH, 43, X_REPH_Rec.ATTRIBUTE5);
1017: dbms_sql.column_value(p_cur_get_REPH, 44, X_REPH_Rec.ATTRIBUTE6);
1018: dbms_sql.column_value(p_cur_get_REPH, 45, X_REPH_Rec.ATTRIBUTE7);
1019: dbms_sql.column_value(p_cur_get_REPH, 46, X_REPH_Rec.ATTRIBUTE8);
1020: dbms_sql.column_value(p_cur_get_REPH, 47, X_REPH_Rec.ATTRIBUTE9);

Line 1017: dbms_sql.column_value(p_cur_get_REPH, 44, X_REPH_Rec.ATTRIBUTE6);

1013: dbms_sql.column_value(p_cur_get_REPH, 40, X_REPH_Rec.ATTRIBUTE2);
1014: dbms_sql.column_value(p_cur_get_REPH, 41, X_REPH_Rec.ATTRIBUTE3);
1015: dbms_sql.column_value(p_cur_get_REPH, 42, X_REPH_Rec.ATTRIBUTE4);
1016: dbms_sql.column_value(p_cur_get_REPH, 43, X_REPH_Rec.ATTRIBUTE5);
1017: dbms_sql.column_value(p_cur_get_REPH, 44, X_REPH_Rec.ATTRIBUTE6);
1018: dbms_sql.column_value(p_cur_get_REPH, 45, X_REPH_Rec.ATTRIBUTE7);
1019: dbms_sql.column_value(p_cur_get_REPH, 46, X_REPH_Rec.ATTRIBUTE8);
1020: dbms_sql.column_value(p_cur_get_REPH, 47, X_REPH_Rec.ATTRIBUTE9);
1021: dbms_sql.column_value(p_cur_get_REPH, 48, X_REPH_Rec.ATTRIBUTE10);

Line 1018: dbms_sql.column_value(p_cur_get_REPH, 45, X_REPH_Rec.ATTRIBUTE7);

1014: dbms_sql.column_value(p_cur_get_REPH, 41, X_REPH_Rec.ATTRIBUTE3);
1015: dbms_sql.column_value(p_cur_get_REPH, 42, X_REPH_Rec.ATTRIBUTE4);
1016: dbms_sql.column_value(p_cur_get_REPH, 43, X_REPH_Rec.ATTRIBUTE5);
1017: dbms_sql.column_value(p_cur_get_REPH, 44, X_REPH_Rec.ATTRIBUTE6);
1018: dbms_sql.column_value(p_cur_get_REPH, 45, X_REPH_Rec.ATTRIBUTE7);
1019: dbms_sql.column_value(p_cur_get_REPH, 46, X_REPH_Rec.ATTRIBUTE8);
1020: dbms_sql.column_value(p_cur_get_REPH, 47, X_REPH_Rec.ATTRIBUTE9);
1021: dbms_sql.column_value(p_cur_get_REPH, 48, X_REPH_Rec.ATTRIBUTE10);
1022: dbms_sql.column_value(p_cur_get_REPH, 49, X_REPH_Rec.ATTRIBUTE11);

Line 1019: dbms_sql.column_value(p_cur_get_REPH, 46, X_REPH_Rec.ATTRIBUTE8);

1015: dbms_sql.column_value(p_cur_get_REPH, 42, X_REPH_Rec.ATTRIBUTE4);
1016: dbms_sql.column_value(p_cur_get_REPH, 43, X_REPH_Rec.ATTRIBUTE5);
1017: dbms_sql.column_value(p_cur_get_REPH, 44, X_REPH_Rec.ATTRIBUTE6);
1018: dbms_sql.column_value(p_cur_get_REPH, 45, X_REPH_Rec.ATTRIBUTE7);
1019: dbms_sql.column_value(p_cur_get_REPH, 46, X_REPH_Rec.ATTRIBUTE8);
1020: dbms_sql.column_value(p_cur_get_REPH, 47, X_REPH_Rec.ATTRIBUTE9);
1021: dbms_sql.column_value(p_cur_get_REPH, 48, X_REPH_Rec.ATTRIBUTE10);
1022: dbms_sql.column_value(p_cur_get_REPH, 49, X_REPH_Rec.ATTRIBUTE11);
1023: dbms_sql.column_value(p_cur_get_REPH, 50, X_REPH_Rec.ATTRIBUTE12);

Line 1020: dbms_sql.column_value(p_cur_get_REPH, 47, X_REPH_Rec.ATTRIBUTE9);

1016: dbms_sql.column_value(p_cur_get_REPH, 43, X_REPH_Rec.ATTRIBUTE5);
1017: dbms_sql.column_value(p_cur_get_REPH, 44, X_REPH_Rec.ATTRIBUTE6);
1018: dbms_sql.column_value(p_cur_get_REPH, 45, X_REPH_Rec.ATTRIBUTE7);
1019: dbms_sql.column_value(p_cur_get_REPH, 46, X_REPH_Rec.ATTRIBUTE8);
1020: dbms_sql.column_value(p_cur_get_REPH, 47, X_REPH_Rec.ATTRIBUTE9);
1021: dbms_sql.column_value(p_cur_get_REPH, 48, X_REPH_Rec.ATTRIBUTE10);
1022: dbms_sql.column_value(p_cur_get_REPH, 49, X_REPH_Rec.ATTRIBUTE11);
1023: dbms_sql.column_value(p_cur_get_REPH, 50, X_REPH_Rec.ATTRIBUTE12);
1024: dbms_sql.column_value(p_cur_get_REPH, 51, X_REPH_Rec.ATTRIBUTE13);

Line 1021: dbms_sql.column_value(p_cur_get_REPH, 48, X_REPH_Rec.ATTRIBUTE10);

1017: dbms_sql.column_value(p_cur_get_REPH, 44, X_REPH_Rec.ATTRIBUTE6);
1018: dbms_sql.column_value(p_cur_get_REPH, 45, X_REPH_Rec.ATTRIBUTE7);
1019: dbms_sql.column_value(p_cur_get_REPH, 46, X_REPH_Rec.ATTRIBUTE8);
1020: dbms_sql.column_value(p_cur_get_REPH, 47, X_REPH_Rec.ATTRIBUTE9);
1021: dbms_sql.column_value(p_cur_get_REPH, 48, X_REPH_Rec.ATTRIBUTE10);
1022: dbms_sql.column_value(p_cur_get_REPH, 49, X_REPH_Rec.ATTRIBUTE11);
1023: dbms_sql.column_value(p_cur_get_REPH, 50, X_REPH_Rec.ATTRIBUTE12);
1024: dbms_sql.column_value(p_cur_get_REPH, 51, X_REPH_Rec.ATTRIBUTE13);
1025: dbms_sql.column_value(p_cur_get_REPH, 52, X_REPH_Rec.ATTRIBUTE14);

Line 1022: dbms_sql.column_value(p_cur_get_REPH, 49, X_REPH_Rec.ATTRIBUTE11);

1018: dbms_sql.column_value(p_cur_get_REPH, 45, X_REPH_Rec.ATTRIBUTE7);
1019: dbms_sql.column_value(p_cur_get_REPH, 46, X_REPH_Rec.ATTRIBUTE8);
1020: dbms_sql.column_value(p_cur_get_REPH, 47, X_REPH_Rec.ATTRIBUTE9);
1021: dbms_sql.column_value(p_cur_get_REPH, 48, X_REPH_Rec.ATTRIBUTE10);
1022: dbms_sql.column_value(p_cur_get_REPH, 49, X_REPH_Rec.ATTRIBUTE11);
1023: dbms_sql.column_value(p_cur_get_REPH, 50, X_REPH_Rec.ATTRIBUTE12);
1024: dbms_sql.column_value(p_cur_get_REPH, 51, X_REPH_Rec.ATTRIBUTE13);
1025: dbms_sql.column_value(p_cur_get_REPH, 52, X_REPH_Rec.ATTRIBUTE14);
1026: dbms_sql.column_value(p_cur_get_REPH, 53, X_REPH_Rec.ATTRIBUTE15);

Line 1023: dbms_sql.column_value(p_cur_get_REPH, 50, X_REPH_Rec.ATTRIBUTE12);

1019: dbms_sql.column_value(p_cur_get_REPH, 46, X_REPH_Rec.ATTRIBUTE8);
1020: dbms_sql.column_value(p_cur_get_REPH, 47, X_REPH_Rec.ATTRIBUTE9);
1021: dbms_sql.column_value(p_cur_get_REPH, 48, X_REPH_Rec.ATTRIBUTE10);
1022: dbms_sql.column_value(p_cur_get_REPH, 49, X_REPH_Rec.ATTRIBUTE11);
1023: dbms_sql.column_value(p_cur_get_REPH, 50, X_REPH_Rec.ATTRIBUTE12);
1024: dbms_sql.column_value(p_cur_get_REPH, 51, X_REPH_Rec.ATTRIBUTE13);
1025: dbms_sql.column_value(p_cur_get_REPH, 52, X_REPH_Rec.ATTRIBUTE14);
1026: dbms_sql.column_value(p_cur_get_REPH, 53, X_REPH_Rec.ATTRIBUTE15);
1027: dbms_sql.column_value(p_cur_get_REPH, 54, X_REPH_Rec.OBJECT_VERSION_NUMBER);

Line 1024: dbms_sql.column_value(p_cur_get_REPH, 51, X_REPH_Rec.ATTRIBUTE13);

1020: dbms_sql.column_value(p_cur_get_REPH, 47, X_REPH_Rec.ATTRIBUTE9);
1021: dbms_sql.column_value(p_cur_get_REPH, 48, X_REPH_Rec.ATTRIBUTE10);
1022: dbms_sql.column_value(p_cur_get_REPH, 49, X_REPH_Rec.ATTRIBUTE11);
1023: dbms_sql.column_value(p_cur_get_REPH, 50, X_REPH_Rec.ATTRIBUTE12);
1024: dbms_sql.column_value(p_cur_get_REPH, 51, X_REPH_Rec.ATTRIBUTE13);
1025: dbms_sql.column_value(p_cur_get_REPH, 52, X_REPH_Rec.ATTRIBUTE14);
1026: dbms_sql.column_value(p_cur_get_REPH, 53, X_REPH_Rec.ATTRIBUTE15);
1027: dbms_sql.column_value(p_cur_get_REPH, 54, X_REPH_Rec.OBJECT_VERSION_NUMBER);
1028:

Line 1025: dbms_sql.column_value(p_cur_get_REPH, 52, X_REPH_Rec.ATTRIBUTE14);

1021: dbms_sql.column_value(p_cur_get_REPH, 48, X_REPH_Rec.ATTRIBUTE10);
1022: dbms_sql.column_value(p_cur_get_REPH, 49, X_REPH_Rec.ATTRIBUTE11);
1023: dbms_sql.column_value(p_cur_get_REPH, 50, X_REPH_Rec.ATTRIBUTE12);
1024: dbms_sql.column_value(p_cur_get_REPH, 51, X_REPH_Rec.ATTRIBUTE13);
1025: dbms_sql.column_value(p_cur_get_REPH, 52, X_REPH_Rec.ATTRIBUTE14);
1026: dbms_sql.column_value(p_cur_get_REPH, 53, X_REPH_Rec.ATTRIBUTE15);
1027: dbms_sql.column_value(p_cur_get_REPH, 54, X_REPH_Rec.OBJECT_VERSION_NUMBER);
1028:
1029: -- Debug Message

Line 1026: dbms_sql.column_value(p_cur_get_REPH, 53, X_REPH_Rec.ATTRIBUTE15);

1022: dbms_sql.column_value(p_cur_get_REPH, 49, X_REPH_Rec.ATTRIBUTE11);
1023: dbms_sql.column_value(p_cur_get_REPH, 50, X_REPH_Rec.ATTRIBUTE12);
1024: dbms_sql.column_value(p_cur_get_REPH, 51, X_REPH_Rec.ATTRIBUTE13);
1025: dbms_sql.column_value(p_cur_get_REPH, 52, X_REPH_Rec.ATTRIBUTE14);
1026: dbms_sql.column_value(p_cur_get_REPH, 53, X_REPH_Rec.ATTRIBUTE15);
1027: dbms_sql.column_value(p_cur_get_REPH, 54, X_REPH_Rec.OBJECT_VERSION_NUMBER);
1028:
1029: -- Debug Message
1030: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Get Column Values Ends');

Line 1027: dbms_sql.column_value(p_cur_get_REPH, 54, X_REPH_Rec.OBJECT_VERSION_NUMBER);

1023: dbms_sql.column_value(p_cur_get_REPH, 50, X_REPH_Rec.ATTRIBUTE12);
1024: dbms_sql.column_value(p_cur_get_REPH, 51, X_REPH_Rec.ATTRIBUTE13);
1025: dbms_sql.column_value(p_cur_get_REPH, 52, X_REPH_Rec.ATTRIBUTE14);
1026: dbms_sql.column_value(p_cur_get_REPH, 53, X_REPH_Rec.ATTRIBUTE15);
1027: dbms_sql.column_value(p_cur_get_REPH, 54, X_REPH_Rec.OBJECT_VERSION_NUMBER);
1028:
1029: -- Debug Message
1030: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Get Column Values Ends');
1031: END Get_Column_Values;

Line 1092: DBMS_SQL.BIND_VARIABLE(p_cur_get_REPH, ':p_REPAIR_HISTORY_ID', P_REPH_Rec.REPAIR_HISTORY_ID);

1088: -- The following example applies to all columns,
1089: -- developers can copy and paste them.
1090: IF( (P_REPH_Rec.REPAIR_HISTORY_ID IS NOT NULL) AND (P_REPH_Rec.REPAIR_HISTORY_ID <> FND_API.G_MISS_NUM) )
1091: THEN
1092: DBMS_SQL.BIND_VARIABLE(p_cur_get_REPH, ':p_REPAIR_HISTORY_ID', P_REPH_Rec.REPAIR_HISTORY_ID);
1093: END IF;
1094:
1095: -- Debug Message
1096: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Bind Variables Ends');

Line 1436: l_cur_get_REPH := dbms_sql.open_cursor;

1432:
1433: -- Debug Message
1434: JTF_PLSQL_API.Debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Open and Parse Cursor');
1435:
1436: l_cur_get_REPH := dbms_sql.open_cursor;
1437:
1438: -- Hint: concatenate all where clause (include flex field/line level if any applies)
1439: -- dbms_sql.parse(l_cur_get_REPH, l_select_cl || l_head_where || l_flex_where || l_lines_where
1440: -- || l_steam_where || l_order_by_cl, dbms_sql.native);

Line 1439: -- dbms_sql.parse(l_cur_get_REPH, l_select_cl || l_head_where || l_flex_where || l_lines_where

1435:
1436: l_cur_get_REPH := dbms_sql.open_cursor;
1437:
1438: -- Hint: concatenate all where clause (include flex field/line level if any applies)
1439: -- dbms_sql.parse(l_cur_get_REPH, l_select_cl || l_head_where || l_flex_where || l_lines_where
1440: -- || l_steam_where || l_order_by_cl, dbms_sql.native);
1441:
1442: -- Hint: Developer should implement Bind Variables procedure according to bind variables in the parameter list
1443: -- Bind(l_crit_REPH_rec, l_crit_exp_purchase_rec, p_start_date, p_end_date,

Line 1440: -- || l_steam_where || l_order_by_cl, dbms_sql.native);

1436: l_cur_get_REPH := dbms_sql.open_cursor;
1437:
1438: -- Hint: concatenate all where clause (include flex field/line level if any applies)
1439: -- dbms_sql.parse(l_cur_get_REPH, l_select_cl || l_head_where || l_flex_where || l_lines_where
1440: -- || l_steam_where || l_order_by_cl, dbms_sql.native);
1441:
1442: -- Hint: Developer should implement Bind Variables procedure according to bind variables in the parameter list
1443: -- Bind(l_crit_REPH_rec, l_crit_exp_purchase_rec, p_start_date, p_end_date,
1444: -- p_crit_exp_salesforce_id, p_crit_ptr_salesforce_id,

Line 1462: l_ignore := dbms_sql.execute(l_cur_get_REPH);

1458: -- Execute
1459: -- Debug Message
1460: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Execute Dsql');
1461:
1462: l_ignore := dbms_sql.execute(l_cur_get_REPH);
1463:
1464: -- Debug Message
1465: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Fetch Results');
1466:

Line 1476: IF((dbms_sql.fetch_rows(l_cur_get_REPH)>0) AND ((p_return_tot_count = FND_API.G_TRUE)

1472: LOOP
1473: -- 1. There are more rows in the cursor.
1474: -- 2. User does not care about total records, and we need to return more.
1475: -- 3. Or user cares about total number of records.
1476: IF((dbms_sql.fetch_rows(l_cur_get_REPH)>0) AND ((p_return_tot_count = FND_API.G_TRUE)
1477: OR (l_returned_rec_count 1478: THEN
1479: -- Debug Message
1480: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: found');

Line 1483: -- dbms_sql.column_value(l_cur_get_opp, 1, l_opp_rec.lead_id);

1479: -- Debug Message
1480: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: found');
1481:
1482: -- Hint: Developer need to implement this part
1483: -- dbms_sql.column_value(l_cur_get_opp, 1, l_opp_rec.lead_id);
1484: -- dbms_sql.column_value(l_cur_get_opp, 7, l_opp_rec.customer_id);
1485: -- dbms_sql.column_value(l_cur_get_opp, 8, l_opp_rec.address_id);
1486:
1487: -- Hint: Check access for this record (e.x. AS_ACCESS_PVT.Has_OpportunityAccess)

Line 1484: -- dbms_sql.column_value(l_cur_get_opp, 7, l_opp_rec.customer_id);

1480: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: found');
1481:
1482: -- Hint: Developer need to implement this part
1483: -- dbms_sql.column_value(l_cur_get_opp, 1, l_opp_rec.lead_id);
1484: -- dbms_sql.column_value(l_cur_get_opp, 7, l_opp_rec.customer_id);
1485: -- dbms_sql.column_value(l_cur_get_opp, 8, l_opp_rec.address_id);
1486:
1487: -- Hint: Check access for this record (e.x. AS_ACCESS_PVT.Has_OpportunityAccess)
1488: -- Return this particular record if

Line 1485: -- dbms_sql.column_value(l_cur_get_opp, 8, l_opp_rec.address_id);

1481:
1482: -- Hint: Developer need to implement this part
1483: -- dbms_sql.column_value(l_cur_get_opp, 1, l_opp_rec.lead_id);
1484: -- dbms_sql.column_value(l_cur_get_opp, 7, l_opp_rec.customer_id);
1485: -- dbms_sql.column_value(l_cur_get_opp, 8, l_opp_rec.address_id);
1486:
1487: -- Hint: Check access for this record (e.x. AS_ACCESS_PVT.Has_OpportunityAccess)
1488: -- Return this particular record if
1489: -- 1. The caller has access to record.