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_CAR_UTIL

Line 1: PACKAGE BODY PO_CLM_CAR_UTIL AS

1: PACKAGE BODY PO_CLM_CAR_UTIL AS
2: /*$Header: POCARUTB.pls 120.7.12020000.4 2013/03/22 11:31:15 smvinod ship $*/
3: PROCEDURE sync_clm_car
4: (
5: p_api_version IN NUMBER,

Line 669: l_report_type VARCHAR2(20):= po_clm_car_util.get_report_type(p_po_header_id);

665: p_rel_without_rpt_reason IN VARCHAR2 DEFAULT NULL
666: ) IS
667: l_car_id NUMBER;
668: l_award_idv_type VARCHAR2(20):=null;
669: l_report_type VARCHAR2(20):= po_clm_car_util.get_report_type(p_po_header_id);
670: l_exemption_reason VARCHAR2(100):=null;
671: l_org_id NUMBER; --CLM Controls Project Changes
672: BEGIN
673:

Line 754: po_clm_car_util.get_car_number(p_po_header_id, p_draft_id),

750: p_draft_id,
751: l_report_type,
752: l_award_idv_type,
753: 'NOT_REPORTED',
754: po_clm_car_util.get_car_number(p_po_header_id, p_draft_id),
755: NULL,
756: po_clm_car_util.get_modification_segment(p_po_header_id, p_draft_id),
757: Decode(p_invoked_from,'MULTI_MOD','NONE','EXEMPT'),
758: Decode(p_invoked_from,'MULTI_MOD',1,NULL),

Line 756: po_clm_car_util.get_modification_segment(p_po_header_id, p_draft_id),

752: l_award_idv_type,
753: 'NOT_REPORTED',
754: po_clm_car_util.get_car_number(p_po_header_id, p_draft_id),
755: NULL,
756: po_clm_car_util.get_modification_segment(p_po_header_id, p_draft_id),
757: Decode(p_invoked_from,'MULTI_MOD','NONE','EXEMPT'),
758: Decode(p_invoked_from,'MULTI_MOD',1,NULL),
759: Decode(p_invoked_from,'MULTI_MOD',p_rel_without_rpt_reason,NULL),
760: po_clm_car_util.get_contr_office_agency_id(l_org_id), --CLM Controls Project Changes

Line 760: po_clm_car_util.get_contr_office_agency_id(l_org_id), --CLM Controls Project Changes

756: po_clm_car_util.get_modification_segment(p_po_header_id, p_draft_id),
757: Decode(p_invoked_from,'MULTI_MOD','NONE','EXEMPT'),
758: Decode(p_invoked_from,'MULTI_MOD',1,NULL),
759: Decode(p_invoked_from,'MULTI_MOD',p_rel_without_rpt_reason,NULL),
760: po_clm_car_util.get_contr_office_agency_id(l_org_id), --CLM Controls Project Changes
761: l_exemption_reason,
762: '0',
763: po_clm_car_util.get_agency_id(l_org_id), --CLM Controls Project Changes
764: po_clm_car_util.get_prepared_user(),

Line 763: po_clm_car_util.get_agency_id(l_org_id), --CLM Controls Project Changes

759: Decode(p_invoked_from,'MULTI_MOD',p_rel_without_rpt_reason,NULL),
760: po_clm_car_util.get_contr_office_agency_id(l_org_id), --CLM Controls Project Changes
761: l_exemption_reason,
762: '0',
763: po_clm_car_util.get_agency_id(l_org_id), --CLM Controls Project Changes
764: po_clm_car_util.get_prepared_user(),
765: SYSDATE,
766: FND_GLOBAL.user_id,
767: SYSDATE,

Line 764: po_clm_car_util.get_prepared_user(),

760: po_clm_car_util.get_contr_office_agency_id(l_org_id), --CLM Controls Project Changes
761: l_exemption_reason,
762: '0',
763: po_clm_car_util.get_agency_id(l_org_id), --CLM Controls Project Changes
764: po_clm_car_util.get_prepared_user(),
765: SYSDATE,
766: FND_GLOBAL.user_id,
767: SYSDATE,
768: FND_GLOBAL.user_id,

Line 770: po_clm_car_util.get_piid(p_po_header_id, p_draft_id));

766: FND_GLOBAL.user_id,
767: SYSDATE,
768: FND_GLOBAL.user_id,
769: FND_GLOBAL.login_id,
770: po_clm_car_util.get_piid(p_po_header_id, p_draft_id));
771: END;
772: END;
773:
774: /*

Line 920: d_module VARCHAR2(70) := 'po.plsql.PO_CLM_CAR_UTIL.car_for_control_type';

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;
923: IF (PO_LOG.d_proc) THEN
924: PO_LOG.proc_begin(d_module);

Line 995: l_report_type := po_clm_car_util.get_report_type(p_po_header_id);

991: d_progress := 40;
992: IF (PO_LOG.d_stmt) THEN
993: PO_LOG.stmt(d_module, d_progress, 'Inserting new car');
994: END IF;
995: l_report_type := po_clm_car_util.get_report_type(p_po_header_id);
996: SELECT ATM.FPDS_AWARD_TYPE
997: INTO l_award_idv_type
998: FROM PO_CLM_TO_FPDS_AWARD_TYP_MAP ATM,
999: PO_HEADERS_MERGE_V POH

Line 1005: l_car_number := po_clm_car_util.get_car_number(p_po_header_id, p_draft_id);

1001: AND NVL(POH.DRAFT_ID,-1) = p_draft_id
1002: AND ATM.REPORT_TYPE(+) = l_report_type
1003: AND ATM.CLM_AWARD_TYPE(+) = POH.CLM_AWARD_TYPE;
1004:
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(

Line 1006: l_modification_segment := po_clm_car_util.get_modification_segment(p_po_header_id, p_draft_id);

1002: AND ATM.REPORT_TYPE(+) = l_report_type
1003: AND ATM.CLM_AWARD_TYPE(+) = POH.CLM_AWARD_TYPE;
1004:
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,

Line 1007: l_PIID := po_clm_car_util.get_piid(p_po_header_id, p_draft_id);

1003: AND ATM.CLM_AWARD_TYPE(+) = POH.CLM_AWARD_TYPE;
1004:
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,

Line 1048: po_clm_car_util.get_contr_office_agency_id(l_org_id), --CLM Controls Project Changes

1044: DECODE( l_fpds_reporting_method,
1045: 'NONE', 1,
1046: 2),
1047: l_fpds_reason,
1048: po_clm_car_util.get_contr_office_agency_id(l_org_id), --CLM Controls Project Changes
1049: l_exemptiom_reason,
1050: '0',
1051: po_clm_car_util.get_agency_id(l_org_id), --CLM Controls Project Changes
1052: po_clm_car_util.get_prepared_user(),

Line 1051: po_clm_car_util.get_agency_id(l_org_id), --CLM Controls Project Changes

1047: l_fpds_reason,
1048: po_clm_car_util.get_contr_office_agency_id(l_org_id), --CLM Controls Project Changes
1049: l_exemptiom_reason,
1050: '0',
1051: po_clm_car_util.get_agency_id(l_org_id), --CLM Controls Project Changes
1052: po_clm_car_util.get_prepared_user(),
1053: SYSDATE,
1054: FND_GLOBAL.user_id,
1055: SYSDATE,

Line 1052: po_clm_car_util.get_prepared_user(),

1048: po_clm_car_util.get_contr_office_agency_id(l_org_id), --CLM Controls Project Changes
1049: l_exemptiom_reason,
1050: '0',
1051: po_clm_car_util.get_agency_id(l_org_id), --CLM Controls Project Changes
1052: po_clm_car_util.get_prepared_user(),
1053: SYSDATE,
1054: FND_GLOBAL.user_id,
1055: SYSDATE,
1056: FND_GLOBAL.user_id,

Line 1075: END PO_CLM_CAR_UTIL;

1071: END IF;
1072: RAISE;
1073: END car_for_control_type;
1074:
1075: END PO_CLM_CAR_UTIL;