DBA Data[Home] [Help]

APPS.GMD_QMSMC dependencies on FND_GLOBAL

Line 999: l_sampling_events.CREATED_BY := local_user; --Bug#6276012 replace FND_GLOBAL.USER_ID;

995: l_sampling_events.locator_id := l_locator_id;
996: l_sampling_events.parent_lot_number := L_parent_lot_number;
997: l_sampling_events.organization_id := L_organization_id;
998: l_sampling_events.CREATION_DATE := SYSDATE;
999: l_sampling_events.CREATED_BY := local_user; --Bug#6276012 replace FND_GLOBAL.USER_ID;
1000: l_sampling_events.LAST_UPDATED_BY := local_user; --Bug#6276012 replace FND_GLOBAL.USER_ID;
1001: l_sampling_events.LAST_UPDATE_DATE := SYSDATE;
1002: l_sampling_events.org_id := l_org_id; --RLNAGARA B5018797 Added this parameter to insert
1003: l_sampling_events.supplier_lot_no := l_vendor_lot_num;

Line 1000: l_sampling_events.LAST_UPDATED_BY := local_user; --Bug#6276012 replace FND_GLOBAL.USER_ID;

996: l_sampling_events.parent_lot_number := L_parent_lot_number;
997: l_sampling_events.organization_id := L_organization_id;
998: l_sampling_events.CREATION_DATE := SYSDATE;
999: l_sampling_events.CREATED_BY := local_user; --Bug#6276012 replace FND_GLOBAL.USER_ID;
1000: l_sampling_events.LAST_UPDATED_BY := local_user; --Bug#6276012 replace FND_GLOBAL.USER_ID;
1001: l_sampling_events.LAST_UPDATE_DATE := SYSDATE;
1002: l_sampling_events.org_id := l_org_id; --RLNAGARA B5018797 Added this parameter to insert
1003: l_sampling_events.supplier_lot_no := l_vendor_lot_num;
1004:

Line 1328: l_event_spec_disp.CREATED_BY := local_user; --Bug#6276012 replace FND_GLOBAL.USER_ID;

1324: l_event_spec_disp.DISPOSITION := '1P';
1325: l_event_spec_disp.SPEC_USED_FOR_LOT_ATTRIB_IND := NULL;
1326: l_event_spec_disp.DELETE_MARK := 0;
1327: l_event_spec_disp.CREATION_DATE := sysdate;
1328: l_event_spec_disp.CREATED_BY := local_user; --Bug#6276012 replace FND_GLOBAL.USER_ID;
1329: l_event_spec_disp.LAST_UPDATE_DATE := sysdate;
1330: l_event_spec_disp.LAST_UPDATED_BY := local_user; --Bug#6276012 replace FND_GLOBAL.USER_ID;
1331:
1332: IF (l_debug = 'Y') THEN

Line 1330: l_event_spec_disp.LAST_UPDATED_BY := local_user; --Bug#6276012 replace FND_GLOBAL.USER_ID;

1326: l_event_spec_disp.DELETE_MARK := 0;
1327: l_event_spec_disp.CREATION_DATE := sysdate;
1328: l_event_spec_disp.CREATED_BY := local_user; --Bug#6276012 replace FND_GLOBAL.USER_ID;
1329: l_event_spec_disp.LAST_UPDATE_DATE := sysdate;
1330: l_event_spec_disp.LAST_UPDATED_BY := local_user; --Bug#6276012 replace FND_GLOBAL.USER_ID;
1331:
1332: IF (l_debug = 'Y') THEN
1333: gmd_debug.put_line('Going to insert event spec disp');
1334: END IF;

Line 1449: l_sampling_events.CREATED_BY := local_user; --Bug#6276012 replace FND_GLOBAL.USER_ID;

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;
1451: l_sampling_events.LAST_UPDATE_DATE := SYSDATE;
1452:
1453: IF (l_debug = 'Y') THEN

Line 1450: l_sampling_events.LAST_UPDATED_BY := local_user; --Bug#6276012 replace FND_GLOBAL.USER_ID;

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;
1451: l_sampling_events.LAST_UPDATE_DATE := SYSDATE;
1452:
1453: IF (l_debug = 'Y') THEN
1454: gmd_debug.put_line('Going to insert sample event');

Line 1714: l_event_spec_disp.CREATED_BY := local_user; --Bug#6276012 replace FND_GLOBAL.USER_ID;

1710: l_event_spec_disp.DISPOSITION := '1P';
1711: l_event_spec_disp.SPEC_USED_FOR_LOT_ATTRIB_IND := NULL;
1712: l_event_spec_disp.DELETE_MARK := 0;
1713: l_event_spec_disp.CREATION_DATE := sysdate;
1714: l_event_spec_disp.CREATED_BY := local_user; --Bug#6276012 replace FND_GLOBAL.USER_ID;
1715: l_event_spec_disp.LAST_UPDATE_DATE := sysdate;
1716: l_event_spec_disp.LAST_UPDATED_BY := local_user; --Bug#6276012 replace FND_GLOBAL.USER_ID;
1717:
1718: IF (l_debug = 'Y') THEN

Line 1716: l_event_spec_disp.LAST_UPDATED_BY := local_user; --Bug#6276012 replace FND_GLOBAL.USER_ID;

1712: l_event_spec_disp.DELETE_MARK := 0;
1713: l_event_spec_disp.CREATION_DATE := sysdate;
1714: l_event_spec_disp.CREATED_BY := local_user; --Bug#6276012 replace FND_GLOBAL.USER_ID;
1715: l_event_spec_disp.LAST_UPDATE_DATE := sysdate;
1716: l_event_spec_disp.LAST_UPDATED_BY := local_user; --Bug#6276012 replace FND_GLOBAL.USER_ID;
1717:
1718: IF (l_debug = 'Y') THEN
1719: gmd_debug.put_line('Going to insert event spec disp');
1720: END IF;

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

2641: l_sampling_events.oprn_id := l_oprn_id;
2642: l_sampling_events.sample_type := 'I';
2643: l_sampling_events.organization_id := L_organization_id;
2644: l_sampling_events.CREATION_DATE := SYSDATE;
2645: l_sampling_events.CREATED_BY := FND_GLOBAL.USER_ID;
2646: l_sampling_events.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2647: l_sampling_events.LAST_UPDATE_DATE := SYSDATE;
2648: --wf_log_pkg.string(6, 'Dummy','Before Creating the Sampling Event');
2649:

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

2642: l_sampling_events.sample_type := 'I';
2643: l_sampling_events.organization_id := L_organization_id;
2644: l_sampling_events.CREATION_DATE := SYSDATE;
2645: l_sampling_events.CREATED_BY := FND_GLOBAL.USER_ID;
2646: l_sampling_events.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2647: l_sampling_events.LAST_UPDATE_DATE := SYSDATE;
2648: --wf_log_pkg.string(6, 'Dummy','Before Creating the Sampling Event');
2649:
2650: /* Bug No.8942353 - Start */

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

2933: l_event_spec_disp.DISPOSITION := '1P';
2934: l_event_spec_disp.SPEC_USED_FOR_LOT_ATTRIB_IND := NULL;
2935: l_event_spec_disp.DELETE_MARK := 0;
2936: l_event_spec_disp.CREATION_DATE := sysdate;
2937: l_event_spec_disp.CREATED_BY := FND_GLOBAL.USER_ID;
2938: l_event_spec_disp.LAST_UPDATE_DATE := sysdate;
2939: l_event_spec_disp.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2940:
2941: IF (l_debug = 'Y') THEN

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

2935: l_event_spec_disp.DELETE_MARK := 0;
2936: l_event_spec_disp.CREATION_DATE := sysdate;
2937: l_event_spec_disp.CREATED_BY := FND_GLOBAL.USER_ID;
2938: l_event_spec_disp.LAST_UPDATE_DATE := sysdate;
2939: l_event_spec_disp.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2940:
2941: IF (l_debug = 'Y') THEN
2942: gmd_debug.put_line('Going to insert event spec disp');
2943: END IF;

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

2955: END IF;
2956: END IF; /* End of check to create event spec for non-auto sample */
2957:
2958: IF l_step_id is NOT NULL THEN
2959: fnd_global.apps_initialize(USER_ID => l_last_update_by,
2960: resp_id => NULL,
2961: resp_appl_id => NULL);
2962:
2963: fnd_profile.initialize(l_last_update_by);