APPS.PO_AUTOCREATE_GROUPING_PVT dependencies on FND_PROFILE

Line 804: IF ( ( FND_PROFILE.value('PO_USE_REQ_NUM_IN_AUTOCREATE') = 'Y' )

800: -- (a) "PO: Use Requisition Line Numbers for Autocreate" is set, and
801: -- (b) we are creating a new PO, and
802: -- (c) all req lines in the Doc Builder come from the same req.
803: --
804: IF ( ( FND_PROFILE.value('PO_USE_REQ_NUM_IN_AUTOCREATE') = 'Y' )
805: AND ( p_add_to_po_header_id IS NULL )
806: AND ( has_same_req_header(p_req_line_id_tbl) ) )
807: THEN
808: d_position := 30;

Line 952: l_need_by_grouping_profile := fnd_profile.value('PO_NEED_BY_GROUPING');

948: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);
949: END IF;
950:
951: -- Get shipment-level profiles
952: l_need_by_grouping_profile := fnd_profile.value('PO_NEED_BY_GROUPING');
953: l_ship_to_grouping_profile := fnd_profile.value('PO_SHIPTO_GROUPING');
954:
955: -- Retrieve all shipment-level attributes for p_req_line_id
956: delivery_one := get_req_line_delivery_info(

Line 953: l_ship_to_grouping_profile := fnd_profile.value('PO_SHIPTO_GROUPING');

949: END IF;
950:
951: -- Get shipment-level profiles
952: l_need_by_grouping_profile := fnd_profile.value('PO_NEED_BY_GROUPING');
953: l_ship_to_grouping_profile := fnd_profile.value('PO_SHIPTO_GROUPING');
954:
955: -- Retrieve all shipment-level attributes for p_req_line_id
956: delivery_one := get_req_line_delivery_info(
957: p_req_line_id,

Line 2297: FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;

2293: IS
2294: l_key NUMBER;
2295:
2296: l_need_by_grouping_profile
2297: FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
2298: l_ship_to_grouping_profile
2299: FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
2300:
2301: d_mod CONSTANT VARCHAR2(100) := D_match_add_to_po_lines;

Line 2299: FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;

2295:
2296: l_need_by_grouping_profile
2297: FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
2298: l_ship_to_grouping_profile
2299: FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
2300:
2301: d_mod CONSTANT VARCHAR2(100) := D_match_add_to_po_lines;
2302: d_position NUMBER := 0;
2303:

Line 2325: l_need_by_grouping_profile := FND_PROFILE.value('PO_NEED_BY_GROUPING');

2321: l_key := PO_CORE_S.get_session_gt_nextval;
2322:
2323: -- Get Profile Option values to be used in query.
2324: --
2325: l_need_by_grouping_profile := FND_PROFILE.value('PO_NEED_BY_GROUPING');
2326: l_ship_to_grouping_profile := FND_PROFILE.value('PO_SHIPTO_GROUPING');
2327:
2328: d_position := 20;
2329: IF PO_LOG.d_stmt THEN

Line 2326: l_ship_to_grouping_profile := FND_PROFILE.value('PO_SHIPTO_GROUPING');

2322:
2323: -- Get Profile Option values to be used in query.
2324: --
2325: l_need_by_grouping_profile := FND_PROFILE.value('PO_NEED_BY_GROUPING');
2326: l_ship_to_grouping_profile := FND_PROFILE.value('PO_SHIPTO_GROUPING');
2327:
2328: d_position := 20;
2329: IF PO_LOG.d_stmt THEN
2330: PO_LOG.stmt(d_mod,d_position,'l_key',l_key);