DBA Data[Home] [Help]

APPS.OKL_AUTO_CASH_APPL_RULES_PVT dependencies on OKC_K_HEADERS_V

Line 81: l_last_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT 1;

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;

Line 84: l_contract_number_start_date OKC_K_HEADERS_V.CONTRACT_NUMBER%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;

Line 85: l_contract_number_id OKC_K_HEADERS_V.ID%TYPE 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';

Line 2867: l_last_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT 1;

2863: l_customer_id NUMBER;
2864: l_customer_num VARCHAR2(30) := p_customer_num;
2865: l_cons_bill_id NUMBER;
2866: l_cons_bill_num VARCHAR2(90);
2867: l_last_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT 1;
2868: l_contract_id NUMBER;
2869: l_contract_num VARCHAR2(120);
2870: l_contract_number_start_date OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
2871: l_contract_number_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;

Line 2870: l_contract_number_start_date OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;

2866: l_cons_bill_num VARCHAR2(90);
2867: l_last_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT 1;
2868: l_contract_id NUMBER;
2869: l_contract_num VARCHAR2(120);
2870: l_contract_number_start_date OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
2871: l_contract_number_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
2872:
2873: l_receivables_invoice_num NUMBER DEFAULT NULL;
2874: l_over_pay VARCHAR(1) DEFAULT NULL;

Line 2871: l_contract_number_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;

2867: l_last_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT 1;
2868: l_contract_id NUMBER;
2869: l_contract_num VARCHAR2(120);
2870: l_contract_number_start_date OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
2871: l_contract_number_id OKC_K_HEADERS_V.ID%TYPE DEFAULT NULL;
2872:
2873: l_receivables_invoice_num NUMBER DEFAULT NULL;
2874: l_over_pay VARCHAR(1) DEFAULT NULL;
2875: l_ordered CONSTANT VARCHAR2(3) := 'ODD';