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.
PACKAGE: APPS.OKE_CHR_PVT

Source


1 PACKAGE OKE_CHR_PVT AUTHID CURRENT_USER AS
2 /*$Header: OKEVCHRS.pls 120.0 2005/05/25 17:44:19 appldev noship $ */
3 
4 -- GLOBAL DATA STRUCTURES
5 
6 TYPE chr_rec_type IS RECORD(
7   k_header_id		NUMBER := OKE_API.G_MISS_NUM,
8   program_id 		NUMBER := OKE_API.G_MISS_NUM,
9   project_id		NUMBER := OKE_API.G_MISS_NUM,
10   boa_id		NUMBER := OKE_API.G_MISS_NUM,
11   k_type_code		OKE_K_HEADERS.K_TYPE_CODE%TYPE   := OKE_API.G_MISS_CHAR,
12   priority_code		OKE_K_HEADERS.PRIORITY_CODE%TYPE := OKE_API.G_MISS_CHAR,
13   prime_k_alias 	OKE_K_HEADERS.PRIME_K_ALIAS%TYPE := OKE_API.G_MISS_CHAR,
14   prime_k_number 	OKE_K_HEADERS.PRIME_K_NUMBER%TYPE := OKE_API.G_MISS_CHAR,
15   authorize_date 	OKE_K_HEADERS.AUTHORIZE_DATE%TYPE := OKE_API.G_MISS_DATE,
16   authorizing_reason 	OKE_K_HEADERS.AUTHORIZING_REASON%TYPE := OKE_API.G_MISS_CHAR,
17   award_cancel_date 	OKE_K_HEADERS.AWARD_CANCEL_DATE%TYPE := OKE_API.G_MISS_DATE,
18   award_date		OKE_K_HEADERS.AWARD_DATE%TYPE := OKE_API.G_MISS_DATE,
19   date_definitized 	OKE_K_HEADERS.DATE_DEFINITIZED%TYPE := OKE_API.G_MISS_DATE,
20   date_issued 		OKE_K_HEADERS.DATE_ISSUED%TYPE := OKE_API.G_MISS_DATE,
21   date_negotiated 	OKE_K_HEADERS.DATE_NEGOTIATED%TYPE := OKE_API.G_MISS_DATE,
22   date_received 	OKE_K_HEADERS.DATE_RECEIVED%TYPE := OKE_API.G_MISS_DATE,
23   date_sign_by_contractor OKE_K_HEADERS.DATE_SIGN_BY_CONTRACTOR%TYPE := OKE_API.G_MISS_DATE,
24   date_sign_by_customer OKE_K_HEADERS.DATE_SIGN_BY_CUSTOMER%TYPE := OKE_API.G_MISS_DATE,
25   faa_approve_date 	OKE_K_HEADERS.FAA_APPROVE_DATE%TYPE := OKE_API.G_MISS_DATE,
26   faa_reject_date 	OKE_K_HEADERS.FAA_REJECT_DATE%TYPE := OKE_API.G_MISS_DATE,
27   booked_flag		OKE_K_HEADERS.BOOKED_FLAG%TYPE := OKE_API.G_MISS_CHAR,
28   open_flag		OKE_K_HEADERS.OPEN_FLAG%TYPE := OKE_API.G_MISS_CHAR,
29   cfe_flag		OKE_K_HEADERS.CFE_FLAG%TYPE := OKE_API.G_MISS_CHAR,
30   vat_code		OKE_K_HEADERS.VAT_CODE%TYPE := OKE_API.G_MISS_CHAR,
31   country_of_origin_code OKE_K_HEADERS.COUNTRY_OF_ORIGIN_CODE%TYPE := OKE_API.G_MISS_CHAR,
32   export_flag		OKE_K_HEADERS.EXPORT_FLAG%TYPE := OKE_API.G_MISS_CHAR,
33   human_subject_flag 	OKE_K_HEADERS.HUMAN_SUBJECT_FLAG%TYPE := OKE_API.G_MISS_CHAR,
34   cqa_flag		OKE_K_HEADERS.CQA_FLAG%TYPE := OKE_API.G_MISS_CHAR,
35   interim_rpt_req_flag 	OKE_K_HEADERS.INTERIM_RPT_REQ_FLAG%TYPE := OKE_API.G_MISS_CHAR,
36   no_competition_authorize OKE_K_HEADERS.NO_COMPETITION_AUTHORIZE%TYPE := OKE_API.G_MISS_CHAR,
37   penalty_clause_flag 	OKE_K_HEADERS.PENALTY_CLAUSE_FLAG%TYPE := OKE_API.G_MISS_CHAR,
38   product_line_code 	OKE_K_HEADERS.PRODUCT_LINE_CODE%TYPE := OKE_API.G_MISS_CHAR,
39   reporting_flag 	OKE_K_HEADERS.REPORTING_FLAG%TYPE := OKE_API.G_MISS_CHAR,
40   sb_plan_req_flag 	OKE_K_HEADERS.SB_PLAN_REQ_FLAG%TYPE := OKE_API.G_MISS_CHAR,
41   sb_report_flag 	OKE_K_HEADERS.SB_REPORT_FLAG%TYPE := OKE_API.G_MISS_CHAR,
42   nte_amount 		OKE_K_HEADERS.NTE_AMOUNT%TYPE := OKE_API.G_MISS_NUM,
43   nte_warning_flag 	OKE_K_HEADERS.NTE_WARNING_FLAG%TYPE := OKE_API.G_MISS_CHAR,
44   bill_without_def_flag OKE_K_HEADERS.BILL_WITHOUT_DEF_FLAG%TYPE := OKE_API.G_MISS_CHAR,
45   cas_flag		OKE_K_HEADERS.CAS_FLAG%TYPE := OKE_API.G_MISS_CHAR,
46   classified_flag 	OKE_K_HEADERS.CLASSIFIED_FLAG%TYPE := OKE_API.G_MISS_CHAR,
47   client_approve_req_flag OKE_K_HEADERS.CLIENT_APPROVE_REQ_FLAG%TYPE := OKE_API.G_MISS_CHAR,
48   cost_of_money 	OKE_K_HEADERS.COST_OF_MONEY%TYPE := OKE_API.G_MISS_CHAR,
49   dcaa_audit_req_flag 	OKE_K_HEADERS.DCAA_AUDIT_REQ_FLAG%TYPE := OKE_API.G_MISS_CHAR,
50   cost_share_flag 	OKE_K_HEADERS.COST_SHARE_FLAG%TYPE := OKE_API.G_MISS_CHAR,
51   oh_rates_final_flag 	OKE_K_HEADERS.OH_RATES_FINAL_FLAG%TYPE := OKE_API.G_MISS_CHAR,
52   progress_payment_flag OKE_K_HEADERS.PROGRESS_PAYMENT_FLAG%TYPE := OKE_API.G_MISS_CHAR,
53   progress_payment_liq_rate OKE_K_HEADERS.PROGRESS_PAYMENT_LIQ_RATE%TYPE := OKE_API.G_MISS_NUM,
54   progress_payment_rate OKE_K_HEADERS.PROGRESS_PAYMENT_RATE%TYPE := OKE_API.G_MISS_NUM,
55   alternate_liquidation_rate OKE_K_HEADERS.ALTERNATE_LIQUIDATION_RATE%TYPE := OKE_API.G_MISS_NUM,
56   prop_delivery_location 	OKE_K_HEADERS.PROP_DELIVERY_LOCATION%TYPE := OKE_API.G_MISS_CHAR,
57   prop_due_date_time 	OKE_K_HEADERS.PROP_DUE_DATE_TIME%TYPE := OKE_API.G_MISS_DATE,
58   prop_due_time		OKE_K_HEADERS.PROP_DUE_TIME%TYPE := OKE_API.G_MISS_CHAR,
59   prop_expire_date 	OKE_K_HEADERS.PROP_EXPIRE_DATE%TYPE := OKE_API.G_MISS_DATE,
60   copies_required       OKE_K_HEADERS.COPIES_REQUIRED%TYPE := OKE_API.G_MISS_NUM,
61   sic_code 		OKE_K_HEADERS.SIC_CODE%TYPE := OKE_API.G_MISS_CHAR,
62   tech_data_wh_rate 	OKE_K_HEADERS.TECH_DATA_WH_RATE%TYPE := OKE_API.G_MISS_NUM,
63   cost_of_sale_rate     OKE_K_HEADERS.COST_OF_SALE_RATE%TYPE := OKE_API.G_MISS_NUM,
64   financial_ctrl_verified_flag OKE_K_HEADERS.FINANCIAL_CTRL_VERIFIED_FLAG%TYPE := OKE_API.G_MISS_CHAR,
65   definitized_flag		OKE_K_HEADERS.DEFINITIZED_FLAG%TYPE := OKE_API.G_MISS_CHAR,
66   created_by		NUMBER := OKE_API.G_MISS_NUM,
67   creation_date		DATE   := OKE_API.G_MISS_DATE,
68   last_updated_by	NUMBER := OKE_API.G_MISS_NUM,
69   last_update_login	NUMBER := OKE_API.G_MISS_NUM,
70   last_update_date	DATE   := OKE_API.G_MISS_DATE,
71   line_value_total	NUMBER := OKE_API.G_MISS_NUM,
72   undef_line_value_total NUMBER := OKE_API.G_MISS_NUM,
73 --  end_date		DATE  := OKE_API.G_MISS_DATE,
74   owning_organization_id NUMBER := OKE_API.G_MISS_NUM,
75   default_task_id	NUMBER := OKE_API.G_MISS_NUM);
76 
77 
78 g_miss_chr_rec	chr_rec_type;
79 
80 TYPE chr_tbl_type IS TABLE OF chr_rec_type
81   INDEX BY BINARY_INTEGER;
82 
83 -- GLOBAL MESSAGE CONSTANTS
84 
85 G_FND_APP 	CONSTANT VARCHAR2(200) := OKE_API.G_FND_APP;
86 G_FORM_UNABLE_TO_RESERVE_REC  CONSTANT VARCHAR2(200) := OKE_API.G_FORM_UNABLE_TO_RESERVE_REC;
87 G_FORM_RECORD_DELETED	CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_DELETED;
88 G_FORM_RECORD_CHANGED	CONSTANT VARCHAR2(200) := OKE_API.G_FORM_RECORD_CHANGED;
89 G_RECORD_LOGICALLY_DELETED	CONSTANT VARCHAR2(200) := OKE_API.G_RECORD_LOGICALLY_DELETED;
90 G_REQUIRED_VALUE	CONSTANT VARCHAR2(200) := OKE_API.G_REQUIRED_VALUE;
91 G_INVALID_VALUE		CONSTANT VARCHAR2(200) := OKE_API.G_INVALID_VALUE;
92 G_COL_NAME_TOKEN	CONSTANT VARCHAR2(200) := OKE_API.G_COL_NAME_TOKEN;
93 G_PARENT_TABLE_TOKEN	CONSTANT VARCHAR2(200) := OKE_API.G_PARENT_TABLE_TOKEN;
94 G_CHILD_TABLE_TOKEN	CONSTANT VARCHAR2(200) := OKE_API.G_CHILD_TABLE_TOKEN;
95 
96 -- GLOBAL VARIABLES
97 
98 G_PKG_NAME	CONSTANT VARCHAR2(200) := 'OKE_CHR_PVT';
99 G_APP_NAME	CONSTANT VARCHAR2(3) := OKE_API.G_APP_NAME;
100 
101 -- PROCEDURES AND FUNCTIONS
102 
103 PROCEDURE change_version;
104 PROCEDURE api_copy;
105 PROCEDURE insert_row(
106   p_api_version 	IN NUMBER,
107   p_init_msg_list		IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
108   x_return_status	OUT NOCOPY VARCHAR2,
109   x_msg_count		OUT NOCOPY NUMBER,
110   x_msg_data		OUT NOCOPY VARCHAR2,
111   p_chr_rec   		IN chr_rec_type,
112   x_chr_rec		OUT NOCOPY chr_rec_type);
113 
114 PROCEDURE insert_row(
115   p_api_version 	IN NUMBER,
116   p_init_msg_list	IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
117   x_return_status	OUT NOCOPY VARCHAR2,
118   x_msg_count		OUT NOCOPY NUMBER,
119   x_msg_data		OUT NOCOPY VARCHAR2,
120   p_chr_tbl		IN chr_tbl_type,
121   x_chr_tbl		OUT NOCOPY chr_tbl_type);
122 
123 
124 
125 PROCEDURE update_row(
126   p_api_version 	IN NUMBER,
127   p_init_msg_list	        IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
128   x_return_status	OUT NOCOPY VARCHAR2,
129   x_msg_count		OUT NOCOPY NUMBER,
130   x_msg_data		OUT NOCOPY VARCHAR2,
131   p_chr_rec   		IN chr_rec_type,
132   x_chr_rec		OUT NOCOPY chr_rec_type);
133 
134 PROCEDURE update_row(
135   p_api_version 	IN NUMBER,
136   p_init_msg_list		IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
137   x_return_status	OUT NOCOPY VARCHAR2,
138   x_msg_count		OUT NOCOPY NUMBER,
139   x_msg_data		OUT NOCOPY VARCHAR2,
140   p_chr_tbl		IN chr_tbl_type,
141   x_chr_tbl		OUT NOCOPY chr_tbl_type);
142 
143 PROCEDURE delete_row(
144   p_api_version 	IN NUMBER,
145   p_init_msg_list		IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
146   x_return_status	OUT NOCOPY VARCHAR2,
147   x_msg_count		OUT NOCOPY NUMBER,
148   x_msg_data		OUT NOCOPY VARCHAR2,
149   p_chr_rec   		IN chr_rec_type);
150 
151 PROCEDURE delete_row(
152   p_api_version 	IN NUMBER,
153   p_init_msg_list		IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
154   x_return_status	OUT NOCOPY VARCHAR2,
155   x_msg_count		OUT NOCOPY NUMBER,
156   x_msg_data		OUT NOCOPY VARCHAR2,
157   p_chr_tbl		IN chr_tbl_type);
158 
159 PROCEDURE validate_row(
160   p_api_version 	IN NUMBER,
161   p_init_msg_list		IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
162   x_return_status	OUT NOCOPY VARCHAR2,
163   x_msg_count		OUT NOCOPY NUMBER,
164   x_msg_data		OUT NOCOPY VARCHAR2,
165   p_chr_rec   		IN chr_rec_type);
166 
167 PROCEDURE validate_row(
168   p_api_version 	IN NUMBER,
169   p_init_msg_list		IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
170   x_return_status	OUT NOCOPY VARCHAR2,
171   x_msg_count		OUT NOCOPY NUMBER,
172   x_msg_data		OUT NOCOPY VARCHAR2,
173   p_chr_tbl		IN chr_tbl_type);
174 
175 END OKE_CHR_PVT;
176