APPS.GMD_RESULTS_PUB dependencies on GMD_EVENT_SPEC_DISP

Line 129: FROM gmd_event_spec_disp e , gmd_sample_spec_disp s , gmd_sampling_events se

125: CURSOR c_get_event_spec (p_sampling_event_id NUMBER, p_sample_id NUMBER)
126: IS
127: SELECT e.event_spec_disp_id, s.disposition , e.spec_id,
128: se.sample_req_cnt, se.sample_active_cnt
129: FROM gmd_event_spec_disp e , gmd_sample_spec_disp s , gmd_sampling_events se
130: WHERE s.event_spec_disp_id = e.event_spec_disp_id
131: AND se.sampling_event_id = e.sampling_event_id
132: AND se.sampling_event_id = p_sampling_event_id
133: AND s.sample_id = p_sample_id

Line 170: FROM GMD_EVENT_SPEC_DISP

166: -- bug 2709353, odaboval added the cursor in order to get the S.E. disposition
167: CURSOR c_sample_event ( p_event_spec_disp NUMBER)
168: IS
169: SELECT disposition
170: FROM GMD_EVENT_SPEC_DISP
171: WHERE event_spec_disp_id = p_event_spec_disp
172: AND delete_mark = 0;
173:
174: /*NSRIVAST, INVCONV*/

Line 1035: FROM GMD_EVENT_SPEC_DISP

1031:
1032: CURSOR c_check_event_spec ( p_event_spec_disp NUMBER)
1033: IS
1034: SELECT 1
1035: FROM GMD_EVENT_SPEC_DISP
1036: WHERE EVENT_SPEC_DISP_ID = p_event_spec_disp
1037: AND DELETE_MARK = 0;
1038:
1039:

Line 1113: GMD_API_PUB.Log_Message('GMD_EVENT_SPEC_DISP_NULL');

1109:
1110: -- Validate event spec disp id is present and valid
1111:
1112: IF ( p_event_spec_disp_id is NULL) THEN
1113: GMD_API_PUB.Log_Message('GMD_EVENT_SPEC_DISP_NULL');
1114: RAISE FND_API.G_EXC_ERROR;
1115: END IF;
1116:
1117: -- Validate that the event_spec_disp_id is Valid