[Home] [Help]
PACKAGE: APPS.PO_CLM_CP_LABEL_EXT
Source
1 PACKAGE PO_CLM_CP_LABEL_EXT AUTHID CURRENT_USER AS
2 /* $Header: PO_CLM_CP_LABEL_EXT.pls 120.2.12020000.3 2013/02/10 19:12:49 vegajula ship $ */
3
4 /*
5 Lookup Types:
6 IDC Types : PO_FEDERAL_IDC_TYPES
7 Contract Type for Quantity based Lines :PO_FEDERAL_CONTRACT_TYPES_QTY
8 Contract Type for Amount based Lines :PO_FEDERAL_CONTRACT_TYPES_AMT
9 Line Type => Value Basis PO.PO_LINE_TYPES_B.ORDER_TYPE_LOOKUP_CODE => (QUANTITY,AMOUNT,RATE,FIXED PRICE);
10 */
11
12
13
14 g_extended_price VARCHAR2(30) := fnd_message.get_string('PO', 'PO_FED_EXTENDED_PRICE');
15 g_estimated_price VARCHAR2(30) := fnd_message.get_string('PO', 'PO_FED_ESTIMATED_PRICE');
16 g_maximum_price VARCHAR2(30) := fnd_message.get_string('PO', 'PO_FED_MAXIMUM_PRICE');
17 g_total_amount VARCHAR2(30) := fnd_message.get_string('PO', 'PO_FED_TOTAL_AMT');
18 g_total_target_price VARCHAR2(30) := fnd_message.get_string('PO', 'PO_FED_TOTAL_TARGET_PRICE');
19 g_estimated_cost VARCHAR2(30) := fnd_message.get_string('PO', 'PO_FED_ESTIMATED_COST');
20 g_estimated_max_cost VARCHAR2(30) := fnd_message.get_string('PO', 'PO_FED_ESTIMATED_MAX_COST');
21
22
23 g_unit_price VARCHAR2(30) := fnd_message.get_string('PO', 'PO_FED_UNIT_PRICE');
24 g_award_fee_lbl VARCHAR2(30) := fnd_message.get_string('PO', 'PO_FED_AWARD_FEE');
25 g_base_fee_lbl VARCHAR2(30) := fnd_message.get_string('PO', 'PO_FED_BASE_FEE');
26 g_other_direct_costs VARCHAR2(30) := fnd_message.get_string('PO', 'PO_FED_OTHER_COSTS');
27 g_target_cost VARCHAR2(30) := fnd_message.get_string('PO', 'PO_FED_TARGET_COST');
28 g_target_profit VARCHAR2(30) := fnd_message.get_string('PO', 'PO_FED_TARGET_PROFIT');
29 g_max_cost VARCHAR2(30) := fnd_message.get_string('PO', 'PO_FED_MAX_COST');
30 g_fixed_fee VARCHAR2(30) := fnd_message.get_string('PO', 'PO_FED_FIXED_FEE');
31 g_target_fee VARCHAR2(30) := fnd_message.get_string('PO', 'PO_FED_TARGET_FEE');
32
33 g_quantity VARCHAR2(30) := fnd_message.get_string('PO', 'PO_FED_QTY');
34 g_estimated_quantity VARCHAR2(30) := fnd_message.get_string('PO', 'PO_FED_ESTIMATED_QTY');
35 g_maximum_quantity VARCHAR2(30) := fnd_message.get_string('PO', 'PO_FED_MAX_QTY');
36 g_TOTAL_AWARD_FEE VARCHAR2(30) := fnd_message.get_string('PO', 'PO_SGD_TOT_AWD_FEE');
37
38 TYPE l_cp_lbl_type IS RECORD (QTYLABEL VARCHAR2(30), AMOUNTLABEL VARCHAR2(30), formula VARCHAR2(120));
39 TYPE l_contracttype_tbl IS TABLE OF l_cp_lbl_type INDEX BY VARCHAR2(30);
40
41 firmfixedpriceAmt l_contracttype_tbl; -- Firm Fixed Price Contract Type
42 firmfixedpriceQty l_contracttype_tbl; -- Firm Fixed Price Contract Type
43
44 FPLevelofEffortAmt l_contracttype_tbl; -- Firm Price Level Of Effort Contract Type
45 FPLevelofEffortQty l_contracttype_tbl; -- Firm Price Level Of Effort Contract Type
46
47 FPEconomicPriceAdjAmt l_contracttype_tbl; --Fixed Price Economic Price Adjustment Contract Type
48 FPEconomicPriceAdjQty l_contracttype_tbl; --Fixed Price Economic Price Adjustment Contract Type
49
50
51 FPProspectRedeterminationAmt l_contracttype_tbl; -- Fixed-Price Prospective Price Redetermination Contract Type
52 FPProspectRedeterminationqty l_contracttype_tbl; -- Fixed-Price Prospective Price Redetermination Contract Type
53
54 FCPRetroRedeterminationAmt l_contracttype_tbl; -- Fixed Ceiling Price Retro Price Redetermination Contract Type
55 FCPRetroRedeterminationqty l_contracttype_tbl; -- Fixed Ceiling Price Retro Price Redetermination Contract Type
56
57 FPAwardFeeAmt l_contracttype_tbl; -- Fixed Priced Award Fee Contract Type
58 FPAwardFeeQty l_contracttype_tbl; -- Fixed Priced Award Fee Contract Type
59
60 AwardFeeAmt l_contracttype_tbl; -- Award Fee Contract Type
61
62 LaborHourAmt l_contracttype_tbl; -- Labor Hour Contract Type
63 LaborHourQty l_contracttype_tbl; -- Labor Hour Contract Type
64
65 TimeNMaterialsAmt l_contracttype_tbl; -- Time-and-Materials Contract Type
66 TimeNMaterialsQty l_contracttype_tbl; -- Time-and-Materials Contract Type
67
68 FPIncentiveFirmTargetAmt l_contracttype_tbl; -- Fixed-Price Incentive (Firm Target) Contract Type
69 FPIncentiveSuccessiveTargetAmt l_contracttype_tbl; -- Fixed-Price Incentive (Successive Targets) Contract Type
70 CostContractAmt l_contracttype_tbl; -- Cost Contract Contract Type
71 CostPlusAwardFeeAmt l_contracttype_tbl; -- Cost-Plus-Award-Fee Contract Type
72 CostPlusFixedFeeAmt l_contracttype_tbl; -- Cost-Plus-Fixed Fee Contract Type
73 CostPlusIncentiveFeeAmt l_contracttype_tbl; -- Cost-Plus-Incentive-Fee Contract Type
74 CostSharingAmt l_contracttype_tbl; -- Cost Sharing Contract Type
75
76 OtherDirectCostAmt l_contracttype_tbl;
77
78 g_FP_AWARD_FEE varchar2(30) := 'FP_AWARD_FEE';
79 g_FP_ECONOMIC_PRICE_ADJ varchar2(30) := 'FP_ECONOMIC_PRICE_ADJ';
80 g_FP_FIRM varchar2(30) := 'FP_FIRM' ;
81 g_FP_LEVEL_EFFORT varchar2(30) := 'FP_LEVEL_EFFORT' ;
82 g_FP_PROSPECT_REDETERMINATION varchar2(30) := 'FP_PROSPECTIVE_REDETERMINATION' ;
83 g_FP_RETRO_REDETERMINATION varchar2(30) := 'FP_RETRO_REDETERMINATION';
84 g_LABOR_HOUR varchar2(30) := 'LABOR_HOUR' ;
85 g_TIME_MATERIALS varchar2(30) := 'TIME_MATERIALS' ;
86 g_OTHERDIRECT_COSTS varchar2(30) := 'OTHER_DIRECT_COSTS';
87
88 g_AWARD_FEE varchar2(30) := 'AWARD_FEE';
89 g_COST_CONTRACT varchar2(30) := 'COST_CONTRACT';
90 g_COST_PLUS_AWARD_FEE varchar2(30) := 'COST_PLUS_AWARD_FEE';
91 g_COST_PLUS_FIXED_FEE varchar2(30) := 'COST_PLUS_FIXED_FEE';
92 g_COST_PLUS_INCENTIVE_FEE varchar2(30) := 'COST_PLUS_INCENTIVE_FEE';
93 g_COST_SHARING varchar2(30) := 'COST_SHARING';
94 g_FP_INCENTIVE_FIRM_TARGET varchar2(30) := 'FP_INCENTIVE_FIRM_TARGET';
95 g_FP_INCENT_SUCCESSIVE_TARGET varchar2(30) := 'FP_INCENTIVE_SUCCESSIVE_TARGET';
96
97 g_idc_na varchar2(30) := 'IDC_NA';
98 g_idc_requirement varchar2(30) := 'IDC_REQUIREMENT';
99 g_idc_definite_qty varchar2(30) := 'IDC_DEFINITE_QTY' ;
100 g_idc_indefinite_qty varchar2(30) := 'IDC_INDEFINITE_QTY';
101
102 FUNCTION getAmountLabel(p_LineType IN VARCHAR2,p_ContractType IN VARCHAR2,p_IDCType IN VARCHAR2 ) RETURN VARCHAR2;
103 FUNCTION getQuantityLabel(p_LineType IN VARCHAR2,p_ContractType IN VARCHAR2,p_IDCType IN VARCHAR2 ) RETURN VARCHAR2;
104 FUNCTION getHintLabel(p_LineType IN VARCHAR2,p_ContractType IN VARCHAR2,p_IDCType IN VARCHAR2 ) RETURN VARCHAR2;
105 END;