eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_BILLING_CONTROLLER_PVT dependencies on OKL_INVOICE_FORMATS_V

Line 3040: l_format_name okl_invoice_formats_v.name%TYPE;

3036: IS
3037:
3038:
3039: l_api_name CONSTANT VARCHAR2(30) := 'process_cons_bill_tbl';
3040: l_format_name okl_invoice_formats_v.name%TYPE;
3041: l_contract_level_yn VARCHAR2(3);
3042: l_group_asset_yn VARCHAR2(3);
3043: l_group_by_contract_yn VARCHAR2(3);
3044: l_ilt_id NUMBER;

Line 3121: FROM okl_invoice_formats_v inf,

3117: ilt.id ilt_id,
3118: ilt.sequence_number,
3119: ilt.name ilt_name,
3120: sty.name sty_name
3121: FROM okl_invoice_formats_v inf,
3122: okl_invoice_types_v ity,
3123: okl_invc_line_types_v ilt,
3124: okl_invc_frmt_strms_v frs,
3125: okl_strm_type_v sty

Line 3144: FROM okl_invoice_formats_v inf,

3140: ity.group_by_contract_yn,
3141: ilt.id ilt_id,
3142: ilt.sequence_number,
3143: ilt.name ilt_name
3144: FROM okl_invoice_formats_v inf,
3145: okl_invoice_types_v ity,
3146: okl_invc_line_types_v ilt
3147: WHERE inf.id = p_format_id
3148: AND ity.inf_id = inf.id

Line 3153: l_invoice_format OKL_INVOICE_FORMATS_V.NAME%TYPE;

3149: AND ilt.ity_id = ity.id
3150: AND inf.ilt_id = ilt.id;
3151:
3152: l_cons_invoice_num OKL_CNSLD_AR_HDRS_B.CONSOLIDATED_INVOICE_NUMBER%TYPE;
3153: l_invoice_format OKL_INVOICE_FORMATS_V.NAME%TYPE;
3154: l_sty_name OKL_STRM_TYPE_V.NAME%TYPE;
3155:
3156: l_old_cnr_id NUMBER;
3157: l_old_lln_id NUMBER;

Line 3189: FROM okl_invoice_formats_v inf,

3185: ilt.sequence_number,
3186: ilt.name ilt_name,
3187: sty.name sty_name,
3188: frs.sty_id sty_id
3189: FROM okl_invoice_formats_v inf,
3190: okl_invoice_types_v ity,
3191: okl_invc_line_types_v ilt,
3192: okl_invc_frmt_strms_v frs,
3193: okl_strm_type_v sty

Line 3212: FROM okl_invoice_formats_v inf,

3208: ilt.sequence_number,
3209: ilt.name ilt_name,
3210: 'DEFAULT FORMAT' sty_name,
3211: NULL
3212: FROM okl_invoice_formats_v inf,
3213: okl_invoice_types_v ity,
3214: okl_invc_line_types_v ilt
3215: WHERE ity.inf_id = inf.id
3216: AND ilt.ity_id = ity.id

Line 3219: inf_id okl_invoice_formats_v.id%type,

3215: WHERE ity.inf_id = inf.id
3216: AND ilt.ity_id = ity.id
3217: AND inf.ilt_id = ilt.id;
3218: TYPE inv_format_type IS RECORD (
3219: inf_id okl_invoice_formats_v.id%type,
3220: inf_name okl_invoice_formats_v.name%type,
3221: contract_level_yn okl_invoice_formats_v.contract_level_yn%type,
3222: ity_id okl_invoice_types_v.id%type,
3223: ity_name okl_invoice_types_v.name%type,

Line 3220: inf_name okl_invoice_formats_v.name%type,

3216: AND ilt.ity_id = ity.id
3217: AND inf.ilt_id = ilt.id;
3218: TYPE inv_format_type IS RECORD (
3219: inf_id okl_invoice_formats_v.id%type,
3220: inf_name okl_invoice_formats_v.name%type,
3221: contract_level_yn okl_invoice_formats_v.contract_level_yn%type,
3222: ity_id okl_invoice_types_v.id%type,
3223: ity_name okl_invoice_types_v.name%type,
3224: group_asset_yn okl_invoice_types_v.group_asset_yn%type,

Line 3221: contract_level_yn okl_invoice_formats_v.contract_level_yn%type,

3217: AND inf.ilt_id = ilt.id;
3218: TYPE inv_format_type IS RECORD (
3219: inf_id okl_invoice_formats_v.id%type,
3220: inf_name okl_invoice_formats_v.name%type,
3221: contract_level_yn okl_invoice_formats_v.contract_level_yn%type,
3222: ity_id okl_invoice_types_v.id%type,
3223: ity_name okl_invoice_types_v.name%type,
3224: group_asset_yn okl_invoice_types_v.group_asset_yn%type,
3225: group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type,

Line 3238: l_inf_id okl_invoice_formats_v.id%type;

3234:
3235: l_inv_format_table inv_format_table;
3236: l_lln_tbl lln_tbl_type;
3237: l_line_counter NUMBER := 0;
3238: l_inf_id okl_invoice_formats_v.id%type;
3239: l_sty_id okl_invc_frmt_strms_v.sty_id%type;
3240: l_loop_counter NUMBER := 0;
3241: l_asset_counter NUMBER := 0;
3242: