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.CSP_PARTS_REQUIREMENT dependencies on CSP_PARTS_REQUIREMENT

Line 1: PACKAGE BODY CSP_PARTS_REQUIREMENT AS

1: PACKAGE BODY CSP_PARTS_REQUIREMENT AS
2: /* $Header: cspvprqb.pls 120.4.12010000.3 2008/11/05 11:52:22 htank ship $ */
3:
4: -- Purpose: Create/Update/Cancel Internal Parts Requirements for Spares
5: --

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'csp_parts_requirement';

7: -- Person Date Comments
8: -- --------- ------ ------------------------------------------
9: -- phegde 05/17/01 Created new package body
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'csp_parts_requirement';
12: G_FILE_NAME CONSTANT VARCHAR2(30) := 'cspvprqb.pls';
13:
14: G_old_resource_id NUMBER; -- variable containing old resource_id; populated in Pre_Update hook
15:

Line 131: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type

127: PROCEDURE process_requirement
128: ( p_api_version IN NUMBER
129: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
130: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
131: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
132: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
133: ,p_create_order_flag IN VARCHAR2
134: ,x_return_status OUT NOCOPY VARCHAR2
135: ,x_msg_count OUT NOCOPY NUMBER

Line 132: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type

128: ( p_api_version IN NUMBER
129: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
130: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
131: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
132: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
133: ,p_create_order_flag IN VARCHAR2
134: ,x_return_status OUT NOCOPY VARCHAR2
135: ,x_msg_count OUT NOCOPY NUMBER
136: ,x_msg_data OUT NOCOPY VARCHAR2

Line 166: l_req_line_details_tbl csp_parts_requirement.Line_detail_Tbl_Type;

162:
163: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;
164: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
165: x_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
166: l_req_line_details_tbl csp_parts_requirement.Line_detail_Tbl_Type;
167: j NUMBER;
168:
169: --Record types and tbl types for finding availability of parts
170: l_parts_list_rec csp_sch_int_pvt.csp_parts_rec_type;

Line 442: l_rqmt_header_Rec.address_type := csp_parts_Requirement.G_ADDR_RESOURCE;

438: l_rqmt_header_Rec.last_update_date := l_today;
439: l_rqmt_header_Rec.last_update_login := nvl(l_login_id, -1);
440: l_rqmt_header_Rec.ship_to_location_id := nvl(l_header_rec.ship_to_location_id, FND_API.G_MISS_NUM);
441: l_rqmt_header_Rec.timezone_id := nvl(l_timezone_id, FND_API.G_MISS_NUM);
442: l_rqmt_header_Rec.address_type := csp_parts_Requirement.G_ADDR_RESOURCE;
443: l_rqmt_header_Rec.task_id := nvl(l_header_rec.task_id, FND_API.G_MISS_NUM);
444: l_rqmt_header_Rec.task_assignment_id := nvl(l_header_rec.task_assignment_id, FND_API.G_MISS_NUM);
445: l_rqmt_header_Rec.shipping_method_code := nvl(l_header_rec.shipping_method_code, FND_API.G_MISS_CHAR);
446: l_rqmt_header_Rec.need_by_date := nvl(l_header_rec.need_by_date, FND_API.G_MISS_DATE);

Line 775: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type

771: PROCEDURE csptrreq_fm_order(
772: p_api_version IN NUMBER
773: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
774: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
775: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
776: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
777: ,x_return_status OUT NOCOPY VARCHAR2
778: ,x_msg_count OUT NOCOPY NUMBER
779: ,x_msg_data OUT NOCOPY VARCHAR2

Line 776: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type

772: p_api_version IN NUMBER
773: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
774: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
775: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
776: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
777: ,x_return_status OUT NOCOPY VARCHAR2
778: ,x_msg_count OUT NOCOPY NUMBER
779: ,x_msg_data OUT NOCOPY VARCHAR2
780: ) IS

Line 1114: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type

1110: PROCEDURE csptrreq_order_res(
1111: p_api_version IN NUMBER
1112: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1113: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1114: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
1115: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
1116: ,x_return_status OUT NOCOPY VARCHAR2
1117: ,x_msg_count OUT NOCOPY NUMBER
1118: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1115: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type

1111: p_api_version IN NUMBER
1112: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1113: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1114: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
1115: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
1116: ,x_return_status OUT NOCOPY VARCHAR2
1117: ,x_msg_count OUT NOCOPY NUMBER
1118: ,x_msg_data OUT NOCOPY VARCHAR2
1119: ) IS

Line 1433: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type

1429: PROCEDURE save_rqmt_line(
1430: p_api_version IN NUMBER
1431: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1432: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1433: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
1434: ,px_line_tbl IN OUT NOCOPY csp_parts_requirement.Line_tbl_type
1435: ,x_return_status OUT NOCOPY VARCHAR2
1436: ,x_msg_count OUT NOCOPY NUMBER
1437: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1434: ,px_line_tbl IN OUT NOCOPY csp_parts_requirement.Line_tbl_type

1430: p_api_version IN NUMBER
1431: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1432: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1433: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
1434: ,px_line_tbl IN OUT NOCOPY csp_parts_requirement.Line_tbl_type
1435: ,x_return_status OUT NOCOPY VARCHAR2
1436: ,x_msg_count OUT NOCOPY NUMBER
1437: ,x_msg_data OUT NOCOPY VARCHAR2
1438: )IS

Line 1441: l_header_rec csp_parts_requirement.Header_rec_type;

1437: ,x_msg_data OUT NOCOPY VARCHAR2
1438: )IS
1439: l_api_version_number CONSTANT NUMBER := 1.0;
1440: l_api_name CONSTANT VARCHAR2(30) := 'save_rqmt_line';
1441: l_header_rec csp_parts_requirement.Header_rec_type;
1442: l_line_tbl csp_parts_requirement.Line_Tbl_type;
1443: l_line_rec Line_rec_type;
1444: l_user_id NUMBER;
1445: l_login_id NUMBER;

Line 1442: l_line_tbl csp_parts_requirement.Line_Tbl_type;

1438: )IS
1439: l_api_version_number CONSTANT NUMBER := 1.0;
1440: l_api_name CONSTANT VARCHAR2(30) := 'save_rqmt_line';
1441: l_header_rec csp_parts_requirement.Header_rec_type;
1442: l_line_tbl csp_parts_requirement.Line_Tbl_type;
1443: l_line_rec Line_rec_type;
1444: l_user_id NUMBER;
1445: l_login_id NUMBER;
1446: l_today DATE;

Line 1923: ,p_line_tbl IN OUT NOCOPY csp_parts_requirement.Rqmt_Line_tbl_type

1919: PROCEDURE delete_rqmt_line(
1920: p_api_version IN NUMBER
1921: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1922: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1923: ,p_line_tbl IN OUT NOCOPY csp_parts_requirement.Rqmt_Line_tbl_type
1924: ,x_return_status OUT NOCOPY VARCHAR2
1925: ,x_msg_count OUT NOCOPY NUMBER
1926: ,x_msg_data OUT NOCOPY VARCHAR2
1927: ) IS

Line 1999: ,x_line_Tbl OUT NOCOPY csp_parts_requirement.Line_tbl_type

1995: p_api_version IN NUMBER
1996: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1997: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1998: ,p_header_id IN NUMBER
1999: ,x_line_Tbl OUT NOCOPY csp_parts_requirement.Line_tbl_type
2000: ,x_avail_flag OUT NOCOPY VARCHAR2
2001: ,x_return_status OUT NOCOPY VARCHAR2
2002: ,x_msg_count OUT NOCOPY NUMBER
2003: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2008: l_header_rec csp_parts_requirement.Header_rec_type;

2004: )IS
2005: l_api_version_number CONSTANT NUMBER := 1.0;
2006: l_api_name CONSTANT VARCHAR2(30) := 'check_availability';
2007: l_count NUMBER;
2008: l_header_rec csp_parts_requirement.Header_rec_type;
2009: l_line_rec csp_parts_requirement.line_rec_type;
2010: l_line_tbl csp_parts_Requirement.line_Tbl_type;
2011: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
2012: EXCP_USER_DEFINED EXCEPTION;

Line 2009: l_line_rec csp_parts_requirement.line_rec_type;

2005: l_api_version_number CONSTANT NUMBER := 1.0;
2006: l_api_name CONSTANT VARCHAR2(30) := 'check_availability';
2007: l_count NUMBER;
2008: l_header_rec csp_parts_requirement.Header_rec_type;
2009: l_line_rec csp_parts_requirement.line_rec_type;
2010: l_line_tbl csp_parts_Requirement.line_Tbl_type;
2011: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
2012: EXCP_USER_DEFINED EXCEPTION;
2013: l_parts_list_rec csp_sch_int_pvt.csp_parts_rec_type;

Line 2010: l_line_tbl csp_parts_Requirement.line_Tbl_type;

2006: l_api_name CONSTANT VARCHAR2(30) := 'check_availability';
2007: l_count NUMBER;
2008: l_header_rec csp_parts_requirement.Header_rec_type;
2009: l_line_rec csp_parts_requirement.line_rec_type;
2010: l_line_tbl csp_parts_Requirement.line_Tbl_type;
2011: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
2012: EXCP_USER_DEFINED EXCEPTION;
2013: l_parts_list_rec csp_sch_int_pvt.csp_parts_rec_type;
2014: l_parts_list_tbl csp_sch_int_pvt.csp_parts_tbl_typ1;

Line 2259: l_header_rec csp_parts_requirement.Header_rec_type;

2255: )IS
2256: l_api_version_number CONSTANT NUMBER := 1.0;
2257: l_api_name CONSTANT VARCHAR2(30) := 'create_order';
2258: l_count NUMBER;
2259: l_header_rec csp_parts_requirement.Header_rec_type;
2260: l_line_rec csp_parts_requirement.line_rec_type;
2261: l_line_tbl csp_parts_Requirement.line_Tbl_type;
2262: l_oe_line_tbl csp_parts_requirement.line_Tbl_Type;
2263: l_po_line_Tbl csp_parts_requirement.line_tbl_type;

Line 2260: l_line_rec csp_parts_requirement.line_rec_type;

2256: l_api_version_number CONSTANT NUMBER := 1.0;
2257: l_api_name CONSTANT VARCHAR2(30) := 'create_order';
2258: l_count NUMBER;
2259: l_header_rec csp_parts_requirement.Header_rec_type;
2260: l_line_rec csp_parts_requirement.line_rec_type;
2261: l_line_tbl csp_parts_Requirement.line_Tbl_type;
2262: l_oe_line_tbl csp_parts_requirement.line_Tbl_Type;
2263: l_po_line_Tbl csp_parts_requirement.line_tbl_type;
2264: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;

Line 2261: l_line_tbl csp_parts_Requirement.line_Tbl_type;

2257: l_api_name CONSTANT VARCHAR2(30) := 'create_order';
2258: l_count NUMBER;
2259: l_header_rec csp_parts_requirement.Header_rec_type;
2260: l_line_rec csp_parts_requirement.line_rec_type;
2261: l_line_tbl csp_parts_Requirement.line_Tbl_type;
2262: l_oe_line_tbl csp_parts_requirement.line_Tbl_Type;
2263: l_po_line_Tbl csp_parts_requirement.line_tbl_type;
2264: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
2265: EXCP_USER_DEFINED EXCEPTION;

Line 2262: l_oe_line_tbl csp_parts_requirement.line_Tbl_Type;

2258: l_count NUMBER;
2259: l_header_rec csp_parts_requirement.Header_rec_type;
2260: l_line_rec csp_parts_requirement.line_rec_type;
2261: l_line_tbl csp_parts_Requirement.line_Tbl_type;
2262: l_oe_line_tbl csp_parts_requirement.line_Tbl_Type;
2263: l_po_line_Tbl csp_parts_requirement.line_tbl_type;
2264: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
2265: EXCP_USER_DEFINED EXCEPTION;
2266: I NUMBER;

Line 2263: l_po_line_Tbl csp_parts_requirement.line_tbl_type;

2259: l_header_rec csp_parts_requirement.Header_rec_type;
2260: l_line_rec csp_parts_requirement.line_rec_type;
2261: l_line_tbl csp_parts_Requirement.line_Tbl_type;
2262: l_oe_line_tbl csp_parts_requirement.line_Tbl_Type;
2263: l_po_line_Tbl csp_parts_requirement.line_tbl_type;
2264: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
2265: EXCP_USER_DEFINED EXCEPTION;
2266: I NUMBER;
2267: J NUMBER;

Line 2298: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',

2294: BEGIN
2295:
2296: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2297: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2298: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2299: 'Begin');
2300: end if;
2301:
2302: SAVEPOINT create_order_PUB;

Line 2328: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',

2324: l_login_id := fnd_global.login_id;
2325:
2326: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2327: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2328: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2329: 'l_user_id = ' || l_user_id
2330: || ', l_login_id = ' || l_login_id);
2331: end if;
2332:

Line 2344: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',

2340: and crld.source_id is null;
2341:
2342: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2343: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2344: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2345: 'p_header_id is NOT NULL and number of lines for this requirement is = ' || l_count);
2346: end if;
2347:
2348: IF (l_count > 0) THEN

Line 2371: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',

2367: l_header_Rec.operation := G_OPR_CREATE;
2368:
2369: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2370: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2371: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2372: 'Part Req Header Data... '
2373: || 'l_header_rec.requirement_header_id = ' || l_header_rec.requirement_header_id
2374: || ', l_header_rec.order_type_id = ' || l_header_rec.order_type_id
2375: || ', l_header_Rec.ship_to_location_id = ' || l_header_Rec.ship_to_location_id

Line 2408: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',

2404: l_line_rec.arrival_Date ;
2405:
2406: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2407: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2408: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2409: 'Part Req Line Data... '
2410: || 'l_line_rec.requirement_line_id = ' || l_line_rec.requirement_line_id
2411: || ', l_line_rec.inventory_item_id = ' || l_line_rec.inventory_item_id
2412: || ', l_line_Rec.revision = ' || l_line_Rec.revision

Line 2443: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',

2439:
2440: IF (l_oe_line_tbl.COUNT > 0) THEN
2441: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2442: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2443: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2444: 'Calling csp_parts_order.process_order...');
2445: end if;
2446: csp_parts_order.process_order(
2447: p_api_version => l_api_version_number

Line 2458: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',

2454: ,x_msg_data => l_msg_data
2455: );
2456: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2457: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2458: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2459: 'csp_parts_order.process_order return status = ' || l_return_status);
2460: end if;
2461:
2462: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2484: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',

2480: WHERE header_id = l_header_Rec.order_header_id;
2481:
2482: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2483: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2484: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2485: 'l_order_number = ' || l_order_number);
2486: end if;
2487: EXCEPTION
2488: when no_data_found then

Line 2491: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',

2487: EXCEPTION
2488: when no_data_found then
2489: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2490: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2491: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2492: 'No Data Found for l_header_rec.order_header_id = '
2493: || l_header_rec.order_header_id || ' in OE_ORDER_HEADERS_ALL');
2494: end if;
2495: null;

Line 2585: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',

2581: END IF;
2582: END If;
2583: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2584: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2585: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2586: 'Returning from csp.plsql.CSP_PARTS_REQUIREMENT.create_order with return status = '
2587: || x_return_status);
2588: end if;
2589: EXCEPTION

Line 2586: 'Returning from csp.plsql.CSP_PARTS_REQUIREMENT.create_order with return status = '

2582: END If;
2583: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2584: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2585: 'csp.plsql.CSP_PARTS_REQUIREMENT.create_order',
2586: 'Returning from csp.plsql.CSP_PARTS_REQUIREMENT.create_order with return status = '
2587: || x_return_status);
2588: end if;
2589: EXCEPTION
2590: WHEN EXCP_USER_DEFINED THEN