DBA Data[Home] [Help]

APPS.GMD_QM_CONC_REPLACE_PKG dependencies on FND_GLOBAL

Line 329: l_user_id NUMBER := fnd_global.user_id;

325: l_row_id VARCHAR2 (200);
326: l_mesg_data VARCHAR2 (2000);
327: l_return_status VARCHAR2 (1);
328: l_action_flag VARCHAR2 (1) := 'U';
329: l_user_id NUMBER := fnd_global.user_id;
330: l_text VARCHAR2 (100);
331: l_object_name_vers VARCHAR2 (200);
332: l_retval BOOLEAN;
333: l_version_enabled VARCHAR2 (1);

Line 677: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

673:
674: UPDATE gmd_specifications_b -- 8281768 added WHO columns.
675: SET spec_status = l_new_status,
676: LAST_UPDATE_DATE = SYSDATE,
677: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
678: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
679:
680: WHERE spec_id = get_object_rec.object_id;
681:

Line 678: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

674: UPDATE gmd_specifications_b -- 8281768 added WHO columns.
675: SET spec_status = l_new_status,
676: LAST_UPDATE_DATE = SYSDATE,
677: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
678: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
679:
680: WHERE spec_id = get_object_rec.object_id;
681:
682: default_log (' Update Specification Succesful');

Line 737: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

733: */
734: UPDATE gmd_specifications_b -- 8281768 added WHO columns
735: SET owner_id = l_new_owner,
736: LAST_UPDATE_DATE = SYSDATE,
737: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
738: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
739:
740: WHERE spec_id = get_object_rec.object_id;
741: default_log (' Update Specification Succesful');

Line 738: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

734: UPDATE gmd_specifications_b -- 8281768 added WHO columns
735: SET owner_id = l_new_owner,
736: LAST_UPDATE_DATE = SYSDATE,
737: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
738: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
739:
740: WHERE spec_id = get_object_rec.object_id;
741: default_log (' Update Specification Succesful');
742: else

Line 803: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

799: -- Bug# 5882074 Changed code to id
800: UPDATE gmd_specifications_b -- 8281768 added WHO columns
801: SET owner_organization_id = l_new_ownerorg,
802: LAST_UPDATE_DATE = SYSDATE,
803: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
804: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
805:
806: WHERE spec_id = get_object_rec.object_id;
807:

Line 804: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

800: UPDATE gmd_specifications_b -- 8281768 added WHO columns
801: SET owner_organization_id = l_new_ownerorg,
802: LAST_UPDATE_DATE = SYSDATE,
803: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
804: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
805:
806: WHERE spec_id = get_object_rec.object_id;
807:
808: default_log ( ' Replace Spec OwnerOrganization, Spec Name: '

Line 925: ,LAST_UPDATED_BY = FND_GLOBAL.USER_ID

921: , report_precision = l_test_values_rec.report_precision
922: , display_precision = l_test_values_rec.store_precision
923: , test_priority = l_test_values_rec.test_priority
924: ,LAST_UPDATE_DATE = SYSDATE
925: ,LAST_UPDATED_BY = FND_GLOBAL.USER_ID
926: ,LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
927:
928:
929: WHERE spec_id = l_spec_test_rec.spec_id

Line 926: ,LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

922: , display_precision = l_test_values_rec.store_precision
923: , test_priority = l_test_values_rec.test_priority
924: ,LAST_UPDATE_DATE = SYSDATE
925: ,LAST_UPDATED_BY = FND_GLOBAL.USER_ID
926: ,LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
927:
928:
929: WHERE spec_id = l_spec_test_rec.spec_id
930: AND test_id = l_spec_test_rec.test_id;