APPS.WMS_RULE_GEN_PKGS dependencies on GMI_RESERVATION_UTIL

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

758: OPEN rule_curs;
759: FETCH rule_curs BULK COLLECT INTO ruletab;
760: CLOSE rule_curs;
761:
762: gmi_reservation_util.println('GENPK , l_counter_str '||l_counter_str);
763: -- LG convergence add my package here
764: IF (l_type_code = PICK_TYPE) THEN
765: gmi_reservation_util.println('GENPK , picking gen');
766: l_package_name := 'WMS_RULE_PICK_PKG';

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

761:
762: gmi_reservation_util.println('GENPK , l_counter_str '||l_counter_str);
763: -- LG convergence add my package here
764: IF (l_type_code = PICK_TYPE) THEN
765: gmi_reservation_util.println('GENPK , picking gen');
766: l_package_name := 'WMS_RULE_PICK_PKG';
767: l_pkg_hdr_S := l_pick_hdr_S;
768: l_pkg_hdr_B := l_pick_hdr_B;
769: l_pkg_open_end := l_pick_open_end;

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

847: x_consist_string,
848: x_order_by_string,
849: x_return_status );
850: ';
851: gmi_reservation_util.println('GENPK , f_avail gen '||l_rule_id);
852: l_pkg_body_f_avail := l_pkg_body_f_avail || l_if_cl ||
853: ' p_rule_id = ' || l_rule_id || ' THEN
854: WMS_RULE_' || l_rule_id || '.fetch_available_rows(
855: p_cursor,

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

855: p_cursor,
856: x_return_status );
857: ';
858: -- end if;
859: -- gmi_reservation_util.println('GENPK , l_body_f_avail '||l_pkg_body_f_avail);
860:
861:
862: l_pkg_body_c := l_pkg_body_c || l_if_cl ||
863: ' p_rule_id = ' || l_rule_id || ' THEN

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

1126:
1127: l_pkg_body_o := l_pkg_body_o || l_endif_cl || l_pkg_open_end ;
1128: --inv_pp_debug.send_long_to_pipe('l_pkg_body_o' || l_pkg_body_o);
1129:
1130: --gmi_reservation_util.println('GENPK , rule_cnt '||rule_cnt);
1131: IF ( rule_cnt >= 1) THEN
1132: j := j + 1;
1133: g_tbl_pkg_body(j) := l_pkg_body_o;
1134:

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

1154: inv_pp_debug.send_long_to_pipe('Begin GenerateSQL : Package Code Type ' || p_pkg_type);
1155: end if;
1156:
1157: IF (p_pkg_type is null or p_pkg_type = 'S') then
1158: gmi_reservation_util.println('GENPK , building spec');
1159:
1160: if inv_pp_debug.is_debug_mode then
1161: inv_pp_debug.send_long_to_pipe('Inside ... Spec for creating specs');
1162: inv_pp_debug.send_long_to_pipe('INSIDE' || p_pkg_type);

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

1193: end if;
1194:
1195: IF (p_pkg_type is null or p_pkg_type = 'B') then
1196:
1197: gmi_reservation_util.println('GENPK , building body');
1198:
1199: if inv_pp_debug.is_debug_mode then
1200: inv_pp_debug.send_long_to_pipe('Inside ... Body for creating Body');
1201: inv_pp_debug.send_long_to_pipe('INSIDE' || p_pkg_type);

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

1221: g_tbl_pkg_body(i) := NULL;
1222: END IF;
1223: END LOOP;
1224:
1225: gmi_reservation_util.println('GENPK , f_count '||g_tbl_pkg_body_f.count);
1226: IF (g_tbl_pkg_body_f.count >=1 ) THEN
1227: BuildPackage(l_pkg_fetch_hdr);
1228: FOR i in 1..g_tbl_pkg_body_f.count loop
1229: IF (g_tbl_pkg_body_f.EXISTS(i)) THEN

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

1236: END IF;
1237:
1238: -- LG convergence ADD
1239: IF (l_type_code = PICK_TYPE) THEN
1240: gmi_reservation_util.println('GENPK , f_count '||g_tbl_pkg_body_f_avail.count);
1241: IF (g_tbl_pkg_body_f_avail.count >=1 ) THEN
1242: BuildPackage(l_pick_fetch_avail_hdr);
1243: FOR i in 1..g_tbl_pkg_body_f_avail.count loop
1244: IF (g_tbl_pkg_body_f_avail.EXISTS(i)) THEN