eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_TP_ACCRUAL_PVT dependencies on FND_GLOBAL

Line 26: --G_CONC_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID;

22: G_PRICING_SIM_EVENT VARCHAR2(30) := FND_PROFILE.value('OZF_PRICING_SIMULATION_EVENT');
23: G_ACCRUAL_ON_SELLING VARCHAR2(1) := FND_PROFILE.value('OZF_ACC_ON_SELLING_PRICE');
24: G_BULK_LIMIT NUMBER := NVL(FND_PROFILE.value('OZF_BULK_LIMIT_SIZE') , 500);
25: G_ALLOW_INTER_COMMIT VARCHAR2(1) := NVL(FND_PROFILE.value('OZF_ALLOW_INTER_COMMIT'), 'Y');
26: --G_CONC_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
27: G_TPM_PROCESS_ENABLED VARCHAR2 (1) := NVL(fnd_profile.VALUE ('OZF_TPM_PROCESS_ENABLED'),'N');
28: G_ORDER_GL_PHASE VARCHAR2 (15) :=NVL(fnd_profile.VALUE ('OZF_ORDER_GLPOST_PHASE'), 'SHIPPED');
29: G_IDSM_PRICING_ADJ_BASIS VARCHAR2 (15) :=NVL(fnd_profile.VALUE ('OZF_IDSM_PRICING_ADJ_BASIS'), 'ORDER_DATE');
30:

Line 4759: AND request_id = FND_GLOBAL.CONC_REQUEST_ID

4755: p_currency_code VARCHAR2) IS
4756: SELECT MIN(date_ordered), MAX(date_ordered)
4757: FROM ozf_resale_lines_int_all
4758: WHERE sold_from_cust_account_id = p_account_id
4759: AND request_id = FND_GLOBAL.CONC_REQUEST_ID
4760: AND org_id = p_org_id
4761: AND currency_code = p_currency_code;
4762:
4763: l_start_date date;

Line 4793: ,NVL (fnd_global.user_id, -1) CREATED_BY

4789: ,logs.column_name COLUMN_NAME
4790: ,logs.column_value COLUMN_VALUE
4791: ,logs.org_id ORG_ID
4792: ,SYSDATE CREATION_DATE
4793: ,NVL (fnd_global.user_id, -1) CREATED_BY
4794: ,SYSDATE LAST_UPDATE_DATE
4795: ,NVL (fnd_global.user_id, -1) LAST_UPDATED_BY
4796: ,NVL (fnd_global.conc_login_id, -1) LAST_UPDATE_LOGIN
4797: ,OZF_TP_ACCRUAL_PVT.G_CONC_REQUEST_ID REQUEST_ID

Line 4795: ,NVL (fnd_global.user_id, -1) LAST_UPDATED_BY

4791: ,logs.org_id ORG_ID
4792: ,SYSDATE CREATION_DATE
4793: ,NVL (fnd_global.user_id, -1) CREATED_BY
4794: ,SYSDATE LAST_UPDATE_DATE
4795: ,NVL (fnd_global.user_id, -1) LAST_UPDATED_BY
4796: ,NVL (fnd_global.conc_login_id, -1) LAST_UPDATE_LOGIN
4797: ,OZF_TP_ACCRUAL_PVT.G_CONC_REQUEST_ID REQUEST_ID
4798: ,fnd_global.prog_appl_id PROGRAM_APPLICATION_ID
4799: ,fnd_global.conc_program_id PROGRAM_ID

Line 4796: ,NVL (fnd_global.conc_login_id, -1) LAST_UPDATE_LOGIN

4792: ,SYSDATE CREATION_DATE
4793: ,NVL (fnd_global.user_id, -1) CREATED_BY
4794: ,SYSDATE LAST_UPDATE_DATE
4795: ,NVL (fnd_global.user_id, -1) LAST_UPDATED_BY
4796: ,NVL (fnd_global.conc_login_id, -1) LAST_UPDATE_LOGIN
4797: ,OZF_TP_ACCRUAL_PVT.G_CONC_REQUEST_ID REQUEST_ID
4798: ,fnd_global.prog_appl_id PROGRAM_APPLICATION_ID
4799: ,fnd_global.conc_program_id PROGRAM_ID
4800: ,SYSDATE PROGRAM_UPDATE_DATE

Line 4798: ,fnd_global.prog_appl_id PROGRAM_APPLICATION_ID

4794: ,SYSDATE LAST_UPDATE_DATE
4795: ,NVL (fnd_global.user_id, -1) LAST_UPDATED_BY
4796: ,NVL (fnd_global.conc_login_id, -1) LAST_UPDATE_LOGIN
4797: ,OZF_TP_ACCRUAL_PVT.G_CONC_REQUEST_ID REQUEST_ID
4798: ,fnd_global.prog_appl_id PROGRAM_APPLICATION_ID
4799: ,fnd_global.conc_program_id PROGRAM_ID
4800: ,SYSDATE PROGRAM_UPDATE_DATE
4801: FROM ozf_resale_logs_all logs, ozf_resale_lines_int_draft_all intDraft -- Fix for Bug 14584673
4802: WHERE logs.resale_id = intDraft.resale_line_int_id

Line 4799: ,fnd_global.conc_program_id PROGRAM_ID

4795: ,NVL (fnd_global.user_id, -1) LAST_UPDATED_BY
4796: ,NVL (fnd_global.conc_login_id, -1) LAST_UPDATE_LOGIN
4797: ,OZF_TP_ACCRUAL_PVT.G_CONC_REQUEST_ID REQUEST_ID
4798: ,fnd_global.prog_appl_id PROGRAM_APPLICATION_ID
4799: ,fnd_global.conc_program_id PROGRAM_ID
4800: ,SYSDATE PROGRAM_UPDATE_DATE
4801: FROM ozf_resale_logs_all logs, ozf_resale_lines_int_draft_all intDraft -- Fix for Bug 14584673
4802: WHERE logs.resale_id = intDraft.resale_line_int_id
4803: AND intDraft.draft_run_id = l_draft_run_id

Line 4862: ozf_utility_PVT.debug_message('source code is null, id:' || FND_GLOBAL.CONC_REQUEST_ID );

4858: p_data_source_code = 'ALL' THEN
4859:
4860: IF p_data_source_code is null THEN
4861: IF OZF_DEBUG_LOW_ON THEN
4862: ozf_utility_PVT.debug_message('source code is null, id:' || FND_GLOBAL.CONC_REQUEST_ID );
4863: END IF;
4864: ELSE
4865: IF OZF_DEBUG_LOW_ON THEN
4866: ozf_utility_PVT.debug_message('source code is '|| p_data_source_code||', id:' || FND_GLOBAL.CONC_REQUEST_ID );

Line 4866: ozf_utility_PVT.debug_message('source code is '|| p_data_source_code||', id:' || FND_GLOBAL.CONC_REQUEST_ID );

4862: ozf_utility_PVT.debug_message('source code is null, id:' || FND_GLOBAL.CONC_REQUEST_ID );
4863: END IF;
4864: ELSE
4865: IF OZF_DEBUG_LOW_ON THEN
4866: ozf_utility_PVT.debug_message('source code is '|| p_data_source_code||', id:' || FND_GLOBAL.CONC_REQUEST_ID );
4867: END IF;
4868: END IF;
4869:
4870: UPDATE ozf_resale_lines_int_all

Line 4873: , program_application_id = FND_GLOBAL.PROG_APPL_ID

4869:
4870: UPDATE ozf_resale_lines_int_all
4871: SET request_id = G_CONC_REQUEST_ID
4872: , dispute_code = null
4873: , program_application_id = FND_GLOBAL.PROG_APPL_ID
4874: , program_update_date = SYSDATE
4875: , program_id = FND_GLOBAL.CONC_PROGRAM_ID
4876: WHERE resale_batch_id IS NULL
4877: AND request_id IS NULL

Line 4875: , program_id = FND_GLOBAL.CONC_PROGRAM_ID

4871: SET request_id = G_CONC_REQUEST_ID
4872: , dispute_code = null
4873: , program_application_id = FND_GLOBAL.PROG_APPL_ID
4874: , program_update_date = SYSDATE
4875: , program_id = FND_GLOBAL.CONC_PROGRAM_ID
4876: WHERE resale_batch_id IS NULL
4877: AND request_id IS NULL
4878: AND org_id = l_org_id; -- nepanda : Fix for bug # 15900683
4879:

Line 4882: ozf_utility_PVT.debug_message('source code is '|| p_data_source_code||', id:' || FND_GLOBAL.CONC_REQUEST_ID );

4878: AND org_id = l_org_id; -- nepanda : Fix for bug # 15900683
4879:
4880: ELSE
4881: IF OZF_DEBUG_LOW_ON THEN
4882: ozf_utility_PVT.debug_message('source code is '|| p_data_source_code||', id:' || FND_GLOBAL.CONC_REQUEST_ID );
4883: END IF;
4884:
4885: UPDATE ozf_resale_lines_int_all
4886: SET request_id = G_CONC_REQUEST_ID

Line 4888: , program_application_id = FND_GLOBAL.PROG_APPL_ID

4884:
4885: UPDATE ozf_resale_lines_int_all
4886: SET request_id = G_CONC_REQUEST_ID
4887: , dispute_code = null
4888: , program_application_id = FND_GLOBAL.PROG_APPL_ID
4889: , program_update_date = SYSDATE
4890: , program_id = FND_GLOBAL.CONC_PROGRAM_ID
4891: WHERE resale_batch_id IS NULL
4892: AND data_source_code = p_data_source_code

Line 4890: , program_id = FND_GLOBAL.CONC_PROGRAM_ID

4886: SET request_id = G_CONC_REQUEST_ID
4887: , dispute_code = null
4888: , program_application_id = FND_GLOBAL.PROG_APPL_ID
4889: , program_update_date = SYSDATE
4890: , program_id = FND_GLOBAL.CONC_PROGRAM_ID
4891: WHERE resale_batch_id IS NULL
4892: AND data_source_code = p_data_source_code
4893: AND request_id IS NULL
4894: AND org_id = l_org_id; -- nepanda : Fix for bug # 15900683

Line 4982: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),

4978: OZF_RESALE_BATCHES_PKG.Insert_Row(
4979: px_resale_batch_id => l_resale_batch_id,
4980: px_object_version_number => l_obj_number,
4981: p_last_update_date => SYSdate,
4982: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
4983: p_creation_date => SYSdate,
4984: p_request_id => G_CONC_REQUEST_ID,
4985: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4986: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),

Line 4985: p_created_by => NVL(FND_GLOBAL.user_id,-1),

4981: p_last_update_date => SYSdate,
4982: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
4983: p_creation_date => SYSdate,
4984: p_request_id => G_CONC_REQUEST_ID,
4985: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4986: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
4987: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
4988: p_program_update_date => SYSdate,
4989: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,

Line 4986: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),

4982: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
4983: p_creation_date => SYSdate,
4984: p_request_id => G_CONC_REQUEST_ID,
4985: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4986: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
4987: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
4988: p_program_update_date => SYSdate,
4989: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
4990: p_created_from => l_created_from,

Line 4987: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,

4983: p_creation_date => SYSdate,
4984: p_request_id => G_CONC_REQUEST_ID,
4985: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4986: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
4987: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
4988: p_program_update_date => SYSdate,
4989: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
4990: p_created_from => l_created_from,
4991: p_batch_number => l_resale_batch_number,

Line 4989: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,

4985: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4986: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
4987: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
4988: p_program_update_date => SYSdate,
4989: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
4990: p_created_from => l_created_from,
4991: p_batch_number => l_resale_batch_number,
4992: p_batch_type => OZF_RESALE_COMMON_PVT.G_TP_ACCRUAL,
4993: p_batch_count => NULL,