DBA Data[Home] [Help]

APPS.AHL_PRD_DISPOSITION_PVT dependencies on FND_GLOBAL

Line 624: X_CREATED_BY => FND_GLOBAL.user_id,

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

Line 626: X_LAST_UPDATED_BY => FND_GLOBAL.user_id,

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

Line 627: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id);

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

Line 677: X_CREATED_BY => FND_GLOBAL.user_id,

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

Line 679: X_LAST_UPDATED_BY => FND_GLOBAL.user_id,

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

Line 680: X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id);

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

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

1165: Select AHL_PRD_DISPOSITIONS_B_S.NEXTVAL into p_x_disposition_rec.disposition_id from dual;
1166: --setting object version number for create
1167: p_x_disposition_rec.object_version_number := 1;
1168: --setting up user/create/update information
1169: p_x_disposition_rec.created_by := fnd_global.user_id;
1170: p_x_disposition_rec.creation_date := SYSDATE;
1171: p_x_disposition_rec.last_updated_by := fnd_global.user_id;
1172: p_x_disposition_rec.last_update_date := SYSDATE;
1173: p_x_disposition_rec.last_update_login := fnd_global.login_id ;

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

1167: p_x_disposition_rec.object_version_number := 1;
1168: --setting up user/create/update information
1169: p_x_disposition_rec.created_by := fnd_global.user_id;
1170: p_x_disposition_rec.creation_date := SYSDATE;
1171: p_x_disposition_rec.last_updated_by := fnd_global.user_id;
1172: p_x_disposition_rec.last_update_date := SYSDATE;
1173: p_x_disposition_rec.last_update_login := fnd_global.login_id ;
1174:
1175: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1169: p_x_disposition_rec.created_by := fnd_global.user_id;
1170: p_x_disposition_rec.creation_date := SYSDATE;
1171: p_x_disposition_rec.last_updated_by := fnd_global.user_id;
1172: p_x_disposition_rec.last_update_date := SYSDATE;
1173: p_x_disposition_rec.last_update_login := fnd_global.login_id ;
1174:
1175: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1176: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Before Insert_Row');
1177: END IF;

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

2192: --dbms_output.put_line(SubStr('After calculate status' ||p_x_disposition_Rec.status_code, 1, 255));
2193: -- setting up object version number
2194: p_x_disposition_rec.object_version_number := p_x_disposition_rec.object_version_number + 1;
2195: --setting up user/create/update information
2196: p_x_disposition_rec.last_updated_by := fnd_global.user_id;
2197: p_x_disposition_rec.last_update_date := SYSDATE;
2198: p_x_disposition_rec.last_update_login := fnd_global.login_id;
2199:
2200: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007

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

2194: p_x_disposition_rec.object_version_number := p_x_disposition_rec.object_version_number + 1;
2195: --setting up user/create/update information
2196: p_x_disposition_rec.last_updated_by := fnd_global.user_id;
2197: p_x_disposition_rec.last_update_date := SYSDATE;
2198: p_x_disposition_rec.last_update_login := fnd_global.login_id;
2199:
2200: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007
2201: -- If the part is removed in 'Inspection' condition, then move the disposition to Complete status.
2202: -- SURRKUMA :: BUG 12658774 - STATUS 'COMPLETED' SHOWN EVEN AFTER TERMINATION, 25-Nov-2011; sorao for backporting