[Home] [Help]
28: cursor next_bill_date_csr( p_khr_id IN NUMBER ) IS
29: SELECT MIN(ste.stream_element_date)
30: FROM OKL_STRM_ELEMENTS ste,
31: OKL_STREAMS stm,
32: okl_strm_type_v sty,
33: okc_k_headers_b khr,
34: OKL_K_HEADERS khl,
35: okc_k_lines_b kle,
36: okc_statuses_b khs,
783: SELECT CHR.id
784: FROM okl_txd_ar_ln_dtls_b tld,
785: okl_txl_ar_inv_lns_b til,
786: okl_trx_ar_invoices_b tai,
787: okl_strm_type_v sty,
788: okc_k_headers_b CHR
789: WHERE tai.trx_status_code = 'SUBMITTED'
790: AND tai.khr_id = CHR.id
791: AND til.tai_id = tai.id
807: WHERE id IN (
808: SELECT CHR.id
809: FROM okl_txl_ar_inv_lns_b til,
810: okl_trx_ar_invoices_b tai,
811: okl_strm_type_v sty,
812: okc_k_headers_b CHR
813: WHERE tai.trx_status_code = 'SUBMITTED'
814: AND tai.khr_id = CHR.id
815: AND til.tai_id = tai.id
929: COUNT(STE.ID) LINE_COUNT
930: FROM
931: OKL_STRM_ELEMENTS STE,
932: OKL_STREAMS STM,
933: OKL_STRM_TYPE_V STY,
934: OKL_PARALLEL_PROCESSES OPP
935: WHERE
936: OPP.ASSIGNED_PROCESS = p_seq_next AND
937: OPP.OBJECT_TYPE = 'CONTRACT' AND
963: OKL_TXD_AR_LN_DTLS_B TLD,
964: OKL_TXL_AR_INV_LNS_B TIL,
965: OKL_TRX_AR_INVOICES_B TAI,
966: OKC_K_HEADERS_B CHR,
967: OKL_STRM_TYPE_V STY,
968: OKL_PARALLEL_PROCESSES OPP
969: WHERE tai.trx_status_code = 'SUBMITTED'
970: AND tai.khr_id = CHR.id
971: AND til.tai_id = tai.id
984: FROM
985: OKL_TXL_AR_INV_LNS_B TIL,
986: OKL_TRX_AR_INVOICES_B TAI,
987: OKC_K_HEADERS_B CHR,
988: OKL_STRM_TYPE_V STY,
989: OKL_PARALLEL_PROCESSES OPP
990: WHERE tai.trx_status_code = 'SUBMITTED'
991: AND tai.khr_id = CHR.id
992: AND til.tai_id = tai.id
3121: FROM okl_invoice_formats_v inf,
3122: okl_invoice_types_v ity,
3123: okl_invc_line_types_v ilt,
3124: okl_invc_frmt_strms_v frs,
3125: okl_strm_type_v sty
3126: WHERE inf.id = p_format_id
3127: AND ity.inf_id = inf.id
3128: AND ilt.ity_id = ity.id
3129: AND frs.ilt_id = ilt.id
3150: AND inf.ilt_id = ilt.id;
3151:
3152: l_cons_invoice_num OKL_CNSLD_AR_HDRS_B.CONSOLIDATED_INVOICE_NUMBER%TYPE;
3153: l_invoice_format OKL_INVOICE_FORMATS_V.NAME%TYPE;
3154: l_sty_name OKL_STRM_TYPE_V.NAME%TYPE;
3155:
3156: l_old_cnr_id NUMBER;
3157: l_old_lln_id NUMBER;
3158: l_cnt NUMBER;
3159:
3160: -- Get all Streams and cache locally
3161: CURSOR strm_csr_perf IS
3162: SELECT id, name
3163: FROM okl_strm_type_v;
3164:
3165: TYPE stream_rec_type IS RECORD (
3166: id okl_strm_type_v.id%TYPE,
3167: name okl_strm_type_v.name%TYPE);
3162: SELECT id, name
3163: FROM okl_strm_type_v;
3164:
3165: TYPE stream_rec_type IS RECORD (
3166: id okl_strm_type_v.id%TYPE,
3167: name okl_strm_type_v.name%TYPE);
3168:
3169: TYPE stream_table IS TABLE OF stream_rec_type
3170: INDEX BY BINARY_INTEGER;
3163: FROM okl_strm_type_v;
3164:
3165: TYPE stream_rec_type IS RECORD (
3166: id okl_strm_type_v.id%TYPE,
3167: name okl_strm_type_v.name%TYPE);
3168:
3169: TYPE stream_table IS TABLE OF stream_rec_type
3170: INDEX BY BINARY_INTEGER;
3171:
3189: FROM okl_invoice_formats_v inf,
3190: okl_invoice_types_v ity,
3191: okl_invc_line_types_v ilt,
3192: okl_invc_frmt_strms_v frs,
3193: okl_strm_type_v sty
3194: WHERE ity.inf_id = inf.id
3195: AND ilt.ity_id = ity.id
3196: AND frs.ilt_id = ilt.id
3197: AND sty.id = frs.sty_id
3225: group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type,
3226: ilt_id okl_invc_line_types_v.id%type,
3227: sequence_number okl_invc_line_types_v.sequence_number%type,
3228: ilt_name okl_invc_line_types_v.name%type,
3229: sty_name okl_strm_type_v.name%type,
3230: sty_id okl_invc_frmt_strms_v.sty_id%type);
3231:
3232: TYPE inv_format_table IS TABLE OF inv_format_type
3233: INDEX BY BINARY_INTEGER;
4050: WHERE id = p_id;
4051:
4052: CURSOR strm_csr ( p_id NUMBER ) IS
4053: SELECT name
4054: FROM okl_strm_type_v
4055: WHERE id = p_id;
4056:
4057: l_contract_number okc_k_headers_b.contract_number%TYPE;
4058: l_stream_name1 okl_strm_type_v.name%TYPE;
4054: FROM okl_strm_type_v
4055: WHERE id = p_id;
4056:
4057: l_contract_number okc_k_headers_b.contract_number%TYPE;
4058: l_stream_name1 okl_strm_type_v.name%TYPE;
4059:
4060:
4061: l_temp_khr_id NUMBER;
4062: