DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_POSTPROC_PVT dependencies on PO_CORE_S

Line 300: x_document_num := po_core_sv1.default_po_unique_identifier

296: x_document_num := REPLACE(x_doc_number,'-');
297:
298: IF Length(x_document_num) > 20 THEN
299:
300: x_document_num := po_core_sv1.default_po_unique_identifier
301: (p_table_name => 'PO_HEADERS',
302: p_org_id => po_autocreate_params.g_purchasing_ou_id
303: );
304:

Line 308: x_document_num := po_core_sv1.default_po_unique_identifier

304:
305: END IF;
306: ELSE
307:
308: x_document_num := po_core_sv1.default_po_unique_identifier
309: (p_table_name => 'PO_HEADERS',
310: p_org_id => po_autocreate_params.g_purchasing_ou_id
311: );
312: END IF;

Line 489: l_clm_default_dist := PO_CORE_S.get_create_default_dist(

485: IF po_autocreate_params.g_mode = 'NEW' THEN
486:
487: --
488: -- Fetch the value for CLM_DEFAULT_DIST_FLAG
489: l_clm_default_dist := PO_CORE_S.get_create_default_dist(
490: p_org_id => PO_AUTOCREATE_PARAMS.g_purchasing_ou_id,
491: p_style_id => l_doc_row.po_style_id,
492: p_doc_sub_type => PO_AUTOCREATE_PARAMS.g_document_subtype);
493: --

Line 540: l_clm_default_dist := PO_CORE_S.get_create_default_dist(

536: AND pha.style_id = pdsh.style_id;
537:
538: --
539: -- Fetch the value for CLM_DEFAULT_DIST_FLAG for New Mod
540: l_clm_default_dist := PO_CORE_S.get_create_default_dist(
541: p_org_id => PO_AUTOCREATE_PARAMS.g_purchasing_ou_id,
542: p_style_id => l_doc_row.po_style_id,
543: p_doc_sub_type => PO_AUTOCREATE_PARAMS.g_document_subtype);
544: --

Line 2846: l_cdrls_enabled := PO_CORE_S.retrieveOptionValue(p_org_id => p_org_id,

2842: THEN
2843: po_debug.debug_begin (p_log_head => g_log_head || l_api_name);
2844: END IF;
2845:
2846: l_cdrls_enabled := PO_CORE_S.retrieveOptionValue(p_org_id => p_org_id,
2847: p_option_column => PO_CORE_S.g_CONT_DATA_REQS_COL);
2848: l_elins_enabled := PO_CORE_S.retrieveOptionValue(p_org_id => p_org_id,
2849: p_option_column => PO_CORE_S.g_EXHIBITS_LINES_COL);
2850:

Line 2847: p_option_column => PO_CORE_S.g_CONT_DATA_REQS_COL);

2843: po_debug.debug_begin (p_log_head => g_log_head || l_api_name);
2844: END IF;
2845:
2846: l_cdrls_enabled := PO_CORE_S.retrieveOptionValue(p_org_id => p_org_id,
2847: p_option_column => PO_CORE_S.g_CONT_DATA_REQS_COL);
2848: l_elins_enabled := PO_CORE_S.retrieveOptionValue(p_org_id => p_org_id,
2849: p_option_column => PO_CORE_S.g_EXHIBITS_LINES_COL);
2850:
2851: IF(l_cdrls_enabled = 'Y' OR l_elins_enabled = 'Y') THEN

Line 2848: l_elins_enabled := PO_CORE_S.retrieveOptionValue(p_org_id => p_org_id,

2844: END IF;
2845:
2846: l_cdrls_enabled := PO_CORE_S.retrieveOptionValue(p_org_id => p_org_id,
2847: p_option_column => PO_CORE_S.g_CONT_DATA_REQS_COL);
2848: l_elins_enabled := PO_CORE_S.retrieveOptionValue(p_org_id => p_org_id,
2849: p_option_column => PO_CORE_S.g_EXHIBITS_LINES_COL);
2850:
2851: IF(l_cdrls_enabled = 'Y' OR l_elins_enabled = 'Y') THEN
2852: --copy data from PON_AUCTION_EXHIBIT_DETAILS to PO_EXHIBIT_DETAILS

Line 2849: p_option_column => PO_CORE_S.g_EXHIBITS_LINES_COL);

2845:
2846: l_cdrls_enabled := PO_CORE_S.retrieveOptionValue(p_org_id => p_org_id,
2847: p_option_column => PO_CORE_S.g_CONT_DATA_REQS_COL);
2848: l_elins_enabled := PO_CORE_S.retrieveOptionValue(p_org_id => p_org_id,
2849: p_option_column => PO_CORE_S.g_EXHIBITS_LINES_COL);
2850:
2851: IF(l_cdrls_enabled = 'Y' OR l_elins_enabled = 'Y') THEN
2852: --copy data from PON_AUCTION_EXHIBIT_DETAILS to PO_EXHIBIT_DETAILS
2853: INSERT INTO po_exhibit_details