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_EDA_DATATEMPLATE_PKG dependencies on PO_UDA_PUB

Line 116: v_instr_type := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PON_AUC_HDRS_EXT_ATTRS',pk1_value => p_auctHeaderId, pk2_value => -1,

112: OPEN csr_eda_mapping('ProcurementInstrumentVehicle',l_temp_attr);
113: FETCH csr_eda_mapping INTO l_temp_attr;
114: CLOSE csr_eda_mapping;
115:
116: v_instr_type := PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PON_AUC_HDRS_EXT_ATTRS',pk1_value => p_auctHeaderId, pk2_value => -1,
117: p_attr_grp_int_name => 'DOD_SOL', p_attr_int_name => 'INSTR_TYPE');
118:
119: IF v_instr_type = 'Q' THEN
120: l_temp_attr := l_temp_attr || '- Manual';

Line 785: SELECT Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => po_line_id, pk2_value => DRAFTID,

781: FUNCTION getGovtSharePerc(isMod VARCHAR2) RETURN number AS
782:
783: CURSOR c IS
784:
785: SELECT Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => po_line_id, pk2_value => DRAFTID,
786: p_attr_grp_int_name => 'AMT_CS_IIQ', p_attr_int_name => 'GOVT_SHARE_PER'))
787: FROM po_lines_merge_v pol
788: WHERE
789: ( ( (isMod = 'N') AND (pol.po_header_id = DOCUMENTID AND pol.draft_id = -1 AND pol.change_status is NULL)) OR

Line 808: SELECT Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => po_line_id, pk2_value => DRAFTID,

804: FUNCTION getMonetaryAmount(isMod VARCHAR2) RETURN number AS
805:
806: CURSOR c IS
807:
808: SELECT Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => po_line_id, pk2_value => DRAFTID,
809: p_attr_grp_int_name => 'AMT_CS_IIQ', p_attr_int_name => 'GOVT_SH_AMOUNT'))
810: FROM po_lines_merge_v pol
811: WHERE
812: ( ( (isMod = 'N') AND (pol.po_header_id = DOCUMENTID AND pol.draft_id = -1 AND pol.change_status is NULL)) OR

Line 833: SELECT Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => po_line_id, pk2_value => DRAFTID,

829: FUNCTION getCtMonetaryAmount(isMod VARCHAR2) RETURN number AS
830:
831: CURSOR c IS
832:
833: SELECT Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => po_line_id, pk2_value => DRAFTID,
834: p_attr_grp_int_name => 'AMT_CS_IIQ', p_attr_int_name => 'CONT_SH_AMOUNT'))
835: FROM po_lines_merge_v pol
836: WHERE
837: ( ( (isMod = 'N') AND (pol.po_header_id = DOCUMENTID AND pol.draft_id = -1 AND pol.change_status is NULL)) OR

Line 2322: SELECT Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => documentId, pk2_value => -1,

2318: ( ( (isMod = 'N') AND (ploc.po_header_id = DOCUMENTID AND ploc.draft_id = -1 AND ploc.change_status is NULL)) OR
2319: ( (isMod = 'Y') AND (ploc.draft_id = DRAFTID AND ploc.change_status is not null) ) ) ;
2320:
2321: CURSOR c_award_fee IS
2322: SELECT Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => documentId, pk2_value => -1,
2323: p_attr_grp_int_name =>
2324: 'AMT_'||Decode(pline.contract_type,'AWARD_FEE','AF','COST_PLUS_AWARD_FEE','CPAF')||'_'
2325: ||Decode(phdr.clm_award_type,'IQ','IIQ','REQ','IR','NEG_AGMNT','IN','DQ','IDQ'),
2326: p_attr_int_name => 'AWARD_FEE'))

Line 2339: SELECT Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => documentId, pk2_value => -1,

2335: AND phdr.po_header_id = documentId
2336: AND Nvl(CLM_EXERCISED_FLAG,'N') = 'N';
2337:
2338: CURSOR c_base_fee IS
2339: SELECT Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => documentId, pk2_value => -1,
2340: p_attr_grp_int_name =>
2341: 'AMT_CPAF_'||Decode(phdr.clm_award_type,'IQ','IIQ','REQ','IR','NEG_AGMNT','IN','DQ','IDQ'),
2342: p_attr_int_name => 'BASE_FEE'))
2343: FROM po_lines_merge_v pline, po_headers_merge_v phdr

Line 2355: SELECT Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => documentId,

2351: AND phdr.po_header_id = documentId
2352: AND Nvl(CLM_EXERCISED_FLAG,'N') = 'N';
2353:
2354: CURSOR c_ceiling_ex IS
2355: SELECT Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => documentId,
2356: pk2_value => -1,p_attr_grp_int_name => 'AMT_'||
2357: Decode(pline.contract_type,'FP_INCENTIVE_SUCCESSIVE_TARGET','FIST','FP_INCENTIVE_FIRM_TARGET','FIFT')
2358: ||'_'||Decode(phdr.clm_award_type,'IQ','IIQ','REQ','IR','NEG_AGMNT','IN','DQ','IDQ'),
2359: p_attr_int_name => 'CEILING_PRICE'))

Line 2372: SELECT Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => documentId, pk2_value => -1,

2368: AND phdr.po_header_id = documentId
2369: AND Nvl(CLM_EXERCISED_FLAG,'N') = 'N';
2370:
2371: CURSOR c_estimated_cost IS
2372: SELECT Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => documentId, pk2_value => -1,
2373: p_attr_grp_int_name => 'AMT_'|| Decode(pline.contract_type,'COST_PLUS_FIXED_FEE','CPFF','COST_PLUS_AWARD_FEE','CPAF')||'_'||
2374: Decode(phdr.clm_award_type,'IQ','IIQ','REQ','IR','NEG_AGMNT','IN','DQ','IDQ'),
2375: p_attr_int_name => 'ESTIMATED_COST'))
2376: FROM po_lines_merge_v pline, po_headers_merge_v phdr

Line 2388: SELECT Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => documentId, pk2_value => -1,

2384: AND phdr.po_header_id = documentId
2385: AND Nvl(CLM_EXERCISED_FLAG,'N') = 'N';
2386:
2387: CURSOR c_fixed_fee IS
2388: SELECT Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => documentId, pk2_value => -1,
2389: p_attr_grp_int_name => 'AMT_CPFF_'||
2390: Decode(phdr.clm_award_type,'IQ','IIQ','REQ','IR','NEG_AGMNT','IN','DQ','IDQ'),
2391: p_attr_int_name => 'FIXED_FEE'))
2392: FROM po_lines_merge_v pline, po_headers_merge_v phdr

Line 2404: SELECT Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => documentId, pk2_value => -1,

2400: AND phdr.po_header_id = documentId
2401: AND Nvl(CLM_EXERCISED_FLAG,'N') = 'N';
2402:
2403: CURSOR c_target_cost IS
2404: SELECT Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => documentId, pk2_value => -1,
2405: p_attr_grp_int_name => 'AMT_'||Decode(pline.contract_type,'COST_PLUS_INCENTIVE_FEE','CPIF',
2406: 'FP_INCENTIVE_FIRM_TARGET','FIFT','FP_INCENTIVE_SUCCESSIVE_TARGET','FIST')
2407: ||'_'||Decode(phdr.clm_award_type,'IQ','IIQ','REQ','IR','NEG_AGMNT','IN','DQ','IDQ'),
2408: p_attr_int_name => 'TARGET_COST'))