[Home] [Help]
54: l_resource_type number;
55: l_employee_id number;
56: l_employee_num varchar2(30);
57: l_params wip_logger.param_tbl_t;
58: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
59:
60: BEGIN
61: if(l_logLevel <= wip_constants.trace_logging) then
62: l_params(1).paramName := 'p_time_entry_id';
319: l_time_uom_flag varchar2(1);
320: l_projected_completion_date date;
321: l_return_status varchar2(10);
322: l_params wip_logger.param_tbl_t;
323: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
324: BEGIN
325: if(l_logLevel <= wip_constants.trace_logging) then
326: l_params(1).paramName := 'p_time_entry_id';
327: l_params(1).paramValue := p_time_entry_id;
511: l_start_date date;
512: l_return_status varchar2(10);
513:
514: l_params wip_logger.param_tbl_t;
515: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
516: cursor delete_cursor is select object_version_number,
517: organization_id,
518: wip_entity_id,
519: operation_seq_num,
613: l_start_date date;
614: l_return_status varchar2(10);
615:
616: l_params wip_logger.param_tbl_t;
617: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
618: cursor delete_cursor is select object_version_number,
619: organization_id,
620: resource_id,
621: resource_seq_num,
710: PROCEDURE job_off_internal(p_wip_entity_id IN NUMBER, p_operation_seq_num NUMBER)
711: IS
712: x_return_status varchar2(10);
713: l_params wip_logger.param_tbl_t;
714: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
715: BEGIN
716:
717: if(l_logLevel <= wip_constants.trace_logging) then
718: l_params(1).paramName := 'p_wip_entity_id';
746: l_uom_code varchar2(3);
747: l_date date;
748: x_return_status varchar2(10);
749: l_params wip_logger.param_tbl_t;
750: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
751: Begin
752: if(l_logLevel <= wip_constants.trace_logging) then
753: l_params(1).paramName := 'p_wip_entity_id';
754: l_params(1).paramValue := p_wip_entity_id;
803: procedure clock_out_machines(p_wip_entity_id number, p_operation_seq_num number)
804: is
805:
806: l_params wip_logger.param_tbl_t;
807: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
808: cursor all_labor_clocked_out(p_scheduled_flag number) is
809: select
810: decode(
811: ( select count(*)
1259: l_retStatus varchar2(10);
1260: l_return_status varchar2(10);
1261:
1262: l_params wip_logger.param_tbl_t;
1263: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1264: --time records (for all resource types) cursor- used for setting cost_flag, add_to_rtg,
1265: -- resource_seq_num (for ad-hoc resources), inserting into wcti and updating wrat status_type to completed
1266: cursor time_records_cursor (c_time_entry_mode1 number,
1267: c_time_entry_mode2 number,
1633: l_retStatus varchar2(1);
1634: l_manual_exist number;
1635: l_return_status varchar2(1);
1636: l_params wip_logger.param_tbl_t;
1637: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1638: cursor has_autocharge_manual_cursor is
1639: select 1
1640: from wip_operation_resources wor
1641: where wor.wip_entity_id = p_wip_entity_id
1784: l_min_start_date_wrat date;
1785:
1786: l_return_status varchar2(1);
1787: l_params wip_logger.param_tbl_t;
1788: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1789: cursor min_start_date_wrat_cursor is select min(wrat.start_date)
1790: from wip_resource_actual_times wrat
1791: where wrat.wip_entity_id = p_wip_entity_id
1792: and wrat.operation_seq_num = p_operation_seq_num
1883: l_active_next_resource_flag varchar2(1);
1884:
1885: l_return_status varchar2(1);
1886: l_params wip_logger.param_tbl_t;
1887: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1888: cursor max_end_date_wrat_cursor is select max(wrat.end_date)
1889: from wip_resource_actual_times wrat
1890: where wrat.wip_entity_id = p_wip_entity_id
1891: and wrat.operation_seq_num = p_operation_seq_num
1985: IS
1986: l_projected_completion_date date;
1987: l_return_status varchar2(1);
1988: l_params wip_logger.param_tbl_t;
1989: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1990: BEGIN
1991: if(l_logLevel <= wip_constants.trace_logging) then
1992: l_params(1).paramName := 'p_organization_id';
1993: l_params(1).paramValue := p_organization_id;
2107: l_msg_count number;
2108: l_msg varchar2(10);
2109: lx_return_status varchar2(10);
2110: l_params wip_logger.param_tbl_t;
2111: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2112: BEGIN
2113: if(l_logLevel <= wip_constants.trace_logging) then
2114: l_params(1).paramName := 'p_employee_id';
2115: l_params(1).paramValue := p_employee_id;
2163: l_status varchar2(1);
2164: l_msg_count number;
2165: l_msg varchar2(255);
2166: l_params wip_logger.param_tbl_t;
2167: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2168: BEGIN
2169: if(l_logLevel <= wip_constants.trace_logging) then
2170: l_params(1).paramName := 'p_wip_entity_id';
2171: l_params(1).paramValue := p_wip_entity_id;
2283: l_person_id number;
2284: l_time_entry number;
2285: l_ret_status varchar2(200);
2286: l_params wip_logger.param_tbl_t;
2287: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2288:
2289: CURSOR shift_in_cursor IS
2290: SELECT 1 FROM wip_resource_actual_times wrat
2291: WHERE wrat.wip_entity_id IS NULL
2379: l_duration number;
2380: badge_validation Boolean:= false;
2381: l_person_id number;
2382: l_params wip_logger.param_tbl_t;
2383: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2384: l_ret_status varchar2(1);
2385:
2386: cursor shift_out_test_cursor is
2387: select start_date from wip_resource_actual_times wrat
2457: l_person_id number;
2458: l_ret_status varchar2(1);
2459:
2460: l_params wip_logger.param_tbl_t;
2461: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2462: cursor undo_shift_in_test_cursor is
2463: select 1 from wip_resource_actual_times wrat
2464: where wrat.wip_entity_id is null
2465: and wrat.EMPLOYEE_ID=l_person_id
2525: l_person_id number;
2526: l_time_entry number;
2527: l_ret_status varchar2(200);
2528: l_params wip_logger.param_tbl_t;
2529: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2530:
2531: CURSOR shift_in_cursor IS
2532: SELECT 1 FROM wip_resource_actual_times wrat
2533: WHERE wrat.wip_entity_id IS NULL
2612: l_person_id number;
2613: l_ret_status varchar2(1);
2614:
2615: l_params wip_logger.param_tbl_t;
2616: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2617: cursor shift_out_test_cursor is
2618: select start_date from wip_resource_actual_times wrat
2619: where wrat.wip_entity_id is null
2620: and wrat.EMPLOYEE_ID=p_wip_employee_id
2681: l_dummy_var number;
2682: badge_validation Boolean :=false;
2683: l_person_id number;
2684: l_params wip_logger.param_tbl_t;
2685: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2686: l_ret_status varchar2(1);
2687:
2688: cursor undo_shift_in_test_cursor is
2689: select 1
2767: lx_return_status varchar2(10);
2768: l_num_job_op number;
2769: l_skill_check number;
2770: l_params wip_logger.param_tbl_t;
2771: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2772: l_ret_status varchar2(1);
2773:
2774: cursor clock_in_cursor is select 1
2775: from wip_resource_actual_times wrat
3048: l_uom_code varchar2(3);
3049: l_ret_status varchar2(1);
3050:
3051: l_params wip_logger.param_tbl_t;
3052: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
3053: cursor clock_out_test_cursor is
3054: select object_version_number,
3055: start_date
3056: from wip_resource_actual_times
3165: IS
3166: l_clock_status varchar2(1);
3167: lx_return_status varchar2(10);
3168: l_params wip_logger.param_tbl_t;
3169: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
3170: l_ret_status varchar2(1);
3171: BEGIN
3172: if(l_logLevel <= wip_constants.trace_logging) then
3173: l_params(1).paramName := 'p_wip_entity_id';
3412: p_txn_uom in varchar2,
3413: p_hour_uom in varchar2,
3414: x_return_status out NOCOPY varchar2)
3415: IS
3416: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);
3417: l_params wip_logger.param_tbl_t;
3418: l_msg VARCHAR2(100);
3419: l_retStatus VARCHAR2(1);
3420: