APPS.OKL_BILLING_CONTROLLER_PVT dependencies on OKL_INVC_LINE_TYPES_V

Line 3053: l_sequence_number okl_invc_line_types_v.sequence_number%TYPE;

3049: l_line_name VARCHAR2(150);
3050: l_ity_id NUMBER;
3051: l_format_type okl_invoice_types_v.name%TYPE;
3052:
3053: l_sequence_number okl_invc_line_types_v.sequence_number%TYPE;
3054: l_cons_line_name VARCHAR2(150);
3055: l_stream_name VARCHAR2(150);
3056: i NUMBER;
3057: l_funct_return VARCHAR2(1);

Line 3123: okl_invc_line_types_v ilt,

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
3126: WHERE inf.id = p_format_id
3127: AND ity.inf_id = inf.id

Line 3146: okl_invc_line_types_v ilt

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
3149: AND ilt.ity_id = ity.id
3150: AND inf.ilt_id = ilt.id;

Line 3191: okl_invc_line_types_v ilt,

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
3194: WHERE ity.inf_id = inf.id
3195: AND ilt.ity_id = ity.id

Line 3214: okl_invc_line_types_v ilt

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
3217: AND inf.ilt_id = ilt.id;
3218: TYPE inv_format_type IS RECORD (

Line 3226: ilt_id okl_invc_line_types_v.id%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,
3226: ilt_id okl_invc_line_types_v.id%type,
3227: sequence_number okl_invc_line_types_v.sequence_number%type,
3228: ilt_name okl_invc_line_types_v.name%type,
3229: sty_name okl_strm_type_v.name%type,
3230: sty_id okl_invc_frmt_strms_v.sty_id%type);

Line 3227: sequence_number okl_invc_line_types_v.sequence_number%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,
3226: ilt_id okl_invc_line_types_v.id%type,
3227: sequence_number okl_invc_line_types_v.sequence_number%type,
3228: ilt_name okl_invc_line_types_v.name%type,
3229: sty_name okl_strm_type_v.name%type,
3230: sty_id okl_invc_frmt_strms_v.sty_id%type);
3231:

Line 3228: ilt_name okl_invc_line_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,
3226: ilt_id okl_invc_line_types_v.id%type,
3227: sequence_number okl_invc_line_types_v.sequence_number%type,
3228: ilt_name okl_invc_line_types_v.name%type,
3229: sty_name okl_strm_type_v.name%type,
3230: sty_id okl_invc_frmt_strms_v.sty_id%type);
3231:
3232: TYPE inv_format_table IS TABLE OF inv_format_type