DBA Data[Home] [Help]

APPS.AHL_OSP_PO_PVT dependencies on FND_GLOBAL

Line 2006: FND_GLOBAL.USER_ID

2002: p_po_line_tbl(i).QUANTITY,
2003: AHL_GLOBAL.AHL_OSP_PROGRAM_ID,
2004: AHL_GLOBAL.AHL_APPLICATION_ID,
2005: SYSDATE,
2006: FND_GLOBAL.USER_ID
2007: -- Added by mpothuku on 10-oct-2007 to fix bug 6431740
2008: ,p_po_line_tbl(i).wip_entity_id
2009: ,DECODE(p_po_line_tbl(i).project_id, null, null, 'Y')
2010: ,DECODE(p_po_line_tbl(i).project_id, null, null, 'Y')

Line 2765: last_updated_by = fnd_global.user_id,

2761: po_interface_header_id = null,
2762: status_code = G_OSP_ENTERED_STATUS,
2763: object_version_number = l_osp_details_rec.object_version_number + 1,
2764: last_update_date = TRUNC(sysdate),
2765: last_updated_by = fnd_global.user_id,
2766: last_update_login = fnd_global.login_id
2767: where osp_order_id = l_osp_details_rec.osp_order_id;
2768: END LOOP;
2769: CLOSE get_po_deleted_osps_csr;

Line 2766: last_update_login = fnd_global.login_id

2762: status_code = G_OSP_ENTERED_STATUS,
2763: object_version_number = l_osp_details_rec.object_version_number + 1,
2764: last_update_date = TRUNC(sysdate),
2765: last_updated_by = fnd_global.user_id,
2766: last_update_login = fnd_global.login_id
2767: where osp_order_id = l_osp_details_rec.osp_order_id;
2768: END LOOP;
2769: CLOSE get_po_deleted_osps_csr;
2770:

Line 2880: last_updated_by = fnd_global.user_id,

2876: set oe_ship_line_id = null,
2877: oe_return_line_id = null,
2878: object_version_number = l_osp_line_details_rec.object_version_number + 1,
2879: last_update_date = TRUNC(sysdate),
2880: last_updated_by = fnd_global.user_id,
2881: last_update_login = fnd_global.login_id
2882: where osp_order_line_id = l_osp_line_details_rec.osp_order_line_id;
2883: END LOOP;
2884: CLOSE get_osp_line_dtls_csr;

Line 2881: last_update_login = fnd_global.login_id

2877: oe_return_line_id = null,
2878: object_version_number = l_osp_line_details_rec.object_version_number + 1,
2879: last_update_date = TRUNC(sysdate),
2880: last_updated_by = fnd_global.user_id,
2881: last_update_login = fnd_global.login_id
2882: where osp_order_line_id = l_osp_line_details_rec.osp_order_line_id;
2883: END LOOP;
2884: CLOSE get_osp_line_dtls_csr;
2885: -- Now for the OSP Order Header, reset OE_HEADER_ID and increment OVN

Line 2890: last_updated_by = fnd_global.user_id,

2886: update ahl_osp_orders_b
2887: set OE_HEADER_ID = null,
2888: object_version_number = l_osp_details_rec.object_version_number + 1,
2889: last_update_date = TRUNC(sysdate),
2890: last_updated_by = fnd_global.user_id,
2891: last_update_login = fnd_global.login_id
2892: where osp_order_id = l_osp_details_rec.osp_order_id;
2893: END LOOP;
2894: CLOSE get_so_deleted_osps_csr;

Line 2891: last_update_login = fnd_global.login_id

2887: set OE_HEADER_ID = null,
2888: object_version_number = l_osp_details_rec.object_version_number + 1,
2889: last_update_date = TRUNC(sysdate),
2890: last_updated_by = fnd_global.user_id,
2891: last_update_login = fnd_global.login_id
2892: where osp_order_id = l_osp_details_rec.osp_order_id;
2893: END LOOP;
2894: CLOSE get_so_deleted_osps_csr;
2895:

Line 3094: P_LAST_UPDATED_BY => fnd_global.user_id, -- Updated

3090: -- Begin Changes by jaramana on January 7, 2008 for the Requisition ER 6034236
3091: P_PO_REQ_LINE_ID => l_osp_line_dtls_rec.PO_REQ_LINE_ID,
3092: -- End Changes by jaramana on January 7, 2008 for the Requisition ER 6034236
3093: P_LAST_UPDATE_DATE => TRUNC(sysdate), -- Updated
3094: P_LAST_UPDATED_BY => fnd_global.user_id, -- Updated
3095: P_LAST_UPDATE_LOGIN => fnd_global.login_id); -- Updated
3096:
3097: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3098: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');

Line 3095: P_LAST_UPDATE_LOGIN => fnd_global.login_id); -- Updated

3091: P_PO_REQ_LINE_ID => l_osp_line_dtls_rec.PO_REQ_LINE_ID,
3092: -- End Changes by jaramana on January 7, 2008 for the Requisition ER 6034236
3093: P_LAST_UPDATE_DATE => TRUNC(sysdate), -- Updated
3094: P_LAST_UPDATED_BY => fnd_global.user_id, -- Updated
3095: P_LAST_UPDATE_LOGIN => fnd_global.login_id); -- Updated
3096:
3097: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3098: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');
3099: END IF;

Line 3239: X_LAST_UPDATED_BY => fnd_global.user_id, -- Updated

3235: X_ATTRIBUTE15 => l_osp_dtls_rec.ATTRIBUTE15,
3236: X_DESCRIPTION => l_osp_dtls_rec.DESCRIPTION,
3237: X_PO_REQ_HEADER_ID => l_osp_dtls_rec.PO_REQ_HEADER_ID, -- Added by jaramana on January 7, 2008 for the Requisition ER 6034236
3238: X_LAST_UPDATE_DATE => TRUNC(sysdate), -- Updated
3239: X_LAST_UPDATED_BY => fnd_global.user_id, -- Updated
3240: X_LAST_UPDATE_LOGIN => fnd_global.login_id); -- Updated
3241: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3242: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');
3243: END IF;

Line 3240: X_LAST_UPDATE_LOGIN => fnd_global.login_id); -- Updated

3236: X_DESCRIPTION => l_osp_dtls_rec.DESCRIPTION,
3237: X_PO_REQ_HEADER_ID => l_osp_dtls_rec.PO_REQ_HEADER_ID, -- Added by jaramana on January 7, 2008 for the Requisition ER 6034236
3238: X_LAST_UPDATE_DATE => TRUNC(sysdate), -- Updated
3239: X_LAST_UPDATED_BY => fnd_global.user_id, -- Updated
3240: X_LAST_UPDATE_LOGIN => fnd_global.login_id); -- Updated
3241: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3242: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');
3243: END IF;
3244: END Update_OSP_Order;