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_REQUIREMENT_HEADERS_PVT

Line 164: l_rqmt_header_Rec csp_requirement_headers_pvt.requirement_header_rec_type;

160: l_header_rec Header_Rec_Type;
161: l_line_rec Line_rec_type;
162: l_line_tbl Line_Tbl_type;
163:
164: l_rqmt_header_Rec csp_requirement_headers_pvt.requirement_header_rec_type;
165:
166: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;
167: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
168: x_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;

Line 584: CSP_REQUIREMENT_HEADERS_PVT.Create_requirement_headers(

580: WHERE task_id = l_header_rec.task_id;
581: EXCEPTION
582: WHEN NO_DATA_FOUND THEN
583: -- call private api for inserting into csp_Requirement_headers
584: CSP_REQUIREMENT_HEADERS_PVT.Create_requirement_headers(
585: P_Api_Version_Number => l_api_Version_number,
586: P_Init_Msg_List => p_init_msg_list,
587: P_Commit => FND_API.G_FALSE,
588: p_validation_level => null,

Line 616: CSP_REQUIREMENT_HEADERS_PVT.Create_requirement_headers(

612: WHERE requirement_header_id = l_header_rec.requirement_header_id;
613: EXCEPTION
614: WHEN NO_DATA_FOUND THEN
615: -- call private api for inserting into csp_Requirement_headers
616: CSP_REQUIREMENT_HEADERS_PVT.Create_requirement_headers(
617: P_Api_Version_Number => l_api_Version_number,
618: P_Init_Msg_List => p_init_msg_list,
619: P_Commit => FND_API.G_FALSE,
620: p_validation_level => null,

Line 639: CSP_REQUIREMENT_HEADERS_PVT.Create_requirement_headers(

635: END IF;
636: END;
637: ELSE
638: -- call private api for inserting into csp_Requirement_headers
639: CSP_REQUIREMENT_HEADERS_PVT.Create_requirement_headers(
640: P_Api_Version_Number => l_api_Version_number,
641: P_Init_Msg_List => p_init_msg_list,
642: P_Commit => FND_API.G_FALSE,
643: p_validation_level => null,

Line 712: CSP_REQUIREMENT_HEADERS_PVT.Update_requirement_headers(

708: END LOOP;
709:
710: ELSIF (l_header_rec.operation = 'UPDATE') THEN
711: -- call private api for updating requirement headers
712: CSP_REQUIREMENT_HEADERS_PVT.Update_requirement_headers(
713: P_Api_Version_Number => l_api_Version_number,
714: P_Init_Msg_List => p_init_msg_list,
715: P_Commit => FND_API.G_FALSE,
716: p_validation_level => null,

Line 1561: l_rqmt_header_Rec csp_requirement_headers_pvt.requirement_header_rec_type;

1557: l_user_id NUMBER;
1558: l_login_id NUMBER;
1559: l_today DATE;
1560: l_parts_defined VARCHAR2(30);
1561: l_rqmt_header_Rec csp_requirement_headers_pvt.requirement_header_rec_type;
1562: l_rqmt_line_Rec csp_requirement_lines_pvt.requirement_line_rec_type;
1563: l_rqmt_line_Tbl csp_requirement_lines_pvt.requirement_line_tbl_type;
1564: l_rqmt_line_Tbl_out csp_requirement_lines_pvt.requirement_line_tbl_type;
1565: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 1809: CSP_REQUIREMENT_HEADERS_PVT.Create_requirement_headers(

1805: END IF;
1806: EXCEPTION
1807: WHEN NO_DATA_FOUND THEN
1808: -- call private api for inserting into csp_Requirement_headers
1809: CSP_REQUIREMENT_HEADERS_PVT.Create_requirement_headers(
1810: P_Api_Version_Number => l_api_Version_number,
1811: P_Init_Msg_List => p_init_msg_list,
1812: P_Commit => FND_API.G_FALSE,
1813: p_validation_level => null,

Line 1835: CSP_REQUIREMENT_HEADERS_PVT.Create_requirement_headers(

1831: NULL;
1832: END;
1833: ELSE */
1834: -- call private api for inserting into csp_Requirement_headers
1835: CSP_REQUIREMENT_HEADERS_PVT.Create_requirement_headers(
1836: P_Api_Version_Number => l_api_Version_number,
1837: P_Init_Msg_List => p_init_msg_list,
1838: P_Commit => FND_API.G_FALSE,
1839: p_validation_level => null,

Line 1884: CSP_REQUIREMENT_HEADERS_PVT.Update_requirement_headers(

1880: l_rqmt_header_Rec.ship_to_location_id := nvl(l_header_rec.ship_to_location_id, FND_API.G_MISS_NUM);
1881: l_rqmt_header_Rec.task_id := nvl(l_header_rec.task_id, FND_API.G_MISS_NUM);
1882: l_rqmt_header_Rec.need_by_date := nvl(l_header_rec.need_by_date, FND_API.G_MISS_DATE);
1883:
1884: CSP_REQUIREMENT_HEADERS_PVT.Update_requirement_headers(
1885: P_Api_Version_Number => l_api_Version_number,
1886: P_Init_Msg_List => p_init_msg_list,
1887: P_Commit => FND_API.G_FALSE,
1888: p_validation_level => null,

Line 2875: l_requirement_header CSP_Requirement_Headers_PVT.REQUIREMENT_HEADER_Rec_Type;

2871: l_ship_multi_src number;
2872: l_dest_ou number;
2873: l_rs_ou number;
2874: l_module varchar2(100) := 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_UPDATE';
2875: l_requirement_header CSP_Requirement_Headers_PVT.REQUIREMENT_HEADER_Rec_Type;
2876: l_order_number varchar2(100);
2877: l_dest_org_name varchar2(240);
2878:
2879: cursor c_parts_req (v_task_id number, v_task_assignment_id number) is

Line 3693: l_requirement_header := CSP_Requirement_headers_PVT.G_MISS_REQUIREMENT_HEADER_REC;

3689: close get_rs_ou;
3690: if(l_rs_ou <> -999 and l_rs_ou = l_dest_ou) then
3691: for cr in c_parts_req(l_task_id, l_Task_Assignment_id)
3692: loop
3693: l_requirement_header := CSP_Requirement_headers_PVT.G_MISS_REQUIREMENT_HEADER_REC;
3694: l_requirement_header.requirement_header_id := cr.requirement_header_id;
3695: l_requirement_header.last_update_date := sysdate;
3696: l_requirement_header.destination_organization_id := l_organization_id;
3697: l_requirement_header.destination_subinventory := l_subinventory_code;

Line 3705: CSP_Requirement_Headers_PVT.Update_requirement_headers(

3701: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3702: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3703: 'before calling Update_requirement_headers...');
3704: end if;
3705: CSP_Requirement_Headers_PVT.Update_requirement_headers(
3706: P_Api_Version_Number => 1.0,
3707: P_Init_Msg_List => FND_API.G_FALSE,
3708: P_Commit => FND_API.G_FALSE,
3709: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 3843: l_requirement_header := CSP_Requirement_headers_PVT.G_MISS_REQUIREMENT_HEADER_REC;

3839: close get_rs_ou;
3840: if(l_rs_ou <> -999 and l_rs_ou = l_dest_ou) then
3841: for cr in c_parts_req(l_task_id, l_Task_Assignment_id)
3842: loop
3843: l_requirement_header := CSP_Requirement_headers_PVT.G_MISS_REQUIREMENT_HEADER_REC;
3844: l_requirement_header.requirement_header_id := cr.requirement_header_id;
3845: l_requirement_header.last_update_date := sysdate;
3846: l_requirement_header.destination_organization_id := l_organization_id;
3847: l_requirement_header.destination_subinventory := l_subinventory_code;

Line 3855: CSP_Requirement_Headers_PVT.Update_requirement_headers(

3851: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3852: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
3853: 'before calling Update_requirement_headers...');
3854: end if;
3855: CSP_Requirement_Headers_PVT.Update_requirement_headers(
3856: P_Api_Version_Number => 1.0,
3857: P_Init_Msg_List => FND_API.G_FALSE,
3858: P_Commit => FND_API.G_FALSE,
3859: p_validation_level => FND_API.G_VALID_LEVEL_FULL,