APPS.OZF_ACCRUAL_ENGINE dependencies on OZF_FUNDS_ALL_B

Line 230: FROM ozf_funds_all_b

226: WHERE qp_list_header_id = p_src_id;
227: -- cursor for accrual fund
228: CURSOR c_fund IS
229: SELECT fund_id , currency_code_tc
230: FROM ozf_funds_all_b
231: WHERE plan_id = p_src_id;
232:
233: /* yzhao: 10/03/2003 fix bug 3156515 - PROMOTIONAL GOODS OFFER EXCEEDS THE BUDGET AMOUNT
234: get utilized amount.

Line 947: FROM ozf_funds_all_b

943: ,NVL(liability_flag, 'N')
944: -- yzhao: 11.5.10
945: ,utilized_amt
946: ,rollup_utilized_amt
947: FROM ozf_funds_all_b
948: WHERE fund_id = p_fund_id;
949:
950: /* R12: yzhao bug 4669269 - obsolete ozf_mc_transactions
951: CURSOR c_mc_trans(p_fund_id IN NUMBER) IS

Line 988: FROM ozf_funds_all_b

984: ,rollup_committed_amt
985: ,rollup_recal_committed
986: -- yzhao: 11.5.10
987: ,rollup_utilized_amt
988: FROM ozf_funds_all_b
989: connect by prior parent_fund_id =fund_id
990: start with fund_id = p_fund_id;
991:
992: /* 10/14/2003 yzhao Fix TEVA bug - customer fully accrual budget committed amount is always 0

Line 1042: ,ozf_funds_all_b fun

1038: -- yzhao: 11.5.10 check if post to gl for off invoice discount
1039: CURSOR c_fund_sob(p_fund_id IN NUMBER) IS
1040: SELECT sob.set_of_books_id, fun.ORG_id, NVL(sob.gl_acct_for_offinv_flag, 'F')
1041: FROM ozf_sys_parameters_all sob
1042: ,ozf_funds_all_b fun
1043: WHERE fun.fund_id = p_fund_id
1044: AND sob.org_id = fun.ORG_id ;
1045: */
1046:

Line 1051: ozf_funds_all_b fun

1047: --nirprasa, for bug 7654383. removed fund's org_id
1048: CURSOR c_fund_ledger(p_fund_id IN NUMBER) IS
1049: SELECT fun.ledger_id
1050: FROM gl_sets_of_books sob,
1051: ozf_funds_all_b fun
1052: where sob.set_of_books_id = fun.ledger_id
1053: and fun.fund_id = p_fund_id;
1054:
1055: CURSOR c_offinv_flag(p_org_id IN NUMBER) IS

Line 2057: UPDATE ozf_funds_all_b

2053: -- end R12 changes
2054: END IF; */
2055: END IF; -- end of fund_type.
2056:
2057: UPDATE ozf_funds_all_b
2058: SET original_budget = l_original_budget,
2059: utilized_amt = l_utilized_amt,
2060: earned_amt = l_earned_amt,
2061: paid_amt = l_paid_amt,

Line 2078: UPDATE ozf_funds_all_b

2074:
2075: IF l_parent_fund_id is NOT NULL THEN
2076: FOR fund IN c_parent(l_parent_fund_id)
2077: LOOP
2078: UPDATE ozf_funds_all_b
2079: SET object_version_number = fund.object_version_number + 1
2080: ,rollup_original_budget = NVL(fund.rollup_original_budget,0) + NVL(l_new_orig_amt,0)
2081: ,rollup_earned_amt = NVL(fund.rollup_earned_amt,0) + NVL(l_new_earned_amt,0)
2082: ,rollup_paid_amt = NVL(fund.rollup_paid_amt,0) + NVL(l_new_paid_amt,0)

Line 5846: FROM ozf_funds_all_b

5842: WHERE org_id = p_org_id;
5843:
5844: CURSOR c_get_fund (p_fund_id IN NUMBER) IS
5845: SELECT object_version_number, parent_fund_id, currency_code_tc,liability_flag,accrual_basis
5846: FROM ozf_funds_all_b
5847: WHERE fund_id = p_fund_id;
5848:
5849: /* R12: yzhao bug 4669269 - obsolete ozf_mc_transactions
5850: CURSOR c_mc_trans(p_fund_id IN NUMBER) IS

Line 5861: FROM ozf_funds_all_b

5857:
5858: CURSOR c_parent (p_fund_id IN NUMBER)IS
5859: SELECT fund_id
5860: ,object_version_number
5861: FROM ozf_funds_all_b
5862: connect by prior parent_fund_id =fund_id
5863: start with fund_id = p_fund_id;
5864:
5865: -- rimehrot: for R12 update ozf_object_fund_summary table

Line 6111: UPDATE ozf_funds_all_b

6107: -- end R12 changes
6108:
6109: END IF; -- p_util_utilization_type = 'SALES_ACCRUAL'
6110:
6111: UPDATE ozf_funds_all_b
6112: SET original_budget = NVL(original_budget, 0) + NVL(l_orig_amt, 0)
6113: ,rollup_original_budget = NVL(rollup_original_budget, 0) + NVL(l_rollup_orig_amt, 0)
6114: ,earned_amt = NVL(earned_amt, 0) + NVL(l_earned_amt, 0)
6115: ,paid_amt = NVL(paid_amt, 0 ) + NVL(l_paid_amt, 0)

Line 6125: UPDATE ozf_funds_all_b

6121:
6122: IF l_parent_fund_id is NOT NULL THEN
6123: FOR fund IN c_parent(l_parent_fund_id)
6124: LOOP
6125: UPDATE ozf_funds_all_b
6126: SET object_version_number = fund.object_version_number + 1
6127: ,rollup_earned_amt = NVL(rollup_earned_amt,0) + NVL(l_new_univ_amt,0)
6128: ,rollup_paid_amt = NVL(rollup_paid_amt,0) + NVL(l_rollup_paid_amt,0)
6129: ,rollup_original_budget = NVL(rollup_original_budget,0) + NVL(l_rollup_orig_amt,0)

Line 6753: FROM ozf_funds_all_b

6749:
6750: CURSOR c_parent (p_fund_id IN NUMBER)IS
6751: SELECT fund_id
6752: ,object_version_number
6753: FROM ozf_funds_all_b
6754: connect by prior parent_fund_id =fund_id
6755: start with fund_id = p_fund_id;
6756:
6757: CURSOR c_get_fund (p_fund_id IN NUMBER) IS

Line 6759: FROM ozf_funds_all_b

6755: start with fund_id = p_fund_id;
6756:
6757: CURSOR c_get_fund (p_fund_id IN NUMBER) IS
6758: SELECT object_version_number, parent_fund_id,liability_flag,accrual_basis
6759: FROM ozf_funds_all_b
6760: WHERE fund_id = p_fund_id;
6761:
6762: CURSOR c_act_budget_rec(p_plan_id IN NUMBER) IS
6763: SELECT activity_budget_id

Line 7028: UPDATE ozf_funds_all_b

7024: l_orig_amt := NVL(l_conv_amount,0) - NVL(p_amount,0);
7025: l_rollup_orig_amt := NVL(l_conv_univ_amount,0) - NVL(p_univ_curr_amount, 0);
7026: END IF;
7027:
7028: UPDATE ozf_funds_all_b
7029: SET original_budget = NVL(original_budget, 0) + l_orig_amt
7030: ,rollup_original_budget = NVL(rollup_original_budget, 0) + l_rollup_orig_amt
7031: ,earned_amt = NVL(earned_amt, 0) + NVL(l_conv_amount, 0)- NVL(p_amount, 0)
7032: ,paid_amt = NVL(paid_amt, 0 ) + NVL(l_paid_conv_amt, 0) - NVL(l_paid_amt, 0)

Line 7043: UPDATE ozf_funds_all_b

7039:
7040: IF l_parent_fund_id is NOT NULL THEN
7041: FOR fund IN c_parent(l_parent_fund_id)
7042: LOOP
7043: UPDATE ozf_funds_all_b
7044: SET object_version_number = fund.object_version_number + 1
7045: ,rollup_earned_amt = NVL(rollup_earned_amt,0) + l_rollup_orig_amt
7046:
7047: ,rollup_paid_amt = NVL(rollup_paid_amt,0) + NVL(l_rollup_paid_amt,0)