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.OKL_SUBSIDY_POOL_PVT dependencies on OKL_SUBSIDY_POOLS_B

Line 24: -- table OKL_SUBSIDY_POOLS_B AND OKL_SUBSIDY_POOLS_TL

20: -- Start of comments
21: --
22: -- Procedure Name : create_sub_pool
23: -- Description : procedure for inserting the records in
24: -- table OKL_SUBSIDY_POOLS_B AND OKL_SUBSIDY_POOLS_TL
25: -- Business Rules : This procedure creates a subsidy pool with the status "new"
26: -- in the table OKL_SUBSIDY_POOLS_B.
27: -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
28: -- x_msg_data, p_sub_pool_rec, x_sub_pool_rec.

Line 26: -- in the table OKL_SUBSIDY_POOLS_B.

22: -- Procedure Name : create_sub_pool
23: -- Description : procedure for inserting the records in
24: -- table OKL_SUBSIDY_POOLS_B AND OKL_SUBSIDY_POOLS_TL
25: -- Business Rules : This procedure creates a subsidy pool with the status "new"
26: -- in the table OKL_SUBSIDY_POOLS_B.
27: -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
28: -- x_msg_data, p_sub_pool_rec, x_sub_pool_rec.
29: -- Version : 1.0
30: -- End of comments

Line 49: -- table OKL_SUBSIDY_POOLS_B AND OKL_SUBSIDY_POOLS_TL

45: -- Start of comments
46: --
47: -- Procedure Name : update_sub_pool
48: -- Description : procedure for updating the records in
49: -- table OKL_SUBSIDY_POOLS_B AND OKL_SUBSIDY_POOLS_TL
50: -- Business Rules : Procedure to update the subsidy pool.
51: -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
52: -- x_msg_data, p_sub_pool_rec, x_sub_pool_rec.
53: -- Version : 1.0

Line 72: -- table OKL_SUBSIDY_POOLS_B then set its status to expire.

68: -- Start of comments
69: --
70: -- Procedure Name : expire_sub_pool
71: -- Description : procedure for validating that if the records exist in the
72: -- table OKL_SUBSIDY_POOLS_B then set its status to expire.
73: -- Business Rules : This procedure sets the pool status to "expire"and this is
74: -- an autonomous transaction.
75: -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
76: -- x_msg_data, p_subsidy_pool_id.

Line 86: p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE);

82: p_init_msg_list IN VARCHAR2,
83: x_return_status OUT NOCOPY VARCHAR2,
84: x_msg_count OUT NOCOPY NUMBER,
85: x_msg_data OUT NOCOPY VARCHAR2,
86: p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE);
87:
88: ---------------------------------------------------------------------------
89: -- PROCEDURE update_total_budget
90: ---------------------------------------------------------------------------

Line 95: -- table OKL_SUBSIDY_POOLS_B.

91: -- Start of comments
92: --
93: -- Procedure Name : update_total_budget
94: -- Description : procedure for updating the total budget amount
95: -- table OKL_SUBSIDY_POOLS_B.
96: -- Business Rules : As soon as any of the budget line attached to a subsisy pool gets
97: -- approved this procedure is called to update the total budgets of the pool
98: -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
99: -- x_msg_data, p_subsidy_pool_id,p_total_budget_amt.

Line 109: p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE,

105: p_init_msg_list IN VARCHAR2,
106: x_return_status OUT NOCOPY VARCHAR2,
107: x_msg_count OUT NOCOPY NUMBER,
108: x_msg_data OUT NOCOPY VARCHAR2,
109: p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE,
110: p_total_budget_amt IN okl_subsidy_pools_b.total_budgets%TYPE );
111:
112: ---------------------------------------------------------------------------
113: -- PROCEDURE update_subsidy_amount

Line 110: p_total_budget_amt IN okl_subsidy_pools_b.total_budgets%TYPE );

106: x_return_status OUT NOCOPY VARCHAR2,
107: x_msg_count OUT NOCOPY NUMBER,
108: x_msg_data OUT NOCOPY VARCHAR2,
109: p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE,
110: p_total_budget_amt IN okl_subsidy_pools_b.total_budgets%TYPE );
111:
112: ---------------------------------------------------------------------------
113: -- PROCEDURE update_subsidy_amount
114: ---------------------------------------------------------------------------

Line 119: -- table OKL_SUBSIDY_POOLS_B.

115: -- Start of comments
116: --
117: -- Procedure Name : update_subsidy_amount
118: -- Description : procedure for updating the total subsidy amount
119: -- table OKL_SUBSIDY_POOLS_B.
120: -- Business Rules : subsidy amount is updated when the contract is booked, rebooked or a
121: -- quote is created, or a contract is reversed.
122: -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
123: -- x_msg_data, p_subsidy_pool_id, p_total_subsidy_amt.

Line 133: p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE,

129: p_init_msg_list IN VARCHAR2,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,
133: p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE,
134: p_total_subsidy_amt IN okl_subsidy_pools_b.total_subsidy_amount%TYPE);
135:
136: ---------------------------------------------------------------------------
137: -- PROCEDURE set_decision_status_code

Line 134: p_total_subsidy_amt IN okl_subsidy_pools_b.total_subsidy_amount%TYPE);

130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,
133: p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE,
134: p_total_subsidy_amt IN okl_subsidy_pools_b.total_subsidy_amount%TYPE);
135:
136: ---------------------------------------------------------------------------
137: -- PROCEDURE set_decision_status_code
138: ---------------------------------------------------------------------------

Line 143: -- table OKL_SUBSIDY_POOLS_B.

139: -- Start of comments
140: --
141: -- Procedure Name : set_decision_status_code
142: -- Description : procedure for updating the decision status code
143: -- table OKL_SUBSIDY_POOLS_B.
144: -- Business Rules : Procedure sets the decision_status_code to the value passed to this procedure.
145: -- this is a status of a pool.
146: -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
147: -- x_msg_data, p_subsidy_pool_id,p_decision_status_code.

Line 157: p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE,

153: p_init_msg_list IN VARCHAR2,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE,
158: p_decision_status_code IN OUT NOCOPY okl_subsidy_pools_b.decision_status_code%TYPE);
159:
160: ---------------------------------------------------------------------------
161: -- PROCEDURE validate_sub_pool

Line 158: p_decision_status_code IN OUT NOCOPY okl_subsidy_pools_b.decision_status_code%TYPE);

154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE,
158: p_decision_status_code IN OUT NOCOPY okl_subsidy_pools_b.decision_status_code%TYPE);
159:
160: ---------------------------------------------------------------------------
161: -- PROCEDURE validate_sub_pool
162: ---------------------------------------------------------------------------

Line 167: -- table OKL_SUBSIDY_POOLS_B AND OKL_SUBSIDY_POOLS_TL

163: -- Start of comments
164: --
165: -- Procedure Name : validate_sub_pool
166: -- Description : procedure for validating the records in
167: -- table OKL_SUBSIDY_POOLS_B AND OKL_SUBSIDY_POOLS_TL
168: -- Business Rules : Validates the record passed to it.
169: -- Parameters : p_api_version, p_init_msg_list, x_return_status, x_msg_count,
170: -- x_msg_data, p_sub_pool_rec.
171: -- Version : 1.0