DBA Data[Home] [Help]

APPS.AHL_OSP_PO_PVT dependencies on FND_GLOBAL

Line 1992: FND_GLOBAL.USER_ID

1988: p_po_line_tbl(i).QUANTITY,
1989: AHL_GLOBAL.AHL_OSP_PROGRAM_ID,
1990: AHL_GLOBAL.AHL_APPLICATION_ID,
1991: SYSDATE,
1992: FND_GLOBAL.USER_ID
1993: -- Added by mpothuku on 10-oct-2007 to fix bug 6431740
1994: ,p_po_line_tbl(i).wip_entity_id
1995: ,DECODE(p_po_line_tbl(i).project_id, null, null, 'Y')
1996: ,DECODE(p_po_line_tbl(i).project_id, null, null, 'Y')

Line 2732: last_updated_by = fnd_global.user_id,

2728: po_interface_header_id = null,
2729: status_code = G_OSP_ENTERED_STATUS,
2730: object_version_number = l_osp_details_rec.object_version_number + 1,
2731: last_update_date = TRUNC(sysdate),
2732: last_updated_by = fnd_global.user_id,
2733: last_update_login = fnd_global.login_id
2734: where osp_order_id = l_osp_details_rec.osp_order_id;
2735: END LOOP;
2736: CLOSE get_po_deleted_osps_csr;

Line 2733: last_update_login = fnd_global.login_id

2729: status_code = G_OSP_ENTERED_STATUS,
2730: object_version_number = l_osp_details_rec.object_version_number + 1,
2731: last_update_date = TRUNC(sysdate),
2732: last_updated_by = fnd_global.user_id,
2733: last_update_login = fnd_global.login_id
2734: where osp_order_id = l_osp_details_rec.osp_order_id;
2735: END LOOP;
2736: CLOSE get_po_deleted_osps_csr;
2737:

Line 2847: last_updated_by = fnd_global.user_id,

2843: set oe_ship_line_id = null,
2844: oe_return_line_id = null,
2845: object_version_number = l_osp_line_details_rec.object_version_number + 1,
2846: last_update_date = TRUNC(sysdate),
2847: last_updated_by = fnd_global.user_id,
2848: last_update_login = fnd_global.login_id
2849: where osp_order_line_id = l_osp_line_details_rec.osp_order_line_id;
2850: END LOOP;
2851: CLOSE get_osp_line_dtls_csr;

Line 2848: last_update_login = fnd_global.login_id

2844: oe_return_line_id = null,
2845: object_version_number = l_osp_line_details_rec.object_version_number + 1,
2846: last_update_date = TRUNC(sysdate),
2847: last_updated_by = fnd_global.user_id,
2848: last_update_login = fnd_global.login_id
2849: where osp_order_line_id = l_osp_line_details_rec.osp_order_line_id;
2850: END LOOP;
2851: CLOSE get_osp_line_dtls_csr;
2852: -- Now for the OSP Order Header, reset OE_HEADER_ID and increment OVN

Line 2857: last_updated_by = fnd_global.user_id,

2853: update ahl_osp_orders_b
2854: set OE_HEADER_ID = null,
2855: object_version_number = l_osp_details_rec.object_version_number + 1,
2856: last_update_date = TRUNC(sysdate),
2857: last_updated_by = fnd_global.user_id,
2858: last_update_login = fnd_global.login_id
2859: where osp_order_id = l_osp_details_rec.osp_order_id;
2860: END LOOP;
2861: CLOSE get_so_deleted_osps_csr;

Line 2858: last_update_login = fnd_global.login_id

2854: set OE_HEADER_ID = null,
2855: object_version_number = l_osp_details_rec.object_version_number + 1,
2856: last_update_date = TRUNC(sysdate),
2857: last_updated_by = fnd_global.user_id,
2858: last_update_login = fnd_global.login_id
2859: where osp_order_id = l_osp_details_rec.osp_order_id;
2860: END LOOP;
2861: CLOSE get_so_deleted_osps_csr;
2862:

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

3057: -- Begin Changes by jaramana on January 7, 2008 for the Requisition ER 6034236
3058: P_PO_REQ_LINE_ID => l_osp_line_dtls_rec.PO_REQ_LINE_ID,
3059: -- End Changes by jaramana on January 7, 2008 for the Requisition ER 6034236
3060: P_LAST_UPDATE_DATE => TRUNC(sysdate), -- Updated
3061: P_LAST_UPDATED_BY => fnd_global.user_id, -- Updated
3062: P_LAST_UPDATE_LOGIN => fnd_global.login_id); -- Updated
3063:
3064: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3065: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');

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

3058: P_PO_REQ_LINE_ID => l_osp_line_dtls_rec.PO_REQ_LINE_ID,
3059: -- End Changes by jaramana on January 7, 2008 for the Requisition ER 6034236
3060: P_LAST_UPDATE_DATE => TRUNC(sysdate), -- Updated
3061: P_LAST_UPDATED_BY => fnd_global.user_id, -- Updated
3062: P_LAST_UPDATE_LOGIN => fnd_global.login_id); -- Updated
3063:
3064: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3065: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');
3066: END IF;

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

3202: X_ATTRIBUTE15 => l_osp_dtls_rec.ATTRIBUTE15,
3203: X_DESCRIPTION => l_osp_dtls_rec.DESCRIPTION,
3204: 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
3205: X_LAST_UPDATE_DATE => TRUNC(sysdate), -- Updated
3206: X_LAST_UPDATED_BY => fnd_global.user_id, -- Updated
3207: X_LAST_UPDATE_LOGIN => fnd_global.login_id); -- Updated
3208: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3209: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');
3210: END IF;

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

3203: X_DESCRIPTION => l_osp_dtls_rec.DESCRIPTION,
3204: 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
3205: X_LAST_UPDATE_DATE => TRUNC(sysdate), -- Updated
3206: X_LAST_UPDATED_BY => fnd_global.user_id, -- Updated
3207: X_LAST_UPDATE_LOGIN => fnd_global.login_id); -- Updated
3208: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3209: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');
3210: END IF;
3211: END Update_OSP_Order;