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.

APPS.PA_CI_SUPPLIER_UTILS dependencies on PA_NUM_TBL_TYPE

Line 1744: p_ci_transaction_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE ,

1740: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1741: x_return_status OUT NOCOPY VARCHAR2,
1742: x_msg_count OUT NOCOPY NUMBER,
1743: x_msg_data OUT NOCOPY VARCHAR2,
1744: p_ci_transaction_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE ,
1745: p_ci_id IN NUMBER,
1746: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1747: p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
1748: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

Line 1746: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

1742: x_msg_count OUT NOCOPY NUMBER,
1743: x_msg_data OUT NOCOPY VARCHAR2,
1744: p_ci_transaction_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE ,
1745: p_ci_id IN NUMBER,
1746: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1747: p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
1748: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1749: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
1750: p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 1748: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

1744: p_ci_transaction_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE ,
1745: p_ci_id IN NUMBER,
1746: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1747: p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
1748: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1749: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
1750: p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1751: ) IS
1752:

Line 1750: p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

1746: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1747: p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
1748: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
1749: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
1750: p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1751: ) IS
1752:
1753: l_api_version number := 1;
1754: l_api_name CONSTANT VARCHAR2(30) := 'delete_supplier_costs';

Line 1869: ,p_ci_transaction_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

1865: ,x_return_status IN OUT NOCOPY VARCHAR2
1866: ,x_msg_data IN OUT NOCOPY VARCHAR2
1867: ,x_msg_count IN OUT NOCOPY NUMBER
1868: ,p_rowid_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1869: ,p_ci_transaction_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1870: ,p_ci_id IN NUMBER
1871: ,p_ci_type_id IN NUMBER
1872: ,p_ci_impact_id IN NUMBER DEFAULT NULL
1873: ,p_calling_mode IN VARCHAR2

Line 1878: ,p_vendor_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

1874: ,p_org_id IN NUMBER
1875: ,p_version_type IN VARCHAR2 DEFAULT 'ALL'
1876: ,p_record_status_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1877: ,p_vendor_name_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE
1878: ,p_vendor_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1879: ,p_po_number_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1880: ,p_po_header_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1881: ,p_po_line_num_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1882: ,p_po_line_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 1880: ,p_po_header_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

1876: ,p_record_status_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1877: ,p_vendor_name_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE
1878: ,p_vendor_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1879: ,p_po_number_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1880: ,p_po_header_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1881: ,p_po_line_num_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1882: ,p_po_line_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1883: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1884: ,p_change_amount_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 1882: ,p_po_line_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

1878: ,p_vendor_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1879: ,p_po_number_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1880: ,p_po_header_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1881: ,p_po_line_num_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1882: ,p_po_line_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1883: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1884: ,p_change_amount_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1885: ,p_change_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1886: ,p_change_description_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE

Line 1884: ,p_change_amount_tbl IN SYSTEM.PA_NUM_TBL_TYPE

1880: ,p_po_header_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1881: ,p_po_line_num_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1882: ,p_po_line_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1883: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1884: ,p_change_amount_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1885: ,p_change_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1886: ,p_change_description_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE
1887: ,p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1888: ,p_resource_list_mem_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 1887: ,p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

1883: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1884: ,p_change_amount_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1885: ,p_change_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1886: ,p_change_description_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE
1887: ,p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1888: ,p_resource_list_mem_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1889: ,p_adjusted_transaction_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1890: ,p_from_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1891: ,p_to_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

Line 1888: ,p_resource_list_mem_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

1884: ,p_change_amount_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1885: ,p_change_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1886: ,p_change_description_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE
1887: ,p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1888: ,p_resource_list_mem_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1889: ,p_adjusted_transaction_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1890: ,p_from_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1891: ,p_to_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1892: ,p_need_by_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE

Line 1889: ,p_adjusted_transaction_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

1885: ,p_change_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1886: ,p_change_description_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE
1887: ,p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1888: ,p_resource_list_mem_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1889: ,p_adjusted_transaction_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1890: ,p_from_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1891: ,p_to_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1892: ,p_need_by_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1893: ,p_estimated_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 1893: ,p_estimated_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE

1889: ,p_adjusted_transaction_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1890: ,p_from_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1891: ,p_to_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1892: ,p_need_by_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1893: ,p_estimated_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1894: ,p_quoted_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1895: ,p_negotiated_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1896: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1897: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL

Line 1894: ,p_quoted_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE

1890: ,p_from_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1891: ,p_to_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1892: ,p_need_by_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1893: ,p_estimated_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1894: ,p_quoted_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1895: ,p_negotiated_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1896: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1897: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
1898: ,p_revenue_override_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 1895: ,p_negotiated_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE

1891: ,p_to_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1892: ,p_need_by_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1893: ,p_estimated_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1894: ,p_quoted_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1895: ,p_negotiated_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1896: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1897: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
1898: ,p_revenue_override_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1899: ,p_audit_history_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 1896: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE

1892: ,p_need_by_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
1893: ,p_estimated_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1894: ,p_quoted_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1895: ,p_negotiated_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1896: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1897: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
1898: ,p_revenue_override_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1899: ,p_audit_history_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1900: ,p_current_audit_flag_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

Line 1897: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL

1893: ,p_estimated_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1894: ,p_quoted_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1895: ,p_negotiated_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1896: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1897: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
1898: ,p_revenue_override_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1899: ,p_audit_history_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1900: ,p_current_audit_flag_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1901: ,p_original_supp_trans_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 1898: ,p_revenue_override_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE

1894: ,p_quoted_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1895: ,p_negotiated_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1896: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1897: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
1898: ,p_revenue_override_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1899: ,p_audit_history_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1900: ,p_current_audit_flag_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1901: ,p_original_supp_trans_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1902: ,p_source_supp_trans_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 1899: ,p_audit_history_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE

1895: ,p_negotiated_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1896: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1897: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
1898: ,p_revenue_override_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1899: ,p_audit_history_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1900: ,p_current_audit_flag_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1901: ,p_original_supp_trans_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1902: ,p_source_supp_trans_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1903: ,p_sup_ref_no_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL

Line 1901: ,p_original_supp_trans_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

1897: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
1898: ,p_revenue_override_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1899: ,p_audit_history_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1900: ,p_current_audit_flag_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1901: ,p_original_supp_trans_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1902: ,p_source_supp_trans_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1903: ,p_sup_ref_no_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
1904: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1905: ,p_expenditure_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

Line 1902: ,p_source_supp_trans_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

1898: ,p_revenue_override_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1899: ,p_audit_history_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1900: ,p_current_audit_flag_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1901: ,p_original_supp_trans_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1902: ,p_source_supp_trans_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1903: ,p_sup_ref_no_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
1904: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1905: ,p_expenditure_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1906: ,p_change_reason_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

Line 1903: ,p_sup_ref_no_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL

1899: ,p_audit_history_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1900: ,p_current_audit_flag_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1901: ,p_original_supp_trans_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1902: ,p_source_supp_trans_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1903: ,p_sup_ref_no_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
1904: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1905: ,p_expenditure_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1906: ,p_change_reason_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1907: ,p_quote_negotiation_ref_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE

Line 1905: ,p_expenditure_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

1901: ,p_original_supp_trans_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1902: ,p_source_supp_trans_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1903: ,p_sup_ref_no_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
1904: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1905: ,p_expenditure_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1906: ,p_change_reason_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1907: ,p_quote_negotiation_ref_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE
1908: ,p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1909: )

Line 1908: ,p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

1904: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1905: ,p_expenditure_org_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1906: ,p_change_reason_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1907: ,p_quote_negotiation_ref_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE
1908: ,p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1909: )
1910: IS
1911: l_api_version number := 1;
1912: l_api_name CONSTANT VARCHAR2(30) := 'save_supplier_costs';

Line 1965: l_ci_transaction_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

1961: l_need_by_date date;
1962: l_expenditure_type varchar2(30);
1963: l_resource_assignment_id number;
1964:
1965: l_ci_transaction_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1966: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1967:
1968: cursor get_project_id is
1969: select project_id

Line 1966: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

1962: l_expenditure_type varchar2(30);
1963: l_resource_assignment_id number;
1964:
1965: l_ci_transaction_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1966: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1967:
1968: cursor get_project_id is
1969: select project_id
1970: from pa_control_items

Line 1997: b_ins_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

1993: l_po_end_date date;
1994:
1995: -- budget impact tables for inserted record
1996: l_ins_count number := 0;
1997: b_ins_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1998: b_ins_sc_line_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1999: b_ins_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2000: b_ins_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2001: b_ins_res_assgn_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 1998: b_ins_sc_line_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

1994:
1995: -- budget impact tables for inserted record
1996: l_ins_count number := 0;
1997: b_ins_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1998: b_ins_sc_line_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1999: b_ins_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2000: b_ins_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2001: b_ins_res_assgn_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2002: b_ins_rlmi_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 1999: b_ins_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

1995: -- budget impact tables for inserted record
1996: l_ins_count number := 0;
1997: b_ins_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1998: b_ins_sc_line_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1999: b_ins_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2000: b_ins_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2001: b_ins_res_assgn_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2002: b_ins_rlmi_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2003: b_ins_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 2000: b_ins_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

1996: l_ins_count number := 0;
1997: b_ins_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1998: b_ins_sc_line_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1999: b_ins_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2000: b_ins_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2001: b_ins_res_assgn_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2002: b_ins_rlmi_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2003: b_ins_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2004:

Line 2001: b_ins_res_assgn_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

1997: b_ins_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1998: b_ins_sc_line_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1999: b_ins_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2000: b_ins_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2001: b_ins_res_assgn_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2002: b_ins_rlmi_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2003: b_ins_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2004:
2005: -- budget impact tables for updated record

Line 2002: b_ins_rlmi_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

1998: b_ins_sc_line_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1999: b_ins_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2000: b_ins_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2001: b_ins_res_assgn_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2002: b_ins_rlmi_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2003: b_ins_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2004:
2005: -- budget impact tables for updated record
2006: l_upd_count number := 0;

Line 2007: b_upd_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2003: b_ins_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2004:
2005: -- budget impact tables for updated record
2006: l_upd_count number := 0;
2007: b_upd_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2008: b_upd_sc_line_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2009: b_upd_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2010: b_upd_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2011: b_upd_res_assgn_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 2008: b_upd_sc_line_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2004:
2005: -- budget impact tables for updated record
2006: l_upd_count number := 0;
2007: b_upd_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2008: b_upd_sc_line_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2009: b_upd_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2010: b_upd_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2011: b_upd_res_assgn_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2012: b_upd_rlmi_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

Line 2009: b_upd_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2005: -- budget impact tables for updated record
2006: l_upd_count number := 0;
2007: b_upd_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2008: b_upd_sc_line_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2009: b_upd_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2010: b_upd_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2011: b_upd_res_assgn_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2012: b_upd_rlmi_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2013: b_upd_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

Line 2010: b_upd_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2006: l_upd_count number := 0;
2007: b_upd_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2008: b_upd_sc_line_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2009: b_upd_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2010: b_upd_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2011: b_upd_res_assgn_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2012: b_upd_rlmi_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2013: b_upd_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2014:

Line 2011: b_upd_res_assgn_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2007: b_upd_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2008: b_upd_sc_line_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2009: b_upd_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2010: b_upd_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2011: b_upd_res_assgn_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2012: b_upd_rlmi_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2013: b_upd_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2014:
2015: cursor get_sc_line(c_sc_line_id number) is

Line 2012: b_upd_rlmi_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2008: b_upd_sc_line_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2009: b_upd_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2010: b_upd_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2011: b_upd_res_assgn_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2012: b_upd_rlmi_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2013: b_upd_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
2014:
2015: cursor get_sc_line(c_sc_line_id number) is
2016: select nvl(raw_cost, 0) raw_cost,