DBA Data[Home] [Help]

APPS.OKL_EXT_BILLING_CHARGES_PVT dependencies on OKL_TRX_AR_INVOICES_V

Line 211: l_amount okl_trx_ar_invoices_v.amount%TYPE;

207: l_try_id okl_trx_types_tl.id%type;
208: l_sty_id okl_strm_type_b.id%type;
209: l_currency_code fnd_currencies.currency_code%type;
210: l_khr_currency fnd_currencies.currency_code%type;
211: l_amount okl_trx_ar_invoices_v.amount%TYPE;
212: l_strm_purpose okl_strm_type_v.stream_type_purpose%TYPE;
213: l_trx_type_name VARCHAR2(30);
214: l_trx_type_lang CONSTANT VARCHAR2(30) := 'US';
215: l_err_status VARCHAR2(1);

Line 418: l_last_updated_by okl_trx_ar_invoices_v.last_updated_by%TYPE := Fnd_Global.USER_ID;

414:
415: -- ----------------------
416: -- Std Who columns
417: -- ----------------------
418: l_last_updated_by okl_trx_ar_invoices_v.last_updated_by%TYPE := Fnd_Global.USER_ID;
419: l_last_update_login okl_trx_ar_invoices_v.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
420: l_request_id okl_trx_ar_invoices_v.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
421:
422: l_program_application_id

Line 419: l_last_update_login okl_trx_ar_invoices_v.last_update_login%TYPE := Fnd_Global.LOGIN_ID;

415: -- ----------------------
416: -- Std Who columns
417: -- ----------------------
418: l_last_updated_by okl_trx_ar_invoices_v.last_updated_by%TYPE := Fnd_Global.USER_ID;
419: l_last_update_login okl_trx_ar_invoices_v.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
420: l_request_id okl_trx_ar_invoices_v.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
421:
422: l_program_application_id
423: okl_trx_ar_invoices_v.program_application_id%TYPE := Fnd_Global.PROG_APPL_ID;

Line 420: l_request_id okl_trx_ar_invoices_v.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;

416: -- Std Who columns
417: -- ----------------------
418: l_last_updated_by okl_trx_ar_invoices_v.last_updated_by%TYPE := Fnd_Global.USER_ID;
419: l_last_update_login okl_trx_ar_invoices_v.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
420: l_request_id okl_trx_ar_invoices_v.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
421:
422: l_program_application_id
423: okl_trx_ar_invoices_v.program_application_id%TYPE := Fnd_Global.PROG_APPL_ID;
424: l_program_id okl_trx_ar_invoices_v.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;

Line 423: okl_trx_ar_invoices_v.program_application_id%TYPE := Fnd_Global.PROG_APPL_ID;

419: l_last_update_login okl_trx_ar_invoices_v.last_update_login%TYPE := Fnd_Global.LOGIN_ID;
420: l_request_id okl_trx_ar_invoices_v.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
421:
422: l_program_application_id
423: okl_trx_ar_invoices_v.program_application_id%TYPE := Fnd_Global.PROG_APPL_ID;
424: l_program_id okl_trx_ar_invoices_v.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
425:
426: bulk_errors EXCEPTION;
427: PRAGMA EXCEPTION_INIT (bulk_errors, -24381);

Line 424: l_program_id okl_trx_ar_invoices_v.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;

420: l_request_id okl_trx_ar_invoices_v.request_id%TYPE := Fnd_Global.CONC_REQUEST_ID;
421:
422: l_program_application_id
423: okl_trx_ar_invoices_v.program_application_id%TYPE := Fnd_Global.PROG_APPL_ID;
424: l_program_id okl_trx_ar_invoices_v.program_id%TYPE := Fnd_Global.CONC_PROGRAM_ID;
425:
426: bulk_errors EXCEPTION;
427: PRAGMA EXCEPTION_INIT (bulk_errors, -24381);
428:

Line 482: processed_sts okl_trx_ar_invoices_v.trx_status_code%TYPE := 'PROCESSED';

478: lx_msg_data VARCHAR2(450);
479: l_msg_index_out NUMBER := 0;
480: l_op_unit_name hr_operating_units.name%TYPE;
481:
482: processed_sts okl_trx_ar_invoices_v.trx_status_code%TYPE := 'PROCESSED';
483: error_sts okl_trx_ar_invoices_v.trx_status_code%TYPE := 'ERROR';
484:
485: --added by kbbhavsa : Bug 5344799/5362220 : 27-June-06
486: l_sty_desc OKL_STRM_TYPE_V.name%TYPE;

Line 483: error_sts okl_trx_ar_invoices_v.trx_status_code%TYPE := 'ERROR';

479: l_msg_index_out NUMBER := 0;
480: l_op_unit_name hr_operating_units.name%TYPE;
481:
482: processed_sts okl_trx_ar_invoices_v.trx_status_code%TYPE := 'PROCESSED';
483: error_sts okl_trx_ar_invoices_v.trx_status_code%TYPE := 'ERROR';
484:
485: --added by kbbhavsa : Bug 5344799/5362220 : 27-June-06
486: l_sty_desc OKL_STRM_TYPE_V.name%TYPE;
487: l_temp_index NUMBER;