DBA Data[Home] [Help]

APPS.HXC_TIMEKEEPER_UTILITIES dependencies on HXC_DEPOSIT_WRAPPER_UTILITIES

Line 539: SELECT hxc_deposit_wrapper_utilities.get_dupdff_code (

535: FROM DUAL;
536: END IF;
537: ELSIF l_reference_field = 'EXPENDITURE_TYPE' THEN
538: IF p_att_tab (att_dep_item).alias_type LIKE 'VALUE%' THEN
539: SELECT hxc_deposit_wrapper_utilities.get_dupdff_code (
540: 'PAEXPITDFF - '|| SUBSTR (new_att_catg, 1, INSTR (new_att_catg, 'ALIAS_SEPARATOR') - 1)
541: )
542: INTO new_att_catg
543: FROM DUAL;

Line 547: hxc_deposit_wrapper_utilities.get_dupdff_code (

543: FROM DUAL;
544: ELSE
545: -- new_att_catg:=get_exp_type_from_alias( new_att_catg);
546: new_att_catg :=
547: hxc_deposit_wrapper_utilities.get_dupdff_code (
548: 'PAEXPITDFF - '|| get_exp_type_from_alias (new_att_catg)
549: );
550: END IF;
551: -- :DETAIL_BLK.C_ATTRIBUTE_CATEGORY:=HXC_DEPOSIT_WRAPPER_UTILITIES.GET_DUPDFF_CODE(:DETAIL_BLK.C_ATTRIBUTE_CATEGORY) ;--3791698

Line 551: -- :DETAIL_BLK.C_ATTRIBUTE_CATEGORY:=HXC_DEPOSIT_WRAPPER_UTILITIES.GET_DUPDFF_CODE(:DETAIL_BLK.C_ATTRIBUTE_CATEGORY) ;--3791698

547: hxc_deposit_wrapper_utilities.get_dupdff_code (
548: 'PAEXPITDFF - '|| get_exp_type_from_alias (new_att_catg)
549: );
550: END IF;
551: -- :DETAIL_BLK.C_ATTRIBUTE_CATEGORY:=HXC_DEPOSIT_WRAPPER_UTILITIES.GET_DUPDFF_CODE(:DETAIL_BLK.C_ATTRIBUTE_CATEGORY) ;--3791698
552: ELSIF l_reference_field = ''
553: /*ADVICE(525): In Oracle 8, VARCHAR2 variables of zero length assigned to CHAR variables will blank-pad
554: these rather than making them NULL [111] */
555: OR l_reference_field IS NULL THEN