DBA Data[Home] [Help]

APPS.GMD_QMSMC dependencies on FND_GLOBAL

Line 860: l_sampling_events.CREATED_BY := FND_GLOBAL.USER_ID;

856: l_sampling_events.lot_number := L_lot_number;
857: l_sampling_events.parent_lot_number := L_parent_lot_number;
858: l_sampling_events.organization_id := L_organization_id;
859: l_sampling_events.CREATION_DATE := SYSDATE;
860: l_sampling_events.CREATED_BY := FND_GLOBAL.USER_ID;
861: l_sampling_events.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
862: l_sampling_events.LAST_UPDATE_DATE := SYSDATE;
863: l_sampling_events.org_id := l_org_id; --RLNAGARA B5018797 Added this parameter to insert
864: l_sampling_events.supplier_lot_no := l_vendor_lot_num;

Line 861: l_sampling_events.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

857: l_sampling_events.parent_lot_number := L_parent_lot_number;
858: l_sampling_events.organization_id := L_organization_id;
859: l_sampling_events.CREATION_DATE := SYSDATE;
860: l_sampling_events.CREATED_BY := FND_GLOBAL.USER_ID;
861: l_sampling_events.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
862: l_sampling_events.LAST_UPDATE_DATE := SYSDATE;
863: l_sampling_events.org_id := l_org_id; --RLNAGARA B5018797 Added this parameter to insert
864: l_sampling_events.supplier_lot_no := l_vendor_lot_num;
865:

Line 1151: l_event_spec_disp.CREATED_BY:=FND_GLOBAL.USER_ID;

1147: l_event_spec_disp.DISPOSITION :='1P';
1148: l_event_spec_disp.SPEC_USED_FOR_LOT_ATTRIB_IND:=NULL;
1149: l_event_spec_disp.DELETE_MARK:=0;
1150: l_event_spec_disp.CREATION_DATE:=sysdate;
1151: l_event_spec_disp.CREATED_BY:=FND_GLOBAL.USER_ID;
1152: l_event_spec_disp.LAST_UPDATE_DATE:=sysdate;
1153: l_event_spec_disp.LAST_UPDATED_BY:=FND_GLOBAL.USER_ID;
1154:
1155: IF (l_debug = 'Y') THEN

Line 1153: l_event_spec_disp.LAST_UPDATED_BY:=FND_GLOBAL.USER_ID;

1149: l_event_spec_disp.DELETE_MARK:=0;
1150: l_event_spec_disp.CREATION_DATE:=sysdate;
1151: l_event_spec_disp.CREATED_BY:=FND_GLOBAL.USER_ID;
1152: l_event_spec_disp.LAST_UPDATE_DATE:=sysdate;
1153: l_event_spec_disp.LAST_UPDATED_BY:=FND_GLOBAL.USER_ID;
1154:
1155: IF (l_debug = 'Y') THEN
1156: gmd_debug.put_line('Going to insert event spec disp');
1157: END IF;

Line 1282: l_sampling_events.CREATED_BY := FND_GLOBAL.USER_ID;

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;
1284: l_sampling_events.LAST_UPDATE_DATE := SYSDATE;
1285:
1286: IF (l_debug = 'Y') THEN

Line 1283: l_sampling_events.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

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;
1284: l_sampling_events.LAST_UPDATE_DATE := SYSDATE;
1285:
1286: IF (l_debug = 'Y') THEN
1287: gmd_debug.put_line('Going to insert sample event');

Line 1530: l_event_spec_disp.CREATED_BY:=FND_GLOBAL.USER_ID;

1526: l_event_spec_disp.DISPOSITION :='1P';
1527: l_event_spec_disp.SPEC_USED_FOR_LOT_ATTRIB_IND:=NULL;
1528: l_event_spec_disp.DELETE_MARK:=0;
1529: l_event_spec_disp.CREATION_DATE:=sysdate;
1530: l_event_spec_disp.CREATED_BY:=FND_GLOBAL.USER_ID;
1531: l_event_spec_disp.LAST_UPDATE_DATE:=sysdate;
1532: l_event_spec_disp.LAST_UPDATED_BY:=FND_GLOBAL.USER_ID;
1533:
1534: IF (l_debug = 'Y') THEN

Line 1532: l_event_spec_disp.LAST_UPDATED_BY:=FND_GLOBAL.USER_ID;

1528: l_event_spec_disp.DELETE_MARK:=0;
1529: l_event_spec_disp.CREATION_DATE:=sysdate;
1530: l_event_spec_disp.CREATED_BY:=FND_GLOBAL.USER_ID;
1531: l_event_spec_disp.LAST_UPDATE_DATE:=sysdate;
1532: l_event_spec_disp.LAST_UPDATED_BY:=FND_GLOBAL.USER_ID;
1533:
1534: IF (l_debug = 'Y') THEN
1535: gmd_debug.put_line('Going to insert event spec disp');
1536: END IF;

Line 2369: l_sampling_events.CREATED_BY := FND_GLOBAL.USER_ID;

2365: l_sampling_events.oprn_id := l_oprn_id;
2366: l_sampling_events.sample_type := 'I';
2367: l_sampling_events.organization_id := L_organization_id;
2368: l_sampling_events.CREATION_DATE := SYSDATE;
2369: l_sampling_events.CREATED_BY := FND_GLOBAL.USER_ID;
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:

Line 2370: l_sampling_events.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

2366: l_sampling_events.sample_type := 'I';
2367: l_sampling_events.organization_id := L_organization_id;
2368: l_sampling_events.CREATION_DATE := SYSDATE;
2369: l_sampling_events.CREATED_BY := FND_GLOBAL.USER_ID;
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 (

Line 2564: l_event_spec_disp.CREATED_BY :=FND_GLOBAL.USER_ID;

2560: l_event_spec_disp.DISPOSITION :='1P';
2561: l_event_spec_disp.SPEC_USED_FOR_LOT_ATTRIB_IND:=NULL;
2562: l_event_spec_disp.DELETE_MARK :=0;
2563: l_event_spec_disp.CREATION_DATE :=sysdate;
2564: l_event_spec_disp.CREATED_BY :=FND_GLOBAL.USER_ID;
2565: l_event_spec_disp.LAST_UPDATE_DATE :=sysdate;
2566: l_event_spec_disp.LAST_UPDATED_BY :=FND_GLOBAL.USER_ID;
2567:
2568: IF (l_debug = 'Y') THEN

Line 2566: l_event_spec_disp.LAST_UPDATED_BY :=FND_GLOBAL.USER_ID;

2562: l_event_spec_disp.DELETE_MARK :=0;
2563: l_event_spec_disp.CREATION_DATE :=sysdate;
2564: l_event_spec_disp.CREATED_BY :=FND_GLOBAL.USER_ID;
2565: l_event_spec_disp.LAST_UPDATE_DATE :=sysdate;
2566: l_event_spec_disp.LAST_UPDATED_BY :=FND_GLOBAL.USER_ID;
2567:
2568: IF (l_debug = 'Y') THEN
2569: gmd_debug.put_line('Going to insert event spec disp');
2570: END IF;

Line 2587: fnd_global.apps_initialize( USER_ID => l_last_update_by ,

2583: END IF ; /* End of check to create event spec for non-auto sample */
2584:
2585:
2586: IF l_step_id is NOT NULL THEN
2587: fnd_global.apps_initialize( USER_ID => l_last_update_by ,
2588: resp_id =>NULL,
2589: resp_appl_id =>NULL);
2590:
2591: fnd_profile.initialize(l_last_update_by );