APPS.OZF_TP_ACCRUAL_PVT dependencies on DBMS_XMLGEN

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

5823: IF G_TPM_PROCESS_ENABLED = 'Y' THEN
5824: l_item_key := 'ACCRUAL_INFO' || TO_CHAR(SYSDATE,'DDMMRRRRHH24MISS');
5825: l_parameter_list := WF_PARAMETER_LIST_T();
5826:
5827: l_budget_data := DBMS_XMLGEN.getXml('SELECT ''FUND'' AccrualType,
5828: util.utilization_id UtilizationId,
5829: util.fund_id FundId,
5830: NVL(map.xref_line_id_value,oe.list_line_id) DiscountLineId,
5831: util.product_id ProductId,

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

5845: AND util.price_adjustment_id = oe.resale_adjustment_id
5846: AND util.gl_posted_flag IN (''Y'', ''X'')
5847: AND oe.list_line_id = map.list_line_id(+)
5848: AND NVL(off.budget_offer_yn, ''N'') = ''Y''', 0);
5849: l_offer_data := DBMS_XMLGEN.getXml('SELECT ''OFFR'' AccrualType,
5850: util.utilization_id UtilizationId,
5851: util.plan_id PromotionId,
5852: util.fund_id FundId,
5853: NVL(map.xref_line_id_value,oe.list_line_id) DiscountLineId,