2645: p_min_child_parent_line_num IN NUMBER,
2646: x_last_line_number OUT NOCOPY NUMBER
2647: ) IS
2648:
2649: l_new_disp_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2650: l_sub_line_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2651: l_document_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2652: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2653: l_parent_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2646: x_last_line_number OUT NOCOPY NUMBER
2647: ) IS
2648:
2649: l_new_disp_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2650: l_sub_line_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2651: l_document_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2652: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2653: l_parent_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2654: l_parent_doc_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2647: ) IS
2648:
2649: l_new_disp_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2650: l_sub_line_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2651: l_document_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2652: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2653: l_parent_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2654: l_parent_doc_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2655: l_parent_max_sub_line_seq_num PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2648:
2649: l_new_disp_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2650: l_sub_line_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2651: l_document_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2652: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2653: l_parent_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2654: l_parent_doc_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2655: l_parent_max_sub_line_seq_num PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2656:
2649: l_new_disp_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2650: l_sub_line_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2651: l_document_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2652: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2653: l_parent_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2654: l_parent_doc_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2655: l_parent_max_sub_line_seq_num PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2656:
2657: l_max_sub_line_sequence_number NUMBER;
2650: l_sub_line_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2651: l_document_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2652: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2653: l_parent_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2654: l_parent_doc_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2655: l_parent_max_sub_line_seq_num PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2656:
2657: l_max_sub_line_sequence_number NUMBER;
2658: l_max_document_line_num NUMBER;
2651: l_document_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2652: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2653: l_parent_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2654: l_parent_doc_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2655: l_parent_max_sub_line_seq_num PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2656:
2657: l_max_sub_line_sequence_number NUMBER;
2658: l_max_document_line_num NUMBER;
2659: l_current_parent_line_number NUMBER;
3438: p_start_disp_line_number in number,
3439: x_last_line_close_date out nocopy date
3440: )
3441: is
3442: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3443: l_close_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3444: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3445: l_batch_start NUMBER ;
3446: l_batch_end NUMBER ;
3439: x_last_line_close_date out nocopy date
3440: )
3441: is
3442: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3443: l_close_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3444: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3445: l_batch_start NUMBER ;
3446: l_batch_end NUMBER ;
3447: l_batch_size NUMBER ;
3440: )
3441: is
3442: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3443: l_close_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3444: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3445: l_batch_start NUMBER ;
3446: l_batch_end NUMBER ;
3447: l_batch_size NUMBER ;
3448: l_max_line_number NUMBER;