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

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 422: from csp_requirement_headers

418: ELSE
419: BEGIN
420: select requirement_header_id
421: into l_check_existence
422: from csp_requirement_headers
423: where requirement_header_id = l_header_rec.requirement_header_id;
424: EXCEPTION
425: WHEN NO_DATA_FOUND THEN
426: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_HEADER');

Line 435: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_HEADERS', FALSE);

431: WHEN OTHERS THEN
432: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
433: fnd_message.set_token('ERR_FIELD', 'l_header_rec.requirement_header_id', FALSE);
434: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
435: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_HEADERS', FALSE);
436: FND_MSG_PUB.ADD;
437: RAISE EXCP_USER_DEFINED;
438: END;
439: END IF;

Line 579: FROM csp_requirement_headers

575: l_header_rec.requirement_header_id IS NULL) THEN
576: BEGIN
577: SELECT requirement_header_id
578: INTO l_requirement_header_id
579: FROM csp_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

Line 583: -- call private api for inserting into csp_Requirement_headers

579: FROM csp_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,

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 611: FROM csp_requirement_headers

607: ELSIF (l_header_rec.requirement_header_id IS NOT NULL) THEN
608: BEGIN
609: SELECT requirement_header_id
610: INTO l_requirement_header_id
611: FROM csp_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

Line 615: -- call private api for inserting into csp_Requirement_headers

611: FROM csp_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,

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 638: -- call private api for inserting into csp_Requirement_headers

634: END IF;
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,

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 834: FROM csp_requirement_headers crh,

830:
831: CURSOR rs_info_cur(p_rqmt_header_id NUMBER) IS
832: SELECT cla.organization_id,
833: cla.subinventory_code
834: FROM csp_requirement_headers crh,
835: jtf_task_assignments jta,
836: csp_INV_LOC_ASSIGNMENTS cla
837: WHERE cla.default_code = 'IN'
838: AND cla.resource_type = decode(crh.task_assignment_id,null,crh.resource_type,jta.resource_type_code)

Line 1495: DELETE FROM csp_requirement_headers

1491: ELSE
1492: DELETE FROM csp_requirement_lines
1493: WHERE requirement_header_id = p_header_id;
1494:
1495: DELETE FROM csp_requirement_headers
1496: WHERE requirement_header_id = p_header_id;
1497: END IF;
1498:
1499: IF fnd_api.to_boolean(p_commit) THEN

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 1792: FROM csp_requirement_headers

1788: IF (l_header_rec.task_id IS NOT NULL) THEN
1789: BEGIN
1790: SELECT requirement_header_id
1791: INTO l_requirement_header_id
1792: FROM csp_requirement_headers
1793: WHERE task_id = l_header_rec.task_id;
1794:
1795: IF (l_requirement_header_id IS NOT NULL) THEN
1796: Rollback to save_rqmt_line_PUB;

Line 1808: -- call private api for inserting into csp_Requirement_headers

1804: return;
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,

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 1834: -- call private api for inserting into csp_Requirement_headers

1830: WHEN OTHERS THEN
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,

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 1859: from csp_requirement_headers

1855: -- check to see if requirement_header_id is valid
1856: BEGIN
1857: select requirement_header_id
1858: into l_check_existence
1859: from csp_requirement_headers
1860: where requirement_header_id = l_header_rec.requirement_header_id;
1861: EXCEPTION
1862: WHEN NO_DATA_FOUND THEN
1863: fnd_message.set_name('CSP', 'CSP_INVALID_REQUIREMENT_HEADER');

Line 1871: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_HEADERS', FALSE);

1867: WHEN OTHERS THEN
1868: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1869: fnd_message.set_token('ERR_FIELD', 'l_header_rec.requirement_header_id', FALSE);
1870: fnd_message.set_token('ROUTINE', G_PKG_NAME||'.'||l_api_name, FALSE);
1871: fnd_message.set_token('TABLE', 'CSP_REQUIREMENT_HEADERS', FALSE);
1872: FND_MSG_PUB.ADD;
1873: RAISE EXCP_USER_DEFINED;
1874: END;
1875:

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 2190: FROM csp_Requirement_headers

2186: l_header_rec.requirement_header_id,
2187: l_header_rec.need_by_Date,
2188: l_header_rec.dest_organization_id,
2189: l_header_rec.dest_subinventory
2190: FROM csp_Requirement_headers
2191: WHERE requirement_header_id = p_header_id;
2192:
2193: EXCEPTION
2194: WHEN no_data_found THEN

Line 2484: FROM csp_Requirement_headers

2480: l_header_Rec.ship_to_location_id,
2481: l_header_rec.need_by_Date,
2482: l_header_rec.dest_organization_id,
2483: l_header_rec.dest_subinventory
2484: FROM csp_Requirement_headers
2485: WHERE requirement_header_id = p_header_id;
2486:
2487: l_header_Rec.operation := G_OPR_CREATE;
2488:

Line 2588: update csp_requirement_headers

2584: ELSE
2585: -- update open_requirement_flag on requirement header
2586: BEGIN
2587: l_open_requirement := 'S';
2588: update csp_requirement_headers
2589: set open_requirement = 'S'
2590: where requirement_header_id = p_header_id;
2591: EXCEPTION
2592: when others then

Line 2666: update csp_requirement_headers

2662: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2663: RAISE FND_API.G_EXC_ERROR;
2664: ELSE
2665: IF (nvl(l_open_requirement, 'W') <> 'S') THEN
2666: update csp_requirement_headers
2667: set open_requirement = 'S'
2668: where requirement_header_id = p_header_id;
2669: END IF;
2670:

Line 2758: FROM csp_requirement_headers

2754: l_subinventory_code VARCHAR2(30);
2755:
2756: CURSOR get_rqmt_Header IS
2757: SELECT requirement_header_id, address_type, destination_organization_id, destination_subinventory
2758: FROM csp_requirement_headers
2759: WHERE task_assignment_id = l_Task_Assignment_id;
2760:
2761: CURSOR get_resource_location IS
2762: SELECT csp.ship_to_location_id

Line 2815: csp_requirement_headers head,

2811:
2812: CURSOR check_IO_booked IS
2813: select head.requirement_header_id, count(dtl.source_type)
2814: from
2815: csp_requirement_headers head,
2816: csp_requirement_lines line,
2817: csp_req_line_details dtl,
2818: oe_order_lines_all oel
2819: where

Line 2831: csp_requirement_headers head,

2827:
2828: CURSOR get_req_line_dtl(v_req_header_id number) is
2829: select dtl.req_line_detail_id, dtl.source_id, dtl.source_type
2830: from
2831: csp_requirement_headers head,
2832: csp_requirement_lines line,
2833: csp_req_line_details dtl
2834: where
2835: head.requirement_header_id = v_req_header_id

Line 2847: csp_requirement_headers ch,

2843:
2844: cursor get_order_header_id is
2845: SELECT oel.header_id
2846: FROM jtf_task_assignments jta,
2847: csp_requirement_headers ch,
2848: csp_requirement_lines cl,
2849: csp_req_line_details cld,
2850: oe_order_lines_all oel
2851: WHERE jta.task_assignment_id = l_task_assignment_id

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 2881: from csp_requirement_headers

2877: l_dest_org_name varchar2(240);
2878:
2879: cursor c_parts_req (v_task_id number, v_task_assignment_id number) is
2880: select requirement_header_id
2881: from csp_requirement_headers
2882: where task_id = v_task_id
2883: and task_assignment_id = v_task_assignment_id;
2884:
2885: cursor get_rs_ou(v_rs_type varchar2, v_rs_id number) is

Line 2896: FROM csp_requirement_headers h,

2892:
2893: cursor get_non_src_req is
2894: SELECT h.requirement_header_id,
2895: h.address_type
2896: FROM csp_requirement_headers h,
2897: csp_requirement_lines l
2898: WHERE h.task_id = l_task_id
2899: AND h.task_assignment_id = l_task_assignment_id
2900: AND l.requirement_header_id = h.requirement_header_id

Line 2941: FROM csp_requirement_headers h,

2937:
2938: l_oth_req_line := 0;
2939: SELECT COUNT(l.requirement_line_id)
2940: INTO l_oth_req_line
2941: FROM csp_requirement_headers h,
2942: csp_requirement_lines l
2943: WHERE h.task_id = l_task_id
2944: AND h.task_assignment_id = l_task_assignment_id
2945: AND h.requirement_header_id = l.requirement_header_id;

Line 3162: UPDATE csp_requirement_headers

3158:
3159: end loop;
3160: close get_req_line_dtl;
3161:
3162: UPDATE csp_requirement_headers
3163: SET task_assignment_id = l_task_assignment_id,
3164: ship_to_location_id = decode(l_ship_to_type, 'C', ship_to_location_id, 'T', ship_to_location_id, l_ship_to_location_id),
3165: destination_organization_id = l_organization_id,
3166: destination_subinventory = l_subinventory_code,

Line 3183: UPDATE csp_requirement_headers

3179: fetch get_non_src_req into l_rqmt_header_id, l_ship_to_type;
3180: close get_non_src_req;
3181:
3182: if l_rqmt_header_id <> 0 then
3183: UPDATE csp_requirement_headers
3184: SET task_assignment_id = l_task_assignment_id,
3185: ship_to_location_id = decode(l_ship_to_type, 'C', ship_to_location_id, 'T', ship_to_location_id, l_ship_to_location_id),
3186: destination_organization_id = l_organization_id,
3187: destination_subinventory = l_subinventory_code,

Line 3213: FROM csp_requirement_headers h,

3209: -- first check for the partial received order line status
3210: l_partial_line := 0;
3211: SELECT count(l.requirement_line_id)
3212: into l_partial_line
3213: FROM csp_requirement_headers h,
3214: csp_requirement_lines l,
3215: csp_req_line_details d,
3216: oe_order_lines_all oola
3217: WHERE h.task_id = l_task_id

Line 3246: FROM csp_requirement_headers h,

3242: -- ship to address type
3243: l_fl_rcvd_lines := 0;
3244: SELECT COUNT(l.requirement_line_id)
3245: into l_fl_rcvd_lines
3246: FROM csp_requirement_headers h,
3247: csp_requirement_lines l,
3248: csp_req_line_details dio,
3249: csp_req_line_details dres,
3250: oe_order_lines_all oola,

Line 3274: FROM csp_requirement_headers h,

3270:
3271: if l_fl_rcvd_lines > 0 then
3272: SELECT ooha.order_number
3273: into l_order_number
3274: FROM csp_requirement_headers h,
3275: csp_requirement_lines l,
3276: csp_req_line_details dio,
3277: oe_order_lines_all oola,
3278: oe_order_headers_all ooha

Line 3303: FROM csp_requirement_headers h,

3299: -- for fully rcvd case
3300: l_fl_rcvd_lines := 0;
3301: SELECT COUNT(l.requirement_line_id)
3302: into l_fl_rcvd_lines
3303: FROM csp_requirement_headers h,
3304: csp_requirement_lines l,
3305: csp_req_line_details dio,
3306: csp_req_line_details dres,
3307: oe_order_lines_all oola,

Line 3334: FROM csp_requirement_headers h,

3330: -- get fully received lines for task and customer ship to case
3331: l_fl_rcvd_multi_source := 0;
3332: SELECT COUNT(l.requirement_line_id)
3333: into l_fl_rcvd_multi_source
3334: FROM csp_requirement_headers h,
3335: csp_requirement_lines l,
3336: csp_req_line_details dio,
3337: csp_req_line_details dres,
3338: csp_req_line_details dother,

Line 3379: FROM csp_requirement_headers h,

3375: SELECT COUNT(requirement_line_id)
3376: into l_oth_req_line
3377: FROM
3378: (SELECT l.requirement_line_id
3379: FROM csp_requirement_headers h,
3380: csp_requirement_lines l,
3381: csp_req_line_details d
3382: WHERE h.task_id = l_task_id
3383: AND h.task_assignment_id = l_Task_Assignment_id

Line 3389: FROM csp_requirement_headers h,

3385: AND h.address_type IN ('T', 'C', 'P')
3386: AND l.requirement_line_id = d.requirement_line_id
3387: MINUS
3388: SELECT l.requirement_line_id
3389: FROM csp_requirement_headers h,
3390: csp_requirement_lines l,
3391: csp_req_line_details dio,
3392: csp_req_line_details dres,
3393: oe_order_lines_all oola,

Line 3431: FROM csp_requirement_headers h,

3427: SELECT COUNT(requirement_line_id)
3428: into l_non_src_line
3429: FROM
3430: (SELECT l.requirement_line_id
3431: FROM csp_requirement_headers h,
3432: csp_requirement_lines l
3433: WHERE h.task_id = l_task_id
3434: AND h.task_assignment_id = l_Task_Assignment_id
3435: AND h.requirement_header_id = l.requirement_header_id

Line 3442: FROM csp_requirement_headers h,

3438: FROM csp_req_line_details d
3439: WHERE d.requirement_line_id = l.requirement_line_id) = 0
3440: MINUS
3441: SELECT l.requirement_line_id
3442: FROM csp_requirement_headers h,
3443: csp_requirement_lines l,
3444: csp_req_line_details dio,
3445: csp_req_line_details dres,
3446: oe_order_lines_all oola,

Line 3506: FROM csp_requirement_headers h,

3502: -- now check for shipped lines
3503: l_shpd_lines := 0;
3504: SELECT COUNT(l.requirement_line_id)
3505: into l_shpd_lines
3506: FROM csp_requirement_headers h,
3507: csp_requirement_lines l,
3508: csp_req_line_details d,
3509: oe_order_lines_all oola
3510: WHERE h.task_id = l_task_id

Line 3527: FROM csp_requirement_headers h

3523: if l_shpd_lines > 0 then
3524: l_tech_spec_pr := 0;
3525: SELECT count(h.address_type)
3526: into l_tech_spec_pr
3527: FROM csp_requirement_headers h
3528: WHERE h.task_id = l_task_id
3529: AND h.task_assignment_id = l_Task_Assignment_id
3530: AND h.address_type IN ('R', 'S');
3531:

Line 3540: FROM csp_requirement_headers h,

3536:
3537: if l_tech_spec_pr > 0 then
3538: SELECT ooha.order_number
3539: INTO l_order_number
3540: FROM csp_requirement_headers h,
3541: csp_requirement_lines l,
3542: csp_req_line_details d,
3543: oe_order_lines_all oola,
3544: oe_order_headers_all ooha

Line 3568: FROM csp_requirement_headers h,

3564: -- now check for same line multiple IO case
3565: l_ship_multi_src := 0;
3566: SELECT COUNT(l.requirement_line_id)
3567: into l_ship_multi_src
3568: FROM csp_requirement_headers h,
3569: csp_requirement_lines l,
3570: csp_req_line_details d,
3571: csp_req_line_details dother,
3572: oe_order_lines_all oola

Line 3605: FROM csp_requirement_headers h,

3601: SELECT COUNT(requirement_line_id)
3602: into l_oth_req_line
3603: FROM
3604: (SELECT l.requirement_line_id
3605: FROM csp_requirement_headers h,
3606: csp_requirement_lines l,
3607: csp_req_line_details d
3608: WHERE h.task_id = l_task_id
3609: AND h.task_assignment_id = l_Task_Assignment_id

Line 3614: FROM csp_requirement_headers h,

3610: AND h.requirement_header_id = l.requirement_header_id
3611: AND l.requirement_line_id = d.requirement_line_id
3612: MINUS
3613: SELECT l.requirement_line_id
3614: FROM csp_requirement_headers h,
3615: csp_requirement_lines l,
3616: csp_req_line_details d,
3617: oe_order_lines_all oola
3618: WHERE h.task_id = l_task_id

Line 3648: FROM csp_requirement_headers h,

3644: SELECT COUNT(requirement_line_id)
3645: into l_non_src_line
3646: FROM
3647: (SELECT l.requirement_line_id
3648: FROM csp_requirement_headers h,
3649: csp_requirement_lines l
3650: WHERE h.task_id = l_task_id
3651: AND h.task_assignment_id = l_Task_Assignment_id
3652: AND h.requirement_header_id = l.requirement_header_id

Line 3658: FROM csp_requirement_headers h,

3654: FROM csp_req_line_details d
3655: WHERE d.requirement_line_id = l.requirement_line_id) = 0
3656: MINUS
3657: SELECT l.requirement_line_id
3658: FROM csp_requirement_headers h,
3659: csp_requirement_lines l,
3660: csp_req_line_details d,
3661: oe_order_lines_all oola
3662: WHERE h.task_id = l_task_id

Line 3680: FROM csp_requirement_headers ch, HR_ALL_ORGANIZATION_UNITS h

3676: if l_non_src_line = 0 then
3677: l_dest_ou := -999;
3678: SELECT ch.destination_organization_id, h.name
3679: into l_dest_ou, l_dest_org_name
3680: FROM csp_requirement_headers ch, HR_ALL_ORGANIZATION_UNITS h
3681: WHERE ch.task_id = l_task_id
3682: AND ch.task_assignment_id = l_Task_Assignment_id
3683: AND ch.destination_organization_id = h.organization_id
3684: AND rownum = 1;

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 3830: FROM csp_requirement_headers ch, HR_ALL_ORGANIZATION_UNITS h

3826: elsif x_return_status = 'C' then
3827: l_dest_ou := -999;
3828: SELECT ch.destination_organization_id, h.name
3829: into l_dest_ou, l_dest_org_name
3830: FROM csp_requirement_headers ch, HR_ALL_ORGANIZATION_UNITS h
3831: WHERE ch.task_id = l_task_id
3832: AND ch.task_assignment_id = l_Task_Assignment_id
3833: AND ch.destination_organization_id = h.organization_id
3834: AND rownum = 1;

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,

Line 4149: FROM csp_requirement_headers rh

4145: l_resource_type_code VARCHAR2(30);
4146:
4147: cursor get_current_ship_to (v_req_header_id number) is
4148: SELECT rh.ship_to_location_id, rh.ADDRESS_TYPE
4149: FROM csp_requirement_headers rh
4150: WHERE rh.requirement_header_id = v_req_header_id;
4151:
4152: cursor get_blank_req_header is
4153: SELECT rh.requirement_header_id

Line 4154: FROM csp_requirement_headers rh,

4150: WHERE rh.requirement_header_id = v_req_header_id;
4151:
4152: cursor get_blank_req_header is
4153: SELECT rh.requirement_header_id
4154: FROM csp_requirement_headers rh,
4155: jtf_task_assignments jta
4156: WHERE jta.task_assignment_id = l_task_assignment_id
4157: AND rh.task_id = jta.task_id
4158: AND rh.task_assignment_id IS NULL

Line 4474: 'before calling CSP_REQUIREMENT_HEADERS_PKG.Update_Row...');

4470:
4471: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4472: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4473: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4474: 'before calling CSP_REQUIREMENT_HEADERS_PKG.Update_Row...');
4475: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4476: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4477: 'l_ship_to_location_id = ' || l_ship_to_location_id);
4478: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 4483: CSP_REQUIREMENT_HEADERS_PKG.Update_Row(

4479: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4480: 'l_ship_to_type = ' || l_ship_to_type);
4481: end if;
4482:
4483: CSP_REQUIREMENT_HEADERS_PKG.Update_Row(
4484: p_REQUIREMENT_HEADER_ID => l_rqmt_header_id,
4485: p_TASK_ASSIGNMENT_ID => l_task_assignment_id,
4486: p_resource_id => l_resource_id,
4487: p_resource_type => l_resource_type_code,

Line 4498: 'after calling CSP_REQUIREMENT_HEADERS_PKG.Update_Row...');

4494:
4495: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4496: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4497: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',
4498: 'after calling CSP_REQUIREMENT_HEADERS_PKG.Update_Row...');
4499: end if;
4500:
4501: end loop;
4502: end if;

Line 4551: FROM csp_requirement_headers h,

4547: -- check if we still has any req line details
4548: l_dtl_count := 0;
4549: SELECT COUNT(*)
4550: INTO l_dtl_count
4551: FROM csp_requirement_headers h,
4552: csp_requirement_lines l,
4553: csp_req_line_details d
4554: WHERE h.task_assignment_id = l_task_assignment_id
4555: AND h.task_id = l_task_id