APPS.GMD_QMSMC dependencies on GMD_SAMPLING_EVENTS

Line 84: l_sampling_events GMD_SAMPLING_EVENTS%ROWTYPE;

80: L_SPEC_TYPE VARCHAR2(100) ;
81: L_RETURN_STATUS VARCHAR2(100) ;
82: L_Msg_DATA VARCHAR2(2000) ;
83:
84: l_sampling_events GMD_SAMPLING_EVENTS%ROWTYPE;
85: l_sampling_events_out GMD_SAMPLING_EVENTS%ROWTYPE;
86: l_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
87: l_event_spec_disp_out GMD_EVENT_SPEC_DISP%ROWTYPE;
88: quality_config GMD_QUALITY_CONFIG%ROWTYPE;

Line 85: l_sampling_events_out GMD_SAMPLING_EVENTS%ROWTYPE;

81: L_RETURN_STATUS VARCHAR2(100) ;
82: L_Msg_DATA VARCHAR2(2000) ;
83:
84: l_sampling_events GMD_SAMPLING_EVENTS%ROWTYPE;
85: l_sampling_events_out GMD_SAMPLING_EVENTS%ROWTYPE;
86: l_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
87: l_event_spec_disp_out GMD_EVENT_SPEC_DISP%ROWTYPE;
88: quality_config GMD_QUALITY_CONFIG%ROWTYPE;
89:

Line 870: IF NOT GMD_SAMPLING_EVENTS_PVT.insert_row (

866: /* Added missing PO Receiving information */
867: l_sampling_events.receipt_id := L_shipment_header_id;
868: l_sampling_events.receipt_line_id := L_receipt_line_id;
869:
870: IF NOT GMD_SAMPLING_EVENTS_PVT.insert_row (
871: p_sampling_events => l_sampling_events,
872: x_sampling_events => l_sampling_events_out) THEN
873: gmd_debug.put_line ('Sampling Event Creation Failed'); -- Bug # 4576699
874:

Line 1279: -- Bug 2825696: added orgn_code to gmd_sampling_events table

1275: l_sampling_events.lot_retest_ind := L_retest_indicator;
1276: l_sampling_events.sample_req_cnt := l_sample_count;
1277: l_sampling_events.sample_taken_cnt := 0;
1278: l_sampling_events.sample_type := 'I';
1279: -- Bug 2825696: added orgn_code to gmd_sampling_events table
1280: l_sampling_events.organization_id := L_organization_id;
1281: l_sampling_events.CREATION_DATE := SYSDATE;
1282: l_sampling_events.CREATED_BY := FND_GLOBAL.USER_ID;
1283: l_sampling_events.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line 1290: IF NOT GMD_SAMPLING_EVENTS_PVT.insert_row (

1286: IF (l_debug = 'Y') THEN
1287: gmd_debug.put_line('Going to insert sample event');
1288: END IF;
1289:
1290: IF NOT GMD_SAMPLING_EVENTS_PVT.insert_row (
1291: p_sampling_events => l_sampling_events,
1292: x_sampling_events => l_sampling_events_out) THEN
1293: gmd_debug.put_line ('Sampling Event Creation Failed'); -- Bug # 4576699
1294: RAISE FND_API.G_EXC_ERROR;

Line 1904: L_SAMPLING_EVENTS GMD_SAMPLING_EVENTS%ROWTYPE;

1900: aname => 'EVENT_KEY');
1901:
1902: Approver AME_UTIL.APPROVERRECORD;
1903: L_WIP_SPEC GMD_SPEC_MATCH_GRP.WIP_SPEC_REC_TYPE;
1904: L_SAMPLING_EVENTS GMD_SAMPLING_EVENTS%ROWTYPE;
1905: l_sampling_events_out GMD_SAMPLING_EVENTS%ROWTYPE;
1906: l_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
1907: l_event_spec_disp_out GMD_EVENT_SPEC_DISP%ROWTYPE;
1908: quality_config GMD_QUALITY_CONFIG%ROWTYPE;

Line 1905: l_sampling_events_out GMD_SAMPLING_EVENTS%ROWTYPE;

1901:
1902: Approver AME_UTIL.APPROVERRECORD;
1903: L_WIP_SPEC GMD_SPEC_MATCH_GRP.WIP_SPEC_REC_TYPE;
1904: L_SAMPLING_EVENTS GMD_SAMPLING_EVENTS%ROWTYPE;
1905: l_sampling_events_out GMD_SAMPLING_EVENTS%ROWTYPE;
1906: l_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
1907: l_event_spec_disp_out GMD_EVENT_SPEC_DISP%ROWTYPE;
1908: quality_config GMD_QUALITY_CONFIG%ROWTYPE;
1909:

Line 2374: IF NOT GMD_SAMPLING_EVENTS_PVT.insert_row (

2370: l_sampling_events.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2371: l_sampling_events.LAST_UPDATE_DATE := SYSDATE;
2372: --wf_log_pkg.string(6, 'Dummy','Before Creating the Sampling Event');
2373:
2374: IF NOT GMD_SAMPLING_EVENTS_PVT.insert_row (
2375: p_sampling_events => l_sampling_events,
2376: x_sampling_events => l_sampling_events_out) THEN
2377: RAISE FND_API.G_EXC_ERROR;
2378: END IF;