DBA Data[Home] [Help]

APPS.PJI_PJP_SUM_DENORM dependencies on PA_VARCHAR2_100_TBL_TYPE

Line 691: sub_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();

687: sub_rollup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
688: sub_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
689: sub_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
690: subro_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
691: sub_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
692: subro_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
693:
694: begin
695: insert into PA_XBS_DENORM_temp

Line 692: subro_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();

688: sub_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
689: sub_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
690: subro_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
691: sub_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
692: subro_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
693:
694: begin
695: insert into PA_XBS_DENORM_temp
696: (

Line 835: sub_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();

831: sub_rollup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
832: sub_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
833: sub_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
834: subro_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
835: sub_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
836: subro_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
837:
838: begin
839: OPEN c_temp( p_wbs_version_id_to );

Line 836: subro_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();

832: sub_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
833: sub_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
834: subro_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
835: sub_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
836: subro_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
837:
838: begin
839: OPEN c_temp( p_wbs_version_id_to );
840: FETCH c_temp bulk collect into

Line 1086: sub_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();

1082: sub_rollup_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1083: sub_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1084: sub_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1085: subro_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1086: sub_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
1087: subro_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
1088:
1089: begin
1090: OPEN c_temp( p_wbs_version_id_from,p_wbs_version_id_to );

Line 1087: subro_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();

1083: sub_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1084: sub_emt_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1085: subro_idtab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1086: sub_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
1087: subro_element_numbertab SYSTEM.PA_VARCHAR2_100_TBL_TYPE := SYSTEM.PA_VARCHAR2_100_TBL_TYPE();
1088:
1089: begin
1090: OPEN c_temp( p_wbs_version_id_from,p_wbs_version_id_to );
1091: FETCH c_temp bulk collect into