DBA Data[Home] [Help]

APPS.PO_PDOI_DIST_PROCESS_PVT dependencies on PO_PDOI_PARAMS

Line 436: AND intf_dists.processing_id = PO_PDOI_PARAMS.g_processing_id

432: AND draft_locs.draft_id = draft_lines.draft_id
433: AND draft_lines.po_header_id = draft_headers.po_header_id(+)
434: AND draft_lines.draft_id = draft_headers.draft_id(+)
435: AND draft_lines.po_header_id = txn_headers.po_header_id(+)
436: AND intf_dists.processing_id = PO_PDOI_PARAMS.g_processing_id
437: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
438: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
439: AND intf_dists.interface_distribution_id > p_max_intf_dist_id
440: ORDER BY intf_dists.interface_distribution_id;

Line 437: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num

433: AND draft_lines.po_header_id = draft_headers.po_header_id(+)
434: AND draft_lines.draft_id = draft_headers.draft_id(+)
435: AND draft_lines.po_header_id = txn_headers.po_header_id(+)
436: AND intf_dists.processing_id = PO_PDOI_PARAMS.g_processing_id
437: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
438: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
439: AND intf_dists.interface_distribution_id > p_max_intf_dist_id
440: ORDER BY intf_dists.interface_distribution_id;
441:

Line 438: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id

434: AND draft_lines.draft_id = draft_headers.draft_id(+)
435: AND draft_lines.po_header_id = txn_headers.po_header_id(+)
436: AND intf_dists.processing_id = PO_PDOI_PARAMS.g_processing_id
437: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
438: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
439: AND intf_dists.interface_distribution_id > p_max_intf_dist_id
440: ORDER BY intf_dists.interface_distribution_id;
441:
442: IF (PO_LOG.d_proc) THEN

Line 819: IF (PO_PDOI_PARAMS.g_product.wip_installed = FND_API.g_TRUE) THEN

815:
816: d_position := 50;
817:
818: -- derive wip attributes if WIP is installed
819: IF (PO_PDOI_PARAMS.g_product.wip_installed = FND_API.g_TRUE) THEN
820: -- derive wip_entity_id from wip_entity
821: derive_wip_entity_id
822: (
823: p_key => l_key,

Line 887: p_chart_of_accounts_id => PO_PDOI_PARAMS.g_sys.coa_id,

883: x_dists.loc_txn_flow_header_id_tbl(i) IS NULL) THEN
884:
885: derive_account_id
886: (p_account_number => x_dists.charge_account_tbl(i),
887: p_chart_of_accounts_id => PO_PDOI_PARAMS.g_sys.coa_id,
888: p_account_segment1 => x_dists.account_segment1_tbl(i),
889: p_account_segment2 => x_dists.account_segment2_tbl(i),
890: p_account_segment3 => x_dists.account_segment3_tbl(i),
891: p_account_segment4 => x_dists.account_segment4_tbl(i),

Line 980: PO_PDOI_PARAMS.g_product.project_11510_installed = FND_API.g_FALSE)

976:
977: -- valiadte and derive project related info
978: IF (x_dists.ln_order_type_lookup_code_tbl(i) = 'FIXED PRICE' AND
979: x_dists.ln_purchase_basis_tbl(i) = 'SERVICES'AND
980: PO_PDOI_PARAMS.g_product.project_11510_installed = FND_API.g_FALSE)
981: OR
982: (x_dists.ln_order_type_lookup_code_tbl(i) = 'TEMP LABOR' AND
983: PO_PDOI_PARAMS.g_product.project_cwk_installed = FND_API.g_FALSE) THEN
984:

Line 983: PO_PDOI_PARAMS.g_product.project_cwk_installed = FND_API.g_FALSE) THEN

979: x_dists.ln_purchase_basis_tbl(i) = 'SERVICES'AND
980: PO_PDOI_PARAMS.g_product.project_11510_installed = FND_API.g_FALSE)
981: OR
982: (x_dists.ln_order_type_lookup_code_tbl(i) = 'TEMP LABOR' AND
983: PO_PDOI_PARAMS.g_product.project_cwk_installed = FND_API.g_FALSE) THEN
984:
985: d_position := 120;
986:
987: IF (PO_LOG.d_stmt) THEN

Line 1006: IF (PO_PDOI_PARAMS.g_product.pa_installed = FND_API.g_TRUE AND

1002:
1003: d_position := 130;
1004:
1005: -- derive project fields if enabled
1006: IF (PO_PDOI_PARAMS.g_product.pa_installed = FND_API.g_TRUE AND
1007: x_dists.project_accounting_context_tbl(i) = 'Y') THEN
1008: IF (PO_LOG.d_stmt) THEN
1009: PO_LOG.stmt(d_module, d_position, 'project info needs to be derived');
1010: END IF;

Line 1018: IF (PO_PDOI_PARAMS.g_product.gms_enabled = FND_API.g_FALSE AND

1014: END IF;
1015:
1016: -- set correct values on gms_txn_required_flag and award_id
1017: -- depending on current context
1018: IF (PO_PDOI_PARAMS.g_product.gms_enabled = FND_API.g_FALSE AND
1019: (x_dists.award_num_tbl(i) IS NOT NULL OR
1020: x_dists.award_id_tbl(i) IS NOT NULL))
1021: OR
1022: (x_dists.project_accounting_context_tbl(i) <> 'Y')

Line 1040: IF (PO_PDOI_PARAMS.g_product.gms_enabled = FND_API.g_TRUE AND

1036: x_dists.gms_txn_required_flag_tbl(i) := 'Y';
1037: END IF;
1038:
1039: -- derive award_id from award_num
1040: IF (PO_PDOI_PARAMS.g_product.gms_enabled = FND_API.g_TRUE AND
1041: x_dists.gms_txn_required_flag_tbl(i) = 'Y' AND
1042: x_dists.award_num_tbl(i) IS NOT NULL AND
1043: x_dists.award_id_tbl(i) IS NULL) THEN
1044:

Line 1213: IF (PO_PDOI_PARAMS.g_product.wip_installed = FND_API.g_TRUE AND

1209:
1210: x_dists.error_flag_tbl(i) := FND_API.g_TRUE;
1211: END IF;
1212:
1213: IF (PO_PDOI_PARAMS.g_product.wip_installed = FND_API.g_TRUE AND
1214: x_dists.dest_type_code_tbl(i) = 'SHOP FLOOR') THEN
1215: -- derivation error for wip_entity_id
1216: IF (x_dists.wip_entity_tbl(i) IS NOT NULL AND
1217: x_dists.wip_entity_id_tbl(i) IS NULL) THEN

Line 1569: l_po_encumbrance_flag := PO_PDOI_PARAMS.g_sys.po_encumbrance_flag;

1565: x_num_list => l_index_tbl
1566: );
1567:
1568: -- read value from system parameter
1569: l_po_encumbrance_flag := PO_PDOI_PARAMS.g_sys.po_encumbrance_flag;
1570:
1571: -- get item_status for each distribution
1572: get_item_status
1573: (

Line 1682: IF (PO_PDOI_PARAMS.g_product.gms_enabled = FND_API.g_TRUE AND

1678: x_dists.gms_txn_required_flag_tbl(i) := 'N';
1679: END IF;
1680:
1681: -- validate the Award transaction and then create the ADL
1682: IF (PO_PDOI_PARAMS.g_product.gms_enabled = FND_API.g_TRUE AND
1683: x_dists.gms_txn_required_flag_tbl(i) = 'Y') THEN
1684:
1685: d_position := 30;
1686:

Line 1774: END IF; -- IF (PO_PDOI_PARAMS.g_product.gms_enabled = FND_API.g_TRUE AND ..

1770: x_dists.error_flag_tbl(i) := FND_API.g_TRUE;
1771: END IF;
1772: END IF; -- IF (x_dists.award_id_tbl(i) IS NOT NULL)
1773: END IF; -- IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1774: END IF; -- IF (PO_PDOI_PARAMS.g_product.gms_enabled = FND_API.g_TRUE AND ..
1775:
1776: d_position := 50;
1777:
1778: IF (PO_LOG.d_stmt) THEN

Line 1821: x_purchasing_ou_id => PO_PDOI_PARAMS.g_request.org_id,

1817:
1818: -- generate account
1819: l_success := PO_WF_BUILD_ACCOUNT_INIT.Start_Workflow
1820: (
1821: x_purchasing_ou_id => PO_PDOI_PARAMS.g_request.org_id,
1822: x_transaction_flow_header_id => x_dists.loc_txn_flow_header_id_tbl(i),
1823: x_dest_charge_success => l_dest_charge_success,
1824: x_dest_variance_success => l_dest_variance_success,
1825: x_dest_charge_account_id => x_dists.dest_charge_account_id_tbl(i),

Line 1847: x_coa_id => PO_PDOI_PARAMS.g_sys.coa_id,

1843: x_charge_account_desc => l_charge_account_desc,
1844: x_budget_account_desc => l_budget_account_desc,
1845: x_accrual_account_desc => l_accrual_account_desc,
1846: x_variance_account_desc => l_variance_account_desc,
1847: x_coa_id => PO_PDOI_PARAMS.g_sys.coa_id,
1848: x_bom_resource_id => x_dists.bom_resource_id_tbl(i),
1849: x_bom_cost_element_id => l_bom_cost_element_id,
1850: x_category_id => x_dists.ln_category_id_tbl(i),
1851: x_destination_type_code => x_dists.dest_type_code_tbl(i),

Line 1876: x_po_encumberance_flag => PO_PDOI_PARAMS.g_sys.po_encumbrance_flag,

1872: x_wip_line_id => x_dists.wip_line_id_tbl(i),
1873: x_wip_repetitive_schedule_id => x_dists.wip_rep_schedule_id_tbl(i),
1874: x_wip_operation_seq_num => x_dists.wip_operation_seq_num_tbl(i),
1875: x_wip_resource_seq_num => x_dists.wip_resource_seq_num_tbl(i),
1876: x_po_encumberance_flag => PO_PDOI_PARAMS.g_sys.po_encumbrance_flag,
1877: x_gl_encumbered_date => x_dists.gl_encumbered_date_tbl(i),
1878: wf_itemkey => l_wf_itemkey,
1879: x_new_combination => l_new_ccid_generated,
1880: header_att1 => x_dists.hd_attribute1_tbl(i),

Line 2057: p_set_of_books_id => PO_PDOI_PARAMS.g_sys.sob_id,

2053: IF (l_po_encumbrance_flag = 'Y') THEN
2054: PO_PERIODS_SV.get_period_info
2055: (
2056: p_roll_logic => NULL,
2057: p_set_of_books_id => PO_PDOI_PARAMS.g_sys.sob_id,
2058: p_date_tbl => x_dists.gl_encumbered_date_tbl,
2059: x_period_name_tbl => x_dists.gl_encumbered_period_tbl,
2060: x_period_year_tbl => l_period_year_tbl,
2061: x_period_num_tbl => l_period_num_tbl,

Line 2181: l_parameter_value_tbl(1) := PO_PDOI_PARAMS.g_sys.coa_id;

2177: l_parameter_name_tbl.EXTEND(5);
2178: l_parameter_value_tbl.EXTEND(5);
2179:
2180: l_parameter_name_tbl(1) := 'CHART_OF_ACCOUNT_ID';
2181: l_parameter_value_tbl(1) := PO_PDOI_PARAMS.g_sys.coa_id;
2182:
2183: l_parameter_name_tbl(2) := 'PO_ENCUMBRANCE_FLAG';
2184: l_parameter_value_tbl(2) := PO_PDOI_PARAMS.g_sys.po_encumbrance_flag;
2185:

Line 2184: l_parameter_value_tbl(2) := PO_PDOI_PARAMS.g_sys.po_encumbrance_flag;

2180: l_parameter_name_tbl(1) := 'CHART_OF_ACCOUNT_ID';
2181: l_parameter_value_tbl(1) := PO_PDOI_PARAMS.g_sys.coa_id;
2182:
2183: l_parameter_name_tbl(2) := 'PO_ENCUMBRANCE_FLAG';
2184: l_parameter_value_tbl(2) := PO_PDOI_PARAMS.g_sys.po_encumbrance_flag;
2185:
2186: l_parameter_name_tbl(3) := 'OPERATING_UNIT';
2187: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_request.org_id;
2188:

Line 2187: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_request.org_id;

2183: l_parameter_name_tbl(2) := 'PO_ENCUMBRANCE_FLAG';
2184: l_parameter_value_tbl(2) := PO_PDOI_PARAMS.g_sys.po_encumbrance_flag;
2185:
2186: l_parameter_name_tbl(3) := 'OPERATING_UNIT';
2187: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_request.org_id;
2188:
2189: l_parameter_name_tbl(4) := 'EXPENSE_ACCRUAL_CODE';
2190: l_parameter_value_tbl(4) := PO_PDOI_PARAMS.g_sys.expense_accrual_code;
2191:

Line 2190: l_parameter_value_tbl(4) := PO_PDOI_PARAMS.g_sys.expense_accrual_code;

2186: l_parameter_name_tbl(3) := 'OPERATING_UNIT';
2187: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_request.org_id;
2188:
2189: l_parameter_name_tbl(4) := 'EXPENSE_ACCRUAL_CODE';
2190: l_parameter_value_tbl(4) := PO_PDOI_PARAMS.g_sys.expense_accrual_code;
2191:
2192: l_parameter_name_tbl(5) := 'ALLOW_TAX_RATE_OVERRIDE';
2193: l_parameter_value_tbl(5) := PO_PDOI_PARAMS.g_profile.allow_tax_rate_override;
2194:

Line 2193: l_parameter_value_tbl(5) := PO_PDOI_PARAMS.g_profile.allow_tax_rate_override;

2189: l_parameter_name_tbl(4) := 'EXPENSE_ACCRUAL_CODE';
2190: l_parameter_value_tbl(4) := PO_PDOI_PARAMS.g_sys.expense_accrual_code;
2191:
2192: l_parameter_name_tbl(5) := 'ALLOW_TAX_RATE_OVERRIDE';
2193: l_parameter_value_tbl(5) := PO_PDOI_PARAMS.g_profile.allow_tax_rate_override;
2194:
2195: PO_VALIDATIONS.validate_pdoi
2196: (
2197: p_distributions => l_distributions,