DBA Data[Home] [Help]

APPS.OKL_SRS_PVT dependencies on OKL_STREAMS_UTIL

Line 2735: in_id Okl_Streams_Util.NumberTabTyp;

2731: -- Version : 1.0
2732: -- History : 09-MAY-20023 BAKUCHIB :Added new procedure
2733: PROCEDURE insert_row_upg(p_srsv_tbl srsv_Tbl_type) IS
2734: l_tabsize NUMBER := p_srsv_tbl.COUNT;
2735: in_id Okl_Streams_Util.NumberTabTyp;
2736: in_stream_type_name Okl_Streams_Util.Var150TabTyp;
2737: in_index_number Okl_Streams_Util.NumberTabTyp;
2738: in_activity_type Okl_Streams_Util.Var150TabTyp;
2739: in_sequence_number Okl_Streams_Util.NumberTabTyp;

Line 2736: in_stream_type_name Okl_Streams_Util.Var150TabTyp;

2732: -- History : 09-MAY-20023 BAKUCHIB :Added new procedure
2733: PROCEDURE insert_row_upg(p_srsv_tbl srsv_Tbl_type) IS
2734: l_tabsize NUMBER := p_srsv_tbl.COUNT;
2735: in_id Okl_Streams_Util.NumberTabTyp;
2736: in_stream_type_name Okl_Streams_Util.Var150TabTyp;
2737: in_index_number Okl_Streams_Util.NumberTabTyp;
2738: in_activity_type Okl_Streams_Util.Var150TabTyp;
2739: in_sequence_number Okl_Streams_Util.NumberTabTyp;
2740: in_sre_date Okl_Streams_Util.DateTabTyp;

Line 2737: in_index_number Okl_Streams_Util.NumberTabTyp;

2733: PROCEDURE insert_row_upg(p_srsv_tbl srsv_Tbl_type) IS
2734: l_tabsize NUMBER := p_srsv_tbl.COUNT;
2735: in_id Okl_Streams_Util.NumberTabTyp;
2736: in_stream_type_name Okl_Streams_Util.Var150TabTyp;
2737: in_index_number Okl_Streams_Util.NumberTabTyp;
2738: in_activity_type Okl_Streams_Util.Var150TabTyp;
2739: in_sequence_number Okl_Streams_Util.NumberTabTyp;
2740: in_sre_date Okl_Streams_Util.DateTabTyp;
2741: in_amount Okl_Streams_Util.NumberTabTyp;

Line 2738: in_activity_type Okl_Streams_Util.Var150TabTyp;

2734: l_tabsize NUMBER := p_srsv_tbl.COUNT;
2735: in_id Okl_Streams_Util.NumberTabTyp;
2736: in_stream_type_name Okl_Streams_Util.Var150TabTyp;
2737: in_index_number Okl_Streams_Util.NumberTabTyp;
2738: in_activity_type Okl_Streams_Util.Var150TabTyp;
2739: in_sequence_number Okl_Streams_Util.NumberTabTyp;
2740: in_sre_date Okl_Streams_Util.DateTabTyp;
2741: in_amount Okl_Streams_Util.NumberTabTyp;
2742: in_sir_id Okl_Streams_Util.NumberTabTyp;

Line 2739: in_sequence_number Okl_Streams_Util.NumberTabTyp;

2735: in_id Okl_Streams_Util.NumberTabTyp;
2736: in_stream_type_name Okl_Streams_Util.Var150TabTyp;
2737: in_index_number Okl_Streams_Util.NumberTabTyp;
2738: in_activity_type Okl_Streams_Util.Var150TabTyp;
2739: in_sequence_number Okl_Streams_Util.NumberTabTyp;
2740: in_sre_date Okl_Streams_Util.DateTabTyp;
2741: in_amount Okl_Streams_Util.NumberTabTyp;
2742: in_sir_id Okl_Streams_Util.NumberTabTyp;
2743: in_stream_int_attribute01 Okl_Streams_Util.Var450TabTyp;

Line 2740: in_sre_date Okl_Streams_Util.DateTabTyp;

2736: in_stream_type_name Okl_Streams_Util.Var150TabTyp;
2737: in_index_number Okl_Streams_Util.NumberTabTyp;
2738: in_activity_type Okl_Streams_Util.Var150TabTyp;
2739: in_sequence_number Okl_Streams_Util.NumberTabTyp;
2740: in_sre_date Okl_Streams_Util.DateTabTyp;
2741: in_amount Okl_Streams_Util.NumberTabTyp;
2742: in_sir_id Okl_Streams_Util.NumberTabTyp;
2743: in_stream_int_attribute01 Okl_Streams_Util.Var450TabTyp;
2744: in_stream_int_attribute02 Okl_Streams_Util.Var450TabTyp;

Line 2741: in_amount Okl_Streams_Util.NumberTabTyp;

2737: in_index_number Okl_Streams_Util.NumberTabTyp;
2738: in_activity_type Okl_Streams_Util.Var150TabTyp;
2739: in_sequence_number Okl_Streams_Util.NumberTabTyp;
2740: in_sre_date Okl_Streams_Util.DateTabTyp;
2741: in_amount Okl_Streams_Util.NumberTabTyp;
2742: in_sir_id Okl_Streams_Util.NumberTabTyp;
2743: in_stream_int_attribute01 Okl_Streams_Util.Var450TabTyp;
2744: in_stream_int_attribute02 Okl_Streams_Util.Var450TabTyp;
2745: in_stream_int_attribute03 Okl_Streams_Util.Var450TabTyp;

Line 2742: in_sir_id Okl_Streams_Util.NumberTabTyp;

2738: in_activity_type Okl_Streams_Util.Var150TabTyp;
2739: in_sequence_number Okl_Streams_Util.NumberTabTyp;
2740: in_sre_date Okl_Streams_Util.DateTabTyp;
2741: in_amount Okl_Streams_Util.NumberTabTyp;
2742: in_sir_id Okl_Streams_Util.NumberTabTyp;
2743: in_stream_int_attribute01 Okl_Streams_Util.Var450TabTyp;
2744: in_stream_int_attribute02 Okl_Streams_Util.Var450TabTyp;
2745: in_stream_int_attribute03 Okl_Streams_Util.Var450TabTyp;
2746: in_stream_int_attribute04 Okl_Streams_Util.Var450TabTyp;

Line 2743: in_stream_int_attribute01 Okl_Streams_Util.Var450TabTyp;

2739: in_sequence_number Okl_Streams_Util.NumberTabTyp;
2740: in_sre_date Okl_Streams_Util.DateTabTyp;
2741: in_amount Okl_Streams_Util.NumberTabTyp;
2742: in_sir_id Okl_Streams_Util.NumberTabTyp;
2743: in_stream_int_attribute01 Okl_Streams_Util.Var450TabTyp;
2744: in_stream_int_attribute02 Okl_Streams_Util.Var450TabTyp;
2745: in_stream_int_attribute03 Okl_Streams_Util.Var450TabTyp;
2746: in_stream_int_attribute04 Okl_Streams_Util.Var450TabTyp;
2747: in_stream_int_attribute05 Okl_Streams_Util.Var450TabTyp;

Line 2744: in_stream_int_attribute02 Okl_Streams_Util.Var450TabTyp;

2740: in_sre_date Okl_Streams_Util.DateTabTyp;
2741: in_amount Okl_Streams_Util.NumberTabTyp;
2742: in_sir_id Okl_Streams_Util.NumberTabTyp;
2743: in_stream_int_attribute01 Okl_Streams_Util.Var450TabTyp;
2744: in_stream_int_attribute02 Okl_Streams_Util.Var450TabTyp;
2745: in_stream_int_attribute03 Okl_Streams_Util.Var450TabTyp;
2746: in_stream_int_attribute04 Okl_Streams_Util.Var450TabTyp;
2747: in_stream_int_attribute05 Okl_Streams_Util.Var450TabTyp;
2748: in_stream_int_attribute06 Okl_Streams_Util.Var450TabTyp;

Line 2745: in_stream_int_attribute03 Okl_Streams_Util.Var450TabTyp;

2741: in_amount Okl_Streams_Util.NumberTabTyp;
2742: in_sir_id Okl_Streams_Util.NumberTabTyp;
2743: in_stream_int_attribute01 Okl_Streams_Util.Var450TabTyp;
2744: in_stream_int_attribute02 Okl_Streams_Util.Var450TabTyp;
2745: in_stream_int_attribute03 Okl_Streams_Util.Var450TabTyp;
2746: in_stream_int_attribute04 Okl_Streams_Util.Var450TabTyp;
2747: in_stream_int_attribute05 Okl_Streams_Util.Var450TabTyp;
2748: in_stream_int_attribute06 Okl_Streams_Util.Var450TabTyp;
2749: in_stream_int_attribute07 Okl_Streams_Util.Var450TabTyp;

Line 2746: in_stream_int_attribute04 Okl_Streams_Util.Var450TabTyp;

2742: in_sir_id Okl_Streams_Util.NumberTabTyp;
2743: in_stream_int_attribute01 Okl_Streams_Util.Var450TabTyp;
2744: in_stream_int_attribute02 Okl_Streams_Util.Var450TabTyp;
2745: in_stream_int_attribute03 Okl_Streams_Util.Var450TabTyp;
2746: in_stream_int_attribute04 Okl_Streams_Util.Var450TabTyp;
2747: in_stream_int_attribute05 Okl_Streams_Util.Var450TabTyp;
2748: in_stream_int_attribute06 Okl_Streams_Util.Var450TabTyp;
2749: in_stream_int_attribute07 Okl_Streams_Util.Var450TabTyp;
2750: in_stream_int_attribute08 Okl_Streams_Util.Var450TabTyp;

Line 2747: in_stream_int_attribute05 Okl_Streams_Util.Var450TabTyp;

2743: in_stream_int_attribute01 Okl_Streams_Util.Var450TabTyp;
2744: in_stream_int_attribute02 Okl_Streams_Util.Var450TabTyp;
2745: in_stream_int_attribute03 Okl_Streams_Util.Var450TabTyp;
2746: in_stream_int_attribute04 Okl_Streams_Util.Var450TabTyp;
2747: in_stream_int_attribute05 Okl_Streams_Util.Var450TabTyp;
2748: in_stream_int_attribute06 Okl_Streams_Util.Var450TabTyp;
2749: in_stream_int_attribute07 Okl_Streams_Util.Var450TabTyp;
2750: in_stream_int_attribute08 Okl_Streams_Util.Var450TabTyp;
2751: in_stream_int_attribute09 Okl_Streams_Util.Var450TabTyp;

Line 2748: in_stream_int_attribute06 Okl_Streams_Util.Var450TabTyp;

2744: in_stream_int_attribute02 Okl_Streams_Util.Var450TabTyp;
2745: in_stream_int_attribute03 Okl_Streams_Util.Var450TabTyp;
2746: in_stream_int_attribute04 Okl_Streams_Util.Var450TabTyp;
2747: in_stream_int_attribute05 Okl_Streams_Util.Var450TabTyp;
2748: in_stream_int_attribute06 Okl_Streams_Util.Var450TabTyp;
2749: in_stream_int_attribute07 Okl_Streams_Util.Var450TabTyp;
2750: in_stream_int_attribute08 Okl_Streams_Util.Var450TabTyp;
2751: in_stream_int_attribute09 Okl_Streams_Util.Var450TabTyp;
2752: in_stream_int_attribute10 Okl_Streams_Util.Var450TabTyp;

Line 2749: in_stream_int_attribute07 Okl_Streams_Util.Var450TabTyp;

2745: in_stream_int_attribute03 Okl_Streams_Util.Var450TabTyp;
2746: in_stream_int_attribute04 Okl_Streams_Util.Var450TabTyp;
2747: in_stream_int_attribute05 Okl_Streams_Util.Var450TabTyp;
2748: in_stream_int_attribute06 Okl_Streams_Util.Var450TabTyp;
2749: in_stream_int_attribute07 Okl_Streams_Util.Var450TabTyp;
2750: in_stream_int_attribute08 Okl_Streams_Util.Var450TabTyp;
2751: in_stream_int_attribute09 Okl_Streams_Util.Var450TabTyp;
2752: in_stream_int_attribute10 Okl_Streams_Util.Var450TabTyp;
2753: in_stream_int_attribute11 Okl_Streams_Util.Var450TabTyp;

Line 2750: in_stream_int_attribute08 Okl_Streams_Util.Var450TabTyp;

2746: in_stream_int_attribute04 Okl_Streams_Util.Var450TabTyp;
2747: in_stream_int_attribute05 Okl_Streams_Util.Var450TabTyp;
2748: in_stream_int_attribute06 Okl_Streams_Util.Var450TabTyp;
2749: in_stream_int_attribute07 Okl_Streams_Util.Var450TabTyp;
2750: in_stream_int_attribute08 Okl_Streams_Util.Var450TabTyp;
2751: in_stream_int_attribute09 Okl_Streams_Util.Var450TabTyp;
2752: in_stream_int_attribute10 Okl_Streams_Util.Var450TabTyp;
2753: in_stream_int_attribute11 Okl_Streams_Util.Var450TabTyp;
2754: in_stream_int_attribute12 Okl_Streams_Util.Var450TabTyp;

Line 2751: in_stream_int_attribute09 Okl_Streams_Util.Var450TabTyp;

2747: in_stream_int_attribute05 Okl_Streams_Util.Var450TabTyp;
2748: in_stream_int_attribute06 Okl_Streams_Util.Var450TabTyp;
2749: in_stream_int_attribute07 Okl_Streams_Util.Var450TabTyp;
2750: in_stream_int_attribute08 Okl_Streams_Util.Var450TabTyp;
2751: in_stream_int_attribute09 Okl_Streams_Util.Var450TabTyp;
2752: in_stream_int_attribute10 Okl_Streams_Util.Var450TabTyp;
2753: in_stream_int_attribute11 Okl_Streams_Util.Var450TabTyp;
2754: in_stream_int_attribute12 Okl_Streams_Util.Var450TabTyp;
2755: in_stream_int_attribute13 Okl_Streams_Util.Var450TabTyp;

Line 2752: in_stream_int_attribute10 Okl_Streams_Util.Var450TabTyp;

2748: in_stream_int_attribute06 Okl_Streams_Util.Var450TabTyp;
2749: in_stream_int_attribute07 Okl_Streams_Util.Var450TabTyp;
2750: in_stream_int_attribute08 Okl_Streams_Util.Var450TabTyp;
2751: in_stream_int_attribute09 Okl_Streams_Util.Var450TabTyp;
2752: in_stream_int_attribute10 Okl_Streams_Util.Var450TabTyp;
2753: in_stream_int_attribute11 Okl_Streams_Util.Var450TabTyp;
2754: in_stream_int_attribute12 Okl_Streams_Util.Var450TabTyp;
2755: in_stream_int_attribute13 Okl_Streams_Util.Var450TabTyp;
2756: in_stream_int_attribute14 Okl_Streams_Util.Var450TabTyp;

Line 2753: in_stream_int_attribute11 Okl_Streams_Util.Var450TabTyp;

2749: in_stream_int_attribute07 Okl_Streams_Util.Var450TabTyp;
2750: in_stream_int_attribute08 Okl_Streams_Util.Var450TabTyp;
2751: in_stream_int_attribute09 Okl_Streams_Util.Var450TabTyp;
2752: in_stream_int_attribute10 Okl_Streams_Util.Var450TabTyp;
2753: in_stream_int_attribute11 Okl_Streams_Util.Var450TabTyp;
2754: in_stream_int_attribute12 Okl_Streams_Util.Var450TabTyp;
2755: in_stream_int_attribute13 Okl_Streams_Util.Var450TabTyp;
2756: in_stream_int_attribute14 Okl_Streams_Util.Var450TabTyp;
2757: in_stream_int_attribute15 Okl_Streams_Util.Var450TabTyp;

Line 2754: in_stream_int_attribute12 Okl_Streams_Util.Var450TabTyp;

2750: in_stream_int_attribute08 Okl_Streams_Util.Var450TabTyp;
2751: in_stream_int_attribute09 Okl_Streams_Util.Var450TabTyp;
2752: in_stream_int_attribute10 Okl_Streams_Util.Var450TabTyp;
2753: in_stream_int_attribute11 Okl_Streams_Util.Var450TabTyp;
2754: in_stream_int_attribute12 Okl_Streams_Util.Var450TabTyp;
2755: in_stream_int_attribute13 Okl_Streams_Util.Var450TabTyp;
2756: in_stream_int_attribute14 Okl_Streams_Util.Var450TabTyp;
2757: in_stream_int_attribute15 Okl_Streams_Util.Var450TabTyp;
2758: in_object_version_number Okl_Streams_Util.NumberTabTyp;

Line 2755: in_stream_int_attribute13 Okl_Streams_Util.Var450TabTyp;

2751: in_stream_int_attribute09 Okl_Streams_Util.Var450TabTyp;
2752: in_stream_int_attribute10 Okl_Streams_Util.Var450TabTyp;
2753: in_stream_int_attribute11 Okl_Streams_Util.Var450TabTyp;
2754: in_stream_int_attribute12 Okl_Streams_Util.Var450TabTyp;
2755: in_stream_int_attribute13 Okl_Streams_Util.Var450TabTyp;
2756: in_stream_int_attribute14 Okl_Streams_Util.Var450TabTyp;
2757: in_stream_int_attribute15 Okl_Streams_Util.Var450TabTyp;
2758: in_object_version_number Okl_Streams_Util.NumberTabTyp;
2759: in_created_by Okl_Streams_Util.NumberTabTyp;

Line 2756: in_stream_int_attribute14 Okl_Streams_Util.Var450TabTyp;

2752: in_stream_int_attribute10 Okl_Streams_Util.Var450TabTyp;
2753: in_stream_int_attribute11 Okl_Streams_Util.Var450TabTyp;
2754: in_stream_int_attribute12 Okl_Streams_Util.Var450TabTyp;
2755: in_stream_int_attribute13 Okl_Streams_Util.Var450TabTyp;
2756: in_stream_int_attribute14 Okl_Streams_Util.Var450TabTyp;
2757: in_stream_int_attribute15 Okl_Streams_Util.Var450TabTyp;
2758: in_object_version_number Okl_Streams_Util.NumberTabTyp;
2759: in_created_by Okl_Streams_Util.NumberTabTyp;
2760: in_last_updated_by Okl_Streams_Util.NumberTabTyp;

Line 2757: in_stream_int_attribute15 Okl_Streams_Util.Var450TabTyp;

2753: in_stream_int_attribute11 Okl_Streams_Util.Var450TabTyp;
2754: in_stream_int_attribute12 Okl_Streams_Util.Var450TabTyp;
2755: in_stream_int_attribute13 Okl_Streams_Util.Var450TabTyp;
2756: in_stream_int_attribute14 Okl_Streams_Util.Var450TabTyp;
2757: in_stream_int_attribute15 Okl_Streams_Util.Var450TabTyp;
2758: in_object_version_number Okl_Streams_Util.NumberTabTyp;
2759: in_created_by Okl_Streams_Util.NumberTabTyp;
2760: in_last_updated_by Okl_Streams_Util.NumberTabTyp;
2761: in_creation_date Okl_Streams_Util.DateTabTyp;

Line 2758: in_object_version_number Okl_Streams_Util.NumberTabTyp;

2754: in_stream_int_attribute12 Okl_Streams_Util.Var450TabTyp;
2755: in_stream_int_attribute13 Okl_Streams_Util.Var450TabTyp;
2756: in_stream_int_attribute14 Okl_Streams_Util.Var450TabTyp;
2757: in_stream_int_attribute15 Okl_Streams_Util.Var450TabTyp;
2758: in_object_version_number Okl_Streams_Util.NumberTabTyp;
2759: in_created_by Okl_Streams_Util.NumberTabTyp;
2760: in_last_updated_by Okl_Streams_Util.NumberTabTyp;
2761: in_creation_date Okl_Streams_Util.DateTabTyp;
2762: in_last_update_date Okl_Streams_Util.DateTabTyp;

Line 2759: in_created_by Okl_Streams_Util.NumberTabTyp;

2755: in_stream_int_attribute13 Okl_Streams_Util.Var450TabTyp;
2756: in_stream_int_attribute14 Okl_Streams_Util.Var450TabTyp;
2757: in_stream_int_attribute15 Okl_Streams_Util.Var450TabTyp;
2758: in_object_version_number Okl_Streams_Util.NumberTabTyp;
2759: in_created_by Okl_Streams_Util.NumberTabTyp;
2760: in_last_updated_by Okl_Streams_Util.NumberTabTyp;
2761: in_creation_date Okl_Streams_Util.DateTabTyp;
2762: in_last_update_date Okl_Streams_Util.DateTabTyp;
2763: in_last_update_login Okl_Streams_Util.NumberTabTyp;

Line 2760: in_last_updated_by Okl_Streams_Util.NumberTabTyp;

2756: in_stream_int_attribute14 Okl_Streams_Util.Var450TabTyp;
2757: in_stream_int_attribute15 Okl_Streams_Util.Var450TabTyp;
2758: in_object_version_number Okl_Streams_Util.NumberTabTyp;
2759: in_created_by Okl_Streams_Util.NumberTabTyp;
2760: in_last_updated_by Okl_Streams_Util.NumberTabTyp;
2761: in_creation_date Okl_Streams_Util.DateTabTyp;
2762: in_last_update_date Okl_Streams_Util.DateTabTyp;
2763: in_last_update_login Okl_Streams_Util.NumberTabTyp;
2764: i number;

Line 2761: in_creation_date Okl_Streams_Util.DateTabTyp;

2757: in_stream_int_attribute15 Okl_Streams_Util.Var450TabTyp;
2758: in_object_version_number Okl_Streams_Util.NumberTabTyp;
2759: in_created_by Okl_Streams_Util.NumberTabTyp;
2760: in_last_updated_by Okl_Streams_Util.NumberTabTyp;
2761: in_creation_date Okl_Streams_Util.DateTabTyp;
2762: in_last_update_date Okl_Streams_Util.DateTabTyp;
2763: in_last_update_login Okl_Streams_Util.NumberTabTyp;
2764: i number;
2765: j number;

Line 2762: in_last_update_date Okl_Streams_Util.DateTabTyp;

2758: in_object_version_number Okl_Streams_Util.NumberTabTyp;
2759: in_created_by Okl_Streams_Util.NumberTabTyp;
2760: in_last_updated_by Okl_Streams_Util.NumberTabTyp;
2761: in_creation_date Okl_Streams_Util.DateTabTyp;
2762: in_last_update_date Okl_Streams_Util.DateTabTyp;
2763: in_last_update_login Okl_Streams_Util.NumberTabTyp;
2764: i number;
2765: j number;
2766: --Declaring the temp variables used for assignment purposes

Line 2763: in_last_update_login Okl_Streams_Util.NumberTabTyp;

2759: in_created_by Okl_Streams_Util.NumberTabTyp;
2760: in_last_updated_by Okl_Streams_Util.NumberTabTyp;
2761: in_creation_date Okl_Streams_Util.DateTabTyp;
2762: in_last_update_date Okl_Streams_Util.DateTabTyp;
2763: in_last_update_login Okl_Streams_Util.NumberTabTyp;
2764: i number;
2765: j number;
2766: --Declaring the temp variables used for assignment purposes
2767: --Added by KTHIRUVA