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.

[Home] [Help]

APPS.PO_AUTOCREATE_GROUPING_PVT dependencies on FND_PROFILE

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

1224: -- (a) "PO: Use Requisition Line Numbers for Autocreate" is set, and
1225: -- (b) we are creating a new PO, and
1226: -- (c) all req lines in the Doc Builder come from the same req.
1227: --
1228: IF ( ( FND_PROFILE.value('PO_USE_REQ_NUM_IN_AUTOCREATE') = 'Y' )
1229: AND ( p_add_to_po_header_id IS NULL )
1230: AND ( has_same_req_header(p_req_line_id_tbl) ) )
1231: THEN
1232: d_position := 30;

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

1417: -- (a) "PO: Use Requisition Line Numbers for Autocreate" is set, and
1418: -- (b) we are creating a new PO, and
1419: -- (c) all req lines in the Doc Builder come from the same req.
1420: --
1421: IF ( ( FND_PROFILE.value('PO_USE_REQ_NUM_IN_AUTOCREATE') = 'Y' )
1422: AND ( p_add_to_po_header_id IS NULL )
1423: AND ( has_same_req_header(p_req_line_id_tbl) ) )
1424: THEN
1425: d_position := 30;

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

2426: PO_LOG.proc_begin(d_mod,'p_po_line_id_to_compare',p_po_line_id_to_compare);
2427: END IF;
2428:
2429: -- Get shipment-level profiles
2430: l_need_by_grouping_profile := fnd_profile.value('PO_NEED_BY_GROUPING');
2431: l_ship_to_grouping_profile := fnd_profile.value('PO_SHIPTO_GROUPING');
2432:
2433: -- Retrieve all shipment-level attributes for p_req_line_id
2434: delivery_one := get_req_line_delivery_info(

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

2427: END IF;
2428:
2429: -- Get shipment-level profiles
2430: l_need_by_grouping_profile := fnd_profile.value('PO_NEED_BY_GROUPING');
2431: l_ship_to_grouping_profile := fnd_profile.value('PO_SHIPTO_GROUPING');
2432:
2433: -- Retrieve all shipment-level attributes for p_req_line_id
2434: delivery_one := get_req_line_delivery_info(
2435: p_req_line_id,

Line 4144: FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;

4140: IS
4141: l_key NUMBER;
4142:
4143: l_need_by_grouping_profile
4144: FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
4145: l_ship_to_grouping_profile
4146: FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
4147:
4148: d_mod CONSTANT VARCHAR2(100) := D_match_add_to_po_lines;

Line 4146: FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;

4142:
4143: l_need_by_grouping_profile
4144: FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
4145: l_ship_to_grouping_profile
4146: FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
4147:
4148: d_mod CONSTANT VARCHAR2(100) := D_match_add_to_po_lines;
4149: d_position NUMBER := 0;
4150:

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

4168: l_key := PO_CORE_S.get_session_gt_nextval;
4169:
4170: -- Get Profile Option values to be used in query.
4171: --
4172: l_need_by_grouping_profile := FND_PROFILE.value('PO_NEED_BY_GROUPING');
4173: l_ship_to_grouping_profile := FND_PROFILE.value('PO_SHIPTO_GROUPING');
4174:
4175: d_position := 20;
4176: IF PO_LOG.d_stmt THEN

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

4169:
4170: -- Get Profile Option values to be used in query.
4171: --
4172: l_need_by_grouping_profile := FND_PROFILE.value('PO_NEED_BY_GROUPING');
4173: l_ship_to_grouping_profile := FND_PROFILE.value('PO_SHIPTO_GROUPING');
4174:
4175: d_position := 20;
4176: IF PO_LOG.d_stmt THEN
4177: PO_LOG.stmt(d_mod,d_position,'l_key',l_key);

Line 4291: FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;

4287: l_key NUMBER;
4288: l_po_line_num_disp_tbl PO_TBL_VARCHAR100 := PO_TBL_VARCHAR100();
4289:
4290: l_need_by_grouping_profile
4291: FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
4292: l_ship_to_grouping_profile
4293: FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
4294:
4295: d_mod CONSTANT VARCHAR2(100) := D_clm_match_add_to_po_lines;

Line 4293: FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;

4289:
4290: l_need_by_grouping_profile
4291: FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
4292: l_ship_to_grouping_profile
4293: FND_PROFILE_OPTION_VALUES.profile_option_value%TYPE;
4294:
4295: d_mod CONSTANT VARCHAR2(100) := D_clm_match_add_to_po_lines;
4296: d_position NUMBER := 0;
4297:

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

4317: l_key := PO_CORE_S.get_session_gt_nextval;
4318:
4319: -- Get Profile Option values to be used in query.
4320: --
4321: l_need_by_grouping_profile := FND_PROFILE.value('PO_NEED_BY_GROUPING');
4322: l_ship_to_grouping_profile := FND_PROFILE.value('PO_SHIPTO_GROUPING');
4323:
4324:
4325:

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

4318:
4319: -- Get Profile Option values to be used in query.
4320: --
4321: l_need_by_grouping_profile := FND_PROFILE.value('PO_NEED_BY_GROUPING');
4322: l_ship_to_grouping_profile := FND_PROFILE.value('PO_SHIPTO_GROUPING');
4323:
4324:
4325:
4326: d_position := 20;