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.

APPS.AHL_OSP_ORDERS_PVT dependencies on FND_GLOBAL

Line 4296: WHERE FU.user_id = fnd_global.user_id

4292: CURSOR get_buyer_id IS
4293: SELECT PA.buyer_id
4294: FROM po_agents_name_v PA,
4295: fnd_user FU
4296: WHERE FU.user_id = fnd_global.user_id
4297: AND PA.buyer_id = FU.employee_id;
4298: BEGIN
4299: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4300: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 4498: l_buyer_id := fnd_global.user_id;

4494: -- Buyer is valid: Use it
4495: l_buyer_id := p_x_osp_order_rec.po_agent_id;
4496: ELSE
4497: --Derive the default po_agent_id
4498: l_buyer_id := fnd_global.user_id;
4499: OPEN get_buyer_id;
4500: FETCH get_buyer_id INTO l_buyer_id;
4501: CLOSE get_buyer_id;
4502: END IF;

Line 4512: x_created_by => FND_GLOBAL.user_id,

4508: AHL_OSP_ORDERS_PKG.insert_row(
4509: x_rowid => l_rowid_dummy,
4510: x_osp_order_id => l_osp_order_id,
4511: x_object_version_number => 1,
4512: x_created_by => FND_GLOBAL.user_id,
4513: x_creation_date => SYSDATE,
4514: x_last_updated_by => FND_GLOBAL.user_id,
4515: x_last_update_date => SYSDATE,
4516: x_last_update_login => FND_GLOBAL.login_id,

Line 4514: x_last_updated_by => FND_GLOBAL.user_id,

4510: x_osp_order_id => l_osp_order_id,
4511: x_object_version_number => 1,
4512: x_created_by => FND_GLOBAL.user_id,
4513: x_creation_date => SYSDATE,
4514: x_last_updated_by => FND_GLOBAL.user_id,
4515: x_last_update_date => SYSDATE,
4516: x_last_update_login => FND_GLOBAL.login_id,
4517: x_osp_order_number => l_osp_order_number,
4518: x_order_type_code => p_x_osp_order_rec.order_type_code, --User entered

Line 4516: x_last_update_login => FND_GLOBAL.login_id,

4512: x_created_by => FND_GLOBAL.user_id,
4513: x_creation_date => SYSDATE,
4514: x_last_updated_by => FND_GLOBAL.user_id,
4515: x_last_update_date => SYSDATE,
4516: x_last_update_login => FND_GLOBAL.login_id,
4517: x_osp_order_number => l_osp_order_number,
4518: x_order_type_code => p_x_osp_order_rec.order_type_code, --User entered
4519: x_single_instance_flag => G_NO_FLAG,
4520: x_po_header_id => NULL, --p_x_osp_order_rec.po_header_id,

Line 4665: x_last_updated_by => fnd_global.user_id,

4661: x_attribute12 => p_x_osp_order_rec.attribute12,
4662: x_attribute13 => p_x_osp_order_rec.attribute13,
4663: x_attribute14 => p_x_osp_order_rec.attribute14,
4664: x_attribute15 => p_x_osp_order_rec.attribute15,
4665: x_last_updated_by => fnd_global.user_id,
4666: x_last_update_date => SYSDATE,
4667: x_last_update_login => fnd_global.login_id
4668: );
4669: --After the header vendor gets changed then calling validate_vendor_service_item.

Line 4667: x_last_update_login => fnd_global.login_id

4663: x_attribute14 => p_x_osp_order_rec.attribute14,
4664: x_attribute15 => p_x_osp_order_rec.attribute15,
4665: x_last_updated_by => fnd_global.user_id,
4666: x_last_update_date => SYSDATE,
4667: x_last_update_login => fnd_global.login_id
4668: );
4669: --After the header vendor gets changed then calling validate_vendor_service_item.
4670: --If it is not for calling validate_vendor_service_item, then it is better to put
4671: --this validation ahead of table_handler calling

Line 4979: p_created_by => fnd_global.user_id,

4975: --Call table handler to insert the line
4976: AHL_OSP_ORDER_LINES_PKG.insert_row(
4977: p_x_osp_order_line_id => l_osp_line_id,
4978: p_object_version_number => 1,
4979: p_created_by => fnd_global.user_id,
4980: p_creation_date => SYSDATE,
4981: p_last_updated_by => fnd_global.user_id,
4982: p_last_update_date => SYSDATE,
4983: p_last_update_login => fnd_global.login_id,

Line 4981: p_last_updated_by => fnd_global.user_id,

4977: p_x_osp_order_line_id => l_osp_line_id,
4978: p_object_version_number => 1,
4979: p_created_by => fnd_global.user_id,
4980: p_creation_date => SYSDATE,
4981: p_last_updated_by => fnd_global.user_id,
4982: p_last_update_date => SYSDATE,
4983: p_last_update_login => fnd_global.login_id,
4984: p_osp_order_id => p_x_osp_order_line_rec.osp_order_id,
4985: p_osp_line_number => l_osp_line_number,

Line 4983: p_last_update_login => fnd_global.login_id,

4979: p_created_by => fnd_global.user_id,
4980: p_creation_date => SYSDATE,
4981: p_last_updated_by => fnd_global.user_id,
4982: p_last_update_date => SYSDATE,
4983: p_last_update_login => fnd_global.login_id,
4984: p_osp_order_id => p_x_osp_order_line_rec.osp_order_id,
4985: p_osp_line_number => l_osp_line_number,
4986: p_status_code => NULL, --Derived from header status when displaying
4987: p_po_line_type_id => to_number(FND_PROFILE.VALUE('AHL_OSP_PO_LINE_TYPE_ID')),

Line 5046: p_created_by => fnd_global.user_id,

5042: --Call table handler to insert the line
5043: AHL_OSP_ORDER_LINES_PKG.insert_row(
5044: p_x_osp_order_line_id => l_osp_line_id,
5045: p_object_version_number => 1,
5046: p_created_by => fnd_global.user_id,
5047: p_creation_date => SYSDATE,
5048: p_last_updated_by => fnd_global.user_id,
5049: p_last_update_date => SYSDATE,
5050: p_last_update_login => fnd_global.login_id,

Line 5048: p_last_updated_by => fnd_global.user_id,

5044: p_x_osp_order_line_id => l_osp_line_id,
5045: p_object_version_number => 1,
5046: p_created_by => fnd_global.user_id,
5047: p_creation_date => SYSDATE,
5048: p_last_updated_by => fnd_global.user_id,
5049: p_last_update_date => SYSDATE,
5050: p_last_update_login => fnd_global.login_id,
5051: p_osp_order_id => p_x_osp_order_line_rec.osp_order_id,
5052: p_osp_line_number => l_osp_line_number,

Line 5050: p_last_update_login => fnd_global.login_id,

5046: p_created_by => fnd_global.user_id,
5047: p_creation_date => SYSDATE,
5048: p_last_updated_by => fnd_global.user_id,
5049: p_last_update_date => SYSDATE,
5050: p_last_update_login => fnd_global.login_id,
5051: p_osp_order_id => p_x_osp_order_line_rec.osp_order_id,
5052: p_osp_line_number => l_osp_line_number,
5053: p_status_code => NULL, --Derived from header status when displaying
5054: p_po_line_type_id => p_x_osp_order_line_rec.po_line_type_id, --derived from PO Line

Line 5999: p_last_updated_by => FND_GLOBAL.user_id,

5995: p_attribute12 => p_x_osp_order_line_rec.attribute12,
5996: p_attribute13 => p_x_osp_order_line_rec.attribute13,
5997: p_attribute14 => p_x_osp_order_line_rec.attribute14,
5998: p_attribute15 => p_x_osp_order_line_rec.attribute15,
5999: p_last_updated_by => FND_GLOBAL.user_id,
6000: p_last_update_date => SYSDATE,
6001: p_last_update_login => FND_GLOBAL.login_id
6002: );
6003: END update_osp_order_line;

Line 6001: p_last_update_login => FND_GLOBAL.login_id

5997: p_attribute14 => p_x_osp_order_line_rec.attribute14,
5998: p_attribute15 => p_x_osp_order_line_rec.attribute15,
5999: p_last_updated_by => FND_GLOBAL.user_id,
6000: p_last_update_date => SYSDATE,
6001: p_last_update_login => FND_GLOBAL.login_id
6002: );
6003: END update_osp_order_line;
6004:
6005: PROCEDURE validate_order_line_update(p_x_osp_order_line_rec IN OUT NOCOPY osp_order_line_rec_type)

Line 7725: last_updated_by = fnd_global.user_id,

7721: IF(p_osp_order_rec.order_type_code = G_OSP_ORDER_TYPE_SERVICE) THEN
7722: UPDATE ahl_osp_order_lines
7723: SET exchange_instance_id = NULL,
7724: last_update_date = SYSDATE,
7725: last_updated_by = fnd_global.user_id,
7726: last_update_login = fnd_global.login_id,
7727: object_version_number = object_version_number+1
7728: WHERE osp_order_id = p_osp_order_rec.osp_order_id;
7729: --set exchange instance id to null and update object_version_number in p_x_osp_order_lines_tbl

Line 7726: last_update_login = fnd_global.login_id,

7722: UPDATE ahl_osp_order_lines
7723: SET exchange_instance_id = NULL,
7724: last_update_date = SYSDATE,
7725: last_updated_by = fnd_global.user_id,
7726: last_update_login = fnd_global.login_id,
7727: object_version_number = object_version_number+1
7728: WHERE osp_order_id = p_osp_order_rec.osp_order_id;
7729: --set exchange instance id to null and update object_version_number in p_x_osp_order_lines_tbl
7730: --nullify_exchange_instance(p_osp_order_rec.osp_order_id, p_x_osp_order_lines_tbl);