1: PACKAGE BODY PO_PDOI_TYPES AS
2: /* $Header: PO_PDOI_TYPES.plb 120.7 2006/09/15 22:25:45 jinwang noship $ */
3:
4: d_pkg_name CONSTANT VARCHAR2(50) :=
5: PO_LOG.get_package_base('PO_PDOI_TYPES');
6:
7: --------------------------------------------------------------------------
8: ---------------------- PRIVATE PROCEDURES PROTOTYPE ----------------------
9: --------------------------------------------------------------------------
76:
77: BEGIN
78: d_position := 0;
79:
80: IF (PO_LOG.d_proc) THEN
81: PO_LOG.proc_begin(d_module);
82: END IF;
83:
84: -- set record count
77: BEGIN
78: d_position := 0;
79:
80: IF (PO_LOG.d_proc) THEN
81: PO_LOG.proc_begin(d_module);
82: END IF;
83:
84: -- set record count
85: x_headers.rec_count := p_num_records;
210:
211: -- attributes added for processing purpose
212: fill_tbl(p_num_records, x_headers.error_flag_tbl);
213:
214: IF (PO_LOG.d_proc) THEN
215: PO_LOG.proc_end (d_module);
216: END IF;
217:
218: EXCEPTION
211: -- attributes added for processing purpose
212: fill_tbl(p_num_records, x_headers.error_flag_tbl);
213:
214: IF (PO_LOG.d_proc) THEN
215: PO_LOG.proc_end (d_module);
216: END IF;
217:
218: EXCEPTION
219: WHEN OTHERS THEN
253:
254: BEGIN
255: d_position := 0;
256:
257: IF (PO_LOG.d_proc) THEN
258: PO_LOG.proc_begin(d_module);
259: END IF;
260:
261: -- set record count
254: BEGIN
255: d_position := 0;
256:
257: IF (PO_LOG.d_proc) THEN
258: PO_LOG.proc_begin(d_module);
259: END IF;
260:
261: -- set record count
262: x_lines.rec_count := p_num_records;
386: fill_tbl(p_num_records, x_lines.need_to_reject_flag_tbl);
387: fill_tbl(p_num_records, x_lines.allow_desc_update_flag_tbl);
388:
389:
390: IF (PO_LOG.d_proc) THEN
391: PO_LOG.proc_end (d_module);
392: END IF;
393:
394: EXCEPTION
387: fill_tbl(p_num_records, x_lines.allow_desc_update_flag_tbl);
388:
389:
390: IF (PO_LOG.d_proc) THEN
391: PO_LOG.proc_end (d_module);
392: END IF;
393:
394: EXCEPTION
395: WHEN OTHERS THEN
429:
430: BEGIN
431: d_position := 0;
432:
433: IF (PO_LOG.d_proc) THEN
434: PO_LOG.proc_begin(d_module);
435: END IF;
436:
437: -- set record count
430: BEGIN
431: d_position := 0;
432:
433: IF (PO_LOG.d_proc) THEN
434: PO_LOG.proc_begin(d_module);
435: END IF;
436:
437: -- set record count
438: x_line_locs.rec_count := p_num_records;
574: -- attributes added for processing purpose
575: fill_tbl(p_num_records, x_line_locs.shipment_num_unique_tbl);
576: fill_tbl(p_num_records, x_line_locs.error_flag_tbl);
577:
578: IF (PO_LOG.d_proc) THEN
579: PO_LOG.proc_end (d_module);
580: END IF;
581:
582: EXCEPTION
575: fill_tbl(p_num_records, x_line_locs.shipment_num_unique_tbl);
576: fill_tbl(p_num_records, x_line_locs.error_flag_tbl);
577:
578: IF (PO_LOG.d_proc) THEN
579: PO_LOG.proc_end (d_module);
580: END IF;
581:
582: EXCEPTION
583: WHEN OTHERS THEN
616:
617: BEGIN
618: d_position := 0;
619:
620: IF (PO_LOG.d_proc) THEN
621: PO_LOG.proc_begin(d_module);
622: END IF;
623:
624: -- set record count
617: BEGIN
618: d_position := 0;
619:
620: IF (PO_LOG.d_proc) THEN
621: PO_LOG.proc_begin(d_module);
622: END IF;
623:
624: -- set record count
625: x_dists.rec_count := p_num_records;
818: fill_tbl(p_num_records, x_dists.dist_num_unique_tbl);
819: fill_tbl(p_num_records, x_dists.error_flag_tbl);
820:
821:
822: IF (PO_LOG.d_proc) THEN
823: PO_LOG.proc_end (d_module);
824: END IF;
825:
826:
819: fill_tbl(p_num_records, x_dists.error_flag_tbl);
820:
821:
822: IF (PO_LOG.d_proc) THEN
823: PO_LOG.proc_end (d_module);
824: END IF;
825:
826:
827: EXCEPTION
861:
862: BEGIN
863: d_position := 0;
864:
865: IF (PO_LOG.d_proc) THEN
866: PO_LOG.proc_begin(d_module);
867: END IF;
868:
869: -- set record count
862: BEGIN
863: d_position := 0;
864:
865: IF (PO_LOG.d_proc) THEN
866: PO_LOG.proc_begin(d_module);
867: END IF;
868:
869: -- set record count
870: x_price_diffs.rec_count := p_num_records;
894: fill_tbl(p_num_records, x_price_diffs.error_flag_tbl);
895: fill_tbl(p_num_records, x_price_diffs.price_diff_num_unique_tbl);
896:
897:
898: IF (PO_LOG.d_proc) THEN
899: PO_LOG.proc_end (d_module);
900: END IF;
901:
902: EXCEPTION
895: fill_tbl(p_num_records, x_price_diffs.price_diff_num_unique_tbl);
896:
897:
898: IF (PO_LOG.d_proc) THEN
899: PO_LOG.proc_end (d_module);
900: END IF;
901:
902: EXCEPTION
903: WHEN OTHERS THEN
936:
937: BEGIN
938: d_position := 0;
939:
940: IF (PO_LOG.d_proc) THEN
941: PO_LOG.proc_begin(d_module);
942: END IF;
943:
944: -- set record count
937: BEGIN
938: d_position := 0;
939:
940: IF (PO_LOG.d_proc) THEN
941: PO_LOG.proc_begin(d_module);
942: END IF;
943:
944: -- set record count
945: x_attr_values.rec_count := p_num_records;
959: -- attributes added for processing purpose
960: fill_tbl(p_num_records, x_attr_values.attribute_values_id_tbl);
961: fill_tbl(p_num_records, x_attr_values.error_flag_tbl);
962:
963: IF (PO_LOG.d_proc) THEN
964: PO_LOG.proc_end (d_module);
965: END IF;
966:
967: EXCEPTION
960: fill_tbl(p_num_records, x_attr_values.attribute_values_id_tbl);
961: fill_tbl(p_num_records, x_attr_values.error_flag_tbl);
962:
963: IF (PO_LOG.d_proc) THEN
964: PO_LOG.proc_end (d_module);
965: END IF;
966:
967: EXCEPTION
968: WHEN OTHERS THEN
1001:
1002: BEGIN
1003: d_position := 0;
1004:
1005: IF (PO_LOG.d_proc) THEN
1006: PO_LOG.proc_begin(d_module);
1007: END IF;
1008:
1009: -- set record count
1002: BEGIN
1003: d_position := 0;
1004:
1005: IF (PO_LOG.d_proc) THEN
1006: PO_LOG.proc_begin(d_module);
1007: END IF;
1008:
1009: -- set record count
1010: x_attr_values_tlp.rec_count := p_num_records;
1026: -- attributes added for processing purpose
1027: fill_tbl(p_num_records, x_attr_values_tlp.error_flag_tbl);
1028: fill_tbl(p_num_records, x_attr_values_tlp.attribute_values_tlp_id_tbl);
1029:
1030: IF (PO_LOG.d_proc) THEN
1031: PO_LOG.proc_end (d_module);
1032: END IF;
1033:
1034: EXCEPTION
1027: fill_tbl(p_num_records, x_attr_values_tlp.error_flag_tbl);
1028: fill_tbl(p_num_records, x_attr_values_tlp.attribute_values_tlp_id_tbl);
1029:
1030: IF (PO_LOG.d_proc) THEN
1031: PO_LOG.proc_end (d_module);
1032: END IF;
1033:
1034: EXCEPTION
1035: WHEN OTHERS THEN