APPS.OZF_RESALE_PVT dependencies on DBMS_XMLGEN

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

1339: --//ER 13333298
1340: IF G_TPM_PROCESS_ENABLED = 'Y' THEN
1341: l_item_key := 'ACCRUAL_INFO' || TO_CHAR(SYSDATE,'DDMMRRRRHH24MISS');
1342: l_parameter_list := WF_PARAMETER_LIST_T();
1343: l_budget_data := DBMS_XMLGEN.getXml('SELECT ''FUND'' AccrualType,
1344: util.utilization_id UtilizationId,
1345: util.fund_id FundId,
1346: NVL(map.xref_line_id_value,oe.list_line_id) DiscountLineId,
1347: util.product_id ProductId,

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

1362: AND util.gl_posted_flag IN (''Y'', ''X'')
1363: AND oe.list_line_id = map.list_line_id(+)
1364: AND NVL(off.budget_offer_yn, ''N'') = ''Y''', 0);
1365:
1366: l_offer_data := DBMS_XMLGEN.getXml('SELECT ''OFFR'' AccrualType,
1367: util.utilization_id UtilizationId,
1368: util.plan_id PromotionId,
1369: util.fund_id FundId,
1370: NVL(map.xref_line_id_value,oe.list_line_id) DiscountLineId,