DBA Data[Home] [Help]

APPS.OZF_RESALE_PVT dependencies on FND_GLOBAL

Line 1273: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);

1269:
1270: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*======================================================================================================*');
1271: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Execution Starts On: ' || to_char(sysdate,'MM-DD-YYYY HH24:MI:SS'));
1272: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '*------------------------------------------------------------------------------------------------------*');
1273: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Request Id : '||FND_GLOBAL.CONC_REQUEST_ID);
1274: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '-------------------------------------------------------------------------------------------------------*');
1275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Resale Batch Id : '||TO_CHAR(p_resale_batch_id));
1276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Start Date : '||p_start_date);
1277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'End Date : '||p_end_date);

Line 1358: AND util.request_id = fnd_global.conc_request_id

1354: ozf_offers off, ozf_resale_adjustments_all oe,
1355: ozf_xref_map map
1356: WHERE line.resale_line_id = util.object_id
1357: AND util.object_type = ''TP_ORDER''
1358: AND util.request_id = fnd_global.conc_request_id
1359: AND util.plan_type = ''OFFR''
1360: AND util.plan_id = off.qp_list_header_id
1361: AND util.price_adjustment_id = oe.resale_adjustment_id
1362: AND util.gl_posted_flag IN (''Y'', ''X'')

Line 1383: AND util.request_id = fnd_global.conc_request_id

1379: ozf_offers off, ozf_resale_adjustments_all oe,
1380: ozf_xref_map map
1381: WHERE line.resale_line_id = util.object_id
1382: AND util.object_type = ''TP_ORDER''
1383: AND util.request_id = fnd_global.conc_request_id
1384: AND util.plan_type = ''OFFR''
1385: AND util.plan_id = off.qp_list_header_id
1386: AND util.price_adjustment_id = oe.resale_adjustment_id
1387: AND util.gl_posted_flag = ''Y''