APPS.GMD_RESULTS_PUB dependencies on GMD_EVENT_SPEC_DISP

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

97: CURSOR c_get_event_spec (p_sampling_event_id NUMBER, p_sample_id NUMBER)
98: IS
99: SELECT e.event_spec_disp_id, s.disposition , e.spec_id,
100: se.sample_req_cnt, se.sample_active_cnt
101: FROM gmd_event_spec_disp e , gmd_sample_spec_disp s , gmd_sampling_events se
102: WHERE s.event_spec_disp_id = e.event_spec_disp_id
103: AND se.sampling_event_id = e.sampling_event_id
104: AND se.sampling_event_id = p_sampling_event_id
105: AND s.sample_id = p_sample_id

Line 122: FROM GMD_EVENT_SPEC_DISP

118: -- bug 2709353, odaboval added the cursor in order to get the S.E. disposition
119: CURSOR c_sample_event ( p_event_spec_disp NUMBER)
120: IS
121: SELECT disposition
122: FROM GMD_EVENT_SPEC_DISP
123: WHERE event_spec_disp_id = p_event_spec_disp
124: AND delete_mark = 0;
125:
126: /*NSRIVAST, INVCONV*/

Line 835: FROM GMD_EVENT_SPEC_DISP

831:
832: CURSOR c_check_event_spec ( p_event_spec_disp NUMBER)
833: IS
834: SELECT 1
835: FROM GMD_EVENT_SPEC_DISP
836: WHERE EVENT_SPEC_DISP_ID = p_event_spec_disp
837: AND DELETE_MARK = 0;
838:
839:

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

909:
910: -- Validate event spec disp id is present and valid
911:
912: IF ( p_event_spec_disp_id is NULL) THEN
913: GMD_API_PUB.Log_Message('GMD_EVENT_SPEC_DISP_NULL');
914: RAISE FND_API.G_EXC_ERROR;
915: END IF;
916:
917: -- Validate that the event_spec_disp_id is Valid