DBA Data[Home] [Help]

APPS.GMD_QMSMC dependencies on GMD_SAMPLING_EVENTS

Line 80: l_sampling_events GMD_SAMPLING_EVENTS%ROWTYPE;

76: L_SPEC_TYPE VARCHAR2(100);
77: L_RETURN_STATUS VARCHAR2(100);
78: L_Msg_DATA VARCHAR2(2000);
79:
80: l_sampling_events GMD_SAMPLING_EVENTS%ROWTYPE;
81: l_sampling_events_out GMD_SAMPLING_EVENTS%ROWTYPE;
82: l_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
83: l_event_spec_disp_out GMD_EVENT_SPEC_DISP%ROWTYPE;
84: quality_config GMD_QUALITY_CONFIG%ROWTYPE;

Line 81: l_sampling_events_out GMD_SAMPLING_EVENTS%ROWTYPE;

77: L_RETURN_STATUS VARCHAR2(100);
78: L_Msg_DATA VARCHAR2(2000);
79:
80: l_sampling_events GMD_SAMPLING_EVENTS%ROWTYPE;
81: l_sampling_events_out GMD_SAMPLING_EVENTS%ROWTYPE;
82: l_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
83: l_event_spec_disp_out GMD_EVENT_SPEC_DISP%ROWTYPE;
84: quality_config GMD_QUALITY_CONFIG%ROWTYPE;
85:

Line 1018: GMD_SAMPLING_EVENTS_PVT.insert_row(p_sampling_events => l_sampling_events,

1014: l_sampling_events.receipt_id := L_shipment_header_id;
1015: l_sampling_events.receipt_line_id := L_receipt_line_id;
1016:
1017: IF NOT
1018: GMD_SAMPLING_EVENTS_PVT.insert_row(p_sampling_events => l_sampling_events,
1019: x_sampling_events => l_sampling_events_out) THEN
1020: gmd_debug.put_line('Sampling Event Creation Failed'); -- Bug # 4576699
1021:
1022: --wf_log_pkg.string(6, 'Dummy','Sampling Event Creation Failed');

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

1442: l_sampling_events.lot_retest_ind := L_retest_indicator;
1443: l_sampling_events.sample_req_cnt := l_sample_count;
1444: l_sampling_events.sample_taken_cnt := 0;
1445: l_sampling_events.sample_type := 'I';
1446: -- Bug 2825696: added orgn_code to gmd_sampling_events table
1447: l_sampling_events.organization_id := L_organization_id;
1448: l_sampling_events.CREATION_DATE := SYSDATE;
1449: l_sampling_events.CREATED_BY := local_user; --Bug#6276012 replace FND_GLOBAL.USER_ID;
1450: l_sampling_events.LAST_UPDATED_BY := local_user; --Bug#6276012 replace FND_GLOBAL.USER_ID;

Line 1458: GMD_SAMPLING_EVENTS_PVT.insert_row(p_sampling_events => l_sampling_events,

1454: gmd_debug.put_line('Going to insert sample event');
1455: END IF;
1456:
1457: IF NOT
1458: GMD_SAMPLING_EVENTS_PVT.insert_row(p_sampling_events => l_sampling_events,
1459: x_sampling_events => l_sampling_events_out) THEN
1460: gmd_debug.put_line('Sampling Event Creation Failed'); -- Bug # 4576699
1461: RAISE FND_API.G_EXC_ERROR;
1462: END IF;

Line 2157: L_SAMPLING_EVENTS GMD_SAMPLING_EVENTS%ROWTYPE;

2153: aname => 'EVENT_KEY');
2154:
2155: Approver AME_UTIL.APPROVERRECORD;
2156: L_WIP_SPEC GMD_SPEC_MATCH_GRP.WIP_SPEC_REC_TYPE;
2157: L_SAMPLING_EVENTS GMD_SAMPLING_EVENTS%ROWTYPE;
2158: l_sampling_events_out GMD_SAMPLING_EVENTS%ROWTYPE;
2159: l_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
2160: l_event_spec_disp_out GMD_EVENT_SPEC_DISP%ROWTYPE;
2161: quality_config GMD_QUALITY_CONFIG%ROWTYPE;

Line 2158: l_sampling_events_out GMD_SAMPLING_EVENTS%ROWTYPE;

2154:
2155: Approver AME_UTIL.APPROVERRECORD;
2156: L_WIP_SPEC GMD_SPEC_MATCH_GRP.WIP_SPEC_REC_TYPE;
2157: L_SAMPLING_EVENTS GMD_SAMPLING_EVENTS%ROWTYPE;
2158: l_sampling_events_out GMD_SAMPLING_EVENTS%ROWTYPE;
2159: l_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;
2160: l_event_spec_disp_out GMD_EVENT_SPEC_DISP%ROWTYPE;
2161: quality_config GMD_QUALITY_CONFIG%ROWTYPE;
2162:

Line 2664: GMD_SAMPLING_EVENTS_PVT.insert_row(p_sampling_events => l_sampling_events,

2660: END IF;
2661: /* Bug No.8942353 - End */
2662:
2663: IF NOT
2664: GMD_SAMPLING_EVENTS_PVT.insert_row(p_sampling_events => l_sampling_events,
2665: x_sampling_events => l_sampling_events_out) THEN
2666: RAISE FND_API.G_EXC_ERROR;
2667: END IF;
2668: