DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_MAINPROC_PVT dependencies on FND_PROFILE

Line 269: l_needby_prf := fnd_profile.value('PO_NEED_BY_GROUPING');

265: PO_DEBUG.debug_begin(p_log_head => g_log_head || l_api_name);
266: END IF;
267:
268: /* Get the profile option values to determine grouping criteria */
269: l_needby_prf := fnd_profile.value('PO_NEED_BY_GROUPING');
270: l_shipto_prf := fnd_profile.value('PO_SHIPTO_GROUPING');
271:
272: /* OE drop ship requirement
273: ** Do not consolidate any shipments linked to a sales order

Line 270: l_shipto_prf := fnd_profile.value('PO_SHIPTO_GROUPING');

266: END IF;
267:
268: /* Get the profile option values to determine grouping criteria */
269: l_needby_prf := fnd_profile.value('PO_NEED_BY_GROUPING');
270: l_shipto_prf := fnd_profile.value('PO_SHIPTO_GROUPING');
271:
272: /* OE drop ship requirement
273: ** Do not consolidate any shipments linked to a sales order
274: ** Neither add them to existing shipments

Line 1294: l_needby_prf := fnd_profile.value('PO_NEED_BY_GROUPING');

1290: IF g_debug_stmt THEN
1291: po_debug.debug_begin (p_log_head => g_log_head || l_api_name);
1292: END IF;
1293:
1294: l_needby_prf := fnd_profile.value('PO_NEED_BY_GROUPING');
1295: l_shipto_prf := fnd_profile.value('PO_SHIPTO_GROUPING');
1296:
1297: IF g_debug_stmt THEN
1298: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,

Line 1295: l_shipto_prf := fnd_profile.value('PO_SHIPTO_GROUPING');

1291: po_debug.debug_begin (p_log_head => g_log_head || l_api_name);
1292: END IF;
1293:
1294: l_needby_prf := fnd_profile.value('PO_NEED_BY_GROUPING');
1295: l_shipto_prf := fnd_profile.value('PO_SHIPTO_GROUPING');
1296:
1297: IF g_debug_stmt THEN
1298: po_debug.debug_stmt (p_log_head => g_log_head || l_api_name, p_token => l_progress,
1299: p_message => 'PO: Use Need-by Date for Default Autocreate grouping : ' || l_needby_prf);

Line 1338: IF (fnd_profile.VALUE ('PO_USE_REQ_NUM_IN_AUTOCREATE') = 'Y' AND po_autocreate_params.g_interface_source_code <> 'SOURCING') THEN

1334: IF (x_document_subtype IN ('STANDARD', 'PLANNED')) THEN
1335: -- For Standard and Planned POs, the line number
1336: -- will be the same as the req line number if the profile
1337: -- is set to 'Y' otherwise use sequential numbers
1338: IF (fnd_profile.VALUE ('PO_USE_REQ_NUM_IN_AUTOCREATE') = 'Y' AND po_autocreate_params.g_interface_source_code <> 'SOURCING') THEN
1339:
1340: -- use requisition numbers
1341: l_progress := '035';
1342: UPDATE po_lines_interface pli

Line 1410: END IF; -- if fnd_profile.value(PO_USE_REQ_NUM...) = 'Y'

1406:
1407: l_sourcing_temp_num := l_sourcing_temp_num + 1;
1408: END LOOP;
1409: END IF; -- po_autocreate_params.g_interface_source_code <> 'SOURCING
1410: END IF; -- if fnd_profile.value(PO_USE_REQ_NUM...) = 'Y'
1411: END IF; -- x_document_subtype IN ('STANDARD', 'PLANNED')
1412:
1413: ELSE
1414: -- mode = 'ADD'