DBA Data[Home] [Help]

APPS.PO_PDOI_DIST_PROCESS_PVT dependencies on PO_PDOI_PARAMS

Line 457: AND intf_dists.processing_id = PO_PDOI_PARAMS.g_processing_id

453: AND draft_locs.draft_id = draft_lines.draft_id
454: AND draft_lines.po_header_id = draft_headers.po_header_id(+)
455: AND draft_lines.draft_id = draft_headers.draft_id(+)
456: AND draft_lines.po_header_id = txn_headers.po_header_id(+)
457: AND intf_dists.processing_id = PO_PDOI_PARAMS.g_processing_id
458: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
459: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
460: AND intf_dists.interface_distribution_id > p_max_intf_dist_id
461:

Line 458: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num

454: AND draft_lines.po_header_id = draft_headers.po_header_id(+)
455: AND draft_lines.draft_id = draft_headers.draft_id(+)
456: AND draft_lines.po_header_id = txn_headers.po_header_id(+)
457: AND intf_dists.processing_id = PO_PDOI_PARAMS.g_processing_id
458: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
459: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
460: AND intf_dists.interface_distribution_id > p_max_intf_dist_id
461:
462: ORDER BY intf_dists.interface_distribution_id;

Line 459: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id

455: AND draft_lines.draft_id = draft_headers.draft_id(+)
456: AND draft_lines.po_header_id = txn_headers.po_header_id(+)
457: AND intf_dists.processing_id = PO_PDOI_PARAMS.g_processing_id
458: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num
459: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
460: AND intf_dists.interface_distribution_id > p_max_intf_dist_id
461:
462: ORDER BY intf_dists.interface_distribution_id;
463:

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

857:
858: d_position := 50;
859:
860: -- derive wip attributes if WIP is installed
861: IF (PO_PDOI_PARAMS.g_product.wip_installed = FND_API.g_TRUE) THEN
862: -- derive wip_entity_id from wip_entity
863: derive_wip_entity_id
864: (
865: p_key => l_key,

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

925: x_dists.loc_txn_flow_header_id_tbl(i) IS NULL) THEN
926:
927: derive_account_id
928: (p_account_number => x_dists.charge_account_tbl(i),
929: p_chart_of_accounts_id => PO_PDOI_PARAMS.g_sys.coa_id,
930: p_account_segment1 => x_dists.account_segment1_tbl(i),
931: p_account_segment2 => x_dists.account_segment2_tbl(i),
932: p_account_segment3 => x_dists.account_segment3_tbl(i),
933: p_account_segment4 => x_dists.account_segment4_tbl(i),

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

1018:
1019: -- valiadte and derive project related info
1020: IF (x_dists.ln_order_type_lookup_code_tbl(i) = 'FIXED PRICE' AND
1021: x_dists.ln_purchase_basis_tbl(i) = 'SERVICES'AND
1022: PO_PDOI_PARAMS.g_product.project_11510_installed = FND_API.g_FALSE)
1023: OR
1024: (x_dists.ln_order_type_lookup_code_tbl(i) = 'TEMP LABOR' AND
1025: PO_PDOI_PARAMS.g_product.project_cwk_installed = FND_API.g_FALSE) THEN
1026:

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

1021: x_dists.ln_purchase_basis_tbl(i) = 'SERVICES'AND
1022: PO_PDOI_PARAMS.g_product.project_11510_installed = FND_API.g_FALSE)
1023: OR
1024: (x_dists.ln_order_type_lookup_code_tbl(i) = 'TEMP LABOR' AND
1025: PO_PDOI_PARAMS.g_product.project_cwk_installed = FND_API.g_FALSE) THEN
1026:
1027: d_position := 120;
1028:
1029: IF (PO_LOG.d_stmt) THEN

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

1044:
1045: d_position := 130;
1046:
1047: -- derive project fields if enabled
1048: IF (PO_PDOI_PARAMS.g_product.pa_installed = FND_API.g_TRUE AND
1049: x_dists.project_accounting_context_tbl(i) = 'Y') THEN
1050: IF (PO_LOG.d_stmt) THEN
1051: PO_LOG.stmt(d_module, d_position, 'project info needs to be derived');
1052: END IF;

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

1056: END IF;
1057:
1058: -- set correct values on gms_txn_required_flag and award_id
1059: -- depending on current context
1060: IF (PO_PDOI_PARAMS.g_product.gms_enabled = FND_API.g_FALSE AND
1061: (x_dists.award_num_tbl(i) IS NOT NULL OR
1062: x_dists.award_id_tbl(i) IS NOT NULL))
1063: OR
1064: (x_dists.project_accounting_context_tbl(i) <> 'Y')

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

1078: x_dists.gms_txn_required_flag_tbl(i) := 'Y';
1079: END IF;
1080:
1081: -- derive award_id from award_num
1082: IF (PO_PDOI_PARAMS.g_product.gms_enabled = FND_API.g_TRUE AND
1083: x_dists.gms_txn_required_flag_tbl(i) = 'Y' AND
1084: x_dists.award_num_tbl(i) IS NOT NULL AND
1085: x_dists.award_id_tbl(i) IS NULL) THEN
1086:

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

1251:
1252: x_dists.error_flag_tbl(i) := FND_API.g_TRUE;
1253: END IF;
1254:
1255: IF (PO_PDOI_PARAMS.g_product.wip_installed = FND_API.g_TRUE AND
1256: x_dists.dest_type_code_tbl(i) = 'SHOP FLOOR') THEN
1257: -- derivation error for wip_entity_id
1258: IF (x_dists.wip_entity_tbl(i) IS NOT NULL AND
1259: x_dists.wip_entity_id_tbl(i) IS NULL) THEN

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

1610: x_num_list => l_index_tbl
1611: );
1612:
1613: -- read value from system parameter
1614: l_po_encumbrance_flag := PO_PDOI_PARAMS.g_sys.po_encumbrance_flag;
1615:
1616: -- get item_status for each distribution
1617: get_item_status
1618: (

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

1753: x_dists.gms_txn_required_flag_tbl(i) := 'N';
1754: END IF;
1755:
1756: -- validate the Award transaction and then create the ADL
1757: IF (PO_PDOI_PARAMS.g_product.gms_enabled = FND_API.g_TRUE AND
1758: x_dists.gms_txn_required_flag_tbl(i) = 'Y') THEN
1759:
1760: d_position := 30;
1761:

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

1845: x_dists.error_flag_tbl(i) := FND_API.g_TRUE;
1846: END IF;
1847: END IF; -- IF (x_dists.award_id_tbl(i) IS NOT NULL)
1848: END IF; -- IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
1849: END IF; -- IF (PO_PDOI_PARAMS.g_product.gms_enabled = FND_API.g_TRUE AND ..
1850:
1851: d_position := 50;
1852:
1853: IF (PO_LOG.d_stmt) THEN

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

1914:
1915: -- generate account
1916: l_success := PO_WF_BUILD_ACCOUNT_INIT.Start_Workflow
1917: (
1918: x_purchasing_ou_id => PO_PDOI_PARAMS.g_request.org_id,
1919: x_transaction_flow_header_id => x_dists.loc_txn_flow_header_id_tbl(i),
1920: x_dest_charge_success => l_dest_charge_success,
1921: x_dest_variance_success => l_dest_variance_success,
1922: x_dest_charge_account_id => x_dists.dest_charge_account_id_tbl(i),

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

1940: x_charge_account_desc => l_charge_account_desc,
1941: x_budget_account_desc => l_budget_account_desc,
1942: x_accrual_account_desc => l_accrual_account_desc,
1943: x_variance_account_desc => l_variance_account_desc,
1944: x_coa_id => PO_PDOI_PARAMS.g_sys.coa_id,
1945: x_bom_resource_id => x_dists.bom_resource_id_tbl(i),
1946: x_bom_cost_element_id => l_bom_cost_element_id,
1947: x_category_id => x_dists.ln_category_id_tbl(i),
1948: x_destination_type_code => x_dists.dest_type_code_tbl(i),

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

1969: x_wip_line_id => x_dists.wip_line_id_tbl(i),
1970: x_wip_repetitive_schedule_id => x_dists.wip_rep_schedule_id_tbl(i),
1971: x_wip_operation_seq_num => x_dists.wip_operation_seq_num_tbl(i),
1972: x_wip_resource_seq_num => x_dists.wip_resource_seq_num_tbl(i),
1973: x_po_encumberance_flag => PO_PDOI_PARAMS.g_sys.po_encumbrance_flag,
1974: x_gl_encumbered_date => x_dists.gl_encumbered_date_tbl(i),
1975: wf_itemkey => l_wf_itemkey,
1976: x_new_combination => l_new_ccid_generated,
1977: header_att1 => x_dists.hd_attribute1_tbl(i),

Line 2153: po_periods_sv.get_period_name(PO_PDOI_PARAMS.g_sys.sob_id,

2149: --Tracking GL Encumbered Date not in Open Accounting Period
2150: -- Budgetary Action in an encumbrance enabled environment.
2151:
2152: IF (l_po_encumbrance_flag = 'Y') THEN
2153: po_periods_sv.get_period_name(PO_PDOI_PARAMS.g_sys.sob_id,
2154: nvl( x_dists.gl_encumbered_date_tbl(i),sysdate),
2155: l_gl_enc_period_name);
2156:
2157: IF (l_gl_enc_period_name IS NULL) THEN

Line 2184: PO_PERIODS_SV.get_gl_date(x_sob_id => PO_PDOI_PARAMS.g_sys.sob_id,

2180: -- GL Date Project#Start: If the profile PO: Validate GL Period has been
2181: -- set to Redefault, default the distribution's GL date.
2182:
2183: IF Nvl(FND_PROFILE.VALUE('PO_VALIDATE_GL_PERIOD'), 'Y') = 'R' THEN
2184: PO_PERIODS_SV.get_gl_date(x_sob_id => PO_PDOI_PARAMS.g_sys.sob_id,
2185: x_gl_date => x_dists.gl_encumbered_date_tbl);
2186: END IF;
2187: -- GL Date Project#End
2188:

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

2186: END IF;
2187: -- GL Date Project#End
2188:
2189: PO_PERIODS_SV.get_period_info(p_roll_logic => NULL,
2190: p_set_of_books_id => PO_PDOI_PARAMS.g_sys.sob_id,
2191: p_date_tbl => x_dists.gl_encumbered_date_tbl,
2192: x_period_name_tbl => x_dists.gl_encumbered_period_tbl,
2193: x_period_year_tbl => l_period_year_tbl,
2194: x_period_num_tbl => l_period_num_tbl,

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

2321: l_parameter_name_tbl.EXTEND(5);
2322: l_parameter_value_tbl.EXTEND(5);
2323:
2324: l_parameter_name_tbl(1) := 'CHART_OF_ACCOUNT_ID';
2325: l_parameter_value_tbl(1) := PO_PDOI_PARAMS.g_sys.coa_id;
2326:
2327: l_parameter_name_tbl(2) := 'PO_ENCUMBRANCE_FLAG';
2328: l_parameter_value_tbl(2) := PO_PDOI_PARAMS.g_sys.po_encumbrance_flag;
2329:

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

2324: l_parameter_name_tbl(1) := 'CHART_OF_ACCOUNT_ID';
2325: l_parameter_value_tbl(1) := PO_PDOI_PARAMS.g_sys.coa_id;
2326:
2327: l_parameter_name_tbl(2) := 'PO_ENCUMBRANCE_FLAG';
2328: l_parameter_value_tbl(2) := PO_PDOI_PARAMS.g_sys.po_encumbrance_flag;
2329:
2330: l_parameter_name_tbl(3) := 'OPERATING_UNIT';
2331: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_request.org_id;
2332:

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

2327: l_parameter_name_tbl(2) := 'PO_ENCUMBRANCE_FLAG';
2328: l_parameter_value_tbl(2) := PO_PDOI_PARAMS.g_sys.po_encumbrance_flag;
2329:
2330: l_parameter_name_tbl(3) := 'OPERATING_UNIT';
2331: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_request.org_id;
2332:
2333: l_parameter_name_tbl(4) := 'EXPENSE_ACCRUAL_CODE';
2334: l_parameter_value_tbl(4) := PO_PDOI_PARAMS.g_sys.expense_accrual_code;
2335:

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

2330: l_parameter_name_tbl(3) := 'OPERATING_UNIT';
2331: l_parameter_value_tbl(3) := PO_PDOI_PARAMS.g_request.org_id;
2332:
2333: l_parameter_name_tbl(4) := 'EXPENSE_ACCRUAL_CODE';
2334: l_parameter_value_tbl(4) := PO_PDOI_PARAMS.g_sys.expense_accrual_code;
2335:
2336: l_parameter_name_tbl(5) := 'ALLOW_TAX_RATE_OVERRIDE';
2337: l_parameter_value_tbl(5) := PO_PDOI_PARAMS.g_profile.allow_tax_rate_override;
2338:

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

2333: l_parameter_name_tbl(4) := 'EXPENSE_ACCRUAL_CODE';
2334: l_parameter_value_tbl(4) := PO_PDOI_PARAMS.g_sys.expense_accrual_code;
2335:
2336: l_parameter_name_tbl(5) := 'ALLOW_TAX_RATE_OVERRIDE';
2337: l_parameter_value_tbl(5) := PO_PDOI_PARAMS.g_profile.allow_tax_rate_override;
2338:
2339: PO_VALIDATIONS.validate_pdoi
2340: (
2341: p_distributions => l_distributions,