APPS.MSC_REL_PLAN_PUB dependencies on MRP_ORG_TRANSFER_RELEASE

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

2749:
2750: l_plan_type NUMBER :=0;
2751: BEGIN
2752:
2753: l_sql_cur := ' SELECT count(*) from MRP_ORG_TRANSFER_RELEASE'|| l_dblink ||
2754: ' WHERE batch_id = :l_arg_po_batch_number' ;
2755:
2756:
2757: OPEN c_row_count for l_sql_cur USING l_arg_po_batch_number;

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

2767:
2768:
2769: IF p_load_type = DRP_REQ_LOAD THEN
2770:
2771: l_sql_stmt := ' INSERT INTO MRP_ORG_TRANSFER_RELEASE' || l_dblink ||
2772: ' ( batch_id, '||
2773: ' Item_ID, ' ||
2774: ' SRC_Organization_ID, ' ||
2775: ' SR_Instance_ID, ' ||

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

2899:
2900:
2901: ELSE
2902:
2903: l_sql_stmt := ' INSERT INTO MRP_ORG_TRANSFER_RELEASE' || l_dblink ||
2904: ' ( batch_id, '||
2905: ' Item_ID, ' ||
2906: ' SRC_Organization_ID, ' ||
2907: ' SR_Instance_ID, ' ||

Line 3038: update mrp_org_transfer_release motr

3034: END IF;
3035:
3036: END IF;
3037:
3038: update mrp_org_transfer_release motr
3039: set earliest_ship_date = (select max(ms.new_schedule_date)
3040: from msc_supplies ms, msc_single_lvl_peg mslp
3041: where ms.plan_id=l_arg_plan_id
3042: and ms.transaction_id = mslp.child_id

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

3071: set releasable = ' || RELEASE_ATTEMPTED || '
3072: ,batch_id = nvl(batch_id,' ||g_batch_id ||')
3073: where plan_id = ' || l_arg_plan_id || '
3074: and transaction_id in
3075: (select transaction_id from MRP_ORG_TRANSFER_RELEASE' || l_dblink || '
3076: where batch_id = ' || l_arg_po_batch_number || ')';
3077: END IF;
3078:
3079: END POPULATE_ISO_IN_SOURCE;

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

3125: CLOSE c_plan_type;
3126:
3127: IF p_load_type = DRP_REQ_LOAD THEN
3128:
3129: l_sql_stmt := ' INSERT INTO MRP_ORG_TRANSFER_RELEASE' || l_dblink ||
3130: ' ( batch_id, '||
3131: ' Item_ID, ' ||
3132: ' SRC_Organization_ID, ' ||
3133: ' SR_Instance_ID, ' ||

Line 3261: /* update mrp_org_transfer_release motr

3257: END IF;
3258:
3259: END IF;
3260:
3261: /* update mrp_org_transfer_release motr
3262: set earliest_ship_date = (select max(ms.new_schedule_date)
3263: from msc_part_supplies ms, msc_single_lvl_peg mslp
3264: where ms.plan_id=l_arg_plan_id
3265: and ms.transaction_id = mslp.child_id

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

3288: set releasable = ' || RELEASE_ATTEMPTED || ',
3289: batch_id = nvl(batch_id,' ||g_batch_id ||')
3290: where plan_id = ' || l_arg_plan_id || '
3291: and transaction_id in (select orig_transaction_id from msc_part_supplies where transaction_id in
3292: (select transaction_id from MRP_ORG_TRANSFER_RELEASE' || l_dblink || '
3293: where batch_id = ' || l_arg_po_batch_number || '))';
3294:
3295: execute immediate ' update msc_part_supplies
3296: set releasable = ' || RELEASE_ATTEMPTED || ',

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

3296: set releasable = ' || RELEASE_ATTEMPTED || ',
3297: batch_id = nvl(batch_id,' ||g_batch_id ||')
3298: where plan_id = ' || l_arg_plan_id || '
3299: and transaction_id in
3300: (select transaction_id from MRP_ORG_TRANSFER_RELEASE' || l_dblink || '
3301: where batch_id = ' || l_arg_po_batch_number || ')';
3302: END IF;
3303:
3304: END POPULATE_ISO_IN_SOURCE_2;

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

3583: CLOSE c_row_count;
3584: */
3585:
3586: --p_arg_loaded_int_repair_orders:= l_after_row_count -l_before_row_count;
3587: /* 6. call populate_iso_in_source to populate mrp_org_transfer_release_table in the source */
3588:
3589: IF p_arg_loaded_int_repair_orders > 0 THEN
3590:
3591: populate_iso_in_source(l_dblink => p_dblink,

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

3921:
3922: --p_arg_loaded_int_repair_orders:= l_after_row_count -l_before_row_count;
3923:
3924:
3925: /* 6. call POPULATE_ISO_IN_SOURCE_2 to populate mrp_org_transfer_release_table in the source */
3926:
3927: IF p_arg_loaded_int_repair_orders > 0 THEN
3928:
3929: populate_iso_in_source_2(l_dblink => p_dblink,