DBA Data[Home] [Help]

APPS.AHL_PP_MATERIALS_PVT dependencies on FND_GLOBAL

Line 1712: X_CREATED_BY => fnd_global.user_id,

1708: X_ATTRIBUTE13 => l_Req_Material_Tbl(i).attribute13,
1709: X_ATTRIBUTE14 => l_Req_Material_Tbl(i).attribute14,
1710: X_ATTRIBUTE15 => l_Req_Material_Tbl(i).attribute15,
1711: X_CREATION_DATE => SYSDATE,
1712: X_CREATED_BY => fnd_global.user_id,
1713: X_LAST_UPDATE_DATE => SYSDATE,
1714: X_LAST_UPDATED_BY => fnd_global.user_id,
1715: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1716: );

Line 1714: X_LAST_UPDATED_BY => fnd_global.user_id,

1710: X_ATTRIBUTE15 => l_Req_Material_Tbl(i).attribute15,
1711: X_CREATION_DATE => SYSDATE,
1712: X_CREATED_BY => fnd_global.user_id,
1713: X_LAST_UPDATE_DATE => SYSDATE,
1714: X_LAST_UPDATED_BY => fnd_global.user_id,
1715: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1716: );
1717:
1718: --Assign out parameter

Line 1715: X_LAST_UPDATE_LOGIN => fnd_global.login_id

1711: X_CREATION_DATE => SYSDATE,
1712: X_CREATED_BY => fnd_global.user_id,
1713: X_LAST_UPDATE_DATE => SYSDATE,
1714: X_LAST_UPDATED_BY => fnd_global.user_id,
1715: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1716: );
1717:
1718: --Assign out parameter
1719: p_x_req_material_tbl(i).schedule_material_id := l_schedule_material_id;

Line 1781: X_CREATED_BY => fnd_global.user_id,

1777: X_ATTRIBUTE13 => l_Req_Material_Tbl(i).attribute13,
1778: X_ATTRIBUTE14 => l_Req_Material_Tbl(i).attribute14,
1779: X_ATTRIBUTE15 => l_Req_Material_Tbl(i).attribute15,
1780: X_CREATION_DATE => SYSDATE,
1781: X_CREATED_BY => fnd_global.user_id,
1782: X_LAST_UPDATE_DATE => SYSDATE,
1783: X_LAST_UPDATED_BY => fnd_global.user_id,
1784: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1785: );

Line 1783: X_LAST_UPDATED_BY => fnd_global.user_id,

1779: X_ATTRIBUTE15 => l_Req_Material_Tbl(i).attribute15,
1780: X_CREATION_DATE => SYSDATE,
1781: X_CREATED_BY => fnd_global.user_id,
1782: X_LAST_UPDATE_DATE => SYSDATE,
1783: X_LAST_UPDATED_BY => fnd_global.user_id,
1784: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1785: );
1786:
1787: --Assign out parameter

Line 1784: X_LAST_UPDATE_LOGIN => fnd_global.login_id

1780: X_CREATION_DATE => SYSDATE,
1781: X_CREATED_BY => fnd_global.user_id,
1782: X_LAST_UPDATE_DATE => SYSDATE,
1783: X_LAST_UPDATED_BY => fnd_global.user_id,
1784: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1785: );
1786:
1787: --Assign out parameter
1788: --

Line 1819: p_last_updated_by => fnd_global.user_id,

1815: Log_Transaction_Record
1816: ( p_wo_operation_txn_id => l_wo_operation_txn_id,
1817: p_object_version_number => 1,
1818: p_last_update_date => sysdate,
1819: p_last_updated_by => fnd_global.user_id,
1820: p_creation_date => sysdate,
1821: p_created_by => fnd_global.user_id,
1822: p_last_update_login => fnd_global.login_id,
1823: p_load_type_code => 2,

Line 1821: p_created_by => fnd_global.user_id,

1817: p_object_version_number => 1,
1818: p_last_update_date => sysdate,
1819: p_last_updated_by => fnd_global.user_id,
1820: p_creation_date => sysdate,
1821: p_created_by => fnd_global.user_id,
1822: p_last_update_login => fnd_global.login_id,
1823: p_load_type_code => 2,
1824: p_transaction_type_code => 1,
1825: p_workorder_operation_id => p_x_req_material_tbl(i).workorder_operation_id,

Line 1822: p_last_update_login => fnd_global.login_id,

1818: p_last_update_date => sysdate,
1819: p_last_updated_by => fnd_global.user_id,
1820: p_creation_date => sysdate,
1821: p_created_by => fnd_global.user_id,
1822: p_last_update_login => fnd_global.login_id,
1823: p_load_type_code => 2,
1824: p_transaction_type_code => 1,
1825: p_workorder_operation_id => p_x_req_material_tbl(i).workorder_operation_id,
1826: p_schedule_material_id => p_x_req_material_tbl(i).schedule_material_id,

Line 1885: X_CREATED_BY => fnd_global.user_id,

1881: X_ATTRIBUTE13 => l_Req_Material_Tbl(i).attribute13,
1882: X_ATTRIBUTE14 => l_Req_Material_Tbl(i).attribute14,
1883: X_ATTRIBUTE15 => l_Req_Material_Tbl(i).attribute15,
1884: X_CREATION_DATE => SYSDATE,
1885: X_CREATED_BY => fnd_global.user_id,
1886: X_LAST_UPDATE_DATE => SYSDATE,
1887: X_LAST_UPDATED_BY => fnd_global.user_id,
1888: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1889: );

Line 1887: X_LAST_UPDATED_BY => fnd_global.user_id,

1883: X_ATTRIBUTE15 => l_Req_Material_Tbl(i).attribute15,
1884: X_CREATION_DATE => SYSDATE,
1885: X_CREATED_BY => fnd_global.user_id,
1886: X_LAST_UPDATE_DATE => SYSDATE,
1887: X_LAST_UPDATED_BY => fnd_global.user_id,
1888: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1889: );
1890:
1891: --Assign out parameter

Line 1888: X_LAST_UPDATE_LOGIN => fnd_global.login_id

1884: X_CREATION_DATE => SYSDATE,
1885: X_CREATED_BY => fnd_global.user_id,
1886: X_LAST_UPDATE_DATE => SYSDATE,
1887: X_LAST_UPDATED_BY => fnd_global.user_id,
1888: X_LAST_UPDATE_LOGIN => fnd_global.login_id
1889: );
1890:
1891: --Assign out parameter
1892: p_x_req_material_tbl(i).schedule_material_id := l_schedule_material_id;

Line 2411: p_last_updated_by => fnd_global.user_id,

2407: Log_Transaction_Record
2408: ( p_wo_operation_txn_id => l_wo_operation_txn_id,
2409: p_object_version_number => 1,
2410: p_last_update_date => sysdate,
2411: p_last_updated_by => fnd_global.user_id,
2412: p_creation_date => sysdate,
2413: p_created_by => fnd_global.user_id,
2414: p_last_update_login => fnd_global.login_id,
2415: p_load_type_code => 2,

Line 2413: p_created_by => fnd_global.user_id,

2409: p_object_version_number => 1,
2410: p_last_update_date => sysdate,
2411: p_last_updated_by => fnd_global.user_id,
2412: p_creation_date => sysdate,
2413: p_created_by => fnd_global.user_id,
2414: p_last_update_login => fnd_global.login_id,
2415: p_load_type_code => 2,
2416: p_transaction_type_code => 1,
2417: p_workorder_operation_id => p_x_req_material_tbl(i).workorder_operation_id,

Line 2414: p_last_update_login => fnd_global.login_id,

2410: p_last_update_date => sysdate,
2411: p_last_updated_by => fnd_global.user_id,
2412: p_creation_date => sysdate,
2413: p_created_by => fnd_global.user_id,
2414: p_last_update_login => fnd_global.login_id,
2415: p_load_type_code => 2,
2416: p_transaction_type_code => 1,
2417: p_workorder_operation_id => p_x_req_material_tbl(i).workorder_operation_id,
2418: p_schedule_material_id => p_x_req_material_tbl(i).schedule_material_id,

Line 2754: last_updated_by = fnd_global.user_id,

2750: attribute13 = l_req_material_rec.attribute13,
2751: attribute14 = l_req_material_rec.attribute14,
2752: attribute15 = l_req_material_rec.attribute15,
2753: last_update_date = sysdate,
2754: last_updated_by = fnd_global.user_id,
2755: last_update_login = fnd_global.login_id
2756: WHERE scheduled_material_id = p_x_req_material_tbl(i).schedule_material_id;
2757: --
2758:

Line 2755: last_update_login = fnd_global.login_id

2751: attribute14 = l_req_material_rec.attribute14,
2752: attribute15 = l_req_material_rec.attribute15,
2753: last_update_date = sysdate,
2754: last_updated_by = fnd_global.user_id,
2755: last_update_login = fnd_global.login_id
2756: WHERE scheduled_material_id = p_x_req_material_tbl(i).schedule_material_id;
2757: --
2758:
2759: END IF; -- p_x_req_material_tbl(i).schedule_material_id

Line 4244: last_updated_by = fnd_global.user_id,

4240: requested_date = trunc(l_prd_wooperation_tbl(i).scheduled_start_date),
4241: organization_id = l_Visit_Task_Rec.organization_id,
4242: object_version_number = object_version_number + 1,
4243: last_update_date = sysdate,
4244: last_updated_by = fnd_global.user_id,
4245: last_update_login = fnd_global.login_id,
4246: ATTRIBUTE_CATEGORY = l_req_material_tbl(l_idx).attribute_category,
4247: ATTRIBUTE1 = l_req_material_tbl(l_idx).attribute1,
4248: ATTRIBUTE2 = l_req_material_tbl(l_idx).attribute2,

Line 4245: last_update_login = fnd_global.login_id,

4241: organization_id = l_Visit_Task_Rec.organization_id,
4242: object_version_number = object_version_number + 1,
4243: last_update_date = sysdate,
4244: last_updated_by = fnd_global.user_id,
4245: last_update_login = fnd_global.login_id,
4246: ATTRIBUTE_CATEGORY = l_req_material_tbl(l_idx).attribute_category,
4247: ATTRIBUTE1 = l_req_material_tbl(l_idx).attribute1,
4248: ATTRIBUTE2 = l_req_material_tbl(l_idx).attribute2,
4249: ATTRIBUTE3 = l_req_material_tbl(l_idx).attribute3,

Line 4311: last_updated_by = fnd_global.user_id,

4307: -- AnRaj: truncating Requested Date for Material Requirement based on discussions with PM
4308: requested_date = trunc(l_prd_wooperation_tbl(i).scheduled_start_date),
4309: organization_id = l_Visit_Task_Rec.organization_id,
4310: last_update_date = sysdate,
4311: last_updated_by = fnd_global.user_id,
4312: last_update_login = fnd_global.login_id,
4313: ATTRIBUTE_CATEGORY = l_req_material_tbl(l_idx).attribute_category,
4314: ATTRIBUTE1 = l_req_material_tbl(l_idx).attribute1,
4315: ATTRIBUTE2 = l_req_material_tbl(l_idx).attribute2,

Line 4312: last_update_login = fnd_global.login_id,

4308: requested_date = trunc(l_prd_wooperation_tbl(i).scheduled_start_date),
4309: organization_id = l_Visit_Task_Rec.organization_id,
4310: last_update_date = sysdate,
4311: last_updated_by = fnd_global.user_id,
4312: last_update_login = fnd_global.login_id,
4313: ATTRIBUTE_CATEGORY = l_req_material_tbl(l_idx).attribute_category,
4314: ATTRIBUTE1 = l_req_material_tbl(l_idx).attribute1,
4315: ATTRIBUTE2 = l_req_material_tbl(l_idx).attribute2,
4316: ATTRIBUTE3 = l_req_material_tbl(l_idx).attribute3,

Line 4402: last_updated_by = fnd_global.user_id,

4398: -- AnRaj: truncating Requested Date for Material Requirement based on discussions with PM
4399: SET requested_date = trunc(l_prd_wooperation_tbl(i).actual_start_date),
4400: object_version_number = object_version_number + 1,
4401: last_update_date = sysdate,
4402: last_updated_by = fnd_global.user_id,
4403: last_update_login = fnd_global.login_id
4404: WHERE scheduled_material_id = l_scheduled_material_id;
4405:
4406: END IF;

Line 4403: last_update_login = fnd_global.login_id

4399: SET requested_date = trunc(l_prd_wooperation_tbl(i).actual_start_date),
4400: object_version_number = object_version_number + 1,
4401: last_update_date = sysdate,
4402: last_updated_by = fnd_global.user_id,
4403: last_update_login = fnd_global.login_id
4404: WHERE scheduled_material_id = l_scheduled_material_id;
4405:
4406: END IF;
4407: END LOOP;