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 2857: l_last_contract_id OKC_K_HEADERS_V.ID%TYPE DEFAULT 1;

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;

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

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