eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_OSS_SOURCE_PK dependencies on MRP_SOURCING_RULE_PUB

Line 2126: l_sourcing_rule_rec MRP_SOURCING_RULE_PUB.sourcing_rule_rec_type;

2122: rcv_count Number;
2123: asg_count Number :=1;
2124: l_make_at_exists Varchar2(1);
2125:
2126: l_sourcing_rule_rec MRP_SOURCING_RULE_PUB.sourcing_rule_rec_type;
2127: l_sourcing_rule_val_rec MRP_SOURCING_RULE_PUB.sourcing_rule_val_rec_type;
2128: l_receiving_org_tbl MRP_SOURCING_RULE_PUB.receiving_org_tbl_type;
2129: l_receiving_org_val_tbl MRP_SOURCING_RULE_PUB.receiving_org_val_tbl_type;
2130: l_shipping_org_tbl MRP_SOURCING_RULE_PUB.shipping_org_tbl_type;

Line 2127: l_sourcing_rule_val_rec MRP_SOURCING_RULE_PUB.sourcing_rule_val_rec_type;

2123: asg_count Number :=1;
2124: l_make_at_exists Varchar2(1);
2125:
2126: l_sourcing_rule_rec MRP_SOURCING_RULE_PUB.sourcing_rule_rec_type;
2127: l_sourcing_rule_val_rec MRP_SOURCING_RULE_PUB.sourcing_rule_val_rec_type;
2128: l_receiving_org_tbl MRP_SOURCING_RULE_PUB.receiving_org_tbl_type;
2129: l_receiving_org_val_tbl MRP_SOURCING_RULE_PUB.receiving_org_val_tbl_type;
2130: l_shipping_org_tbl MRP_SOURCING_RULE_PUB.shipping_org_tbl_type;
2131: l_shipping_org_val_tbl MRP_SOURCING_RULE_PUB.shipping_org_val_tbl_type;

Line 2128: l_receiving_org_tbl MRP_SOURCING_RULE_PUB.receiving_org_tbl_type;

2124: l_make_at_exists Varchar2(1);
2125:
2126: l_sourcing_rule_rec MRP_SOURCING_RULE_PUB.sourcing_rule_rec_type;
2127: l_sourcing_rule_val_rec MRP_SOURCING_RULE_PUB.sourcing_rule_val_rec_type;
2128: l_receiving_org_tbl MRP_SOURCING_RULE_PUB.receiving_org_tbl_type;
2129: l_receiving_org_val_tbl MRP_SOURCING_RULE_PUB.receiving_org_val_tbl_type;
2130: l_shipping_org_tbl MRP_SOURCING_RULE_PUB.shipping_org_tbl_type;
2131: l_shipping_org_val_tbl MRP_SOURCING_RULE_PUB.shipping_org_val_tbl_type;
2132: x_sourcing_rule_rec MRP_SOURCING_RULE_PUB.sourcing_rule_rec_type;

Line 2129: l_receiving_org_val_tbl MRP_SOURCING_RULE_PUB.receiving_org_val_tbl_type;

2125:
2126: l_sourcing_rule_rec MRP_SOURCING_RULE_PUB.sourcing_rule_rec_type;
2127: l_sourcing_rule_val_rec MRP_SOURCING_RULE_PUB.sourcing_rule_val_rec_type;
2128: l_receiving_org_tbl MRP_SOURCING_RULE_PUB.receiving_org_tbl_type;
2129: l_receiving_org_val_tbl MRP_SOURCING_RULE_PUB.receiving_org_val_tbl_type;
2130: l_shipping_org_tbl MRP_SOURCING_RULE_PUB.shipping_org_tbl_type;
2131: l_shipping_org_val_tbl MRP_SOURCING_RULE_PUB.shipping_org_val_tbl_type;
2132: x_sourcing_rule_rec MRP_SOURCING_RULE_PUB.sourcing_rule_rec_type;
2133: x_sourcing_rule_val_rec MRP_SOURCING_RULE_PUB.sourcing_rule_val_rec_type;

Line 2130: l_shipping_org_tbl MRP_SOURCING_RULE_PUB.shipping_org_tbl_type;

2126: l_sourcing_rule_rec MRP_SOURCING_RULE_PUB.sourcing_rule_rec_type;
2127: l_sourcing_rule_val_rec MRP_SOURCING_RULE_PUB.sourcing_rule_val_rec_type;
2128: l_receiving_org_tbl MRP_SOURCING_RULE_PUB.receiving_org_tbl_type;
2129: l_receiving_org_val_tbl MRP_SOURCING_RULE_PUB.receiving_org_val_tbl_type;
2130: l_shipping_org_tbl MRP_SOURCING_RULE_PUB.shipping_org_tbl_type;
2131: l_shipping_org_val_tbl MRP_SOURCING_RULE_PUB.shipping_org_val_tbl_type;
2132: x_sourcing_rule_rec MRP_SOURCING_RULE_PUB.sourcing_rule_rec_type;
2133: x_sourcing_rule_val_rec MRP_SOURCING_RULE_PUB.sourcing_rule_val_rec_type;
2134: x_receiving_org_tbl MRP_SOURCING_RULE_PUB.receiving_org_tbl_type;

Line 2131: l_shipping_org_val_tbl MRP_SOURCING_RULE_PUB.shipping_org_val_tbl_type;

2127: l_sourcing_rule_val_rec MRP_SOURCING_RULE_PUB.sourcing_rule_val_rec_type;
2128: l_receiving_org_tbl MRP_SOURCING_RULE_PUB.receiving_org_tbl_type;
2129: l_receiving_org_val_tbl MRP_SOURCING_RULE_PUB.receiving_org_val_tbl_type;
2130: l_shipping_org_tbl MRP_SOURCING_RULE_PUB.shipping_org_tbl_type;
2131: l_shipping_org_val_tbl MRP_SOURCING_RULE_PUB.shipping_org_val_tbl_type;
2132: x_sourcing_rule_rec MRP_SOURCING_RULE_PUB.sourcing_rule_rec_type;
2133: x_sourcing_rule_val_rec MRP_SOURCING_RULE_PUB.sourcing_rule_val_rec_type;
2134: x_receiving_org_tbl MRP_SOURCING_RULE_PUB.receiving_org_tbl_type;
2135: x_receiving_org_val_tbl MRP_SOURCING_RULE_PUB.receiving_org_val_tbl_type;

Line 2132: x_sourcing_rule_rec MRP_SOURCING_RULE_PUB.sourcing_rule_rec_type;

2128: l_receiving_org_tbl MRP_SOURCING_RULE_PUB.receiving_org_tbl_type;
2129: l_receiving_org_val_tbl MRP_SOURCING_RULE_PUB.receiving_org_val_tbl_type;
2130: l_shipping_org_tbl MRP_SOURCING_RULE_PUB.shipping_org_tbl_type;
2131: l_shipping_org_val_tbl MRP_SOURCING_RULE_PUB.shipping_org_val_tbl_type;
2132: x_sourcing_rule_rec MRP_SOURCING_RULE_PUB.sourcing_rule_rec_type;
2133: x_sourcing_rule_val_rec MRP_SOURCING_RULE_PUB.sourcing_rule_val_rec_type;
2134: x_receiving_org_tbl MRP_SOURCING_RULE_PUB.receiving_org_tbl_type;
2135: x_receiving_org_val_tbl MRP_SOURCING_RULE_PUB.receiving_org_val_tbl_type;
2136: x_shipping_org_tbl MRP_SOURCING_RULE_PUB.shipping_org_tbl_type;

Line 2133: x_sourcing_rule_val_rec MRP_SOURCING_RULE_PUB.sourcing_rule_val_rec_type;

2129: l_receiving_org_val_tbl MRP_SOURCING_RULE_PUB.receiving_org_val_tbl_type;
2130: l_shipping_org_tbl MRP_SOURCING_RULE_PUB.shipping_org_tbl_type;
2131: l_shipping_org_val_tbl MRP_SOURCING_RULE_PUB.shipping_org_val_tbl_type;
2132: x_sourcing_rule_rec MRP_SOURCING_RULE_PUB.sourcing_rule_rec_type;
2133: x_sourcing_rule_val_rec MRP_SOURCING_RULE_PUB.sourcing_rule_val_rec_type;
2134: x_receiving_org_tbl MRP_SOURCING_RULE_PUB.receiving_org_tbl_type;
2135: x_receiving_org_val_tbl MRP_SOURCING_RULE_PUB.receiving_org_val_tbl_type;
2136: x_shipping_org_tbl MRP_SOURCING_RULE_PUB.shipping_org_tbl_type;
2137: x_shipping_org_val_tbl MRP_SOURCING_RULE_PUB.shipping_org_val_tbl_type;

Line 2134: x_receiving_org_tbl MRP_SOURCING_RULE_PUB.receiving_org_tbl_type;

2130: l_shipping_org_tbl MRP_SOURCING_RULE_PUB.shipping_org_tbl_type;
2131: l_shipping_org_val_tbl MRP_SOURCING_RULE_PUB.shipping_org_val_tbl_type;
2132: x_sourcing_rule_rec MRP_SOURCING_RULE_PUB.sourcing_rule_rec_type;
2133: x_sourcing_rule_val_rec MRP_SOURCING_RULE_PUB.sourcing_rule_val_rec_type;
2134: x_receiving_org_tbl MRP_SOURCING_RULE_PUB.receiving_org_tbl_type;
2135: x_receiving_org_val_tbl MRP_SOURCING_RULE_PUB.receiving_org_val_tbl_type;
2136: x_shipping_org_tbl MRP_SOURCING_RULE_PUB.shipping_org_tbl_type;
2137: x_shipping_org_val_tbl MRP_SOURCING_RULE_PUB.shipping_org_val_tbl_type;
2138:

Line 2135: x_receiving_org_val_tbl MRP_SOURCING_RULE_PUB.receiving_org_val_tbl_type;

2131: l_shipping_org_val_tbl MRP_SOURCING_RULE_PUB.shipping_org_val_tbl_type;
2132: x_sourcing_rule_rec MRP_SOURCING_RULE_PUB.sourcing_rule_rec_type;
2133: x_sourcing_rule_val_rec MRP_SOURCING_RULE_PUB.sourcing_rule_val_rec_type;
2134: x_receiving_org_tbl MRP_SOURCING_RULE_PUB.receiving_org_tbl_type;
2135: x_receiving_org_val_tbl MRP_SOURCING_RULE_PUB.receiving_org_val_tbl_type;
2136: x_shipping_org_tbl MRP_SOURCING_RULE_PUB.shipping_org_tbl_type;
2137: x_shipping_org_val_tbl MRP_SOURCING_RULE_PUB.shipping_org_val_tbl_type;
2138:
2139:

Line 2136: x_shipping_org_tbl MRP_SOURCING_RULE_PUB.shipping_org_tbl_type;

2132: x_sourcing_rule_rec MRP_SOURCING_RULE_PUB.sourcing_rule_rec_type;
2133: x_sourcing_rule_val_rec MRP_SOURCING_RULE_PUB.sourcing_rule_val_rec_type;
2134: x_receiving_org_tbl MRP_SOURCING_RULE_PUB.receiving_org_tbl_type;
2135: x_receiving_org_val_tbl MRP_SOURCING_RULE_PUB.receiving_org_val_tbl_type;
2136: x_shipping_org_tbl MRP_SOURCING_RULE_PUB.shipping_org_tbl_type;
2137: x_shipping_org_val_tbl MRP_SOURCING_RULE_PUB.shipping_org_val_tbl_type;
2138:
2139:
2140: /* This is for Assignment processing

Line 2137: x_shipping_org_val_tbl MRP_SOURCING_RULE_PUB.shipping_org_val_tbl_type;

2133: x_sourcing_rule_val_rec MRP_SOURCING_RULE_PUB.sourcing_rule_val_rec_type;
2134: x_receiving_org_tbl MRP_SOURCING_RULE_PUB.receiving_org_tbl_type;
2135: x_receiving_org_val_tbl MRP_SOURCING_RULE_PUB.receiving_org_val_tbl_type;
2136: x_shipping_org_tbl MRP_SOURCING_RULE_PUB.shipping_org_tbl_type;
2137: x_shipping_org_val_tbl MRP_SOURCING_RULE_PUB.shipping_org_val_tbl_type;
2138:
2139:
2140: /* This is for Assignment processing
2141: */

Line 2346: MRP_SOURCING_RULE_PUB.PROCESS_SOURCING_RULE(

2342: */
2343:
2344: If l_cur_assg_id is not null then
2345: l_stmt_num := 100;
2346: MRP_SOURCING_RULE_PUB.PROCESS_SOURCING_RULE(
2347: p_api_version_number => 1.0,
2348: p_return_values => FND_API.G_TRUE,
2349: p_sourcing_rule_rec => l_sourcing_rule_rec,
2350: p_sourcing_rule_val_rec => l_sourcing_rule_val_rec,

Line 2468: l_sourcing_rule_rec := MRP_SOURCING_RULE_PUB.G_MISS_SOURCING_RULE_REC;

2464: rule record type
2465: */
2466: l_stmt_num := 130;
2467:
2468: l_sourcing_rule_rec := MRP_SOURCING_RULE_PUB.G_MISS_SOURCING_RULE_REC;
2469: select attribute1,
2470: attribute2,
2471: attribute3,
2472: attribute4,

Line 2576: -- l_receiving_org_tbl := MRP_SOURCING_RULE_PUB.G_MISS_RECEIVING_ORG_TBL;

2572: IF l_sr_receipt_id_cache_tbl.EXISTS(source_tree_rec.sr_receipt_id) = FALSE THEN
2573:
2574: sr_receipt_id_cachedloc := NULL;
2575:
2576: -- l_receiving_org_tbl := MRP_SOURCING_RULE_PUB.G_MISS_RECEIVING_ORG_TBL;
2577: -- l_receiving_org_val_tbl:= MRP_SOURCING_RULE_PUB.G_MISS_RECEIVING_ORG_VAL_TBL;
2578: -- l_shipping_org_tbl := MRP_SOURCING_RULE_PUB.G_MISS_SHIPPING_ORG_TBL;
2579: -- l_shipping_org_val_tbl := MRP_SOURCING_RULE_PUB.G_MISS_SHIPPING_ORG_VAL_TBL;
2580: -- rcv_count := 1;

Line 2577: -- l_receiving_org_val_tbl:= MRP_SOURCING_RULE_PUB.G_MISS_RECEIVING_ORG_VAL_TBL;

2573:
2574: sr_receipt_id_cachedloc := NULL;
2575:
2576: -- l_receiving_org_tbl := MRP_SOURCING_RULE_PUB.G_MISS_RECEIVING_ORG_TBL;
2577: -- l_receiving_org_val_tbl:= MRP_SOURCING_RULE_PUB.G_MISS_RECEIVING_ORG_VAL_TBL;
2578: -- l_shipping_org_tbl := MRP_SOURCING_RULE_PUB.G_MISS_SHIPPING_ORG_TBL;
2579: -- l_shipping_org_val_tbl := MRP_SOURCING_RULE_PUB.G_MISS_SHIPPING_ORG_VAL_TBL;
2580: -- rcv_count := 1;
2581: select attribute1,

Line 2578: -- l_shipping_org_tbl := MRP_SOURCING_RULE_PUB.G_MISS_SHIPPING_ORG_TBL;

2574: sr_receipt_id_cachedloc := NULL;
2575:
2576: -- l_receiving_org_tbl := MRP_SOURCING_RULE_PUB.G_MISS_RECEIVING_ORG_TBL;
2577: -- l_receiving_org_val_tbl:= MRP_SOURCING_RULE_PUB.G_MISS_RECEIVING_ORG_VAL_TBL;
2578: -- l_shipping_org_tbl := MRP_SOURCING_RULE_PUB.G_MISS_SHIPPING_ORG_TBL;
2579: -- l_shipping_org_val_tbl := MRP_SOURCING_RULE_PUB.G_MISS_SHIPPING_ORG_VAL_TBL;
2580: -- rcv_count := 1;
2581: select attribute1,
2582: attribute2,

Line 2579: -- l_shipping_org_val_tbl := MRP_SOURCING_RULE_PUB.G_MISS_SHIPPING_ORG_VAL_TBL;

2575:
2576: -- l_receiving_org_tbl := MRP_SOURCING_RULE_PUB.G_MISS_RECEIVING_ORG_TBL;
2577: -- l_receiving_org_val_tbl:= MRP_SOURCING_RULE_PUB.G_MISS_RECEIVING_ORG_VAL_TBL;
2578: -- l_shipping_org_tbl := MRP_SOURCING_RULE_PUB.G_MISS_SHIPPING_ORG_TBL;
2579: -- l_shipping_org_val_tbl := MRP_SOURCING_RULE_PUB.G_MISS_SHIPPING_ORG_VAL_TBL;
2580: -- rcv_count := 1;
2581: select attribute1,
2582: attribute2,
2583: attribute3,

Line 2918: MRP_SOURCING_RULE_PUB.PROCESS_SOURCING_RULE(

2914:
2915: oe_debug_pub.add(lpad(' ',g_pg_level)||'~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~');
2916: END If;
2917:
2918: MRP_SOURCING_RULE_PUB.PROCESS_SOURCING_RULE(
2919: p_api_version_number => 1.0,
2920: p_return_values => FND_API.G_TRUE,
2921: p_sourcing_rule_rec => l_sourcing_rule_rec,
2922: p_sourcing_rule_val_rec => l_sourcing_rule_val_rec,

Line 2998: l_sourcing_rule_rec := MRP_SOURCING_RULE_PUB.G_MISS_SOURCING_RULE_REC;

2994:
2995: oe_debug_pub.add('Inside make at rule loop ',5);
2996: l_stmt_num := 210;
2997:
2998: l_sourcing_rule_rec := MRP_SOURCING_RULE_PUB.G_MISS_SOURCING_RULE_REC;
2999: l_sourcing_rule_rec.organization_id := oss_make_orgs.rcv_org_id;
3000: l_sourcing_rule_rec.status := 1;
3001: l_sourcing_rule_rec.planning_active := 1;
3002: select 'CTO*'||bom_cto_oss_source_rule_s1.nextval

Line 3042: MRP_SOURCING_RULE_PUB.PROCESS_SOURCING_RULE(

3038:
3039:
3040: l_stmt_num := 220;
3041:
3042: MRP_SOURCING_RULE_PUB.PROCESS_SOURCING_RULE(
3043: p_api_version_number => 1.0,
3044: p_return_values => FND_API.G_TRUE,
3045: p_commit => FND_API.G_FALSE,
3046: p_sourcing_rule_rec => l_sourcing_rule_rec,