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.OZF_ADJUSTMENT_EXT_PVT dependencies on OZF_ACTBUDGETS_PVT

Line 682: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

678: l_error_location NUMBER;
679: l_line_ctr NUMBER := 1;
680: l_adj_amount NUMBER := 0;
681:
682: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
683: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
684: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
685: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
686: l_order_line_tbl order_line_tbl_type;

Line 683: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;

679: l_line_ctr NUMBER := 1;
680: l_adj_amount NUMBER := 0;
681:
682: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
683: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
684: l_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
685: l_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
686: l_order_line_tbl order_line_tbl_type;
687:

Line 1220: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

1216: WHERE org_id = p_org_id;
1217:
1218:
1219: l_offer_info c_offer_info%ROWTYPE;
1220: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1221: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
1222: l_cust_number NUMBER;
1223: l_order_line_tbl order_line_tbl_type;
1224: l_req_line_attrs_tbl qp_runtime_source.accum_req_line_attrs_tbl;

Line 1221: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;

1217:
1218:
1219: l_offer_info c_offer_info%ROWTYPE;
1220: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
1221: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
1222: l_cust_number NUMBER;
1223: l_order_line_tbl order_line_tbl_type;
1224: l_req_line_attrs_tbl qp_runtime_source.accum_req_line_attrs_tbl;
1225: l_index NUMBER := 1;

Line 4225: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

4221: l_volume_type VARCHAR2(30);
4222: l_msg_data VARCHAR2 (2000) := NULL;
4223: l_msg_count NUMBER;
4224: l_apply_discount VARCHAR2(1);
4225: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
4226: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
4227: l_adj_amount NUMBER;
4228: l_utilization_amount NUMBER;
4229: l_act_budget_id NUMBER;

Line 4226: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;

4222: l_msg_data VARCHAR2 (2000) := NULL;
4223: l_msg_count NUMBER;
4224: l_apply_discount VARCHAR2(1);
4225: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
4226: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
4227: l_adj_amount NUMBER;
4228: l_utilization_amount NUMBER;
4229: l_act_budget_id NUMBER;
4230: l_conv_type ozf_funds_utilized_all_b.exchange_rate_type%TYPE;

Line 4882: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

4878:
4879: l_api_name CONSTANT VARCHAR2(30) := 'Process_SSD_Result';
4880: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
4881: l_return_status VARCHAR2(30);
4882: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
4883: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
4884: l_offer_info c_offer_info%ROWTYPE;
4885: l_created_from_adjustments VARCHAR2(2);
4886: l_cust_number NUMBER;

Line 4883: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;

4879: l_api_name CONSTANT VARCHAR2(30) := 'Process_SSD_Result';
4880: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
4881: l_return_status VARCHAR2(30);
4882: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
4883: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
4884: l_offer_info c_offer_info%ROWTYPE;
4885: l_created_from_adjustments VARCHAR2(2);
4886: l_cust_number NUMBER;
4887: l_util_amount NUMBER;

Line 5390: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

5386:
5387: l_api_name CONSTANT VARCHAR2(30) := 'Process_Result';
5388: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
5389: l_return_status VARCHAR2(30);
5390: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
5391: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
5392: l_offer_info c_offer_info%ROWTYPE;
5393: l_created_from_adjustments VARCHAR2(2);
5394: l_cust_number NUMBER;

Line 5391: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;

5387: l_api_name CONSTANT VARCHAR2(30) := 'Process_Result';
5388: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
5389: l_return_status VARCHAR2(30);
5390: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
5391: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
5392: l_offer_info c_offer_info%ROWTYPE;
5393: l_created_from_adjustments VARCHAR2(2);
5394: l_cust_number NUMBER;
5395: l_util_amount NUMBER;

Line 5748: l_act_budgets_rec OZF_ACTBUDGETS_PVT.act_budgets_rec_type;

5744: l_return_status VARCHAR2(30);
5745: l_object_type VARCHAR2(30);
5746: l_has_error BOOLEAN := FALSE;
5747: l_is_valid_offer BOOLEAN;
5748: l_act_budgets_rec OZF_ACTBUDGETS_PVT.act_budgets_rec_type;
5749: l_act_util_rec OZF_ACTBUDGETS_PVT.act_util_rec_type;
5750:
5751:
5752: BEGIN

Line 5749: l_act_util_rec OZF_ACTBUDGETS_PVT.act_util_rec_type;

5745: l_object_type VARCHAR2(30);
5746: l_has_error BOOLEAN := FALSE;
5747: l_is_valid_offer BOOLEAN;
5748: l_act_budgets_rec OZF_ACTBUDGETS_PVT.act_budgets_rec_type;
5749: l_act_util_rec OZF_ACTBUDGETS_PVT.act_util_rec_type;
5750:
5751:
5752: BEGIN
5753: -- Debug Message

Line 5985: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

5981: x_msg_count OUT NOCOPY NUMBER,
5982: x_msg_data OUT NOCOPY VARCHAR2
5983: ) IS
5984: l_act_budget_id NUMBER;
5985: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
5986: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
5987: l_return_status VARCHAR2 (1);
5988: l_util_amount NUMBER;
5989: l_api_name VARCHAR2 (50) := 'perform_adjustment';

Line 5986: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;

5982: x_msg_data OUT NOCOPY VARCHAR2
5983: ) IS
5984: l_act_budget_id NUMBER;
5985: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
5986: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
5987: l_return_status VARCHAR2 (1);
5988: l_util_amount NUMBER;
5989: l_api_name VARCHAR2 (50) := 'perform_adjustment';
5990: l_full_name CONSTANT VARCHAR2 (90) := g_pkg_name

Line 6929: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,

6925: ----------------------------------------------------------------------
6926: PROCEDURE process_accrual (
6927: p_earned_amt IN NUMBER,
6928: p_qp_list_header_id IN NUMBER,
6929: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
6930: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type:= NULL,
6931: x_return_status OUT NOCOPY VARCHAR2,
6932: x_msg_count OUT NOCOPY NUMBER,
6933: x_msg_data OUT NOCOPY VARCHAR2);

Line 6930: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type:= NULL,

6926: PROCEDURE process_accrual (
6927: p_earned_amt IN NUMBER,
6928: p_qp_list_header_id IN NUMBER,
6929: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
6930: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type:= NULL,
6931: x_return_status OUT NOCOPY VARCHAR2,
6932: x_msg_count OUT NOCOPY NUMBER,
6933: x_msg_data OUT NOCOPY VARCHAR2);
6934:

Line 7105: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,

7101: ----------------------------------------------------------------------
7102: PROCEDURE process_accrual (
7103: p_earned_amt IN NUMBER,
7104: p_qp_list_header_id IN NUMBER,
7105: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
7106: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type := NULL,
7107: x_return_status OUT NOCOPY VARCHAR2,
7108: x_msg_count OUT NOCOPY NUMBER,
7109: x_msg_data OUT NOCOPY VARCHAR2

Line 7106: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type := NULL,

7102: PROCEDURE process_accrual (
7103: p_earned_amt IN NUMBER,
7104: p_qp_list_header_id IN NUMBER,
7105: p_act_util_rec IN ozf_actbudgets_pvt.act_util_rec_type,
7106: p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type := NULL,
7107: x_return_status OUT NOCOPY VARCHAR2,
7108: x_msg_count OUT NOCOPY NUMBER,
7109: x_msg_data OUT NOCOPY VARCHAR2
7110: ) IS

Line 7114: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type := p_act_budgets_rec;

7110: ) IS
7111: l_fund_amt_tbl ozf_accrual_engine.ozf_fund_amt_tbl_type;
7112: l_api_name VARCHAR2(30):= 'process_accrual';
7113: l_full_name VARCHAR2(60):= g_pkg_name ||'.'||l_api_name||' : ' ;
7114: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type := p_act_budgets_rec;
7115: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type := p_act_util_rec;
7116: l_earned_amount NUMBER;
7117: l_old_earned_amount NUMBER;
7118: l_header_id NUMBER; -- order or invoice id

Line 7115: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type := p_act_util_rec;

7111: l_fund_amt_tbl ozf_accrual_engine.ozf_fund_amt_tbl_type;
7112: l_api_name VARCHAR2(30):= 'process_accrual';
7113: l_full_name VARCHAR2(60):= g_pkg_name ||'.'||l_api_name||' : ' ;
7114: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type := p_act_budgets_rec;
7115: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type := p_act_util_rec;
7116: l_earned_amount NUMBER;
7117: l_old_earned_amount NUMBER;
7118: l_header_id NUMBER; -- order or invoice id
7119: l_line_id NUMBER; -- order or invoice id

Line 7970: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;

7966: l_old_operator VARCHAR2(30);
7967: y1 NUMBER; -- Initial Adjsutment
7968: l_current_max_tier NUMBER;
7969: l_current_min_tier NUMBER;
7970: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type ;
7971: l_adj_amount NUMBER;
7972: l_volume_type VARCHAR2(30);
7973: l_current_tier_value NUMBER;
7974: l_total NUMBER;

Line 9174: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;

9170: l_invoice_to_org_id NUMBER;
9171: l_ship_to_org_id NUMBER;
9172: l_cust_number NUMBER;
9173: l_act_budget_id NUMBER;
9174: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
9175: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
9176: l_offer_info c_offer_info%ROWTYPE;
9177: l_order_line_info c_order_line_info%ROWTYPE;
9178: l_amountTbl amountTbl ;

Line 9175: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;

9171: l_ship_to_org_id NUMBER;
9172: l_cust_number NUMBER;
9173: l_act_budget_id NUMBER;
9174: l_act_budgets_rec ozf_actbudgets_pvt.act_budgets_rec_type;
9175: l_act_util_rec ozf_actbudgets_pvt.act_util_rec_type;
9176: l_offer_info c_offer_info%ROWTYPE;
9177: l_order_line_info c_order_line_info%ROWTYPE;
9178: l_amountTbl amountTbl ;
9179: l_objectTypeTbl objectTypeTbl ;