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.17.12010000.4 2008/10/16 09:35:19 anuthi ship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

1959: , t_attribute30(attx)
1960: , t_bld_blk_info_type_id(attx)
1961: , t_attribute_category(attx) );
1962:
1963: hxc_time_category_utils_pkg.g_master_tc_info_rec.attribute_count := x;
1964:
1965: -- delete attribute array
1966:
1967: t_bb_id.delete;

Line 2141: hxc_time_category_utils_pkg.g_tc_bb_not_ok_string := NULL;

2137:
2138: execute immediate l_trunc_blks;
2139: execute immediate l_trunc_atts;
2140:
2141: hxc_time_category_utils_pkg.g_tc_bb_not_ok_string := NULL;
2142:
2143: -- populate bld blk array
2144:
2145: l_ind := p_blocks.FIRST;

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

2165: -- always set the master timecard id
2166:
2167: IF ( p_blocks(l_ind).scope = 'TIMECARD' )
2168: THEN
2169: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_card_id := p_blocks(l_ind).time_building_block_id;
2170: END IF;
2171:
2172: -- only copy blocks which are NOT deleted
2173:

Line 2247: IF ( hxc_time_category_utils_pkg.g_tc_bb_not_ok_string IS NULL )

2243:
2244: IF ( t_scope(x) = 'DETAIL' )
2245: THEN
2246:
2247: IF ( hxc_time_category_utils_pkg.g_tc_bb_not_ok_string IS NULL )
2248: THEN
2249:
2250: hxc_time_category_utils_pkg.g_tc_bb_not_ok_string := t_bb_id(x);
2251:

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

2246:
2247: IF ( hxc_time_category_utils_pkg.g_tc_bb_not_ok_string IS NULL )
2248: THEN
2249:
2250: hxc_time_category_utils_pkg.g_tc_bb_not_ok_string := t_bb_id(x);
2251:
2252: ELSE
2253:
2254: hxc_time_category_utils_pkg.g_tc_bb_not_ok_string

Line 2254: hxc_time_category_utils_pkg.g_tc_bb_not_ok_string

2250: hxc_time_category_utils_pkg.g_tc_bb_not_ok_string := t_bb_id(x);
2251:
2252: ELSE
2253:
2254: hxc_time_category_utils_pkg.g_tc_bb_not_ok_string
2255: := hxc_time_category_utils_pkg.g_tc_bb_not_ok_string || ', ' || t_bb_id(x);
2256:
2257: END IF;
2258:

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

2251:
2252: ELSE
2253:
2254: hxc_time_category_utils_pkg.g_tc_bb_not_ok_string
2255: := hxc_time_category_utils_pkg.g_tc_bb_not_ok_string || ', ' || t_bb_id(x);
2256:
2257: END IF;
2258:
2259: END IF; -- t_scope(x) = 'DETAIL'

Line 3019: ELSIF ( hxc_time_category_utils_pkg.g_time_category_id IS NULL )

3015: END IF;
3016:
3017: dbms_sql.close_cursor ( l_csr );
3018:
3019: ELSIF ( hxc_time_category_utils_pkg.g_time_category_id IS NULL )
3020: THEN
3021:
3022: l_sql := l_select_null;
3023:

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

3319: hr_utility.trace('tc id is : '||TO_CHAR(g_params.p_time_category_id));
3320: hr_utility.trace('scope is : '||g_params.p_scope);
3321: hr_utility.trace('tbb id is : '||TO_CHAR(g_params.p_tbb_id));
3322: hr_utility.trace('tbb ovn is : '||TO_CHAR(g_params.p_tbb_ovn));
3323: hr_utility.trace('Master tc id '||to_char(hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id));
3324: hr_utility.trace('Master TC id '||to_char(hxc_time_category_utils_pkg.g_master_tc_info_rec.time_card_id));
3325: hr_utility.trace('Master att cnt '||to_char(hxc_time_category_utils_pkg.g_master_tc_info_rec.attribute_count));
3326:
3327: IF ( g_params.p_use_tc_cache )

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

3320: hr_utility.trace('scope is : '||g_params.p_scope);
3321: hr_utility.trace('tbb id is : '||TO_CHAR(g_params.p_tbb_id));
3322: hr_utility.trace('tbb ovn is : '||TO_CHAR(g_params.p_tbb_ovn));
3323: hr_utility.trace('Master tc id '||to_char(hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id));
3324: hr_utility.trace('Master TC id '||to_char(hxc_time_category_utils_pkg.g_master_tc_info_rec.time_card_id));
3325: hr_utility.trace('Master att cnt '||to_char(hxc_time_category_utils_pkg.g_master_tc_info_rec.attribute_count));
3326:
3327: IF ( g_params.p_use_tc_cache )
3328: THEN

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

3321: hr_utility.trace('tbb id is : '||TO_CHAR(g_params.p_tbb_id));
3322: hr_utility.trace('tbb ovn is : '||TO_CHAR(g_params.p_tbb_ovn));
3323: hr_utility.trace('Master tc id '||to_char(hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id));
3324: hr_utility.trace('Master TC id '||to_char(hxc_time_category_utils_pkg.g_master_tc_info_rec.time_card_id));
3325: hr_utility.trace('Master att cnt '||to_char(hxc_time_category_utils_pkg.g_master_tc_info_rec.attribute_count));
3326:
3327: IF ( g_params.p_use_tc_cache )
3328: THEN
3329: hr_utility.trace('p_use_tc_cache is TRUE');

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

3407:
3408:
3409: -- For the master time category check the cache
3410:
3411: IF ( hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id IS NULL )
3412: THEN
3413:
3414: IF ( g_debug ) THEN
3415: hr_utility.trace('Master Time Category !!!!!!');

Line 3420: hxc_time_category_utils_pkg.g_time_category_id := p_time_category_id;

3416: END IF;
3417:
3418: -- set master TC info
3419:
3420: hxc_time_category_utils_pkg.g_time_category_id := p_time_category_id;
3421:
3422: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id := p_time_category_id;
3423: hxc_time_category_utils_pkg.g_master_tc_info_rec.operator := l_time_category_info.operator;
3424:

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

3418: -- set master TC info
3419:
3420: hxc_time_category_utils_pkg.g_time_category_id := p_time_category_id;
3421:
3422: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id := p_time_category_id;
3423: hxc_time_category_utils_pkg.g_master_tc_info_rec.operator := l_time_category_info.operator;
3424:
3425:
3426:

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

3419:
3420: hxc_time_category_utils_pkg.g_time_category_id := p_time_category_id;
3421:
3422: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id := p_time_category_id;
3423: hxc_time_category_utils_pkg.g_master_tc_info_rec.operator := l_time_category_info.operator;
3424:
3425:
3426:
3427: -- check tc bb cache

Line 3437: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_card_id ) AND

3433: hr_utility.trace('tc bb ok cache exists');
3434: END IF;
3435:
3436: IF ( ( g_tc_bb_ok_cache(p_time_category_id).timecard_id =
3437: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_card_id ) AND
3438: ( g_tc_bb_ok_cache(p_time_category_id).attribute_count =
3439: hxc_time_category_utils_pkg.g_master_tc_info_rec.attribute_count ) )
3440: THEN
3441:

Line 3439: hxc_time_category_utils_pkg.g_master_tc_info_rec.attribute_count ) )

3435:
3436: IF ( ( g_tc_bb_ok_cache(p_time_category_id).timecard_id =
3437: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_card_id ) AND
3438: ( g_tc_bb_ok_cache(p_time_category_id).attribute_count =
3439: hxc_time_category_utils_pkg.g_master_tc_info_rec.attribute_count ) )
3440: THEN
3441:
3442: IF ( g_debug ) THEN
3443: hr_utility.trace('Using tc bb ok cache');

Line 3487: IF ( hxc_time_category_utils_pkg.g_tc_bb_not_ok_string IS NULL )

3483: IF ( g_debug ) THEN
3484: hr_utility.trace('Using temporary table to generate not ok bbs');
3485: END IF;
3486:
3487: IF ( hxc_time_category_utils_pkg.g_tc_bb_not_ok_string IS NULL )
3488: THEN
3489:
3490: -- generate tc_bb_not_ok_string (this should always be generated in
3491: -- push_timecard)

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

3514: IF ( g_debug ) THEN
3515: hr_utility.trace('bb not ok string is '||p_tc_bb_not_ok_string);
3516: END IF;
3517:
3518: ELSE -- hxc_time_category_utils_pkg.g_tc_bb_not_ok_string IS NOT NULL
3519:
3520: p_tc_bb_not_ok_string := hxc_time_category_utils_pkg.g_tc_bb_not_ok_string;
3521:
3522: IF ( g_debug ) THEN

Line 3520: p_tc_bb_not_ok_string := hxc_time_category_utils_pkg.g_tc_bb_not_ok_string;

3516: END IF;
3517:
3518: ELSE -- hxc_time_category_utils_pkg.g_tc_bb_not_ok_string IS NOT NULL
3519:
3520: p_tc_bb_not_ok_string := hxc_time_category_utils_pkg.g_tc_bb_not_ok_string;
3521:
3522: IF ( g_debug ) THEN
3523: hr_utility.trace('Using cache : bb not ok string is '||p_tc_bb_not_ok_string);
3524: END IF;

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

3522: IF ( g_debug ) THEN
3523: hr_utility.trace('Using cache : bb not ok string is '||p_tc_bb_not_ok_string);
3524: END IF;
3525:
3526: END IF; -- hxc_time_category_utils_pkg.g_tc_bb_not_ok_string IS NULL
3527:
3528: ELSE -- using live table
3529:
3530: IF ( g_debug ) THEN

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

3597: -- can only use bb cache for master time category
3598:
3599: l_tc_bb_cache_exists := FALSE;
3600:
3601: END IF; -- IF ( hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id IS NULL )
3602:
3603:
3604:
3605:

Line 3731: , hxc_time_category_utils_pkg.g_master_tc_info_rec.operator );

3727: , NULL
3728: , p_tc_bb_ok_tab
3729: , p_tc_bb_ok_string
3730: , p_tc_bb_not_ok_string
3731: , hxc_time_category_utils_pkg.g_master_tc_info_rec.operator );
3732:
3733: l_continue_evaluation := continue_evaluation ( hxc_time_category_utils_pkg.g_master_tc_info_rec.operator
3734: , p_tc_bb_ok_string
3735: , p_tc_bb_not_ok_string );

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

3729: , p_tc_bb_ok_string
3730: , p_tc_bb_not_ok_string
3731: , hxc_time_category_utils_pkg.g_master_tc_info_rec.operator );
3732:
3733: l_continue_evaluation := continue_evaluation ( hxc_time_category_utils_pkg.g_master_tc_info_rec.operator
3734: , p_tc_bb_ok_string
3735: , p_tc_bb_not_ok_string );
3736:
3737:

Line 3766: , hxc_time_category_utils_pkg.g_master_tc_info_rec.operator );

3762: , l_vs_comp_tab(l_vs_ind).sql_string
3763: , p_tc_bb_ok_tab
3764: , p_tc_bb_ok_string
3765: , p_tc_bb_not_ok_string
3766: , hxc_time_category_utils_pkg.g_master_tc_info_rec.operator );
3767:
3768: l_vs_ind := l_vs_comp_tab.NEXT(l_vs_ind);
3769:
3770: l_continue_evaluation := continue_evaluation ( hxc_time_category_utils_pkg.g_master_tc_info_rec.operator

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

3766: , hxc_time_category_utils_pkg.g_master_tc_info_rec.operator );
3767:
3768: l_vs_ind := l_vs_comp_tab.NEXT(l_vs_ind);
3769:
3770: l_continue_evaluation := continue_evaluation ( hxc_time_category_utils_pkg.g_master_tc_info_rec.operator
3771: , p_tc_bb_ok_string
3772: , p_tc_bb_not_ok_string );
3773:
3774: END LOOP;

Line 3800: , hxc_time_category_utils_pkg.g_master_tc_info_rec.operator );

3796: , l_an_comp_tab(l_an_ind).sql_string
3797: , p_tc_bb_ok_tab
3798: , p_tc_bb_ok_string
3799: , p_tc_bb_not_ok_string
3800: , hxc_time_category_utils_pkg.g_master_tc_info_rec.operator );
3801:
3802: l_an_ind := l_an_comp_tab.NEXT(l_an_ind);
3803:
3804: l_continue_evaluation := continue_evaluation ( hxc_time_category_utils_pkg.g_master_tc_info_rec.operator

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

3800: , hxc_time_category_utils_pkg.g_master_tc_info_rec.operator );
3801:
3802: l_an_ind := l_an_comp_tab.NEXT(l_an_ind);
3803:
3804: l_continue_evaluation := continue_evaluation ( hxc_time_category_utils_pkg.g_master_tc_info_rec.operator
3805: , p_tc_bb_ok_string
3806: , p_tc_bb_not_ok_string );
3807:
3808: END LOOP;

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

3830: , p_tc_bb_not_ok_string => p_tc_bb_not_ok_string );
3831:
3832: l_ff_ind := l_tc_comp_tab.NEXT(l_ff_ind);
3833:
3834: l_continue_evaluation := continue_evaluation ( hxc_time_category_utils_pkg.g_master_tc_info_rec.operator
3835: , p_tc_bb_ok_string
3836: , p_tc_bb_not_ok_string );
3837:
3838: END LOOP;

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

3874:
3875:
3876: -- Only maintain these global variables for the master time category
3877:
3878: IF ( p_time_category_id = hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id )
3879: THEN
3880:
3881: -- setting global time category variables
3882:

Line 3883: hxc_time_category_utils_pkg.g_tc_in_bb_ok := p_time_category_id;

3879: THEN
3880:
3881: -- setting global time category variables
3882:
3883: hxc_time_category_utils_pkg.g_tc_in_bb_ok := p_time_category_id;
3884: hxc_time_category_utils_pkg.g_tc_bb_ok_tab := p_tc_bb_ok_tab;
3885: hxc_time_category_utils_pkg.g_tc_bb_ok_string := p_tc_bb_ok_string;
3886:
3887: -- *****************************************************************************

Line 3884: hxc_time_category_utils_pkg.g_tc_bb_ok_tab := p_tc_bb_ok_tab;

3880:
3881: -- setting global time category variables
3882:
3883: hxc_time_category_utils_pkg.g_tc_in_bb_ok := p_time_category_id;
3884: hxc_time_category_utils_pkg.g_tc_bb_ok_tab := p_tc_bb_ok_tab;
3885: hxc_time_category_utils_pkg.g_tc_bb_ok_string := p_tc_bb_ok_string;
3886:
3887: -- *****************************************************************************
3888: -- bb ok cache is not being used currently

Line 3885: hxc_time_category_utils_pkg.g_tc_bb_ok_string := p_tc_bb_ok_string;

3881: -- setting global time category variables
3882:
3883: hxc_time_category_utils_pkg.g_tc_in_bb_ok := p_time_category_id;
3884: hxc_time_category_utils_pkg.g_tc_bb_ok_tab := p_tc_bb_ok_tab;
3885: hxc_time_category_utils_pkg.g_tc_bb_ok_string := p_tc_bb_ok_string;
3886:
3887: -- *****************************************************************************
3888: -- bb ok cache is not being used currently
3889: -- *****************************************************************************

Line 3900: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_card_id;

3896:
3897: g_tc_bb_ok_cache(p_time_category_id).bb_ok_string := p_tc_bb_ok_string;
3898:
3899: g_tc_bb_ok_cache(p_time_category_id).timecard_id :=
3900: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_card_id;
3901:
3902: g_tc_bb_ok_cache(p_time_category_id).attribute_count :=
3903: hxc_time_category_utils_pkg.g_master_tc_info_rec.attribute_count;
3904:

Line 3903: hxc_time_category_utils_pkg.g_master_tc_info_rec.attribute_count;

3899: g_tc_bb_ok_cache(p_time_category_id).timecard_id :=
3900: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_card_id;
3901:
3902: g_tc_bb_ok_cache(p_time_category_id).attribute_count :=
3903: hxc_time_category_utils_pkg.g_master_tc_info_rec.attribute_count;
3904:
3905: */
3906:
3907:

Line 3919: hxc_time_category_utils_pkg.g_tc_in_bb_ok := p_time_category_id;

3915: IF ( g_debug ) THEN
3916: hr_utility.trace('Using bb outcome cache');
3917: END IF;
3918:
3919: hxc_time_category_utils_pkg.g_tc_in_bb_ok := p_time_category_id;
3920:
3921: hxc_time_category_utils_pkg.g_tc_bb_ok_string := g_tc_bb_ok_cache( p_time_category_id ).bb_ok_string;
3922:
3923: hxc_time_category_utils_pkg.g_tc_bb_ok_tab := get_bb_ok_tab_from_string ( p_time_category_id );

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

3917: END IF;
3918:
3919: hxc_time_category_utils_pkg.g_tc_in_bb_ok := p_time_category_id;
3920:
3921: hxc_time_category_utils_pkg.g_tc_bb_ok_string := g_tc_bb_ok_cache( p_time_category_id ).bb_ok_string;
3922:
3923: hxc_time_category_utils_pkg.g_tc_bb_ok_tab := get_bb_ok_tab_from_string ( p_time_category_id );
3924:
3925: p_tc_bb_ok_string := g_tc_bb_ok_cache( p_time_category_id ).bb_ok_string;

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

3919: hxc_time_category_utils_pkg.g_tc_in_bb_ok := p_time_category_id;
3920:
3921: hxc_time_category_utils_pkg.g_tc_bb_ok_string := g_tc_bb_ok_cache( p_time_category_id ).bb_ok_string;
3922:
3923: hxc_time_category_utils_pkg.g_tc_bb_ok_tab := get_bb_ok_tab_from_string ( p_time_category_id );
3924:
3925: p_tc_bb_ok_string := g_tc_bb_ok_cache( p_time_category_id ).bb_ok_string;
3926:
3927:

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

3951: END IF; -- l debug
3952:
3953: -- Reset Variables for the Master TC
3954:
3955: IF ( p_time_category_id = hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id )
3956: THEN
3957:
3958: -- reset master time category variables now the cache has been maintained
3959:

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

3956: THEN
3957:
3958: -- reset master time category variables now the cache has been maintained
3959:
3960: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id := NULL;
3961:
3962: END IF;
3963:
3964:

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

3994: l_proc := g_package||'chk_tc_bb_ok';
3995: hr_utility.set_location('Entering '||l_proc, 10);
3996: END IF;
3997:
3998: IF ( ( g_tc_in_bb_ok <> hxc_time_category_utils_pkg.g_time_category_id ) OR
3999: ( g_tc_in_bb_ok IS NULL ) )
4000: THEN
4001: IF hxc_time_category_utils_pkg.g_time_category_id is not null then
4002: IF g_empty_time_category_tab.exists(hxc_time_category_utils_pkg.g_time_category_id) then

Line 4001: IF hxc_time_category_utils_pkg.g_time_category_id is not null then

3997:
3998: IF ( ( g_tc_in_bb_ok <> hxc_time_category_utils_pkg.g_time_category_id ) OR
3999: ( g_tc_in_bb_ok IS NULL ) )
4000: THEN
4001: IF hxc_time_category_utils_pkg.g_time_category_id is not null then
4002: IF g_empty_time_category_tab.exists(hxc_time_category_utils_pkg.g_time_category_id) then
4003: IF NOT g_empty_time_category_tab(hxc_time_category_utils_pkg.g_time_category_id).p_status THEN
4004: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4005: fnd_message.set_token('PROCEDURE', l_proc);

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

3998: IF ( ( g_tc_in_bb_ok <> hxc_time_category_utils_pkg.g_time_category_id ) OR
3999: ( g_tc_in_bb_ok IS NULL ) )
4000: THEN
4001: IF hxc_time_category_utils_pkg.g_time_category_id is not null then
4002: IF g_empty_time_category_tab.exists(hxc_time_category_utils_pkg.g_time_category_id) then
4003: IF NOT g_empty_time_category_tab(hxc_time_category_utils_pkg.g_time_category_id).p_status THEN
4004: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4005: fnd_message.set_token('PROCEDURE', l_proc);
4006: fnd_message.set_token('STEP','g tc id not tc tab id');

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

3999: ( g_tc_in_bb_ok IS NULL ) )
4000: THEN
4001: IF hxc_time_category_utils_pkg.g_time_category_id is not null then
4002: IF g_empty_time_category_tab.exists(hxc_time_category_utils_pkg.g_time_category_id) then
4003: IF NOT g_empty_time_category_tab(hxc_time_category_utils_pkg.g_time_category_id).p_status THEN
4004: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
4005: fnd_message.set_token('PROCEDURE', l_proc);
4006: fnd_message.set_token('STEP','g tc id not tc tab id');
4007: fnd_message.raise_error;

Line 4651: l_tc_bb_ok_tab hxc_time_category_utils_pkg.g_tc_bb_ok_tab%TYPE;

4647: PROCEDURE initialise_time_category (
4648: p_time_category_id NUMBER
4649: , p_tco_att hxc_self_service_time_deposit.building_block_attribute_info ) IS
4650:
4651: l_tc_bb_ok_tab hxc_time_category_utils_pkg.g_tc_bb_ok_tab%TYPE;
4652: l_tc_bb_ok_string VARCHAR2(32000);
4653: l_tc_bb_not_ok_string VARCHAR2(32000);
4654:
4655: l_proc VARCHAR2(72);

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

4668: -- complained of some value getting preloaded here, making the process
4669: -- error out.
4670: -- Added few extra trace messages too, for clarity in future.
4671:
4672: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id := NULL;
4673: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_card_id := NULL;
4674: hxc_time_category_utils_pkg.g_master_tc_info_rec.operator := NULL;
4675: hxc_time_category_utils_pkg.g_master_tc_info_rec.attribute_count := NULL;
4676:

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

4669: -- error out.
4670: -- Added few extra trace messages too, for clarity in future.
4671:
4672: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id := NULL;
4673: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_card_id := NULL;
4674: hxc_time_category_utils_pkg.g_master_tc_info_rec.operator := NULL;
4675: hxc_time_category_utils_pkg.g_master_tc_info_rec.attribute_count := NULL;
4676:
4677:

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

4670: -- Added few extra trace messages too, for clarity in future.
4671:
4672: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id := NULL;
4673: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_card_id := NULL;
4674: hxc_time_category_utils_pkg.g_master_tc_info_rec.operator := NULL;
4675: hxc_time_category_utils_pkg.g_master_tc_info_rec.attribute_count := NULL;
4676:
4677:
4678:

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

4671:
4672: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_category_id := NULL;
4673: hxc_time_category_utils_pkg.g_master_tc_info_rec.time_card_id := NULL;
4674: hxc_time_category_utils_pkg.g_master_tc_info_rec.operator := NULL;
4675: hxc_time_category_utils_pkg.g_master_tc_info_rec.attribute_count := NULL;
4676:
4677:
4678:
4679: IF ( g_debug ) THEN

Line 4686: hxc_time_category_utils_pkg.evaluate_time_category (

4682: hr_utility.trace('Initialise_time_category for time_category_id :'||p_time_category_id);
4683: hr_utility.trace('Assigned NULL to the master tc id record ');
4684: END IF;
4685:
4686: hxc_time_category_utils_pkg.evaluate_time_category (
4687: p_time_category_id => p_time_category_id
4688: , p_tc_bb_ok_tab => l_tc_bb_ok_tab
4689: , p_tc_bb_ok_string => l_tc_bb_ok_string
4690: , p_tc_bb_not_ok_string => l_tc_bb_not_ok_string );

Line 4750: l_tc_bb_ok_tab hxc_time_category_utils_pkg.t_tc_bb_ok;

4746:
4747: l_timecard_hrs NUMBER := 0;
4748: l_time_category_id hxc_time_categories.time_category_id%TYPE;
4749:
4750: l_tc_bb_ok_tab hxc_time_category_utils_pkg.t_tc_bb_ok;
4751: l_tc_bb_ok_string VARCHAR2(32000);
4752: l_tc_bb_not_ok_string VARCHAR2(32000);
4753:
4754: l_proc varchar2(72);

Line 4865: l_tc_bb_ok_tab hxc_time_category_utils_pkg.t_tc_bb_ok;

4861:
4862: l_timecard_hrs NUMBER := 0;
4863: l_time_category_id hxc_time_categories.time_category_id%TYPE;
4864:
4865: l_tc_bb_ok_tab hxc_time_category_utils_pkg.t_tc_bb_ok;
4866: l_tc_bb_ok_string VARCHAR2(32000);
4867: l_tc_bb_not_ok_string VARCHAR2(32000);
4868:
4869: l_precision VARCHAR2(4);

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

5019:
5020: l_timecard_hrs := category_detail_hrs (
5021: p_tbb_id => p_tbb_id
5022: , p_tbb_ovn => p_tbb_ovn
5023: , p_time_category_id => hxc_time_category_utils_pkg.g_time_category_id );
5024:
5025: RETURN l_timecard_hrs;
5026:
5027: END category_detail_hrs;

Line 5047: l_tc_bb_ok_tab hxc_time_category_utils_pkg.t_tc_bb_ok;

5043:
5044: l_hrs NUMBER := 0;
5045: l_proc VARCHAR2(72);
5046:
5047: l_tc_bb_ok_tab hxc_time_category_utils_pkg.t_tc_bb_ok;
5048: l_tc_bb_ok_string VARCHAR2(32000);
5049: l_tc_bb_not_ok_string VARCHAR2(32000);
5050:
5051:

Line 5180: hxc_time_category_utils_pkg.g_time_category_id :=

5176: then
5177: l_rounding_rule := 'ROUND_TO_NEAREST';
5178: end if;
5179:
5180: hxc_time_category_utils_pkg.g_time_category_id :=
5181: get_time_category_id ( p_time_category_name => p_time_category_name );
5182:
5183: OPEN csr_get_total_timecard_hrs;
5184: FETCH csr_get_total_timecard_hrs INTO l_hours;

Line 5473: end hxc_time_category_utils_pkg;

5469: return false;
5470:
5471: End reset_cache;
5472:
5473: end hxc_time_category_utils_pkg;