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.HXC_TIME_CATEGORY_UTILS_PKG dependencies on HXC_TIME_CATEGORY_UTILS_PKG

Line 1: Package Body hxc_time_category_utils_pkg as

1: Package Body hxc_time_category_utils_pkg as
2: /* $Header: hxchtcutl.pkb 120.23.12020000.6 2012/12/12 06:35:12 jnerella ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 1984: hxc_time_category_utils_pkg.g_master_tc_info_rec.attribute_count := x;

1980: , t_attribute30(attx)
1981: , t_bld_blk_info_type_id(attx)
1982: , t_attribute_category(attx) );
1983:
1984: hxc_time_category_utils_pkg.g_master_tc_info_rec.attribute_count := x;
1985:
1986: -- delete attribute array
1987:
1988: t_bb_id.delete;

Line 2162: hxc_time_category_utils_pkg.g_tc_bb_not_ok_string := NULL;

2158:
2159: execute immediate l_trunc_blks;
2160: execute immediate l_trunc_atts;
2161:
2162: hxc_time_category_utils_pkg.g_tc_bb_not_ok_string := NULL;
2163:
2164: -- populate bld blk array
2165:
2166: l_ind := p_blocks.FIRST;

Line 2190: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_card_id := p_blocks(l_ind).time_building_block_id;

2186: -- always set the master timecard id
2187:
2188: IF ( p_blocks(l_ind).scope = 'TIMECARD' )
2189: THEN
2190: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_card_id := p_blocks(l_ind).time_building_block_id;
2191: END IF;
2192:
2193: -- only copy blocks which are NOT deleted
2194:

Line 2268: IF ( hxc_time_category_utils_pkg.g_tc_bb_not_ok_string IS NULL )

2264:
2265: IF ( t_scope(x) = 'DETAIL' )
2266: THEN
2267:
2268: IF ( hxc_time_category_utils_pkg.g_tc_bb_not_ok_string IS NULL )
2269: THEN
2270:
2271: hxc_time_category_utils_pkg.g_tc_bb_not_ok_string := t_bb_id(x);
2272:

Line 2271: hxc_time_category_utils_pkg.g_tc_bb_not_ok_string := t_bb_id(x);

2267:
2268: IF ( hxc_time_category_utils_pkg.g_tc_bb_not_ok_string IS NULL )
2269: THEN
2270:
2271: hxc_time_category_utils_pkg.g_tc_bb_not_ok_string := t_bb_id(x);
2272:
2273: ELSE
2274:
2275: hxc_time_category_utils_pkg.g_tc_bb_not_ok_string

Line 2275: hxc_time_category_utils_pkg.g_tc_bb_not_ok_string

2271: hxc_time_category_utils_pkg.g_tc_bb_not_ok_string := t_bb_id(x);
2272:
2273: ELSE
2274:
2275: hxc_time_category_utils_pkg.g_tc_bb_not_ok_string
2276: := hxc_time_category_utils_pkg.g_tc_bb_not_ok_string || ', ' || t_bb_id(x);
2277:
2278: END IF;
2279:

Line 2276: := hxc_time_category_utils_pkg.g_tc_bb_not_ok_string || ', ' || t_bb_id(x);

2272:
2273: ELSE
2274:
2275: hxc_time_category_utils_pkg.g_tc_bb_not_ok_string
2276: := hxc_time_category_utils_pkg.g_tc_bb_not_ok_string || ', ' || t_bb_id(x);
2277:
2278: END IF;
2279:
2280: END IF; -- t_scope(x) = 'DETAIL'

Line 3129: ELSIF ( hxc_time_category_utils_pkg.g_time_category_id IS NULL )

3125: END IF;
3126:
3127: dbms_sql.close_cursor ( l_csr );
3128:
3129: ELSIF ( hxc_time_category_utils_pkg.g_time_category_id IS NULL )
3130: THEN
3131: IF ( g_debug ) THEN
3132: hr_utility.trace('KRISH p_tc_bb_ok_string 2');
3133: END IF;

Line 3440: hr_utility.trace('Master tc id '||to_char(hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id));

3436: hr_utility.trace('tc id is : '||TO_CHAR(g_params.p_time_category_id));
3437: hr_utility.trace('scope is : '||g_params.p_scope);
3438: hr_utility.trace('tbb id is : '||TO_CHAR(g_params.p_tbb_id));
3439: hr_utility.trace('tbb ovn is : '||TO_CHAR(g_params.p_tbb_ovn));
3440: hr_utility.trace('Master tc id '||to_char(hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id));
3441: hr_utility.trace('Master TC id '||to_char(hxc_time_category_utils_pkg.g_master_tc_info_rec.time_card_id));
3442: hr_utility.trace('Master att cnt '||to_char(hxc_time_category_utils_pkg.g_master_tc_info_rec.attribute_count));
3443:
3444: IF ( g_params.p_use_tc_cache )

Line 3441: hr_utility.trace('Master TC id '||to_char(hxc_time_category_utils_pkg.g_master_tc_info_rec.time_card_id));

3437: hr_utility.trace('scope is : '||g_params.p_scope);
3438: hr_utility.trace('tbb id is : '||TO_CHAR(g_params.p_tbb_id));
3439: hr_utility.trace('tbb ovn is : '||TO_CHAR(g_params.p_tbb_ovn));
3440: hr_utility.trace('Master tc id '||to_char(hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id));
3441: hr_utility.trace('Master TC id '||to_char(hxc_time_category_utils_pkg.g_master_tc_info_rec.time_card_id));
3442: hr_utility.trace('Master att cnt '||to_char(hxc_time_category_utils_pkg.g_master_tc_info_rec.attribute_count));
3443:
3444: IF ( g_params.p_use_tc_cache )
3445: THEN

Line 3442: hr_utility.trace('Master att cnt '||to_char(hxc_time_category_utils_pkg.g_master_tc_info_rec.attribute_count));

3438: hr_utility.trace('tbb id is : '||TO_CHAR(g_params.p_tbb_id));
3439: hr_utility.trace('tbb ovn is : '||TO_CHAR(g_params.p_tbb_ovn));
3440: hr_utility.trace('Master tc id '||to_char(hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id));
3441: hr_utility.trace('Master TC id '||to_char(hxc_time_category_utils_pkg.g_master_tc_info_rec.time_card_id));
3442: hr_utility.trace('Master att cnt '||to_char(hxc_time_category_utils_pkg.g_master_tc_info_rec.attribute_count));
3443:
3444: IF ( g_params.p_use_tc_cache )
3445: THEN
3446: hr_utility.trace('p_use_tc_cache is TRUE');

Line 3528: IF ( hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id IS NULL )

3524:
3525:
3526: -- For the master time category check the cache
3527:
3528: IF ( hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id IS NULL )
3529: THEN
3530:
3531: IF ( g_debug ) THEN
3532: hr_utility.trace('Master Time Category !!!!!!');

Line 3537: hxc_time_category_utils_pkg.g_time_category_id := p_time_category_id;

3533: END IF;
3534:
3535: -- set master TC info
3536:
3537: hxc_time_category_utils_pkg.g_time_category_id := p_time_category_id;
3538:
3539: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id := p_time_category_id;
3540: hxc_time_category_utils_pkg.g_master_tc_info_rec.operator := l_time_category_info.operator;
3541:

Line 3539: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id := p_time_category_id;

3535: -- set master TC info
3536:
3537: hxc_time_category_utils_pkg.g_time_category_id := p_time_category_id;
3538:
3539: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id := p_time_category_id;
3540: hxc_time_category_utils_pkg.g_master_tc_info_rec.operator := l_time_category_info.operator;
3541:
3542:
3543:

Line 3540: hxc_time_category_utils_pkg.g_master_tc_info_rec.operator := l_time_category_info.operator;

3536:
3537: hxc_time_category_utils_pkg.g_time_category_id := p_time_category_id;
3538:
3539: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id := p_time_category_id;
3540: hxc_time_category_utils_pkg.g_master_tc_info_rec.operator := l_time_category_info.operator;
3541:
3542:
3543:
3544: -- check tc bb cache

Line 3554: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_card_id ) AND

3550: hr_utility.trace('tc bb ok cache exists');
3551: END IF;
3552:
3553: IF ( ( g_tc_bb_ok_cache(p_time_category_id).timecard_id =
3554: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_card_id ) AND
3555: ( g_tc_bb_ok_cache(p_time_category_id).attribute_count =
3556: hxc_time_category_utils_pkg.g_master_tc_info_rec.attribute_count ) )
3557: THEN
3558:

Line 3556: hxc_time_category_utils_pkg.g_master_tc_info_rec.attribute_count ) )

3552:
3553: IF ( ( g_tc_bb_ok_cache(p_time_category_id).timecard_id =
3554: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_card_id ) AND
3555: ( g_tc_bb_ok_cache(p_time_category_id).attribute_count =
3556: hxc_time_category_utils_pkg.g_master_tc_info_rec.attribute_count ) )
3557: THEN
3558:
3559: IF ( g_debug ) THEN
3560: hr_utility.trace('Using tc bb ok cache');

Line 3604: IF ( hxc_time_category_utils_pkg.g_tc_bb_not_ok_string IS NULL )

3600: IF ( g_debug ) THEN
3601: hr_utility.trace('Using temporary table to generate not ok bbs');
3602: END IF;
3603:
3604: IF ( hxc_time_category_utils_pkg.g_tc_bb_not_ok_string IS NULL )
3605: THEN
3606:
3607: -- generate tc_bb_not_ok_string (this should always be generated in
3608: -- push_timecard)

Line 3635: ELSE -- hxc_time_category_utils_pkg.g_tc_bb_not_ok_string IS NOT NULL

3631: IF ( g_debug ) THEN
3632: hr_utility.trace('bb not ok string is '||p_tc_bb_not_ok_string);
3633: END IF;
3634:
3635: ELSE -- hxc_time_category_utils_pkg.g_tc_bb_not_ok_string IS NOT NULL
3636:
3637: p_tc_bb_not_ok_string := hxc_time_category_utils_pkg.g_tc_bb_not_ok_string;
3638:
3639: IF ( g_debug ) THEN

Line 3637: p_tc_bb_not_ok_string := hxc_time_category_utils_pkg.g_tc_bb_not_ok_string;

3633: END IF;
3634:
3635: ELSE -- hxc_time_category_utils_pkg.g_tc_bb_not_ok_string IS NOT NULL
3636:
3637: p_tc_bb_not_ok_string := hxc_time_category_utils_pkg.g_tc_bb_not_ok_string;
3638:
3639: IF ( g_debug ) THEN
3640: hr_utility.trace('Using cache : bb not ok string is '||p_tc_bb_not_ok_string);
3641: END IF;

Line 3643: END IF; -- hxc_time_category_utils_pkg.g_tc_bb_not_ok_string IS NULL

3639: IF ( g_debug ) THEN
3640: hr_utility.trace('Using cache : bb not ok string is '||p_tc_bb_not_ok_string);
3641: END IF;
3642:
3643: END IF; -- hxc_time_category_utils_pkg.g_tc_bb_not_ok_string IS NULL
3644:
3645: ELSE -- using live table
3646:
3647: IF ( g_debug ) THEN

Line 3718: END IF; -- IF ( hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id IS NULL )

3714: -- can only use bb cache for master time category
3715:
3716: l_tc_bb_cache_exists := FALSE;
3717:
3718: END IF; -- IF ( hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id IS NULL )
3719:
3720:
3721:
3722:

Line 3848: , hxc_time_category_utils_pkg.g_master_tc_info_rec.operator );

3844: , NULL
3845: , p_tc_bb_ok_tab
3846: , p_tc_bb_ok_string
3847: , p_tc_bb_not_ok_string
3848: , hxc_time_category_utils_pkg.g_master_tc_info_rec.operator );
3849:
3850: l_continue_evaluation := continue_evaluation ( hxc_time_category_utils_pkg.g_master_tc_info_rec.operator
3851: , p_tc_bb_ok_string
3852: , p_tc_bb_not_ok_string );

Line 3850: l_continue_evaluation := continue_evaluation ( hxc_time_category_utils_pkg.g_master_tc_info_rec.operator

3846: , p_tc_bb_ok_string
3847: , p_tc_bb_not_ok_string
3848: , hxc_time_category_utils_pkg.g_master_tc_info_rec.operator );
3849:
3850: l_continue_evaluation := continue_evaluation ( hxc_time_category_utils_pkg.g_master_tc_info_rec.operator
3851: , p_tc_bb_ok_string
3852: , p_tc_bb_not_ok_string );
3853:
3854:

Line 3883: , hxc_time_category_utils_pkg.g_master_tc_info_rec.operator );

3879: , l_vs_comp_tab(l_vs_ind).sql_string
3880: , p_tc_bb_ok_tab
3881: , p_tc_bb_ok_string
3882: , p_tc_bb_not_ok_string
3883: , hxc_time_category_utils_pkg.g_master_tc_info_rec.operator );
3884:
3885: l_vs_ind := l_vs_comp_tab.NEXT(l_vs_ind);
3886:
3887: l_continue_evaluation := continue_evaluation ( hxc_time_category_utils_pkg.g_master_tc_info_rec.operator

Line 3887: l_continue_evaluation := continue_evaluation ( hxc_time_category_utils_pkg.g_master_tc_info_rec.operator

3883: , hxc_time_category_utils_pkg.g_master_tc_info_rec.operator );
3884:
3885: l_vs_ind := l_vs_comp_tab.NEXT(l_vs_ind);
3886:
3887: l_continue_evaluation := continue_evaluation ( hxc_time_category_utils_pkg.g_master_tc_info_rec.operator
3888: , p_tc_bb_ok_string
3889: , p_tc_bb_not_ok_string );
3890:
3891: END LOOP;

Line 3917: , hxc_time_category_utils_pkg.g_master_tc_info_rec.operator );

3913: , l_an_comp_tab(l_an_ind).sql_string
3914: , p_tc_bb_ok_tab
3915: , p_tc_bb_ok_string
3916: , p_tc_bb_not_ok_string
3917: , hxc_time_category_utils_pkg.g_master_tc_info_rec.operator );
3918:
3919: l_an_ind := l_an_comp_tab.NEXT(l_an_ind);
3920:
3921: l_continue_evaluation := continue_evaluation ( hxc_time_category_utils_pkg.g_master_tc_info_rec.operator

Line 3921: l_continue_evaluation := continue_evaluation ( hxc_time_category_utils_pkg.g_master_tc_info_rec.operator

3917: , hxc_time_category_utils_pkg.g_master_tc_info_rec.operator );
3918:
3919: l_an_ind := l_an_comp_tab.NEXT(l_an_ind);
3920:
3921: l_continue_evaluation := continue_evaluation ( hxc_time_category_utils_pkg.g_master_tc_info_rec.operator
3922: , p_tc_bb_ok_string
3923: , p_tc_bb_not_ok_string );
3924:
3925: END LOOP;

Line 3951: l_continue_evaluation := continue_evaluation ( hxc_time_category_utils_pkg.g_master_tc_info_rec.operator

3947: , p_tc_bb_not_ok_string => p_tc_bb_not_ok_string );
3948:
3949: l_ff_ind := l_tc_comp_tab.NEXT(l_ff_ind);
3950:
3951: l_continue_evaluation := continue_evaluation ( hxc_time_category_utils_pkg.g_master_tc_info_rec.operator
3952: , p_tc_bb_ok_string
3953: , p_tc_bb_not_ok_string );
3954:
3955: END LOOP;

Line 3995: IF ( p_time_category_id = hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id )

3991:
3992:
3993: -- Only maintain these global variables for the master time category
3994:
3995: IF ( p_time_category_id = hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id )
3996: THEN
3997:
3998: -- setting global time category variables
3999:

Line 4000: hxc_time_category_utils_pkg.g_tc_in_bb_ok := p_time_category_id;

3996: THEN
3997:
3998: -- setting global time category variables
3999:
4000: hxc_time_category_utils_pkg.g_tc_in_bb_ok := p_time_category_id;
4001: hxc_time_category_utils_pkg.g_tc_bb_ok_tab := p_tc_bb_ok_tab;
4002: hxc_time_category_utils_pkg.g_tc_bb_ok_string := p_tc_bb_ok_string;
4003:
4004: -- *****************************************************************************

Line 4001: hxc_time_category_utils_pkg.g_tc_bb_ok_tab := p_tc_bb_ok_tab;

3997:
3998: -- setting global time category variables
3999:
4000: hxc_time_category_utils_pkg.g_tc_in_bb_ok := p_time_category_id;
4001: hxc_time_category_utils_pkg.g_tc_bb_ok_tab := p_tc_bb_ok_tab;
4002: hxc_time_category_utils_pkg.g_tc_bb_ok_string := p_tc_bb_ok_string;
4003:
4004: -- *****************************************************************************
4005: -- bb ok cache is not being used currently

Line 4002: hxc_time_category_utils_pkg.g_tc_bb_ok_string := p_tc_bb_ok_string;

3998: -- setting global time category variables
3999:
4000: hxc_time_category_utils_pkg.g_tc_in_bb_ok := p_time_category_id;
4001: hxc_time_category_utils_pkg.g_tc_bb_ok_tab := p_tc_bb_ok_tab;
4002: hxc_time_category_utils_pkg.g_tc_bb_ok_string := p_tc_bb_ok_string;
4003:
4004: -- *****************************************************************************
4005: -- bb ok cache is not being used currently
4006: -- *****************************************************************************

Line 4017: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_card_id;

4013:
4014: g_tc_bb_ok_cache(p_time_category_id).bb_ok_string := p_tc_bb_ok_string;
4015:
4016: g_tc_bb_ok_cache(p_time_category_id).timecard_id :=
4017: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_card_id;
4018:
4019: g_tc_bb_ok_cache(p_time_category_id).attribute_count :=
4020: hxc_time_category_utils_pkg.g_master_tc_info_rec.attribute_count;
4021:

Line 4020: hxc_time_category_utils_pkg.g_master_tc_info_rec.attribute_count;

4016: g_tc_bb_ok_cache(p_time_category_id).timecard_id :=
4017: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_card_id;
4018:
4019: g_tc_bb_ok_cache(p_time_category_id).attribute_count :=
4020: hxc_time_category_utils_pkg.g_master_tc_info_rec.attribute_count;
4021:
4022: */
4023:
4024:

Line 4036: hxc_time_category_utils_pkg.g_tc_in_bb_ok := p_time_category_id;

4032: IF ( g_debug ) THEN
4033: hr_utility.trace('Using bb outcome cache');
4034: END IF;
4035:
4036: hxc_time_category_utils_pkg.g_tc_in_bb_ok := p_time_category_id;
4037:
4038: hxc_time_category_utils_pkg.g_tc_bb_ok_string := g_tc_bb_ok_cache( p_time_category_id ).bb_ok_string;
4039:
4040: hxc_time_category_utils_pkg.g_tc_bb_ok_tab := get_bb_ok_tab_from_string ( p_time_category_id );

Line 4038: hxc_time_category_utils_pkg.g_tc_bb_ok_string := g_tc_bb_ok_cache( p_time_category_id ).bb_ok_string;

4034: END IF;
4035:
4036: hxc_time_category_utils_pkg.g_tc_in_bb_ok := p_time_category_id;
4037:
4038: hxc_time_category_utils_pkg.g_tc_bb_ok_string := g_tc_bb_ok_cache( p_time_category_id ).bb_ok_string;
4039:
4040: hxc_time_category_utils_pkg.g_tc_bb_ok_tab := get_bb_ok_tab_from_string ( p_time_category_id );
4041:
4042: p_tc_bb_ok_string := g_tc_bb_ok_cache( p_time_category_id ).bb_ok_string;

Line 4040: hxc_time_category_utils_pkg.g_tc_bb_ok_tab := get_bb_ok_tab_from_string ( p_time_category_id );

4036: hxc_time_category_utils_pkg.g_tc_in_bb_ok := p_time_category_id;
4037:
4038: hxc_time_category_utils_pkg.g_tc_bb_ok_string := g_tc_bb_ok_cache( p_time_category_id ).bb_ok_string;
4039:
4040: hxc_time_category_utils_pkg.g_tc_bb_ok_tab := get_bb_ok_tab_from_string ( p_time_category_id );
4041:
4042: p_tc_bb_ok_string := g_tc_bb_ok_cache( p_time_category_id ).bb_ok_string;
4043:
4044:

Line 4072: IF ( p_time_category_id = hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id )

4068: END IF; -- l debug
4069:
4070: -- Reset Variables for the Master TC
4071:
4072: IF ( p_time_category_id = hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id )
4073: THEN
4074:
4075: -- reset master time category variables now the cache has been maintained
4076:

Line 4077: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id := NULL;

4073: THEN
4074:
4075: -- reset master time category variables now the cache has been maintained
4076:
4077: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id := NULL;
4078:
4079: END IF;
4080:
4081:

Line 4115: IF ( ( g_tc_in_bb_ok <> hxc_time_category_utils_pkg.g_time_category_id ) OR

4111: l_proc := g_package||'chk_tc_bb_ok';
4112: hr_utility.set_location('Entering '||l_proc, 10);
4113: END IF;
4114:
4115: IF ( ( g_tc_in_bb_ok <> hxc_time_category_utils_pkg.g_time_category_id ) OR
4116: ( g_tc_in_bb_ok IS NULL ) )
4117: THEN
4118: IF hxc_time_category_utils_pkg.g_time_category_id is not null then
4119: IF g_empty_time_category_tab.exists(hxc_time_category_utils_pkg.g_time_category_id) then

Line 4118: IF hxc_time_category_utils_pkg.g_time_category_id is not null then

4114:
4115: IF ( ( g_tc_in_bb_ok <> hxc_time_category_utils_pkg.g_time_category_id ) OR
4116: ( g_tc_in_bb_ok IS NULL ) )
4117: THEN
4118: IF hxc_time_category_utils_pkg.g_time_category_id is not null then
4119: IF g_empty_time_category_tab.exists(hxc_time_category_utils_pkg.g_time_category_id) then
4120: IF NOT g_empty_time_category_tab(hxc_time_category_utils_pkg.g_time_category_id).p_status THEN
4121: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4122: fnd_message.set_token('PROCEDURE', l_proc);

Line 4119: IF g_empty_time_category_tab.exists(hxc_time_category_utils_pkg.g_time_category_id) then

4115: IF ( ( g_tc_in_bb_ok <> hxc_time_category_utils_pkg.g_time_category_id ) OR
4116: ( g_tc_in_bb_ok IS NULL ) )
4117: THEN
4118: IF hxc_time_category_utils_pkg.g_time_category_id is not null then
4119: IF g_empty_time_category_tab.exists(hxc_time_category_utils_pkg.g_time_category_id) then
4120: IF NOT g_empty_time_category_tab(hxc_time_category_utils_pkg.g_time_category_id).p_status THEN
4121: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4122: fnd_message.set_token('PROCEDURE', l_proc);
4123: fnd_message.set_token('STEP','g tc id not tc tab id');

Line 4120: IF NOT g_empty_time_category_tab(hxc_time_category_utils_pkg.g_time_category_id).p_status THEN

4116: ( g_tc_in_bb_ok IS NULL ) )
4117: THEN
4118: IF hxc_time_category_utils_pkg.g_time_category_id is not null then
4119: IF g_empty_time_category_tab.exists(hxc_time_category_utils_pkg.g_time_category_id) then
4120: IF NOT g_empty_time_category_tab(hxc_time_category_utils_pkg.g_time_category_id).p_status THEN
4121: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4122: fnd_message.set_token('PROCEDURE', l_proc);
4123: fnd_message.set_token('STEP','g tc id not tc tab id');
4124: fnd_message.raise_error;

Line 4768: l_tc_bb_ok_tab hxc_time_category_utils_pkg.g_tc_bb_ok_tab%TYPE;

4764: PROCEDURE initialise_time_category (
4765: p_time_category_id NUMBER
4766: , p_tco_att hxc_self_service_time_deposit.building_block_attribute_info ) IS
4767:
4768: l_tc_bb_ok_tab hxc_time_category_utils_pkg.g_tc_bb_ok_tab%TYPE;
4769: l_tc_bb_ok_string VARCHAR2(32000);
4770: l_tc_bb_not_ok_string VARCHAR2(32000);
4771:
4772: l_proc VARCHAR2(72);

Line 4789: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id := NULL;

4785: -- complained of some value getting preloaded here, making the process
4786: -- error out.
4787: -- Added few extra trace messages too, for clarity in future.
4788:
4789: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id := NULL;
4790: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_card_id := NULL;
4791: hxc_time_category_utils_pkg.g_master_tc_info_rec.operator := NULL;
4792: hxc_time_category_utils_pkg.g_master_tc_info_rec.attribute_count := NULL;
4793:

Line 4790: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_card_id := NULL;

4786: -- error out.
4787: -- Added few extra trace messages too, for clarity in future.
4788:
4789: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id := NULL;
4790: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_card_id := NULL;
4791: hxc_time_category_utils_pkg.g_master_tc_info_rec.operator := NULL;
4792: hxc_time_category_utils_pkg.g_master_tc_info_rec.attribute_count := NULL;
4793:
4794:

Line 4791: hxc_time_category_utils_pkg.g_master_tc_info_rec.operator := NULL;

4787: -- Added few extra trace messages too, for clarity in future.
4788:
4789: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id := NULL;
4790: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_card_id := NULL;
4791: hxc_time_category_utils_pkg.g_master_tc_info_rec.operator := NULL;
4792: hxc_time_category_utils_pkg.g_master_tc_info_rec.attribute_count := NULL;
4793:
4794:
4795:

Line 4792: hxc_time_category_utils_pkg.g_master_tc_info_rec.attribute_count := NULL;

4788:
4789: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id := NULL;
4790: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_card_id := NULL;
4791: hxc_time_category_utils_pkg.g_master_tc_info_rec.operator := NULL;
4792: hxc_time_category_utils_pkg.g_master_tc_info_rec.attribute_count := NULL;
4793:
4794:
4795:
4796: IF ( g_debug ) THEN

Line 4803: hxc_time_category_utils_pkg.evaluate_time_category (

4799: hr_utility.trace('Initialise_time_category for time_category_id :'||p_time_category_id);
4800: hr_utility.trace('Assigned NULL to the master tc id record ');
4801: END IF;
4802:
4803: hxc_time_category_utils_pkg.evaluate_time_category (
4804: p_time_category_id => p_time_category_id
4805: , p_tc_bb_ok_tab => l_tc_bb_ok_tab
4806: , p_tc_bb_ok_string => l_tc_bb_ok_string
4807: , p_tc_bb_not_ok_string => l_tc_bb_not_ok_string );

Line 4867: l_tc_bb_ok_tab hxc_time_category_utils_pkg.t_tc_bb_ok;

4863:
4864: l_timecard_hrs NUMBER := 0;
4865: l_time_category_id hxc_time_categories.time_category_id%TYPE;
4866:
4867: l_tc_bb_ok_tab hxc_time_category_utils_pkg.t_tc_bb_ok;
4868: l_tc_bb_ok_string VARCHAR2(32000);
4869: l_tc_bb_not_ok_string VARCHAR2(32000);
4870:
4871: l_proc varchar2(72);

Line 4982: l_tc_bb_ok_tab hxc_time_category_utils_pkg.t_tc_bb_ok;

4978:
4979: l_timecard_hrs NUMBER := 0;
4980: l_time_category_id hxc_time_categories.time_category_id%TYPE;
4981:
4982: l_tc_bb_ok_tab hxc_time_category_utils_pkg.t_tc_bb_ok;
4983: l_tc_bb_ok_string VARCHAR2(32000);
4984: l_tc_bb_not_ok_string VARCHAR2(32000);
4985:
4986: l_precision VARCHAR2(4);

Line 5140: , p_time_category_id => hxc_time_category_utils_pkg.g_time_category_id );

5136:
5137: l_timecard_hrs := category_detail_hrs (
5138: p_tbb_id => p_tbb_id
5139: , p_tbb_ovn => p_tbb_ovn
5140: , p_time_category_id => hxc_time_category_utils_pkg.g_time_category_id );
5141:
5142: RETURN l_timecard_hrs;
5143:
5144: END category_detail_hrs;

Line 5164: l_tc_bb_ok_tab hxc_time_category_utils_pkg.t_tc_bb_ok;

5160:
5161: l_hrs NUMBER := 0;
5162: l_proc VARCHAR2(72);
5163:
5164: l_tc_bb_ok_tab hxc_time_category_utils_pkg.t_tc_bb_ok;
5165: l_tc_bb_ok_string VARCHAR2(32000);
5166: l_tc_bb_not_ok_string VARCHAR2(32000);
5167:
5168:

Line 5297: hxc_time_category_utils_pkg.g_time_category_id :=

5293: then
5294: l_rounding_rule := 'ROUND_TO_NEAREST';
5295: end if;
5296:
5297: hxc_time_category_utils_pkg.g_time_category_id :=
5298: get_time_category_id ( p_time_category_name => p_time_category_name );
5299:
5300: OPEN csr_get_total_timecard_hrs;
5301: FETCH csr_get_total_timecard_hrs INTO l_hours;

Line 5864: end hxc_time_category_utils_pkg;

5860:
5861: END delete_tc_comps2;
5862:
5863:
5864: end hxc_time_category_utils_pkg;