DBA Data[Home] [Help]

APPS.PJI_REP_MEASURE_UTIL dependencies on PJI_REP_OVERVIEW_TYPE

Line 1730: l_overview_type pji_rep_overview_type_tbl; --table of objects

1726: , x_msg_count IN OUT NOCOPY NUMBER
1727: , x_msg_data IN OUT NOCOPY VARCHAR2
1728: ) AS
1729:
1730: l_overview_type pji_rep_overview_type_tbl; --table of objects
1731:
1732: l_temp_overview_type pji_rep_overview_type_tbl;
1733: l_result_index NUMBER;
1734:

Line 1732: l_temp_overview_type pji_rep_overview_type_tbl;

1728: ) AS
1729:
1730: l_overview_type pji_rep_overview_type_tbl; --table of objects
1731:
1732: l_temp_overview_type pji_rep_overview_type_tbl;
1733: l_result_index NUMBER;
1734:
1735: l_pji_facts pji_ac_proj_f_rec;
1736: l_pji_facts_null pji_ac_proj_f_rec;

Line 1932: l_overview_type := pji_rep_overview_type_tbl();

1928: x_msg_count := 0;
1929: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1930: END IF;
1931:
1932: l_overview_type := pji_rep_overview_type_tbl();
1933: l_temp_overview_type := pji_rep_overview_type_tbl();
1934:
1935:
1936: IF p_measure_set_code.COUNT < 1 THEN

Line 1933: l_temp_overview_type := pji_rep_overview_type_tbl();

1929: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1930: END IF;
1931:
1932: l_overview_type := pji_rep_overview_type_tbl();
1933: l_temp_overview_type := pji_rep_overview_type_tbl();
1934:
1935:
1936: IF p_measure_set_code.COUNT < 1 THEN
1937: RETURN;

Line 2035: pji_rep_overview_type(

2031: --
2032: BEGIN
2033:
2034: SELECT
2035: pji_rep_overview_type(
2036: plan_version_id
2037: ,plan_type_id
2038: ,SUM(ptd_mask * raw_cost)
2039: ,SUM(ptd_mask * brdn_cost)

Line 2517: l_overview_type(i) := pji_rep_overview_type(NULL,NULL,NULL,NULL,NULL,NULL,

2513: --
2514:
2515: l_overview_type.EXTEND(13);
2516: FOR i IN l_overview_type.FIRST .. l_overview_type.LAST LOOP
2517: l_overview_type(i) := pji_rep_overview_type(NULL,NULL,NULL,NULL,NULL,NULL,
2518: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
2519: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
2520: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
2521: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,

Line 9670: ,p_source_table IN pji_rep_overview_type_tbl

9666:
9667: PROCEDURE Merge_Overview_Type
9668: (
9669: p_source_index IN NUMBER
9670: ,p_source_table IN pji_rep_overview_type_tbl
9671: ,p_target_index IN NUMBER
9672: ,p_target_table IN OUT NOCOPY pji_rep_overview_type_tbl
9673: )
9674: IS

Line 9672: ,p_target_table IN OUT NOCOPY pji_rep_overview_type_tbl

9668: (
9669: p_source_index IN NUMBER
9670: ,p_source_table IN pji_rep_overview_type_tbl
9671: ,p_target_index IN NUMBER
9672: ,p_target_table IN OUT NOCOPY pji_rep_overview_type_tbl
9673: )
9674: IS
9675: BEGIN
9676: