APPS.WMS_RULE_GEN_PKGS dependencies on GMI_RESERVATION_UTIL

Line 769: gmi_reservation_util.println('GENPK , l_counter_str '||l_counter_str);

765: OPEN rule_curs;
766: FETCH rule_curs BULK COLLECT INTO ruletab;
767: CLOSE rule_curs;
768:
769: gmi_reservation_util.println('GENPK , l_counter_str '||l_counter_str);
770: -- LG convergence add my package here
771: IF (l_type_code = PICK_TYPE) THEN
772: gmi_reservation_util.println('GENPK , picking gen');
773: l_package_name := 'WMS_RULE_PICK_PKG';

Line 772: gmi_reservation_util.println('GENPK , picking gen');

768:
769: gmi_reservation_util.println('GENPK , l_counter_str '||l_counter_str);
770: -- LG convergence add my package here
771: IF (l_type_code = PICK_TYPE) THEN
772: gmi_reservation_util.println('GENPK , picking gen');
773: l_package_name := 'WMS_RULE_PICK_PKG';
774: l_pkg_hdr_S := l_pick_hdr_S;
775: l_pkg_hdr_B := l_pick_hdr_B;
776: l_pkg_open_end := l_pick_open_end;

Line 858: gmi_reservation_util.println('GENPK , f_avail gen '||l_rule_id);

854: x_consist_string,
855: x_order_by_string,
856: x_return_status );
857: ';
858: gmi_reservation_util.println('GENPK , f_avail gen '||l_rule_id);
859: l_pkg_body_f_avail := l_pkg_body_f_avail || l_if_cl ||
860: ' p_rule_id = ' || l_rule_id || ' THEN
861: WMS_RULE_' || l_rule_id || '.fetch_available_rows(
862: p_cursor,

Line 866: -- gmi_reservation_util.println('GENPK , l_body_f_avail '||l_pkg_body_f_avail);

862: p_cursor,
863: x_return_status );
864: ';
865: -- end if;
866: -- gmi_reservation_util.println('GENPK , l_body_f_avail '||l_pkg_body_f_avail);
867:
868:
869: l_pkg_body_c := l_pkg_body_c || l_if_cl ||
870: ' p_rule_id = ' || l_rule_id || ' THEN

Line 1137: --gmi_reservation_util.println('GENPK , rule_cnt '||rule_cnt);

1133:
1134: l_pkg_body_o := l_pkg_body_o || l_endif_cl || l_pkg_open_end ;
1135: --inv_pp_debug.send_long_to_pipe('l_pkg_body_o' || l_pkg_body_o);
1136:
1137: --gmi_reservation_util.println('GENPK , rule_cnt '||rule_cnt);
1138: IF ( rule_cnt >= 1) THEN
1139: j := j + 1;
1140: g_tbl_pkg_body(j) := l_pkg_body_o;
1141:

Line 1165: gmi_reservation_util.println('GENPK , building spec');

1161: inv_pp_debug.send_long_to_pipe('Begin GenerateSQL : Package Code Type ' || p_pkg_type);
1162: end if;
1163:
1164: IF (p_pkg_type is null or p_pkg_type = 'S') then
1165: gmi_reservation_util.println('GENPK , building spec');
1166:
1167: if inv_pp_debug.is_debug_mode then
1168: inv_pp_debug.send_long_to_pipe('Inside ... Spec for creating specs');
1169: inv_pp_debug.send_long_to_pipe('INSIDE' || p_pkg_type);

Line 1204: gmi_reservation_util.println('GENPK , building body');

1200: end if;
1201:
1202: IF (p_pkg_type is null or p_pkg_type = 'B') then
1203:
1204: gmi_reservation_util.println('GENPK , building body');
1205:
1206: if inv_pp_debug.is_debug_mode then
1207: inv_pp_debug.send_long_to_pipe('Inside ... Body for creating Body');
1208: inv_pp_debug.send_long_to_pipe('INSIDE' || p_pkg_type);

Line 1232: gmi_reservation_util.println('GENPK , f_count '||g_tbl_pkg_body_f.count);

1228: g_tbl_pkg_body(i) := NULL;
1229: END IF;
1230: END LOOP;
1231:
1232: gmi_reservation_util.println('GENPK , f_count '||g_tbl_pkg_body_f.count);
1233: IF (g_tbl_pkg_body_f.count >=1 ) THEN
1234: BuildPackage(l_pkg_fetch_hdr);
1235: FOR i in 1..g_tbl_pkg_body_f.count loop
1236: IF (g_tbl_pkg_body_f.EXISTS(i)) THEN

Line 1247: gmi_reservation_util.println('GENPK , f_count '||g_tbl_pkg_body_f_avail.count);

1243: END IF;
1244:
1245: -- LG convergence ADD
1246: IF (l_type_code = PICK_TYPE) THEN
1247: gmi_reservation_util.println('GENPK , f_count '||g_tbl_pkg_body_f_avail.count);
1248: IF (g_tbl_pkg_body_f_avail.count >=1 ) THEN
1249: BuildPackage(l_pick_fetch_avail_hdr);
1250: FOR i in 1..g_tbl_pkg_body_f_avail.count loop
1251: IF (g_tbl_pkg_body_f_avail.EXISTS(i)) THEN