APPS.CSD_REPAIR_HISTORY_PVT dependencies on DBMS_SQL

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1024: dbms_sql.column_value(p_cur_get_REPH, 47, X_REPH_Rec.ATTRIBUTE9);
1025: dbms_sql.column_value(p_cur_get_REPH, 48, X_REPH_Rec.ATTRIBUTE10);
1026: dbms_sql.column_value(p_cur_get_REPH, 49, X_REPH_Rec.ATTRIBUTE11);
1027: dbms_sql.column_value(p_cur_get_REPH, 50, X_REPH_Rec.ATTRIBUTE12);
1028: dbms_sql.column_value(p_cur_get_REPH, 51, X_REPH_Rec.ATTRIBUTE13);
1029: dbms_sql.column_value(p_cur_get_REPH, 52, X_REPH_Rec.ATTRIBUTE14);
1030: dbms_sql.column_value(p_cur_get_REPH, 53, X_REPH_Rec.ATTRIBUTE15);
1031: dbms_sql.column_value(p_cur_get_REPH, 54, X_REPH_Rec.OBJECT_VERSION_NUMBER);
1032:

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

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

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

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

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

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

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

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

Line 1440: l_cur_get_REPH := dbms_sql.open_cursor;

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

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

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

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

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

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

1462: -- Execute
1463: -- Debug Message
1464: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Execute Dsql');
1465:
1466: l_ignore := dbms_sql.execute(l_cur_get_REPH);
1467:
1468: -- Debug Message
1469: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSD', 'Private API: Fetch Results');
1470:

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

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

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

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

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

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

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

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