77: l_due_date DATE DEFAULT NULL;
78: l_customer_id NUMBER;
79: l_customer_num VARCHAR2(30) := p_customer_num;
80: l_cons_bill_num VARCHAR2(90);
81: l_last_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT 1;
82: l_contract_id NUMBER;
83: l_contract_num VARCHAR2(120);
84: l_contract_number_start_date OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
85: l_contract_number_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
80: l_cons_bill_num VARCHAR2(90);
81: l_last_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT 1;
82: l_contract_id NUMBER;
83: l_contract_num VARCHAR2(120);
84: l_contract_number_start_date OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
85: l_contract_number_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
86:
87: l_receivables_invoice_num NUMBER DEFAULT NULL;
88: l_over_pay VARCHAR(1) DEFAULT NULL;
81: l_last_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT 1;
82: l_contract_id NUMBER;
83: l_contract_num VARCHAR2(120);
84: l_contract_number_start_date OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
85: l_contract_number_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
86:
87: l_receivables_invoice_num NUMBER DEFAULT NULL;
88: l_over_pay VARCHAR(1) DEFAULT NULL;
89: l_ordered CONSTANT VARCHAR2(3) := 'ODD';
2853: l_customer_id NUMBER;
2854: l_customer_num VARCHAR2(30) := p_customer_num;
2855: l_cons_bill_id NUMBER;
2856: l_cons_bill_num VARCHAR2(90);
2857: l_last_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT 1;
2858: l_contract_id NUMBER;
2859: l_contract_num VARCHAR2(120);
2860: l_contract_number_start_date OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
2861: l_contract_number_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
2856: l_cons_bill_num VARCHAR2(90);
2857: l_last_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT 1;
2858: l_contract_id NUMBER;
2859: l_contract_num VARCHAR2(120);
2860: l_contract_number_start_date OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
2861: l_contract_number_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
2862:
2863: l_receivables_invoice_num NUMBER DEFAULT NULL;
2864: l_over_pay VARCHAR(1) DEFAULT NULL;
2857: l_last_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT 1;
2858: l_contract_id NUMBER;
2859: l_contract_num VARCHAR2(120);
2860: l_contract_number_start_date OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
2861: l_contract_number_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
2862:
2863: l_receivables_invoice_num NUMBER DEFAULT NULL;
2864: l_over_pay VARCHAR(1) DEFAULT NULL;
2865: l_ordered CONSTANT VARCHAR2(3) := 'ODD';