DBA Data[Home] [Help]

APPS.AHL_PRD_DISPOSITION_PVT dependencies on FND_GLOBAL

Line 621: X_CREATED_BY => FND_GLOBAL.user_id,

617: X_ATTRIBUTE14 => NULL,
618: X_ATTRIBUTE15 => NULL,
619: X_COMMENTS => NULL,
620: X_CREATION_DATE => SYSDATE,
621: X_CREATED_BY => FND_GLOBAL.user_id,
622: X_LAST_UPDATE_DATE => SYSDATE,
623: X_LAST_UPDATED_BY => FND_GLOBAL.user_id,
624: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id);
625:

Line 623: X_LAST_UPDATED_BY => FND_GLOBAL.user_id,

619: X_COMMENTS => NULL,
620: X_CREATION_DATE => SYSDATE,
621: X_CREATED_BY => FND_GLOBAL.user_id,
622: X_LAST_UPDATE_DATE => SYSDATE,
623: X_LAST_UPDATED_BY => FND_GLOBAL.user_id,
624: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id);
625:
626: --Insert the same record into the Disposition History table as well
627: SELECT AHL_PRD_DISPOSITIONS_B_H_S.NEXTVAL

Line 624: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id);

620: X_CREATION_DATE => SYSDATE,
621: X_CREATED_BY => FND_GLOBAL.user_id,
622: X_LAST_UPDATE_DATE => SYSDATE,
623: X_LAST_UPDATED_BY => FND_GLOBAL.user_id,
624: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id);
625:
626: --Insert the same record into the Disposition History table as well
627: SELECT AHL_PRD_DISPOSITIONS_B_H_S.NEXTVAL
628: INTO l_disposition_h_id

Line 674: X_CREATED_BY => FND_GLOBAL.user_id,

670: X_ATTRIBUTE14 => NULL,
671: X_ATTRIBUTE15 => NULL,
672: X_COMMENTS => NULL,
673: X_CREATION_DATE => SYSDATE,
674: X_CREATED_BY => FND_GLOBAL.user_id,
675: X_LAST_UPDATE_DATE => SYSDATE,
676: X_LAST_UPDATED_BY => FND_GLOBAL.user_id,
677: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id);
678: EXCEPTION

Line 676: X_LAST_UPDATED_BY => FND_GLOBAL.user_id,

672: X_COMMENTS => NULL,
673: X_CREATION_DATE => SYSDATE,
674: X_CREATED_BY => FND_GLOBAL.user_id,
675: X_LAST_UPDATE_DATE => SYSDATE,
676: X_LAST_UPDATED_BY => FND_GLOBAL.user_id,
677: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id);
678: EXCEPTION
679: WHEN NO_DATA_FOUND THEN --This +100 is raised explicitly in INSERT_ROW
680: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INSERT_FAILED' );

Line 677: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id);

673: X_CREATION_DATE => SYSDATE,
674: X_CREATED_BY => FND_GLOBAL.user_id,
675: X_LAST_UPDATE_DATE => SYSDATE,
676: X_LAST_UPDATED_BY => FND_GLOBAL.user_id,
677: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id);
678: EXCEPTION
679: WHEN NO_DATA_FOUND THEN --This +100 is raised explicitly in INSERT_ROW
680: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INSERT_FAILED' );
681: FND_MSG_PUB.add;

Line 1110: p_x_disposition_rec.created_by := fnd_global.user_id;

1106: Select AHL_PRD_DISPOSITIONS_B_S.NEXTVAL into p_x_disposition_rec.disposition_id from dual;
1107: --setting object version number for create
1108: p_x_disposition_rec.object_version_number := 1;
1109: --setting up user/create/update information
1110: p_x_disposition_rec.created_by := fnd_global.user_id;
1111: p_x_disposition_rec.creation_date := SYSDATE;
1112: p_x_disposition_rec.last_updated_by := fnd_global.user_id;
1113: p_x_disposition_rec.last_update_date := SYSDATE;
1114: p_x_disposition_rec.last_update_login := fnd_global.login_id ;

Line 1112: p_x_disposition_rec.last_updated_by := fnd_global.user_id;

1108: p_x_disposition_rec.object_version_number := 1;
1109: --setting up user/create/update information
1110: p_x_disposition_rec.created_by := fnd_global.user_id;
1111: p_x_disposition_rec.creation_date := SYSDATE;
1112: p_x_disposition_rec.last_updated_by := fnd_global.user_id;
1113: p_x_disposition_rec.last_update_date := SYSDATE;
1114: p_x_disposition_rec.last_update_login := fnd_global.login_id ;
1115:
1116: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1114: p_x_disposition_rec.last_update_login := fnd_global.login_id ;

1110: p_x_disposition_rec.created_by := fnd_global.user_id;
1111: p_x_disposition_rec.creation_date := SYSDATE;
1112: p_x_disposition_rec.last_updated_by := fnd_global.user_id;
1113: p_x_disposition_rec.last_update_date := SYSDATE;
1114: p_x_disposition_rec.last_update_login := fnd_global.login_id ;
1115:
1116: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1117: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Before Insert_Row');
1118: END IF;

Line 2003: p_x_disposition_rec.last_updated_by := fnd_global.user_id;

1999: --dbms_output.put_line(SubStr('After calculate status' ||p_x_disposition_Rec.status_code, 1, 255));
2000: -- setting up object version number
2001: p_x_disposition_rec.object_version_number := p_x_disposition_rec.object_version_number + 1;
2002: --setting up user/create/update information
2003: p_x_disposition_rec.last_updated_by := fnd_global.user_id;
2004: p_x_disposition_rec.last_update_date := SYSDATE;
2005: p_x_disposition_rec.last_update_login := fnd_global.login_id;
2006:
2007: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007

Line 2005: p_x_disposition_rec.last_update_login := fnd_global.login_id;

2001: p_x_disposition_rec.object_version_number := p_x_disposition_rec.object_version_number + 1;
2002: --setting up user/create/update information
2003: p_x_disposition_rec.last_updated_by := fnd_global.user_id;
2004: p_x_disposition_rec.last_update_date := SYSDATE;
2005: p_x_disposition_rec.last_update_login := fnd_global.login_id;
2006:
2007: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007
2008: -- If the part is removed in 'Inspection' condition, then move the disposition to Complete status.
2009: IF (p_x_disposition_rec.condition_id = fnd_profile.value('AHL_MTL_MAT_STATUS_INSPECTION') AND