1 package GMS_COST_PLUS_EXTN as
2 /* $Header: gmscpexs.pls 120.2 2005/10/23 05:11:32 rshaik noship $ */
3
4 PROCEDURE get_award_ind_rate_sch_rev_id(x_award_id IN Number,
5 x_task_id IN Number, -- Bug 2097676: Multiple IDC Build
6 x_exp_item_date IN Date,
7 x_rate_sch_rev_id IN OUT NOCOPY Number,
8 x_status IN OUT NOCOPY Number,
9 x_stage IN OUT NOCOPY Number);
10
11 --- PRAGMA RESTRICT_REFERENCES(get_award_ind_rate_sch_rev_id, WNDS, WNPS); /* commented as per 3786374 */
12
13 FUNCTION get_award_cmt_compiled_set_id
14 ( x_task_id IN NUMBER,
15 x_expenditure_item_date IN DATE,
16 p_expenditure_type IN VARCHAR2, --Bug 3003584
17 x_organization_id IN NUMBER,
18 x_schedule_type IN VARCHAR2,
19 x_award_id IN NUMBER)
20 RETURN NUMBER;
21 --- PRAGMA RESTRICT_REFERENCES(get_award_cmt_compiled_set_id, WNDS, WNPS); /* commented as per 3786374 */
22
23 -- Bug : 2557041 - Added p_mode parameter , This parameter is used to
24 -- restrict creation of burden adjustments in check funds mode
25
26 -- R12 Funds Management Uptake : Added p_partial_flag parameter to fail packet having exceptional
27 -- records based on the FULL/PARTIAL MODE.
28 FUNCTION update_bc_pkt_burden_raw_cost(x_packet_id IN NUMBER,
29 p_mode IN VARCHAR2,
30 p_partial_flag IN VARCHAR2 DEFAULT 'N') return boolean;
31 -- returns TRUE if success, FALSE if failure;
32
33 FUNCTION update_source_burden_raw_cost(x_packet_id in number, p_mode varchar2, p_partial_flag varchar2) return boolean;
34 -- returns TRUE if success, FALSE if failure;
35
36 -- Added for Bug:1331903
37 FUNCTION get_award_compiled_set_id( x_doc_type in VARCHAR2,
38 x_distribution_id in NUMBER,
39 x_distribution_line_number in NUMBER default NULL ) RETURN number ;
40
41 FUNCTION get_burdenable_raw_cost( x_doc_type in VARCHAR2,
42 x_distribution_id in NUMBER,
43 x_distribution_line_number in NUMBER default NULL ) RETURN number;
44
45 Function is_spon_project(x_project_id IN NUMBER ) RETURN number;
46
47 FUNCTION award_cmt_compiled_set_id
48 ( x_document_header_id IN NUMBER,
49 x_document_distribution_id IN NUMBER,
50 x_task_id IN NUMBER,
51 x_document_type IN VARCHAR2,
52 x_expenditure_item_date IN DATE,
53 p_expenditure_type IN VARCHAR2,--Bug 3003584
54 x_organization_id IN NUMBER,
55 x_schedule_type IN VARCHAR2,
56 x_award_id IN NUMBER)
57
58 RETURN NUMBER ;
59
60
61 -- ********************************************************************************
62 -- BUG: 1808115 - AP prepayment apply/unapply missing award and Award distribution
63 -- Following code is fixing the burden aspect of the new award distribution.
64 -- ********************************************************************************
65
66 PROCEDURE CALC_prepayment_burden( X_AP_REC ap_invoice_distributions_all%ROWTYPE ,
67 X_adl_rec gms_award_distributions%ROWTYPE ) ;
68
69 -----------------------------------------------------------------------------------------------
70 -- This procedure is used to update top_task_id and parent_resource_id for interface programs
71 -- Bug 2143160
72 -----------------------------------------------------------------------------------------------
73 Procedure update_top_tsk_par_res (x_packet_id IN NUMBER);
74
75 -- ------------------------------------------------------------------------------------------------
76 -- Update expenditure_category and revenue category on gms_bc_packets because of change in RLMI API.
77 -- Update person_id,job_id,vendor_id columns on gms_bc_packets.
78 -- This is done before setup_rlmi is called Bug 2143160
79 -- ------------------------------------------------------------------------------------------------
80 PROCEDURE update_exp_rev_cat (x_packet_id IN NUMBER);
81
82 -- ------------------------------------------------------------------------------------------------
83 -- Following function is used to check if the transaction source allows burdening
84 -- Function called in update_bc_pkt_burden_raw_cost and calc_exp_burden
85 -- -----------------------------------------------------------------------------------------------
86 FUNCTION burden_allowed(p_transaction_source VARCHAR2) RETURN VARCHAR2;
87 PRAGMA RESTRICT_REFERENCES(burden_allowed, WNDS, WNPS);
88
89 END GMS_COST_PLUS_EXTN;