APPS.MSC_REL_PLAN_PUB dependencies on MRP_ORG_TRANSFER_RELEASE

Line 2220: l_sql_cur := ' SELECT count(*) from MRP_ORG_TRANSFER_RELEASE'|| l_dblink ||

2216:
2217: l_plan_type NUMBER :=0;
2218: BEGIN
2219:
2220: l_sql_cur := ' SELECT count(*) from MRP_ORG_TRANSFER_RELEASE'|| l_dblink ||
2221: ' WHERE batch_id = :l_arg_po_batch_number' ;
2222:
2223:
2224: OPEN c_row_count for l_sql_cur USING l_arg_po_batch_number;

Line 2238: l_sql_stmt := ' INSERT INTO MRP_ORG_TRANSFER_RELEASE' || l_dblink ||

2234:
2235:
2236: IF p_load_type = DRP_REQ_LOAD THEN
2237:
2238: l_sql_stmt := ' INSERT INTO MRP_ORG_TRANSFER_RELEASE' || l_dblink ||
2239: ' ( batch_id, '||
2240: ' Item_ID, ' ||
2241: ' SRC_Organization_ID, ' ||
2242: ' SR_Instance_ID, ' ||

Line 2368: l_sql_stmt := ' INSERT INTO MRP_ORG_TRANSFER_RELEASE' || l_dblink ||

2364:
2365:
2366: ELSE
2367:
2368: l_sql_stmt := ' INSERT INTO MRP_ORG_TRANSFER_RELEASE' || l_dblink ||
2369: ' ( batch_id, '||
2370: ' Item_ID, ' ||
2371: ' SRC_Organization_ID, ' ||
2372: ' SR_Instance_ID, ' ||

Line 2500: update mrp_org_transfer_release motr

2496: END IF;
2497:
2498: END IF;
2499:
2500: update mrp_org_transfer_release motr
2501: set earliest_ship_date = (select max(ms.new_schedule_date)
2502: from msc_supplies ms, msc_single_lvl_peg mslp
2503: where ms.plan_id=l_arg_plan_id
2504: and ms.transaction_id = mslp.child_id

Line 2537: (select transaction_id from MRP_ORG_TRANSFER_RELEASE' || l_dblink || '

2533: set releasable = ' || RELEASE_ATTEMPTED || '
2534: ,batch_id = nvl(batch_id,' ||g_batch_id ||')
2535: where plan_id = ' || l_arg_plan_id || '
2536: and transaction_id in
2537: (select transaction_id from MRP_ORG_TRANSFER_RELEASE' || l_dblink || '
2538: where batch_id = ' || l_arg_po_batch_number || ')';
2539: END IF;
2540:
2541: END POPULATE_ISO_IN_SOURCE;

Line 2591: l_sql_stmt := ' INSERT INTO MRP_ORG_TRANSFER_RELEASE' || l_dblink ||

2587: CLOSE c_plan_type;
2588:
2589: IF p_load_type = DRP_REQ_LOAD THEN
2590:
2591: l_sql_stmt := ' INSERT INTO MRP_ORG_TRANSFER_RELEASE' || l_dblink ||
2592: ' ( batch_id, '||
2593: ' Item_ID, ' ||
2594: ' SRC_Organization_ID, ' ||
2595: ' SR_Instance_ID, ' ||

Line 2721: /* update mrp_org_transfer_release motr

2717: END IF;
2718:
2719: END IF;
2720:
2721: /* update mrp_org_transfer_release motr
2722: set earliest_ship_date = (select max(ms.new_schedule_date)
2723: from msc_part_supplies ms, msc_single_lvl_peg mslp
2724: where ms.plan_id=l_arg_plan_id
2725: and ms.transaction_id = mslp.child_id

Line 2752: (select transaction_id from MRP_ORG_TRANSFER_RELEASE' || l_dblink || '

2748: set releasable = ' || RELEASE_ATTEMPTED || ',
2749: batch_id = nvl(batch_id,' ||g_batch_id ||')
2750: where plan_id = ' || l_arg_plan_id || '
2751: and transaction_id in (select orig_transaction_id from msc_part_supplies where transaction_id in
2752: (select transaction_id from MRP_ORG_TRANSFER_RELEASE' || l_dblink || '
2753: where batch_id = ' || l_arg_po_batch_number || '))';
2754:
2755: execute immediate ' update msc_part_supplies
2756: set releasable = ' || RELEASE_ATTEMPTED || ',

Line 2760: (select transaction_id from MRP_ORG_TRANSFER_RELEASE' || l_dblink || '

2756: set releasable = ' || RELEASE_ATTEMPTED || ',
2757: batch_id = nvl(batch_id,' ||g_batch_id ||')
2758: where plan_id = ' || l_arg_plan_id || '
2759: and transaction_id in
2760: (select transaction_id from MRP_ORG_TRANSFER_RELEASE' || l_dblink || '
2761: where batch_id = ' || l_arg_po_batch_number || ')';
2762: END IF;
2763:
2764: END POPULATE_ISO_IN_SOURCE_2;

Line 3047: /* 6. call populate_iso_in_source to populate mrp_org_transfer_release_table in the source */

3043: CLOSE c_row_count;
3044: */
3045:
3046: --p_arg_loaded_int_repair_orders:= l_after_row_count -l_before_row_count;
3047: /* 6. call populate_iso_in_source to populate mrp_org_transfer_release_table in the source */
3048:
3049: IF p_arg_loaded_int_repair_orders > 0 THEN
3050:
3051: populate_iso_in_source(l_dblink => p_dblink,

Line 3385: /* 6. call POPULATE_ISO_IN_SOURCE_2 to populate mrp_org_transfer_release_table in the source */

3381:
3382: --p_arg_loaded_int_repair_orders:= l_after_row_count -l_before_row_count;
3383:
3384:
3385: /* 6. call POPULATE_ISO_IN_SOURCE_2 to populate mrp_org_transfer_release_table in the source */
3386:
3387: IF p_arg_loaded_int_repair_orders > 0 THEN
3388:
3389: populate_iso_in_source_2(l_dblink => p_dblink,