[Home] [Help]
2111: IF (PO_LOG.d_proc) THEN
2112: PO_LOG.proc_begin(d_module, 'line counts', x_lines.rec_count);
2113: END IF;
2114:
2115: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);
2116:
2117: -- assign a new key used in temporary table
2118: l_key := PO_CORE_S.get_session_gt_nextval;
2119:
2776: END IF; --PO_PDOI_PARAMS.g_request.clm_flag='Y'
2777: --CLM PDOI Integration Ends
2778: END LOOP;
2779:
2780: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);
2781:
2782: IF (PO_LOG.d_proc) THEN
2783: PO_LOG.proc_end (d_module);
2784: END IF;
2829: IF (PO_LOG.d_proc) THEN
2830: PO_LOG.proc_begin(d_module, 'line counts', x_lines.rec_count);
2831: END IF;
2832:
2833: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);
2834:
2835: -- assign a new key used in temporary table
2836: l_key := PO_CORE_S.get_session_gt_nextval;
2837:
3016: x_lines.error_flag_tbl(i) := FND_API.g_TRUE;
3017: END IF;
3018: END LOOP;
3019:
3020: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);
3021:
3022: IF (PO_LOG.d_proc) THEN
3023: PO_LOG.proc_end (d_module);
3024: END IF;
3096: IF (PO_LOG.d_proc) THEN
3097: PO_LOG.proc_begin(d_module);
3098: END IF;
3099:
3100: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_DEFAULT);
3101:
3102: -- get key value to identify rows in po_session_gt table
3103: l_key := PO_CORE_S.get_session_gt_nextval;
3104:
3497:
3498: END IF; --PO_PDOI_PARAMS.g_request.clm_flag='Y'
3499: --CLM PDOI Integration Ends
3500:
3501: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_DEFAULT);
3502:
3503: IF (PO_LOG.d_proc) THEN
3504: PO_LOG.proc_end (d_module);
3505: END IF;
3563: PO_LOG.proc_begin(d_module, 'po_line_id', x_lines.po_line_id_tbl);
3564: PO_LOG.proc_begin(d_module, 'draft_id', x_lines.draft_id_tbl);
3565: END IF;
3566:
3567: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);
3568:
3569: -- assign a new key used in temporary table
3570: l_key := PO_CORE_S.get_session_gt_nextval;
3571:
3633: x_lines.item_id_tbl(l_index) := l_item_id_tbl(i);
3634: x_lines.job_id_tbl(l_index) := l_job_id_tbl(i);
3635: END LOOP;
3636:
3637: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_DERIVE);
3638:
3639: IF (PO_LOG.d_proc) THEN
3640: PO_LOG.proc_end (d_module);
3641: END IF;
3686: IF (PO_LOG.d_proc) THEN
3687: PO_LOG.proc_begin(d_module);
3688: END IF;
3689:
3690: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_MATCH);
3691:
3692: -- initialize index table
3693: PO_PDOI_UTL.generate_ordered_num_list
3694: (
3829: p_id_tbl => l_rej_intf_line_id_tbl,
3830: p_cascade => FND_API.g_TRUE
3831: );
3832:
3833: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_MATCH);
3834:
3835: IF (PO_LOG.d_proc) THEN
3836: PO_LOG.proc_end (d_module);
3837: END IF;
4133: l_index := x_processing_row_tbl.NEXT(l_index);
4134: END LOOP;
4135: END IF;
4136:
4137: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_UNIQUENESS_CHECK);
4138:
4139: -- get key value for po_session_gt table
4140: l_key := PO_CORE_S.get_session_gt_nextval;
4141:
4317: END IF;
4318: END LOOP;
4319: END IF;
4320:
4321: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_UNIQUENESS_CHECK);
4322:
4323: IF (PO_LOG.d_proc) THEN
4324: PO_LOG.proc_end (d_module);
4325: END IF;
4474: IF (PO_LOG.d_proc) THEN
4475: PO_LOG.proc_begin(d_module, 'action', p_action);
4476: END IF;
4477:
4478: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_VALIDATE);
4479:
4480: l_lines.interface_id := x_lines.intf_line_id_tbl;
4481: l_lines.over_tolerance_error_flag := x_lines.over_tolerance_err_flag_tbl;
4482: l_lines.expiration_date := x_lines.expiration_date_tbl;
4647: );
4648:
4649: d_position := 100;
4650:
4651: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_VALIDATE);
4652:
4653: IF (PO_LOG.d_proc) THEN
4654: PO_LOG.proc_end(d_module, 'result_type', l_result_type);
4655: END IF;