DBA Data[Home] [Help]

APPS.CSP_ITEM_PL_PARAMS_PVT dependencies on FND_GLOBAL

Line 106: last_updated_by = fnd_global.user_id,

102: newbuy_edq_factor = decode(p_newbuy_edq_factor, nvl(l_item_newbuy_edq_factor, l_newbuy_edq_factor), newbuy_edq_factor, p_newbuy_edq_factor),
103: excess_edq_multiple = decode(p_excess_edq_multiple, nvl(l_item_excess_Edq_multiple, l_edq_multiple), excess_edq_multiple, p_excess_edq_multiple),
104: repair_edq_multiple = decode(p_repair_edq_multiple, nvl(l_item_repair_edq_multiple, l_edq_multiple), repair_edq_multiple, p_repair_edq_multiple),
105: newbuy_edq_multiple = decode(p_newbuy_edq_multiple, nvl(l_item_newbuy_edq_multiple, l_edq_multiple), newbuy_edq_multiple, p_newbuy_edq_multiple),
106: last_updated_by = fnd_global.user_id,
107: last_update_date = sysdate,
108: last_update_login = fnd_global.login_id
109: WHERE organization_id = p_organization_id
110: AND inventory_item_id = p_inventory_item_id;

Line 108: last_update_login = fnd_global.login_id

104: repair_edq_multiple = decode(p_repair_edq_multiple, nvl(l_item_repair_edq_multiple, l_edq_multiple), repair_edq_multiple, p_repair_edq_multiple),
105: newbuy_edq_multiple = decode(p_newbuy_edq_multiple, nvl(l_item_newbuy_edq_multiple, l_edq_multiple), newbuy_edq_multiple, p_newbuy_edq_multiple),
106: last_updated_by = fnd_global.user_id,
107: last_update_date = sysdate,
108: last_update_login = fnd_global.login_id
109: WHERE organization_id = p_organization_id
110: AND inventory_item_id = p_inventory_item_id;
111:
112: csp_plan_details_pkg.reorders(p_organization_id,p_inventory_item_id);

Line 151: fnd_global.user_id created_by,

147: SELECT
148: l_item_pl_params_s,
149: p_organization_id,
150: p_inventory_item_id,
151: fnd_global.user_id created_by,
152: sysdate creation_date,
153: fnd_global.user_id last_updated_by,
154: sysdate last_update_Date,
155: fnd_global.login_id last_update_login,

Line 153: fnd_global.user_id last_updated_by,

149: p_organization_id,
150: p_inventory_item_id,
151: fnd_global.user_id created_by,
152: sysdate creation_date,
153: fnd_global.user_id last_updated_by,
154: sysdate last_update_Date,
155: fnd_global.login_id last_update_login,
156: decode(nvl(p_excess_service_level, 0), nvl(cpp.excess_service_level, 0), null, p_excess_service_level) excess_Service_level,
157: decode(p_repair_service_level, cpp.repair_service_level, null, p_repair_service_level) repair_Service_level,

Line 155: fnd_global.login_id last_update_login,

151: fnd_global.user_id created_by,
152: sysdate creation_date,
153: fnd_global.user_id last_updated_by,
154: sysdate last_update_Date,
155: fnd_global.login_id last_update_login,
156: decode(nvl(p_excess_service_level, 0), nvl(cpp.excess_service_level, 0), null, p_excess_service_level) excess_Service_level,
157: decode(p_repair_service_level, cpp.repair_service_level, null, p_repair_service_level) repair_Service_level,
158: decode(p_newbuy_service_level, cpp.newbuy_service_level, null, p_newbuy_service_level) newbuy_service_level,
159: decode(p_excess_edq_factor, cpp.excess_edq_factor, null, p_excess_edq_Factor) excess_edq_Factor,