2789: p_min_child_parent_line_num IN NUMBER,
2790: x_last_line_number OUT NOCOPY NUMBER
2791: ) IS
2792:
2793: l_new_disp_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2794: l_sub_line_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2795: l_document_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2796: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2797: l_parent_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2790: x_last_line_number OUT NOCOPY NUMBER
2791: ) IS
2792:
2793: l_new_disp_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2794: l_sub_line_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2795: l_document_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2796: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2797: l_parent_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2798: l_parent_doc_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2791: ) IS
2792:
2793: l_new_disp_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2794: l_sub_line_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2795: l_document_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2796: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2797: l_parent_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2798: l_parent_doc_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2799: l_parent_max_sub_line_seq_num PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2792:
2793: l_new_disp_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2794: l_sub_line_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2795: l_document_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2796: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2797: l_parent_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2798: l_parent_doc_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2799: l_parent_max_sub_line_seq_num PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2800:
2793: l_new_disp_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2794: l_sub_line_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2795: l_document_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2796: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2797: l_parent_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2798: l_parent_doc_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2799: l_parent_max_sub_line_seq_num PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2800:
2801: l_max_sub_line_sequence_number NUMBER;
2794: l_sub_line_seq_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2795: l_document_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2796: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2797: l_parent_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2798: l_parent_doc_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2799: l_parent_max_sub_line_seq_num PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2800:
2801: l_max_sub_line_sequence_number NUMBER;
2802: l_max_document_line_num NUMBER;
2795: l_document_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2796: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2797: l_parent_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2798: l_parent_doc_disp_line_number PON_NEG_COPY_DATATYPES_GRP.VARCHAR50_TYPE;
2799: l_parent_max_sub_line_seq_num PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
2800:
2801: l_max_sub_line_sequence_number NUMBER;
2802: l_max_document_line_num NUMBER;
2803: l_current_parent_line_number NUMBER;
3582: p_start_disp_line_number in number,
3583: x_last_line_close_date out nocopy date
3584: )
3585: is
3586: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3587: l_close_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3588: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3589: l_batch_start NUMBER ;
3590: l_batch_end NUMBER ;
3583: x_last_line_close_date out nocopy date
3584: )
3585: is
3586: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3587: l_close_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3588: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3589: l_batch_start NUMBER ;
3590: l_batch_end NUMBER ;
3591: l_batch_size NUMBER ;
3584: )
3585: is
3586: l_line_number PON_NEG_COPY_DATATYPES_GRP.NUMBER_TYPE;
3587: l_close_date PON_NEG_COPY_DATATYPES_GRP.SIMPLE_DATE_TYPE;
3588: l_group_type PON_NEG_COPY_DATATYPES_GRP.VARCHAR100_TYPE;
3589: l_batch_start NUMBER ;
3590: l_batch_end NUMBER ;
3591: l_batch_size NUMBER ;
3592: l_max_line_number NUMBER;