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:
28: ---------------------------------------------------------------------
29: -- FUNCTION
30: -- is_valid_offer

Line 3907: AND request_id = FND_GLOBAL.CONC_REQUEST_ID

3903: p_currency_code VARCHAR2) IS
3904: SELECT MIN(date_ordered), MAX(date_ordered)
3905: FROM ozf_resale_lines_int_all
3906: WHERE sold_from_cust_account_id = p_account_id
3907: AND request_id = FND_GLOBAL.CONC_REQUEST_ID
3908: AND org_id = p_org_id
3909: AND currency_code = p_currency_code;
3910:
3911: l_start_date date;

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

3949: p_data_source_code = 'ALL' THEN
3950:
3951: IF p_data_source_code is null THEN
3952: IF OZF_DEBUG_LOW_ON THEN
3953: ozf_utility_PVT.debug_message('source code is null, id:' || FND_GLOBAL.CONC_REQUEST_ID );
3954: END IF;
3955: ELSE
3956: IF OZF_DEBUG_LOW_ON THEN
3957: ozf_utility_PVT.debug_message('source code is '|| p_data_source_code||', id:' || FND_GLOBAL.CONC_REQUEST_ID );

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

3953: ozf_utility_PVT.debug_message('source code is null, id:' || FND_GLOBAL.CONC_REQUEST_ID );
3954: END IF;
3955: ELSE
3956: IF OZF_DEBUG_LOW_ON THEN
3957: ozf_utility_PVT.debug_message('source code is '|| p_data_source_code||', id:' || FND_GLOBAL.CONC_REQUEST_ID );
3958: END IF;
3959: END IF;
3960: UPDATE ozf_resale_lines_int_all
3961: SET request_id = G_CONC_REQUEST_ID

Line 3963: , program_application_id = FND_GLOBAL.PROG_APPL_ID

3959: END IF;
3960: UPDATE ozf_resale_lines_int_all
3961: SET request_id = G_CONC_REQUEST_ID
3962: , dispute_code = null
3963: , program_application_id = FND_GLOBAL.PROG_APPL_ID
3964: , program_update_date = SYSDATE
3965: , program_id = FND_GLOBAL.CONC_PROGRAM_ID
3966: WHERE resale_batch_id IS NULL
3967: AND request_id IS NULL

Line 3965: , program_id = FND_GLOBAL.CONC_PROGRAM_ID

3961: SET request_id = G_CONC_REQUEST_ID
3962: , dispute_code = null
3963: , program_application_id = FND_GLOBAL.PROG_APPL_ID
3964: , program_update_date = SYSDATE
3965: , program_id = FND_GLOBAL.CONC_PROGRAM_ID
3966: WHERE resale_batch_id IS NULL
3967: AND request_id IS NULL
3968: AND org_id = MO_GLOBAL.get_current_org_id();
3969:

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

3968: AND org_id = MO_GLOBAL.get_current_org_id();
3969:
3970: ELSE
3971: IF OZF_DEBUG_LOW_ON THEN
3972: ozf_utility_PVT.debug_message('source code is '|| p_data_source_code||', id:' || FND_GLOBAL.CONC_REQUEST_ID );
3973: END IF;
3974: UPDATE ozf_resale_lines_int_all
3975: SET request_id = G_CONC_REQUEST_ID
3976: , dispute_code = null

Line 3977: , program_application_id = FND_GLOBAL.PROG_APPL_ID

3973: END IF;
3974: UPDATE ozf_resale_lines_int_all
3975: SET request_id = G_CONC_REQUEST_ID
3976: , dispute_code = null
3977: , program_application_id = FND_GLOBAL.PROG_APPL_ID
3978: , program_update_date = SYSDATE
3979: , program_id = FND_GLOBAL.CONC_PROGRAM_ID
3980: WHERE resale_batch_id IS NULL
3981: AND data_source_code = p_data_source_code

Line 3979: , program_id = FND_GLOBAL.CONC_PROGRAM_ID

3975: SET request_id = G_CONC_REQUEST_ID
3976: , dispute_code = null
3977: , program_application_id = FND_GLOBAL.PROG_APPL_ID
3978: , program_update_date = SYSDATE
3979: , program_id = FND_GLOBAL.CONC_PROGRAM_ID
3980: WHERE resale_batch_id IS NULL
3981: AND data_source_code = p_data_source_code
3982: AND request_id IS NULL
3983: AND org_id = MO_GLOBAL.get_current_org_id();

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

4044: OZF_RESALE_BATCHES_PKG.Insert_Row(
4045: px_resale_batch_id => l_resale_batch_id,
4046: px_object_version_number => l_obj_number,
4047: p_last_update_date => SYSdate,
4048: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
4049: p_creation_date => SYSdate,
4050: p_request_id => G_CONC_REQUEST_ID,
4051: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4052: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),

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

4047: p_last_update_date => SYSdate,
4048: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
4049: p_creation_date => SYSdate,
4050: p_request_id => G_CONC_REQUEST_ID,
4051: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4052: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
4053: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
4054: p_program_update_date => SYSdate,
4055: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,

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

4048: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
4049: p_creation_date => SYSdate,
4050: p_request_id => G_CONC_REQUEST_ID,
4051: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4052: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
4053: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
4054: p_program_update_date => SYSdate,
4055: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
4056: p_created_from => l_created_from,

Line 4053: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,

4049: p_creation_date => SYSdate,
4050: p_request_id => G_CONC_REQUEST_ID,
4051: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4052: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
4053: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
4054: p_program_update_date => SYSdate,
4055: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
4056: p_created_from => l_created_from,
4057: p_batch_number => l_resale_batch_number,

Line 4055: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,

4051: p_created_by => NVL(FND_GLOBAL.user_id,-1),
4052: p_last_update_login => NVL(FND_GLOBAL.conc_login_id,-1),
4053: p_program_application_id => FND_GLOBAL.PROG_APPL_ID,
4054: p_program_update_date => SYSdate,
4055: p_program_id => FND_GLOBAL.CONC_PROGRAM_ID,
4056: p_created_from => l_created_from,
4057: p_batch_number => l_resale_batch_number,
4058: p_batch_type => OZF_RESALE_COMMON_PVT.G_TP_ACCRUAL,
4059: p_batch_count => NULL,