121:
122: l_calc_rec l_calc_rec_type;
123:
124: Type line_report_rec_type IS RECORD (
125: Dnz_chr_id OKC_K_HEADERS_B.ID%Type
126: ,Contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%Type
127: ,Contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%Type
128: ,Currency_code OKC_K_HEADERS_B.CURRENCY_CODE%Type
129: ,Organization_id OKC_K_HEADERS_B.INV_ORGANIZATION_ID%Type
122: l_calc_rec l_calc_rec_type;
123:
124: Type line_report_rec_type IS RECORD (
125: Dnz_chr_id OKC_K_HEADERS_B.ID%Type
126: ,Contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%Type
127: ,Contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%Type
128: ,Currency_code OKC_K_HEADERS_B.CURRENCY_CODE%Type
129: ,Organization_id OKC_K_HEADERS_B.INV_ORGANIZATION_ID%Type
130: ,Line_id OKC_K_LINES_B.ID%Type
123:
124: Type line_report_rec_type IS RECORD (
125: Dnz_chr_id OKC_K_HEADERS_B.ID%Type
126: ,Contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%Type
127: ,Contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%Type
128: ,Currency_code OKC_K_HEADERS_B.CURRENCY_CODE%Type
129: ,Organization_id OKC_K_HEADERS_B.INV_ORGANIZATION_ID%Type
130: ,Line_id OKC_K_LINES_B.ID%Type
131: ,Line_Number OKC_K_LINES_B.LINE_NUMBER%Type
124: Type line_report_rec_type IS RECORD (
125: Dnz_chr_id OKC_K_HEADERS_B.ID%Type
126: ,Contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%Type
127: ,Contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%Type
128: ,Currency_code OKC_K_HEADERS_B.CURRENCY_CODE%Type
129: ,Organization_id OKC_K_HEADERS_B.INV_ORGANIZATION_ID%Type
130: ,Line_id OKC_K_LINES_B.ID%Type
131: ,Line_Number OKC_K_LINES_B.LINE_NUMBER%Type
132: ,Cle_id OKC_K_LINES_B.CLE_ID%Type
125: Dnz_chr_id OKC_K_HEADERS_B.ID%Type
126: ,Contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%Type
127: ,Contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%Type
128: ,Currency_code OKC_K_HEADERS_B.CURRENCY_CODE%Type
129: ,Organization_id OKC_K_HEADERS_B.INV_ORGANIZATION_ID%Type
130: ,Line_id OKC_K_LINES_B.ID%Type
131: ,Line_Number OKC_K_LINES_B.LINE_NUMBER%Type
132: ,Cle_id OKC_K_LINES_B.CLE_ID%Type
133: ,Lse_Id OKC_K_LINES_B.LSE_ID%Type
148: --Start mchoudha Bug#3537100 17-APR-04
149: --For Billing Report
150:
151: Type Bill_report_rec_type IS RECORD (
152: Currency_code OKC_K_HEADERS_B.CURRENCY_CODE%Type
153: ,Successful_Lines NUMBER
154: ,Rejected_Lines NUMBER
155: ,Successful_SubLines NUMBER
156: ,Rejected_SubLines NUMBER