APPS.GMO_INSTRUCTION_PVT dependencies on GMO_INSTR_TASK_INSTANCE

Line 3696: FROM GMO_INSTR_TASK_INSTANCE_T

3692:
3693: CURSOR L_TEMP_TASK_EREC_CSR IS
3694: SELECT INSTRUCTION_PROCESS_ID, INSTR_TASK_SEQ, TASK_EREC_ID,
3695: TASK_IDENTIFIER, TASK_VALUE, MANUAL_ENTRY, INSTRUCTION_ID
3696: FROM GMO_INSTR_TASK_INSTANCE_T
3697: WHERE
3698: INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
3699: AND INSTRUCTION_ID = L_INSTRUCTION_ID
3700: ORDER BY INSTR_TASK_SEQ;

Line 3871: DELETE FROM GMO_INSTR_TASK_INSTANCE

3867: END LOOP;
3868: CLOSE L_TEMP_INSTR_EREC_CSR;
3869:
3870: --First delete data from instr_task_instance table
3871: DELETE FROM GMO_INSTR_TASK_INSTANCE
3872: WHERE INSTRUCTION_ID = L_INSTR_REC.INSTRUCTION_ID;
3873:
3874: OPEN L_TEMP_TASK_EREC_CSR;
3875: LOOP

Line 3879: INSERT INTO GMO_INSTR_TASK_INSTANCE

3875: LOOP
3876: FETCH L_TEMP_TASK_EREC_CSR INTO L_TASK_EREC_REC;
3877: EXIT WHEN L_TEMP_TASK_EREC_CSR%NOTFOUND;
3878:
3879: INSERT INTO GMO_INSTR_TASK_INSTANCE
3880: (
3881: INSTRUCTION_ID,
3882: INSTR_TASK_SEQ,
3883: TASK_EREC_ID,

Line 3974: -- id into the GMO_INSTR_TASK_INSTANCE_T table

3970: END SEND_INSTANCE_ACKN;
3971:
3972: -- This API is called to send the task acknowledgment
3973: -- It acknowledges the task identifier, value and e-record
3974: -- id into the GMO_INSTR_TASK_INSTANCE_T table
3975:
3976: PROCEDURE SEND_TASK_ACKN
3977: (
3978: P_INSTRUCTION_ID IN NUMBER,

Line 4053: DELETE FROM GMO_INSTR_TASK_INSTANCE_T

4049: -- Remove all previously entered manual data, and enter the new
4050: -- rows passed in current API call, this will take care of
4051: -- delete task row in case of manual entry
4052:
4053: DELETE FROM GMO_INSTR_TASK_INSTANCE_T
4054: WHERE INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID
4055: AND INSTRUCTION_ID = P_INSTRUCTION_ID
4056: AND MANUAL_ENTRY = GMO_CONSTANTS_GRP.YES;
4057:

Line 4066: INSERT INTO GMO_INSTR_TASK_INSTANCE_T

4062: --so we insert the record when either id or erecord is available
4063: IF ( (P_TASK_ERECORD_ID(I) IS NOT NULL)
4064: OR (P_TASK_IDENTIFIER(I) IS NOT NULL)) THEN
4065:
4066: INSERT INTO GMO_INSTR_TASK_INSTANCE_T
4067: (
4068: INSTRUCTION_PROCESS_ID,
4069: INSTRUCTION_ID,
4070: INSTR_TASK_SEQ,

Line 4085: GMO_INSTR_TASK_INSTANCE_S.NEXTVAL,

4081: VALUES
4082: (
4083: P_INSTRUCTION_PROCESS_ID,
4084: P_INSTRUCTION_ID,
4085: GMO_INSTR_TASK_INSTANCE_S.NEXTVAL,
4086: TO_NUMBER(P_TASK_ERECORD_ID(I),999999999999.999999),
4087: P_TASK_IDENTIFIER(I),
4088: P_TASK_VALUE(I),
4089: P_MANUAL_ENTRY,

Line 4751: FROM GMO_INSTR_TASK_INSTANCE

4747:
4748: CURSOR L_INSTR_TASK_CSR IS
4749: SELECT INSTRUCTION_ID, INSTR_TASK_SEQ, TASK_EREC_ID,
4750: TASK_IDENTIFIER, TASK_VALUE, MANUAL_ENTRY
4751: FROM GMO_INSTR_TASK_INSTANCE
4752: WHERE INSTRUCTION_ID = L_INSTRUCTION_ID;
4753:
4754: CURSOR L_INSTR_EREC_CSR IS
4755: SELECT INSTRUCTION_ID, INSTR_EREC_SEQ, INSTR_EREC_ID,

Line 4858: INSERT INTO GMO_INSTR_TASK_INSTANCE_T

4854: LOOP
4855: FETCH L_INSTR_TASK_CSR INTO L_INSTR_TASK_REC;
4856: EXIT WHEN L_INSTR_TASK_CSR%NOTFOUND;
4857:
4858: INSERT INTO GMO_INSTR_TASK_INSTANCE_T
4859: (
4860: INSTRUCTION_ID,
4861: INSTRUCTION_PROCESS_ID,
4862: INSTR_TASK_SEQ,

Line 6291: GMO_INSTR_TASK_INSTANCE TK

6287: (SELECT XMLAGG(XMLELEMENT("TASK_DETAILS",XMLFOREST(TK.TASK_EREC_ID AS TASK_ERECORD_ID,
6288: TK.TASK_IDENTIFIER AS TASK_IDENTIFIER,
6289: TK.TASK_VALUE AS TASK_VALUE)))
6290: FROM
6291: GMO_INSTR_TASK_INSTANCE TK
6292: WHERE TK.INSTRUCTION_ID = INSTR.INSTRUCTION_ID) AS TASKS
6293: )
6294: )
6295: )