APPS.OZF_ACCRUAL_ENGINE dependencies on DBMS_XMLGEN

Line 5702: l_budget_data := DBMS_XMLGEN.getXml('SELECT ''FUND'' AccrualType,

5698: l_item_key := 'ACCRUAL_INFO' || TO_CHAR(SYSDATE,'DDMMRRRRHH24MISS');
5699: l_parameter_list := WF_PARAMETER_LIST_T();
5700:
5701:
5702: l_budget_data := DBMS_XMLGEN.getXml('SELECT ''FUND'' AccrualType,
5703: util.utilization_id UtilizationId,
5704: util.fund_id FundId,
5705: NVL(map.xref_line_id_value,oe.list_line_id) DiscountLineId,
5706: util.product_id ProductId,

Line 5728: l_offer_data := DBMS_XMLGEN.getXml('SELECT ''OFFR'' AccrualType,

5724: AND NVL(line.invoiced_quantity, NVL(line.shipped_quantity, 0)) <> 0
5725: AND NVL(off.budget_offer_yn, ''N'') = ''Y''', 0);
5726:
5727:
5728: l_offer_data := DBMS_XMLGEN.getXml('SELECT ''OFFR'' AccrualType,
5729: util.utilization_id UtilizationId,
5730: util.plan_id PromotionId,
5731: util.fund_id FundId,
5732: NVL(map.xref_line_id_value,oe.list_line_id) DiscountLineId,