DBA Data[Home] [Help]

APPS.OTFR2483 dependencies on OTFR2483

Line 1: PACKAGE BODY otfr2483 AS

1: PACKAGE BODY otfr2483 AS
2: /* $Header: otfr2483.pkb 120.9 2006/09/19 18:20:08 aparkes noship $ */
3: --
4: procedure trace_sql (p_sql IN VARCHAR2) is
5: l_start number;

Line 2: /* $Header: otfr2483.pkb 120.9 2006/09/19 18:20:08 aparkes noship $ */

1: PACKAGE BODY otfr2483 AS
2: /* $Header: otfr2483.pkb 120.9 2006/09/19 18:20:08 aparkes noship $ */
3: --
4: procedure trace_sql (p_sql IN VARCHAR2) is
5: l_start number;
6: l_len number;

Line 1138: ,otfr2483.get_dif_balance(ass.assignment_id,

1134: ,to_number(NULL) ftrn_id
1135: ,to_number(NULL) trn_hrs
1136: ,to_number(NULL) dif_trn_id
1137: ,to_number(NULL) dif_hrs
1138: ,otfr2483.get_dif_balance(ass.assignment_id,
1139: acc.accrual_plan_id,
1140: ass.payroll_id,
1141: comp.business_group_id,
1142: :p_comp_end) dif_bal

Line 3199: hr_utility.trace('Leaving otfr2483.build_XML');

3195: load_xml(p_xml,'FIELDS',c_CloseGrpTag);
3196: --
3197: --dbms_lob.createtemporary(p_xml,TRUE);
3198: --p_xml := g_xml;
3199: hr_utility.trace('Leaving otfr2483.build_XML');
3200: end build_XML;
3201: --
3202: PROCEDURE run_2483 (errbuf OUT NOCOPY VARCHAR2
3203: ,retcode OUT NOCOPY NUMBER

Line 3290: END otfr2483;

3286: retcode :=2; /* Critical Error */
3287: errbuf := sqlerrm;
3288: END run_2483;
3289: --
3290: END otfr2483;