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.PO_CLM_CAR_UTIL dependencies on PO_CLM_CARS

Line 46: SELECT * FROM PO_CLM_CARS WHERE po_header_id = p_h_id AND po_draft_id = p_d_id AND car_id <> c_id AND reporting_method = 'SINGLE_CAR';

42: l_po_draft_id NUMBER;
43: l_reporting_method VARCHAR2(30) := 'SINGLE_CAR';
44: l_org_id NUMBER; --CLM Controls Project Changes
45: CURSOR c_dup (c_id NUMBER, p_h_id NUMBER, p_d_id NUMBER) IS
46: SELECT * FROM PO_CLM_CARS WHERE po_header_id = p_h_id AND po_draft_id = p_d_id AND car_id <> c_id AND reporting_method = 'SINGLE_CAR';
47: BEGIN
48: IF p_clm_car_row IS NOT NULL THEN
49: l_car_id := p_clm_car_row.car_id;
50: IF l_car_id IS NULL THEN

Line 51: l_car_id := PO_CLM_CARS_S.NEXTVAL;

47: BEGIN
48: IF p_clm_car_row IS NOT NULL THEN
49: l_car_id := p_clm_car_row.car_id;
50: IF l_car_id IS NULL THEN
51: l_car_id := PO_CLM_CARS_S.NEXTVAL;
52: END IF;
53:
54: l_po_draft_id := p_clm_car_row.po_draft_id;
55: IF l_po_draft_id IS NULL THEN

Line 65: FROM PO_CLM_CARS

61: --default the reporting method of mod to its base award's reporting method
62: IF l_po_draft_id <> -1 THEN
63: SELECT DISTINCT REPORTING_METHOD
64: INTO l_reporting_method
65: FROM PO_CLM_CARS
66: WHERE PO_HEADER_ID = p_clm_car_row.po_header_id
67: AND PO_DRAFT_ID = -1;
68: END IF;
69:

Line 87: MERGE INTO PO_CLM_CARS c using DUAL on (c.car_id = l_car_id AND

83: RAISE e_single_car_violation;
84: END IF;
85: CLOSE c_dup;
86:
87: MERGE INTO PO_CLM_CARS c using DUAL on (c.car_id = l_car_id AND
88: c.po_header_id = p_clm_car_row.po_header_id AND
89: c.po_draft_id = l_po_draft_id)
90: WHEN NOT MATCHED THEN INSERT (c.car_id,
91: c.po_header_id,

Line 202: l_car_rec PO_CLM_CARS%ROWTYPE;

198: x_car_id OUT NOCOPY NUMBER,
199: x_return_status OUT NOCOPY VARCHAR2,
200: x_error_msg OUT NOCOPY VARCHAR2
201: ) IS
202: l_car_rec PO_CLM_CARS%ROWTYPE;
203: CURSOR c_car IS SELECT *
204: FROM PO_CLM_CARS
205: WHERE PO_HEADER_ID = p_po_header_id
206: AND PO_DRAFT_ID = NVL(p_po_draft_id, -1) FOR UPDATE;

Line 204: FROM PO_CLM_CARS

200: x_error_msg OUT NOCOPY VARCHAR2
201: ) IS
202: l_car_rec PO_CLM_CARS%ROWTYPE;
203: CURSOR c_car IS SELECT *
204: FROM PO_CLM_CARS
205: WHERE PO_HEADER_ID = p_po_header_id
206: AND PO_DRAFT_ID = NVL(p_po_draft_id, -1) FOR UPDATE;
207: BEGIN
208: OPEN c_car;

Line 213: UPDATE PO_CLM_CARS

209: FETCH c_car INTO l_car_rec;
210: IF c_car%FOUND THEN
211: IF l_car_rec.CAR_STATUS = 'NOT_REPORTED' THEN
212: x_car_id := l_car_rec.CAR_ID;
213: UPDATE PO_CLM_CARS
214: SET CAR_STATUS = NVL(p_car_status, l_car_rec.car_status),
215: CAR_DESCRIPTION = NVL(p_car_description, l_car_rec.car_description)
216: WHERE CURRENT OF c_car;
217: x_return_status := 'S';

Line 265: DELETE FROM PO_CLM_CARS

261: ) IS
262:
263: BEGIN
264: -- delete the car
265: DELETE FROM PO_CLM_CARS
266: WHERE car_id = p_car_id
267: AND po_header_id = p_po_header_id
268: AND po_draft_id = NVL(p_po_draft_id, -1);
269:

Line 384: FROM PO_CLM_CARS

380: BEGIN
381: IF p_car_id IS NOT NULL THEN
382: SELECT PIID, MODIFICATION_SEGMENT
383: INTO l_piid_from_tab, l_mod_num_from_tab
384: FROM PO_CLM_CARS
385: WHERE CAR_ID = p_car_id
386: AND PO_HEADER_ID = p_po_header_id
387: AND PO_DRAFT_ID = NVL(p_po_draft_id, -1);
388: ELSE

Line 391: FROM PO_CLM_CARS

387: AND PO_DRAFT_ID = NVL(p_po_draft_id, -1);
388: ELSE
389: SELECT PIID, MODIFICATION_SEGMENT
390: INTO l_piid_from_tab, l_mod_num_from_tab
391: FROM PO_CLM_CARS
392: WHERE PO_HEADER_ID = p_po_header_id
393: AND PO_DRAFT_ID = NVL(p_po_draft_id, -1);
394: END IF;
395:

Line 448: FROM PO_CLM_CARS

444: IF l_ref_idv_id IS NOT NULL THEN
445: BEGIN
446: SELECT AGENCY_ID
447: INTO x_ref_idv_agency_id
448: FROM PO_CLM_CARS
449: WHERE PO_HEADER_ID = l_ref_idv_id
450: AND PO_DRAFT_ID = -1;
451: EXCEPTION
452: WHEN NO_DATA_FOUND THEN

Line 485: FROM PO_CLM_CARS

481: l_car_status VARCHAR2(60);
482: BEGIN
483: SELECT CAR_STATUS
484: INTO l_car_status
485: FROM PO_CLM_CARS
486: WHERE CAR_ID = p_car_id
487: AND PO_HEADER_ID = p_po_header_id
488: AND PO_DRAFT_ID = p_po_draft_id;
489: RETURN l_car_status;

Line 653: UPDATE PO_CLM_CARS

649: p_po_header_id IN NUMBER,
650: p_po_draft_id IN NUMBER
651: ) IS
652: BEGIN
653: UPDATE PO_CLM_CARS
654: SET CAR_STATUS = 'DRAFT'
655: WHERE PO_HEADER_ID = p_po_header_id
656: AND PO_DRAFT_ID = p_po_draft_id
657: AND CAR_STATUS = 'AUTHENTICATED';

Line 693: FROM po_clm_cars

689:
690: IF(p_invoked_from <> 'MULTI_MOD') THEN
691: BEGIN
692: SELECT exemption_reason INTO l_exemption_reason
693: FROM po_clm_cars
694: WHERE po_header_id = p_po_header_id
695: AND po_draft_id = -1
696: AND reporting_method = 'EXEMPT';
697: EXCEPTION

Line 707: FROM po_clm_cars

703: END IF;
704:
705: BEGIN
706: SELECT car_id INTO l_car_id
707: FROM po_clm_cars
708: WHERE po_header_id = p_po_header_id
709: AND po_draft_id = p_draft_id;
710: EXCEPTION
711: WHEN no_data_found THEN

Line 723: INSERT INTO po_clm_cars(

719: POH.DRAFT_ID = p_draft_id AND
720: ATM.REPORT_TYPE(+) = l_report_type AND
721: ATM.CLM_AWARD_TYPE(+) = POH.CLM_AWARD_TYPE;
722:
723: INSERT INTO po_clm_cars(
724: car_id,
725: po_header_id,
726: po_draft_id,
727: report_type,

Line 748: PO_CLM_CARS_S.NEXTVAL,

744: CREATED_BY,
745: LAST_UPDATE_LOGIN,
746: PIID)
747: VALUES(
748: PO_CLM_CARS_S.NEXTVAL,
749: p_po_header_id,
750: p_draft_id,
751: l_report_type,
752: l_award_idv_type,

Line 890: -- po_clm_cars.

886: ------------------------------------------------------------------------------
887: --Start of Comments
888: --Name: car_for_control_type
889: --Modifies:
890: -- po_clm_cars.
891: --Function:
892: -- This procedure is to create or updat ecar when control type exists
893: -- on Award/ Mod/ IDV
894: --Parameters:

Line 916: l_fpds_reporting_method PO_CLM_CARS.REPORTING_METHOD%TYPE;

912: l_modification_segment VARCHAR2(60);
913: l_PIID VARCHAR2(60);
914: l_car_number VARCHAR2(60);
915: l_update_car VARCHAr2(1);
916: l_fpds_reporting_method PO_CLM_CARS.REPORTING_METHOD%TYPE;
917: l_fpds_reason PO_CLM_CARS.REL_WITHOUT_RPT_REASON%TYPE;
918: l_exemptiom_reason PO_CLM_CARS.EXEMPTION_REASON%TYPE;
919: d_progress NUMBER;
920: d_module VARCHAR2(70) := 'po.plsql.PO_CLM_CAR_UTIL.car_for_control_type';

Line 917: l_fpds_reason PO_CLM_CARS.REL_WITHOUT_RPT_REASON%TYPE;

913: l_PIID VARCHAR2(60);
914: l_car_number VARCHAR2(60);
915: l_update_car VARCHAr2(1);
916: l_fpds_reporting_method PO_CLM_CARS.REPORTING_METHOD%TYPE;
917: l_fpds_reason PO_CLM_CARS.REL_WITHOUT_RPT_REASON%TYPE;
918: l_exemptiom_reason PO_CLM_CARS.EXEMPTION_REASON%TYPE;
919: d_progress NUMBER;
920: d_module VARCHAR2(70) := 'po.plsql.PO_CLM_CAR_UTIL.car_for_control_type';
921: BEGIN

Line 918: l_exemptiom_reason PO_CLM_CARS.EXEMPTION_REASON%TYPE;

914: l_car_number VARCHAR2(60);
915: l_update_car VARCHAr2(1);
916: l_fpds_reporting_method PO_CLM_CARS.REPORTING_METHOD%TYPE;
917: l_fpds_reason PO_CLM_CARS.REL_WITHOUT_RPT_REASON%TYPE;
918: l_exemptiom_reason PO_CLM_CARS.EXEMPTION_REASON%TYPE;
919: d_progress NUMBER;
920: d_module VARCHAR2(70) := 'po.plsql.PO_CLM_CAR_UTIL.car_for_control_type';
921: BEGIN
922: d_progress := 0;

Line 954: FROM po_clm_cars

950: BEGIN
951: d_progress := 20;
952: SELECT car_id
953: INTO l_car_id
954: FROM po_clm_cars
955: WHERE po_header_id = p_po_header_id
956: AND NVL(po_draft_id, -1) = p_draft_id;
957: IF (PO_LOG.d_stmt) THEN
958: PO_LOG.stmt(d_module, d_progress, 'Car exists car_id '|| l_car_id);

Line 970: UPDATE po_clm_cars

966: IF l_exemptiom_reason = 'NA' THEN
967: l_exemptiom_reason := NULL;
968: END IF;
969:
970: UPDATE po_clm_cars
971: SET reporting_method = l_fpds_reporting_method,
972: approved_without_reporting = DECODE( l_fpds_reporting_method,
973: 'NONE', 1,
974: 2),

Line 1009: INSERT INTO po_clm_cars(

1005: l_car_number := po_clm_car_util.get_car_number(p_po_header_id, p_draft_id);
1006: l_modification_segment := po_clm_car_util.get_modification_segment(p_po_header_id, p_draft_id);
1007: l_PIID := po_clm_car_util.get_piid(p_po_header_id, p_draft_id);
1008: -- create new car
1009: INSERT INTO po_clm_cars(
1010: car_id,
1011: po_header_id,
1012: po_draft_id,
1013: report_type,

Line 1034: PO_CLM_CARS_S.NEXTVAL,

1030: created_by,
1031: last_update_login,
1032: piid)
1033: VALUES(
1034: PO_CLM_CARS_S.NEXTVAL,
1035: p_po_header_id,
1036: p_draft_id,
1037: l_report_type,
1038: l_award_idv_type,