eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.AHL_OSP_ORDERS_PVT dependencies on FND_GLOBAL

Line 3954: WHERE FU.user_id = fnd_global.user_id

3950: CURSOR get_buyer_id IS
3951: SELECT PA.buyer_id
3952: FROM po_agents_name_v PA,
3953: fnd_user FU
3954: WHERE FU.user_id = fnd_global.user_id
3955: AND PA.buyer_id = FU.employee_id;
3956: BEGIN
3957: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3958: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 4156: l_buyer_id := fnd_global.user_id;

4152: -- Buyer is valid: Use it
4153: l_buyer_id := p_x_osp_order_rec.po_agent_id;
4154: ELSE
4155: --Derive the default po_agent_id
4156: l_buyer_id := fnd_global.user_id;
4157: OPEN get_buyer_id;
4158: FETCH get_buyer_id INTO l_buyer_id;
4159: CLOSE get_buyer_id;
4160: END IF;

Line 4170: x_created_by => FND_GLOBAL.user_id,

4166: AHL_OSP_ORDERS_PKG.insert_row(
4167: x_rowid => l_rowid_dummy,
4168: x_osp_order_id => l_osp_order_id,
4169: x_object_version_number => 1,
4170: x_created_by => FND_GLOBAL.user_id,
4171: x_creation_date => SYSDATE,
4172: x_last_updated_by => FND_GLOBAL.user_id,
4173: x_last_update_date => SYSDATE,
4174: x_last_update_login => FND_GLOBAL.login_id,

Line 4172: x_last_updated_by => FND_GLOBAL.user_id,

4168: x_osp_order_id => l_osp_order_id,
4169: x_object_version_number => 1,
4170: x_created_by => FND_GLOBAL.user_id,
4171: x_creation_date => SYSDATE,
4172: x_last_updated_by => FND_GLOBAL.user_id,
4173: x_last_update_date => SYSDATE,
4174: x_last_update_login => FND_GLOBAL.login_id,
4175: x_osp_order_number => l_osp_order_number,
4176: x_order_type_code => p_x_osp_order_rec.order_type_code, --User entered

Line 4174: x_last_update_login => FND_GLOBAL.login_id,

4170: x_created_by => FND_GLOBAL.user_id,
4171: x_creation_date => SYSDATE,
4172: x_last_updated_by => FND_GLOBAL.user_id,
4173: x_last_update_date => SYSDATE,
4174: x_last_update_login => FND_GLOBAL.login_id,
4175: x_osp_order_number => l_osp_order_number,
4176: x_order_type_code => p_x_osp_order_rec.order_type_code, --User entered
4177: x_single_instance_flag => G_NO_FLAG,
4178: x_po_header_id => NULL, --p_x_osp_order_rec.po_header_id,

Line 4323: x_last_updated_by => fnd_global.user_id,

4319: x_attribute12 => p_x_osp_order_rec.attribute12,
4320: x_attribute13 => p_x_osp_order_rec.attribute13,
4321: x_attribute14 => p_x_osp_order_rec.attribute14,
4322: x_attribute15 => p_x_osp_order_rec.attribute15,
4323: x_last_updated_by => fnd_global.user_id,
4324: x_last_update_date => SYSDATE,
4325: x_last_update_login => fnd_global.login_id
4326: );
4327: --After the header vendor gets changed then calling validate_vendor_service_item.

Line 4325: x_last_update_login => fnd_global.login_id

4321: x_attribute14 => p_x_osp_order_rec.attribute14,
4322: x_attribute15 => p_x_osp_order_rec.attribute15,
4323: x_last_updated_by => fnd_global.user_id,
4324: x_last_update_date => SYSDATE,
4325: x_last_update_login => fnd_global.login_id
4326: );
4327: --After the header vendor gets changed then calling validate_vendor_service_item.
4328: --If it is not for calling validate_vendor_service_item, then it is better to put
4329: --this validation ahead of table_handler calling

Line 4629: p_created_by => fnd_global.user_id,

4625: --Call table handler to insert the line
4626: AHL_OSP_ORDER_LINES_PKG.insert_row(
4627: p_x_osp_order_line_id => l_osp_line_id,
4628: p_object_version_number => 1,
4629: p_created_by => fnd_global.user_id,
4630: p_creation_date => SYSDATE,
4631: p_last_updated_by => fnd_global.user_id,
4632: p_last_update_date => SYSDATE,
4633: p_last_update_login => fnd_global.login_id,

Line 4631: p_last_updated_by => fnd_global.user_id,

4627: p_x_osp_order_line_id => l_osp_line_id,
4628: p_object_version_number => 1,
4629: p_created_by => fnd_global.user_id,
4630: p_creation_date => SYSDATE,
4631: p_last_updated_by => fnd_global.user_id,
4632: p_last_update_date => SYSDATE,
4633: p_last_update_login => fnd_global.login_id,
4634: p_osp_order_id => p_x_osp_order_line_rec.osp_order_id,
4635: p_osp_line_number => l_osp_line_number,

Line 4633: p_last_update_login => fnd_global.login_id,

4629: p_created_by => fnd_global.user_id,
4630: p_creation_date => SYSDATE,
4631: p_last_updated_by => fnd_global.user_id,
4632: p_last_update_date => SYSDATE,
4633: p_last_update_login => fnd_global.login_id,
4634: p_osp_order_id => p_x_osp_order_line_rec.osp_order_id,
4635: p_osp_line_number => l_osp_line_number,
4636: p_status_code => NULL, --Derived from header status when displaying
4637: p_po_line_type_id => to_number(FND_PROFILE.VALUE('AHL_OSP_PO_LINE_TYPE_ID')),

Line 4696: p_created_by => fnd_global.user_id,

4692: --Call table handler to insert the line
4693: AHL_OSP_ORDER_LINES_PKG.insert_row(
4694: p_x_osp_order_line_id => l_osp_line_id,
4695: p_object_version_number => 1,
4696: p_created_by => fnd_global.user_id,
4697: p_creation_date => SYSDATE,
4698: p_last_updated_by => fnd_global.user_id,
4699: p_last_update_date => SYSDATE,
4700: p_last_update_login => fnd_global.login_id,

Line 4698: p_last_updated_by => fnd_global.user_id,

4694: p_x_osp_order_line_id => l_osp_line_id,
4695: p_object_version_number => 1,
4696: p_created_by => fnd_global.user_id,
4697: p_creation_date => SYSDATE,
4698: p_last_updated_by => fnd_global.user_id,
4699: p_last_update_date => SYSDATE,
4700: p_last_update_login => fnd_global.login_id,
4701: p_osp_order_id => p_x_osp_order_line_rec.osp_order_id,
4702: p_osp_line_number => l_osp_line_number,

Line 4700: p_last_update_login => fnd_global.login_id,

4696: p_created_by => fnd_global.user_id,
4697: p_creation_date => SYSDATE,
4698: p_last_updated_by => fnd_global.user_id,
4699: p_last_update_date => SYSDATE,
4700: p_last_update_login => fnd_global.login_id,
4701: p_osp_order_id => p_x_osp_order_line_rec.osp_order_id,
4702: p_osp_line_number => l_osp_line_number,
4703: p_status_code => NULL, --Derived from header status when displaying
4704: p_po_line_type_id => p_x_osp_order_line_rec.po_line_type_id, --derived from PO Line

Line 5568: p_last_updated_by => FND_GLOBAL.user_id,

5564: p_attribute12 => p_x_osp_order_line_rec.attribute12,
5565: p_attribute13 => p_x_osp_order_line_rec.attribute13,
5566: p_attribute14 => p_x_osp_order_line_rec.attribute14,
5567: p_attribute15 => p_x_osp_order_line_rec.attribute15,
5568: p_last_updated_by => FND_GLOBAL.user_id,
5569: p_last_update_date => SYSDATE,
5570: p_last_update_login => FND_GLOBAL.login_id
5571: );
5572: END update_osp_order_line;

Line 5570: p_last_update_login => FND_GLOBAL.login_id

5566: p_attribute14 => p_x_osp_order_line_rec.attribute14,
5567: p_attribute15 => p_x_osp_order_line_rec.attribute15,
5568: p_last_updated_by => FND_GLOBAL.user_id,
5569: p_last_update_date => SYSDATE,
5570: p_last_update_login => FND_GLOBAL.login_id
5571: );
5572: END update_osp_order_line;
5573:
5574: PROCEDURE validate_order_line_update(p_x_osp_order_line_rec IN OUT NOCOPY osp_order_line_rec_type)

Line 7276: last_updated_by = fnd_global.user_id,

7272: IF(p_osp_order_rec.order_type_code = G_OSP_ORDER_TYPE_SERVICE) THEN
7273: UPDATE ahl_osp_order_lines
7274: SET exchange_instance_id = NULL,
7275: last_update_date = SYSDATE,
7276: last_updated_by = fnd_global.user_id,
7277: last_update_login = fnd_global.login_id,
7278: object_version_number = object_version_number+1
7279: WHERE osp_order_id = p_osp_order_rec.osp_order_id;
7280: --set exchange instance id to null and update object_version_number in p_x_osp_order_lines_tbl

Line 7277: last_update_login = fnd_global.login_id,

7273: UPDATE ahl_osp_order_lines
7274: SET exchange_instance_id = NULL,
7275: last_update_date = SYSDATE,
7276: last_updated_by = fnd_global.user_id,
7277: last_update_login = fnd_global.login_id,
7278: object_version_number = object_version_number+1
7279: WHERE osp_order_id = p_osp_order_rec.osp_order_id;
7280: --set exchange instance id to null and update object_version_number in p_x_osp_order_lines_tbl
7281: --nullify_exchange_instance(p_osp_order_rec.osp_order_id, p_x_osp_order_lines_tbl);