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.MTL_RELATED_ITEMS_PVT dependencies on FND_GLOBAL

Line 367: ,p_instance_pk2_value => FND_GLOBAL.org_id

363: IF INV_EGO_REVISION_VALIDATE.check_data_security (
364: p_function => 'EGO_EDIT_RELATED_ITEMS'
365: ,p_object_name => 'EGO_ITEM'
366: ,p_instance_pk1_value => l_Rel_Item_Rec.INVENTORY_ITEM_ID
367: ,p_instance_pk2_value => FND_GLOBAL.org_id
368: ,P_User_Id => FND_GLOBAL.user_id) <> 'T'
369: OR
370: INV_EGO_REVISION_VALIDATE.check_data_security (
371: p_function => 'EGO_EDIT_RELATED_ITEMS'

Line 368: ,P_User_Id => FND_GLOBAL.user_id) <> 'T'

364: p_function => 'EGO_EDIT_RELATED_ITEMS'
365: ,p_object_name => 'EGO_ITEM'
366: ,p_instance_pk1_value => l_Rel_Item_Rec.INVENTORY_ITEM_ID
367: ,p_instance_pk2_value => FND_GLOBAL.org_id
368: ,P_User_Id => FND_GLOBAL.user_id) <> 'T'
369: OR
370: INV_EGO_REVISION_VALIDATE.check_data_security (
371: p_function => 'EGO_EDIT_RELATED_ITEMS'
372: ,p_object_name => 'EGO_ITEM'

Line 374: ,p_instance_pk2_value => FND_GLOBAL.org_id

370: INV_EGO_REVISION_VALIDATE.check_data_security (
371: p_function => 'EGO_EDIT_RELATED_ITEMS'
372: ,p_object_name => 'EGO_ITEM'
373: ,p_instance_pk1_value => l_Rel_Item_Rec.RELATED_ITEM_ID
374: ,p_instance_pk2_value => FND_GLOBAL.org_id
375: ,P_User_Id => FND_GLOBAL.user_id) <> 'T'
376: THEN
377: Error_Handler.Add_Error_message
378: (

Line 375: ,P_User_Id => FND_GLOBAL.user_id) <> 'T'

371: p_function => 'EGO_EDIT_RELATED_ITEMS'
372: ,p_object_name => 'EGO_ITEM'
373: ,p_instance_pk1_value => l_Rel_Item_Rec.RELATED_ITEM_ID
374: ,p_instance_pk2_value => FND_GLOBAL.org_id
375: ,P_User_Id => FND_GLOBAL.user_id) <> 'T'
376: THEN
377: Error_Handler.Add_Error_message
378: (
379: p_message_name => 'INV_IOI_ITEM_UPDATE_PRIV'

Line 911: --,X_CREATED_BY => NVL(L_REL_ITEM_REC.CREATED_BY, FND_GLOBAL.USER_ID)

907: ,X_ATTR_DATE9 => L_REL_ITEM_REC.ATTR_DATE9
908: ,X_ATTR_DATE10 => L_REL_ITEM_REC.ATTR_DATE10
909: ,X_PLANNING_ENABLED_FLAG => L_REL_ITEM_REC.PLANNING_ENABLED_FLAG
910: --,X_CREATION_DATE => Nvl(l_Rel_Item_Rec.Creation_Date, SYSDATE)
911: --,X_CREATED_BY => NVL(L_REL_ITEM_REC.CREATED_BY, FND_GLOBAL.USER_ID)
912: --,X_LAST_UPDATE_DATE => NVL(L_REL_ITEM_REC.LAST_UPDATE_DATE, sysdate)
913: --,X_LAST_UPDATED_BY => NVL(L_REL_ITEM_REC.LAST_UPDATED_BY, FND_GLOBAL.USER_ID)
914: --,X_LAST_UPDATE_LOGIN => NVL(L_REL_ITEM_REC.LAST_UPDATE_LOGIN, FND_GLOBAL.LOGIN_ID)
915: ,X_CREATION_DATE => SYSDATE

Line 913: --,X_LAST_UPDATED_BY => NVL(L_REL_ITEM_REC.LAST_UPDATED_BY, FND_GLOBAL.USER_ID)

909: ,X_PLANNING_ENABLED_FLAG => L_REL_ITEM_REC.PLANNING_ENABLED_FLAG
910: --,X_CREATION_DATE => Nvl(l_Rel_Item_Rec.Creation_Date, SYSDATE)
911: --,X_CREATED_BY => NVL(L_REL_ITEM_REC.CREATED_BY, FND_GLOBAL.USER_ID)
912: --,X_LAST_UPDATE_DATE => NVL(L_REL_ITEM_REC.LAST_UPDATE_DATE, sysdate)
913: --,X_LAST_UPDATED_BY => NVL(L_REL_ITEM_REC.LAST_UPDATED_BY, FND_GLOBAL.USER_ID)
914: --,X_LAST_UPDATE_LOGIN => NVL(L_REL_ITEM_REC.LAST_UPDATE_LOGIN, FND_GLOBAL.LOGIN_ID)
915: ,X_CREATION_DATE => SYSDATE
916: ,X_CREATED_BY =>FND_GLOBAL.USER_ID
917: ,X_LAST_UPDATE_DATE => sysdate

Line 914: --,X_LAST_UPDATE_LOGIN => NVL(L_REL_ITEM_REC.LAST_UPDATE_LOGIN, FND_GLOBAL.LOGIN_ID)

910: --,X_CREATION_DATE => Nvl(l_Rel_Item_Rec.Creation_Date, SYSDATE)
911: --,X_CREATED_BY => NVL(L_REL_ITEM_REC.CREATED_BY, FND_GLOBAL.USER_ID)
912: --,X_LAST_UPDATE_DATE => NVL(L_REL_ITEM_REC.LAST_UPDATE_DATE, sysdate)
913: --,X_LAST_UPDATED_BY => NVL(L_REL_ITEM_REC.LAST_UPDATED_BY, FND_GLOBAL.USER_ID)
914: --,X_LAST_UPDATE_LOGIN => NVL(L_REL_ITEM_REC.LAST_UPDATE_LOGIN, FND_GLOBAL.LOGIN_ID)
915: ,X_CREATION_DATE => SYSDATE
916: ,X_CREATED_BY =>FND_GLOBAL.USER_ID
917: ,X_LAST_UPDATE_DATE => sysdate
918: ,X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

Line 916: ,X_CREATED_BY =>FND_GLOBAL.USER_ID

912: --,X_LAST_UPDATE_DATE => NVL(L_REL_ITEM_REC.LAST_UPDATE_DATE, sysdate)
913: --,X_LAST_UPDATED_BY => NVL(L_REL_ITEM_REC.LAST_UPDATED_BY, FND_GLOBAL.USER_ID)
914: --,X_LAST_UPDATE_LOGIN => NVL(L_REL_ITEM_REC.LAST_UPDATE_LOGIN, FND_GLOBAL.LOGIN_ID)
915: ,X_CREATION_DATE => SYSDATE
916: ,X_CREATED_BY =>FND_GLOBAL.USER_ID
917: ,X_LAST_UPDATE_DATE => sysdate
918: ,X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
919: ,X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID
920: ,X_OBJECT_VERSION_NUMBER => NULL

Line 918: ,X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

914: --,X_LAST_UPDATE_LOGIN => NVL(L_REL_ITEM_REC.LAST_UPDATE_LOGIN, FND_GLOBAL.LOGIN_ID)
915: ,X_CREATION_DATE => SYSDATE
916: ,X_CREATED_BY =>FND_GLOBAL.USER_ID
917: ,X_LAST_UPDATE_DATE => sysdate
918: ,X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
919: ,X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID
920: ,X_OBJECT_VERSION_NUMBER => NULL
921: );
922: END IF;

Line 919: ,X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID

915: ,X_CREATION_DATE => SYSDATE
916: ,X_CREATED_BY =>FND_GLOBAL.USER_ID
917: ,X_LAST_UPDATE_DATE => sysdate
918: ,X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
919: ,X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID
920: ,X_OBJECT_VERSION_NUMBER => NULL
921: );
922: END IF;
923:

Line 1163: --,X_LAST_UPDATED_BY => Nvl(l_Rel_Item_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)

1159: ,X_ATTR_DATE9 => l_Rel_Item_Rec.Attr_Date9
1160: ,X_ATTR_DATE10 => l_Rel_Item_Rec.Attr_Date10
1161: ,X_PLANNING_ENABLED_FLAG => l_Rel_Item_Rec.Planning_Enabled_Flag
1162: --,X_LAST_UPDATE_DATE => Nvl(l_Rel_Item_Rec.Last_Update_Date, SYSDATE)
1163: --,X_LAST_UPDATED_BY => Nvl(l_Rel_Item_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)
1164: --,X_LAST_UPDATE_LOGIN => Nvl(l_Rel_Item_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID)
1165: ,X_LAST_UPDATE_DATE => SYSDATE
1166: ,X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1167: ,X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID

Line 1164: --,X_LAST_UPDATE_LOGIN => Nvl(l_Rel_Item_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID)

1160: ,X_ATTR_DATE10 => l_Rel_Item_Rec.Attr_Date10
1161: ,X_PLANNING_ENABLED_FLAG => l_Rel_Item_Rec.Planning_Enabled_Flag
1162: --,X_LAST_UPDATE_DATE => Nvl(l_Rel_Item_Rec.Last_Update_Date, SYSDATE)
1163: --,X_LAST_UPDATED_BY => Nvl(l_Rel_Item_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)
1164: --,X_LAST_UPDATE_LOGIN => Nvl(l_Rel_Item_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID)
1165: ,X_LAST_UPDATE_DATE => SYSDATE
1166: ,X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1167: ,X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID
1168: );

Line 1166: ,X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

1162: --,X_LAST_UPDATE_DATE => Nvl(l_Rel_Item_Rec.Last_Update_Date, SYSDATE)
1163: --,X_LAST_UPDATED_BY => Nvl(l_Rel_Item_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)
1164: --,X_LAST_UPDATE_LOGIN => Nvl(l_Rel_Item_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID)
1165: ,X_LAST_UPDATE_DATE => SYSDATE
1166: ,X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1167: ,X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID
1168: );
1169: END IF;
1170:

Line 1167: ,X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID

1163: --,X_LAST_UPDATED_BY => Nvl(l_Rel_Item_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)
1164: --,X_LAST_UPDATE_LOGIN => Nvl(l_Rel_Item_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID)
1165: ,X_LAST_UPDATE_DATE => SYSDATE
1166: ,X_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1167: ,X_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID
1168: );
1169: END IF;
1170:
1171: -- raising post business event

Line 1576: --,P_CREATED_BY => Nvl(l_Rel_Item_Rec.Created_By, FND_GLOBAL.USER_ID)

1572: ,P_START_DATE => l_Pln_Info_Rec.Start_Date
1573: ,P_END_DATE => l_Pln_Info_Rec.End_Date
1574: ,P_ALL_CUSTOMERS_FLAG => l_Pln_Info_Rec.All_Customers_Flag
1575: --,P_CREATION_DATE => Nvl(l_Rel_Item_Rec.Creation_Date, SYSDATE)
1576: --,P_CREATED_BY => Nvl(l_Rel_Item_Rec.Created_By, FND_GLOBAL.USER_ID)
1577: --,P_LAST_UPDATE_DATE => Nvl(l_Rel_Item_Rec.Last_Update_Date, SYSDATE)
1578: --,P_LAST_UPDATED_BY => Nvl(l_Rel_Item_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)
1579: --,P_LAST_UPDATE_LOGIN => Nvl(l_Rel_Item_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID)
1580: ,P_CREATION_DATE => SYSDATE

Line 1578: --,P_LAST_UPDATED_BY => Nvl(l_Rel_Item_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)

1574: ,P_ALL_CUSTOMERS_FLAG => l_Pln_Info_Rec.All_Customers_Flag
1575: --,P_CREATION_DATE => Nvl(l_Rel_Item_Rec.Creation_Date, SYSDATE)
1576: --,P_CREATED_BY => Nvl(l_Rel_Item_Rec.Created_By, FND_GLOBAL.USER_ID)
1577: --,P_LAST_UPDATE_DATE => Nvl(l_Rel_Item_Rec.Last_Update_Date, SYSDATE)
1578: --,P_LAST_UPDATED_BY => Nvl(l_Rel_Item_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)
1579: --,P_LAST_UPDATE_LOGIN => Nvl(l_Rel_Item_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID)
1580: ,P_CREATION_DATE => SYSDATE
1581: ,P_CREATED_BY => FND_GLOBAL.USER_ID
1582: ,P_LAST_UPDATE_DATE => SYSDATE

Line 1579: --,P_LAST_UPDATE_LOGIN => Nvl(l_Rel_Item_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID)

1575: --,P_CREATION_DATE => Nvl(l_Rel_Item_Rec.Creation_Date, SYSDATE)
1576: --,P_CREATED_BY => Nvl(l_Rel_Item_Rec.Created_By, FND_GLOBAL.USER_ID)
1577: --,P_LAST_UPDATE_DATE => Nvl(l_Rel_Item_Rec.Last_Update_Date, SYSDATE)
1578: --,P_LAST_UPDATED_BY => Nvl(l_Rel_Item_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)
1579: --,P_LAST_UPDATE_LOGIN => Nvl(l_Rel_Item_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID)
1580: ,P_CREATION_DATE => SYSDATE
1581: ,P_CREATED_BY => FND_GLOBAL.USER_ID
1582: ,P_LAST_UPDATE_DATE => SYSDATE
1583: ,P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

Line 1581: ,P_CREATED_BY => FND_GLOBAL.USER_ID

1577: --,P_LAST_UPDATE_DATE => Nvl(l_Rel_Item_Rec.Last_Update_Date, SYSDATE)
1578: --,P_LAST_UPDATED_BY => Nvl(l_Rel_Item_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)
1579: --,P_LAST_UPDATE_LOGIN => Nvl(l_Rel_Item_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID)
1580: ,P_CREATION_DATE => SYSDATE
1581: ,P_CREATED_BY => FND_GLOBAL.USER_ID
1582: ,P_LAST_UPDATE_DATE => SYSDATE
1583: ,P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1584: ,P_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID
1585: ,X_PLN_INFO_ID => returned_pln_info_id

Line 1583: ,P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

1579: --,P_LAST_UPDATE_LOGIN => Nvl(l_Rel_Item_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID)
1580: ,P_CREATION_DATE => SYSDATE
1581: ,P_CREATED_BY => FND_GLOBAL.USER_ID
1582: ,P_LAST_UPDATE_DATE => SYSDATE
1583: ,P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1584: ,P_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID
1585: ,X_PLN_INFO_ID => returned_pln_info_id
1586: );
1587: END IF;

Line 1584: ,P_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID

1580: ,P_CREATION_DATE => SYSDATE
1581: ,P_CREATED_BY => FND_GLOBAL.USER_ID
1582: ,P_LAST_UPDATE_DATE => SYSDATE
1583: ,P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1584: ,P_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID
1585: ,X_PLN_INFO_ID => returned_pln_info_id
1586: );
1587: END IF;
1588:

Line 1619: -- ,P_LAST_UPDATED_BY => Nvl(l_Rel_Item_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)

1615: ,P_START_DATE => l_Pln_Info_Rec.Start_Date
1616: ,P_END_DATE => l_Pln_Info_Rec.End_Date
1617: ,P_ALL_CUSTOMERS_FLAG => l_Pln_Info_Rec.All_Customers_Flag
1618: -- ,P_LAST_UPDATE_DATE => Nvl(l_Rel_Item_Rec.Last_Update_Date, SYSDATE)
1619: -- ,P_LAST_UPDATED_BY => Nvl(l_Rel_Item_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)
1620: -- ,P_LAST_UPDATE_LOGIN => Nvl(l_Rel_Item_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID)
1621: ,P_LAST_UPDATE_DATE =>SYSDATE
1622: ,P_LAST_UPDATED_BY =>FND_GLOBAL.USER_ID
1623: ,P_LAST_UPDATE_LOGIN =>FND_GLOBAL.LOGIN_ID

Line 1620: -- ,P_LAST_UPDATE_LOGIN => Nvl(l_Rel_Item_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID)

1616: ,P_END_DATE => l_Pln_Info_Rec.End_Date
1617: ,P_ALL_CUSTOMERS_FLAG => l_Pln_Info_Rec.All_Customers_Flag
1618: -- ,P_LAST_UPDATE_DATE => Nvl(l_Rel_Item_Rec.Last_Update_Date, SYSDATE)
1619: -- ,P_LAST_UPDATED_BY => Nvl(l_Rel_Item_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)
1620: -- ,P_LAST_UPDATE_LOGIN => Nvl(l_Rel_Item_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID)
1621: ,P_LAST_UPDATE_DATE =>SYSDATE
1622: ,P_LAST_UPDATED_BY =>FND_GLOBAL.USER_ID
1623: ,P_LAST_UPDATE_LOGIN =>FND_GLOBAL.LOGIN_ID
1624: );

Line 1622: ,P_LAST_UPDATED_BY =>FND_GLOBAL.USER_ID

1618: -- ,P_LAST_UPDATE_DATE => Nvl(l_Rel_Item_Rec.Last_Update_Date, SYSDATE)
1619: -- ,P_LAST_UPDATED_BY => Nvl(l_Rel_Item_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)
1620: -- ,P_LAST_UPDATE_LOGIN => Nvl(l_Rel_Item_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID)
1621: ,P_LAST_UPDATE_DATE =>SYSDATE
1622: ,P_LAST_UPDATED_BY =>FND_GLOBAL.USER_ID
1623: ,P_LAST_UPDATE_LOGIN =>FND_GLOBAL.LOGIN_ID
1624: );
1625: END;
1626: END IF;

Line 1623: ,P_LAST_UPDATE_LOGIN =>FND_GLOBAL.LOGIN_ID

1619: -- ,P_LAST_UPDATED_BY => Nvl(l_Rel_Item_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)
1620: -- ,P_LAST_UPDATE_LOGIN => Nvl(l_Rel_Item_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID)
1621: ,P_LAST_UPDATE_DATE =>SYSDATE
1622: ,P_LAST_UPDATED_BY =>FND_GLOBAL.USER_ID
1623: ,P_LAST_UPDATE_LOGIN =>FND_GLOBAL.LOGIN_ID
1624: );
1625: END;
1626: END IF;
1627:

Line 1919: --,P_CREATED_BY => Nvl(l_Rel_Item_Rec.Created_By, FND_GLOBAL.USER_ID)

1915: ,P_SITE_USE_ID => l_Cust_Ref_Rec.Site_Use_Id
1916: ,P_START_DATE => l_Cust_Ref_Rec.Start_Date
1917: ,P_END_DATE => l_Cust_Ref_Rec.End_Date
1918: --,P_CREATION_DATE => Nvl(l_Rel_Item_Rec.Creation_Date, SYSDATE)
1919: --,P_CREATED_BY => Nvl(l_Rel_Item_Rec.Created_By, FND_GLOBAL.USER_ID)
1920: --,P_Last_Update_Date => Nvl(L_Rel_Item_Rec.Last_Update_Date, Sysdate)
1921: --,P_LAST_UPDATED_BY => Nvl(l_Rel_Item_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)
1922: --,P_LAST_UPDATE_LOGIN => Nvl(l_Rel_Item_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID)
1923: ,P_CREATION_DATE => SYSDATE

Line 1921: --,P_LAST_UPDATED_BY => Nvl(l_Rel_Item_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)

1917: ,P_END_DATE => l_Cust_Ref_Rec.End_Date
1918: --,P_CREATION_DATE => Nvl(l_Rel_Item_Rec.Creation_Date, SYSDATE)
1919: --,P_CREATED_BY => Nvl(l_Rel_Item_Rec.Created_By, FND_GLOBAL.USER_ID)
1920: --,P_Last_Update_Date => Nvl(L_Rel_Item_Rec.Last_Update_Date, Sysdate)
1921: --,P_LAST_UPDATED_BY => Nvl(l_Rel_Item_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)
1922: --,P_LAST_UPDATE_LOGIN => Nvl(l_Rel_Item_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID)
1923: ,P_CREATION_DATE => SYSDATE
1924: ,P_CREATED_BY => FND_GLOBAL.USER_ID
1925: ,P_Last_Update_Date => Sysdate

Line 1922: --,P_LAST_UPDATE_LOGIN => Nvl(l_Rel_Item_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID)

1918: --,P_CREATION_DATE => Nvl(l_Rel_Item_Rec.Creation_Date, SYSDATE)
1919: --,P_CREATED_BY => Nvl(l_Rel_Item_Rec.Created_By, FND_GLOBAL.USER_ID)
1920: --,P_Last_Update_Date => Nvl(L_Rel_Item_Rec.Last_Update_Date, Sysdate)
1921: --,P_LAST_UPDATED_BY => Nvl(l_Rel_Item_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)
1922: --,P_LAST_UPDATE_LOGIN => Nvl(l_Rel_Item_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID)
1923: ,P_CREATION_DATE => SYSDATE
1924: ,P_CREATED_BY => FND_GLOBAL.USER_ID
1925: ,P_Last_Update_Date => Sysdate
1926: ,P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

Line 1924: ,P_CREATED_BY => FND_GLOBAL.USER_ID

1920: --,P_Last_Update_Date => Nvl(L_Rel_Item_Rec.Last_Update_Date, Sysdate)
1921: --,P_LAST_UPDATED_BY => Nvl(l_Rel_Item_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)
1922: --,P_LAST_UPDATE_LOGIN => Nvl(l_Rel_Item_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID)
1923: ,P_CREATION_DATE => SYSDATE
1924: ,P_CREATED_BY => FND_GLOBAL.USER_ID
1925: ,P_Last_Update_Date => Sysdate
1926: ,P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1927: ,P_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID
1928: );

Line 1926: ,P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

1922: --,P_LAST_UPDATE_LOGIN => Nvl(l_Rel_Item_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID)
1923: ,P_CREATION_DATE => SYSDATE
1924: ,P_CREATED_BY => FND_GLOBAL.USER_ID
1925: ,P_Last_Update_Date => Sysdate
1926: ,P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1927: ,P_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID
1928: );
1929: END;
1930:

Line 1927: ,P_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID

1923: ,P_CREATION_DATE => SYSDATE
1924: ,P_CREATED_BY => FND_GLOBAL.USER_ID
1925: ,P_Last_Update_Date => Sysdate
1926: ,P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1927: ,P_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID
1928: );
1929: END;
1930:
1931: End If;

Line 1959: --,P_LAST_UPDATED_BY => Nvl(l_Rel_Item_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)

1955: ,P_SITE_USE_ID => l_Cust_Ref_Rec.Site_Use_Id
1956: ,P_START_DATE => l_Cust_Ref_Rec.Start_Date
1957: ,P_END_DATE => l_Cust_Ref_Rec.End_Date
1958: --,P_LAST_UPDATE_DATE => Nvl(l_Rel_Item_Rec.Last_Update_Date, SYSDATE)
1959: --,P_LAST_UPDATED_BY => Nvl(l_Rel_Item_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)
1960: --,P_LAST_UPDATE_LOGIN => Nvl(l_Rel_Item_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID)
1961: ,P_LAST_UPDATE_DATE => SYSDATE
1962: ,P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1963: ,P_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID

Line 1960: --,P_LAST_UPDATE_LOGIN => Nvl(l_Rel_Item_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID)

1956: ,P_START_DATE => l_Cust_Ref_Rec.Start_Date
1957: ,P_END_DATE => l_Cust_Ref_Rec.End_Date
1958: --,P_LAST_UPDATE_DATE => Nvl(l_Rel_Item_Rec.Last_Update_Date, SYSDATE)
1959: --,P_LAST_UPDATED_BY => Nvl(l_Rel_Item_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)
1960: --,P_LAST_UPDATE_LOGIN => Nvl(l_Rel_Item_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID)
1961: ,P_LAST_UPDATE_DATE => SYSDATE
1962: ,P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1963: ,P_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID
1964: );

Line 1962: ,P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID

1958: --,P_LAST_UPDATE_DATE => Nvl(l_Rel_Item_Rec.Last_Update_Date, SYSDATE)
1959: --,P_LAST_UPDATED_BY => Nvl(l_Rel_Item_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)
1960: --,P_LAST_UPDATE_LOGIN => Nvl(l_Rel_Item_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID)
1961: ,P_LAST_UPDATE_DATE => SYSDATE
1962: ,P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1963: ,P_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID
1964: );
1965: END;
1966: END IF;

Line 1963: ,P_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID

1959: --,P_LAST_UPDATED_BY => Nvl(l_Rel_Item_Rec.Last_Updated_By, FND_GLOBAL.USER_ID)
1960: --,P_LAST_UPDATE_LOGIN => Nvl(l_Rel_Item_Rec.Last_Update_Login, FND_GLOBAL.LOGIN_ID)
1961: ,P_LAST_UPDATE_DATE => SYSDATE
1962: ,P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID
1963: ,P_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID
1964: );
1965: END;
1966: END IF;
1967: END IF;

Line 2270: REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID

2266:
2267: FOR L_MTL_REL_ITEM_REC IN C_INTF_ROWS(P_DATA_SET_ID) LOOP
2268: UPDATE MTL_RELATED_ITEMS_INTERFACE
2269: SET TRANSACTION_ID = MTL_RELATED_ITEMS_INTERFACE_S.NEXTVAL,
2270: REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID
2271: WHERE ROWID = l_mtl_Rel_Item_rec.ROWID;
2272: END LOOP;
2273:
2274: FOR l_mtl_Rel_Item_rec IN c_intf_rows(p_data_set_id) LOOP

Line 2526: ,user_id => fnd_global.user_id

2522: -- place into mtl_interface_error_table
2523: l_dummyInt := mtl_cross_references_pvt.LOG_ERROR --bug 12533707 -- invpuopi.mtl_log_interface_err
2524: (
2525: org_id => l_msg.organization_id
2526: ,user_id => fnd_global.user_id
2527: ,login_id => fnd_global.login_id
2528: ,prog_appid => null
2529: ,prog_id => null
2530: ,req_id => fnd_global.conc_request_id

Line 2527: ,login_id => fnd_global.login_id

2523: l_dummyInt := mtl_cross_references_pvt.LOG_ERROR --bug 12533707 -- invpuopi.mtl_log_interface_err
2524: (
2525: org_id => l_msg.organization_id
2526: ,user_id => fnd_global.user_id
2527: ,login_id => fnd_global.login_id
2528: ,prog_appid => null
2529: ,prog_id => null
2530: ,req_id => fnd_global.conc_request_id
2531: ,trans_id => l_mtl_Rel_Item_rec.Transaction_Id

Line 2530: ,req_id => fnd_global.conc_request_id

2526: ,user_id => fnd_global.user_id
2527: ,login_id => fnd_global.login_id
2528: ,prog_appid => null
2529: ,prog_id => null
2530: ,req_id => fnd_global.conc_request_id
2531: ,trans_id => l_mtl_Rel_Item_rec.Transaction_Id
2532: ,error_text => l_msg.message_text
2533: ,p_column_name => null
2534: ,tbl_name => 'MTL_RELATED_ITEMS_INTERFACE'