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_SD_BATCH_PVT dependencies on FND_GLOBAL

Line 1339: last_updated_by = FND_GLOBAL.USER_ID,

1335: UPDATE ozf_sd_batch_headers_all
1336: SET status_code = 'CLOSED',
1337: claim_id = l_claim_id,
1338: last_update_date = sysdate,
1339: last_updated_by = FND_GLOBAL.USER_ID,
1340: object_version_number = object_version_number + 1
1341: WHERE batch_id = l_batch_id;
1342: ELSE
1343: UPDATE ozf_sd_batch_headers_all

Line 1346: last_updated_by = FND_GLOBAL.USER_ID,

1342: ELSE
1343: UPDATE ozf_sd_batch_headers_all
1344: SET status_code = 'PENDING_CLAIM',
1345: last_update_date = sysdate,
1346: last_updated_by = FND_GLOBAL.USER_ID,
1347: object_version_number = object_version_number + 1
1348: WHERE batch_id = l_batch_id;
1349:
1350: IF OZF_DEBUG_HIGH_ON THEN

Line 1610: FND_GLOBAL.USER_ID, --las_updated_by

1606: 'D', -- Value can be Debit or Credit. defaulted to Credit
1607: p_batch_status, --NEW for new batch and APPROVED for child batch
1608: sysdate,
1609: sysdate,
1610: FND_GLOBAL.USER_ID, --las_updated_by
1611: FND_GLOBAL.CONC_REQUEST_ID, --? conc program id
1612: FND_GLOBAL.USER_ID, --created by
1613: null, --created from --??
1614: FND_GLOBAL.CONC_LOGIN_ID, -- last_update_login

Line 1611: FND_GLOBAL.CONC_REQUEST_ID, --? conc program id

1607: p_batch_status, --NEW for new batch and APPROVED for child batch
1608: sysdate,
1609: sysdate,
1610: FND_GLOBAL.USER_ID, --las_updated_by
1611: FND_GLOBAL.CONC_REQUEST_ID, --? conc program id
1612: FND_GLOBAL.USER_ID, --created by
1613: null, --created from --??
1614: FND_GLOBAL.CONC_LOGIN_ID, -- last_update_login
1615: FND_GLOBAL.PROG_APPL_ID, -- program app id

Line 1612: FND_GLOBAL.USER_ID, --created by

1608: sysdate,
1609: sysdate,
1610: FND_GLOBAL.USER_ID, --las_updated_by
1611: FND_GLOBAL.CONC_REQUEST_ID, --? conc program id
1612: FND_GLOBAL.USER_ID, --created by
1613: null, --created from --??
1614: FND_GLOBAL.CONC_LOGIN_ID, -- last_update_login
1615: FND_GLOBAL.PROG_APPL_ID, -- program app id
1616: sysdate,

Line 1614: FND_GLOBAL.CONC_LOGIN_ID, -- last_update_login

1610: FND_GLOBAL.USER_ID, --las_updated_by
1611: FND_GLOBAL.CONC_REQUEST_ID, --? conc program id
1612: FND_GLOBAL.USER_ID, --created by
1613: null, --created from --??
1614: FND_GLOBAL.CONC_LOGIN_ID, -- last_update_login
1615: FND_GLOBAL.PROG_APPL_ID, -- program app id
1616: sysdate,
1617: FND_GLOBAL.CONC_PROGRAM_ID, --program id
1618: null, --l_transfer_type to be updated when batch is exported

Line 1615: FND_GLOBAL.PROG_APPL_ID, -- program app id

1611: FND_GLOBAL.CONC_REQUEST_ID, --? conc program id
1612: FND_GLOBAL.USER_ID, --created by
1613: null, --created from --??
1614: FND_GLOBAL.CONC_LOGIN_ID, -- last_update_login
1615: FND_GLOBAL.PROG_APPL_ID, -- program app id
1616: sysdate,
1617: FND_GLOBAL.CONC_PROGRAM_ID, --program id
1618: null, --l_transfer_type to be updated when batch is exported
1619: l_org_id, --default batch Org ID

Line 1617: FND_GLOBAL.CONC_PROGRAM_ID, --program id

1613: null, --created from --??
1614: FND_GLOBAL.CONC_LOGIN_ID, -- last_update_login
1615: FND_GLOBAL.PROG_APPL_ID, -- program app id
1616: sysdate,
1617: FND_GLOBAL.CONC_PROGRAM_ID, --program id
1618: null, --l_transfer_type to be updated when batch is exported
1619: l_org_id, --default batch Org ID
1620: p_parent_batch_id,
1621: p_batch_type,

Line 1622: NVL(p_owner,OZF_UTILITY_PVT.get_resource_id(FND_GLOBAL.USER_ID)),

1618: null, --l_transfer_type to be updated when batch is exported
1619: l_org_id, --default batch Org ID
1620: p_parent_batch_id,
1621: p_batch_type,
1622: NVL(p_owner,OZF_UTILITY_PVT.get_resource_id(FND_GLOBAL.USER_ID)),
1623: l_ssd_imd_claim_flag -- added for ER 13245462
1624: );
1625: END Create_Batch_Header;
1626:

Line 2299: to_char(FND_GLOBAL.USER_ID) || '*' ||

2295: to_char(l_fund_req_amount_remaining) || '*' ||
2296: to_char(l_amount_remaining) || '*' ||
2297: to_char('Y') || '*' || to_char(l_order_date) || '*' ||
2298: to_char(sysdate) || '*' || to_char(sysdate) || '*' ||
2299: to_char(FND_GLOBAL.USER_ID) || '*' ||
2300: to_char(FND_GLOBAL.CONC_REQUEST_ID) || '*' ||
2301: to_char(FND_GLOBAL.USER_ID) || '*' ||
2302: to_char(FND_GLOBAL.CONC_LOGIN_ID) || '*' ||
2303: to_char(FND_GLOBAL.PROG_APPL_ID) || '*' ||

Line 2300: to_char(FND_GLOBAL.CONC_REQUEST_ID) || '*' ||

2296: to_char(l_amount_remaining) || '*' ||
2297: to_char('Y') || '*' || to_char(l_order_date) || '*' ||
2298: to_char(sysdate) || '*' || to_char(sysdate) || '*' ||
2299: to_char(FND_GLOBAL.USER_ID) || '*' ||
2300: to_char(FND_GLOBAL.CONC_REQUEST_ID) || '*' ||
2301: to_char(FND_GLOBAL.USER_ID) || '*' ||
2302: to_char(FND_GLOBAL.CONC_LOGIN_ID) || '*' ||
2303: to_char(FND_GLOBAL.PROG_APPL_ID) || '*' ||
2304: to_char(null) || '*' ||

Line 2301: to_char(FND_GLOBAL.USER_ID) || '*' ||

2297: to_char('Y') || '*' || to_char(l_order_date) || '*' ||
2298: to_char(sysdate) || '*' || to_char(sysdate) || '*' ||
2299: to_char(FND_GLOBAL.USER_ID) || '*' ||
2300: to_char(FND_GLOBAL.CONC_REQUEST_ID) || '*' ||
2301: to_char(FND_GLOBAL.USER_ID) || '*' ||
2302: to_char(FND_GLOBAL.CONC_LOGIN_ID) || '*' ||
2303: to_char(FND_GLOBAL.PROG_APPL_ID) || '*' ||
2304: to_char(null) || '*' ||
2305: to_char(FND_GLOBAL.CONC_PROGRAM_ID) || '*' ||

Line 2302: to_char(FND_GLOBAL.CONC_LOGIN_ID) || '*' ||

2298: to_char(sysdate) || '*' || to_char(sysdate) || '*' ||
2299: to_char(FND_GLOBAL.USER_ID) || '*' ||
2300: to_char(FND_GLOBAL.CONC_REQUEST_ID) || '*' ||
2301: to_char(FND_GLOBAL.USER_ID) || '*' ||
2302: to_char(FND_GLOBAL.CONC_LOGIN_ID) || '*' ||
2303: to_char(FND_GLOBAL.PROG_APPL_ID) || '*' ||
2304: to_char(null) || '*' ||
2305: to_char(FND_GLOBAL.CONC_PROGRAM_ID) || '*' ||
2306: to_char(l_org_id) || '*' ||

Line 2303: to_char(FND_GLOBAL.PROG_APPL_ID) || '*' ||

2299: to_char(FND_GLOBAL.USER_ID) || '*' ||
2300: to_char(FND_GLOBAL.CONC_REQUEST_ID) || '*' ||
2301: to_char(FND_GLOBAL.USER_ID) || '*' ||
2302: to_char(FND_GLOBAL.CONC_LOGIN_ID) || '*' ||
2303: to_char(FND_GLOBAL.PROG_APPL_ID) || '*' ||
2304: to_char(null) || '*' ||
2305: to_char(FND_GLOBAL.CONC_PROGRAM_ID) || '*' ||
2306: to_char(l_org_id) || '*' ||
2307: to_char(l_inv_org_id) || '*' ||

Line 2305: to_char(FND_GLOBAL.CONC_PROGRAM_ID) || '*' ||

2301: to_char(FND_GLOBAL.USER_ID) || '*' ||
2302: to_char(FND_GLOBAL.CONC_LOGIN_ID) || '*' ||
2303: to_char(FND_GLOBAL.PROG_APPL_ID) || '*' ||
2304: to_char(null) || '*' ||
2305: to_char(FND_GLOBAL.CONC_PROGRAM_ID) || '*' ||
2306: to_char(l_org_id) || '*' ||
2307: to_char(l_inv_org_id) || '*' ||
2308: to_char(l_approved_discount_type) || '*' ||
2309: to_char(l_approved_discount_value) || '*' ||

Line 2441: FND_GLOBAL.USER_ID, --l_last_updated_by,

2437: 'N', -- l_active_flag
2438: l_order_date, -- from OE order lines/header
2439: sysdate, --l_creation_date,
2440: sysdate, --l_last_update_date,
2441: FND_GLOBAL.USER_ID, --l_last_updated_by,
2442: FND_GLOBAL.CONC_REQUEST_ID, --l_request_id,
2443: FND_GLOBAL.USER_ID, --l_created_by,
2444: --l_created_from,
2445: FND_GLOBAL.CONC_LOGIN_ID, --l_last_update_login,

Line 2442: FND_GLOBAL.CONC_REQUEST_ID, --l_request_id,

2438: l_order_date, -- from OE order lines/header
2439: sysdate, --l_creation_date,
2440: sysdate, --l_last_update_date,
2441: FND_GLOBAL.USER_ID, --l_last_updated_by,
2442: FND_GLOBAL.CONC_REQUEST_ID, --l_request_id,
2443: FND_GLOBAL.USER_ID, --l_created_by,
2444: --l_created_from,
2445: FND_GLOBAL.CONC_LOGIN_ID, --l_last_update_login,
2446: FND_GLOBAL.PROG_APPL_ID, --l_program_application_id,

Line 2443: FND_GLOBAL.USER_ID, --l_created_by,

2439: sysdate, --l_creation_date,
2440: sysdate, --l_last_update_date,
2441: FND_GLOBAL.USER_ID, --l_last_updated_by,
2442: FND_GLOBAL.CONC_REQUEST_ID, --l_request_id,
2443: FND_GLOBAL.USER_ID, --l_created_by,
2444: --l_created_from,
2445: FND_GLOBAL.CONC_LOGIN_ID, --l_last_update_login,
2446: FND_GLOBAL.PROG_APPL_ID, --l_program_application_id,
2447: null, --l_program_update_date,

Line 2445: FND_GLOBAL.CONC_LOGIN_ID, --l_last_update_login,

2441: FND_GLOBAL.USER_ID, --l_last_updated_by,
2442: FND_GLOBAL.CONC_REQUEST_ID, --l_request_id,
2443: FND_GLOBAL.USER_ID, --l_created_by,
2444: --l_created_from,
2445: FND_GLOBAL.CONC_LOGIN_ID, --l_last_update_login,
2446: FND_GLOBAL.PROG_APPL_ID, --l_program_application_id,
2447: null, --l_program_update_date,
2448: FND_GLOBAL.CONC_PROGRAM_ID, --l_program_id,
2449: l_inv_org_id,

Line 2446: FND_GLOBAL.PROG_APPL_ID, --l_program_application_id,

2442: FND_GLOBAL.CONC_REQUEST_ID, --l_request_id,
2443: FND_GLOBAL.USER_ID, --l_created_by,
2444: --l_created_from,
2445: FND_GLOBAL.CONC_LOGIN_ID, --l_last_update_login,
2446: FND_GLOBAL.PROG_APPL_ID, --l_program_application_id,
2447: null, --l_program_update_date,
2448: FND_GLOBAL.CONC_PROGRAM_ID, --l_program_id,
2449: l_inv_org_id,
2450: 'Y',

Line 2448: FND_GLOBAL.CONC_PROGRAM_ID, --l_program_id,

2444: --l_created_from,
2445: FND_GLOBAL.CONC_LOGIN_ID, --l_last_update_login,
2446: FND_GLOBAL.PROG_APPL_ID, --l_program_application_id,
2447: null, --l_program_update_date,
2448: FND_GLOBAL.CONC_PROGRAM_ID, --l_program_id,
2449: l_inv_org_id,
2450: 'Y',
2451:
2452: l_approved_discount_type,

Line 3142: to_char(FND_GLOBAL.USER_ID) || '*' ||

3138: to_char(l_fund_req_amount_remaining) || '*' ||
3139: to_char(l_amount_remaining) || '*' ||
3140: to_char('Y') || '*' || to_char(l_order_date) || '*' ||
3141: to_char(sysdate) || '*' || to_char(sysdate) || '*' ||
3142: to_char(FND_GLOBAL.USER_ID) || '*' ||
3143: to_char(FND_GLOBAL.CONC_REQUEST_ID) || '*' ||
3144: to_char(FND_GLOBAL.USER_ID) || '*' ||
3145: to_char(FND_GLOBAL.CONC_LOGIN_ID) || '*' ||
3146: to_char(FND_GLOBAL.PROG_APPL_ID) || '*' ||

Line 3143: to_char(FND_GLOBAL.CONC_REQUEST_ID) || '*' ||

3139: to_char(l_amount_remaining) || '*' ||
3140: to_char('Y') || '*' || to_char(l_order_date) || '*' ||
3141: to_char(sysdate) || '*' || to_char(sysdate) || '*' ||
3142: to_char(FND_GLOBAL.USER_ID) || '*' ||
3143: to_char(FND_GLOBAL.CONC_REQUEST_ID) || '*' ||
3144: to_char(FND_GLOBAL.USER_ID) || '*' ||
3145: to_char(FND_GLOBAL.CONC_LOGIN_ID) || '*' ||
3146: to_char(FND_GLOBAL.PROG_APPL_ID) || '*' ||
3147: to_char(null) || '*' ||

Line 3144: to_char(FND_GLOBAL.USER_ID) || '*' ||

3140: to_char('Y') || '*' || to_char(l_order_date) || '*' ||
3141: to_char(sysdate) || '*' || to_char(sysdate) || '*' ||
3142: to_char(FND_GLOBAL.USER_ID) || '*' ||
3143: to_char(FND_GLOBAL.CONC_REQUEST_ID) || '*' ||
3144: to_char(FND_GLOBAL.USER_ID) || '*' ||
3145: to_char(FND_GLOBAL.CONC_LOGIN_ID) || '*' ||
3146: to_char(FND_GLOBAL.PROG_APPL_ID) || '*' ||
3147: to_char(null) || '*' ||
3148: to_char(FND_GLOBAL.CONC_PROGRAM_ID) || '*' ||

Line 3145: to_char(FND_GLOBAL.CONC_LOGIN_ID) || '*' ||

3141: to_char(sysdate) || '*' || to_char(sysdate) || '*' ||
3142: to_char(FND_GLOBAL.USER_ID) || '*' ||
3143: to_char(FND_GLOBAL.CONC_REQUEST_ID) || '*' ||
3144: to_char(FND_GLOBAL.USER_ID) || '*' ||
3145: to_char(FND_GLOBAL.CONC_LOGIN_ID) || '*' ||
3146: to_char(FND_GLOBAL.PROG_APPL_ID) || '*' ||
3147: to_char(null) || '*' ||
3148: to_char(FND_GLOBAL.CONC_PROGRAM_ID) || '*' ||
3149: to_char(l_org_id) || '*' ||

Line 3146: to_char(FND_GLOBAL.PROG_APPL_ID) || '*' ||

3142: to_char(FND_GLOBAL.USER_ID) || '*' ||
3143: to_char(FND_GLOBAL.CONC_REQUEST_ID) || '*' ||
3144: to_char(FND_GLOBAL.USER_ID) || '*' ||
3145: to_char(FND_GLOBAL.CONC_LOGIN_ID) || '*' ||
3146: to_char(FND_GLOBAL.PROG_APPL_ID) || '*' ||
3147: to_char(null) || '*' ||
3148: to_char(FND_GLOBAL.CONC_PROGRAM_ID) || '*' ||
3149: to_char(l_org_id) || '*' ||
3150: to_char(l_inv_org_id) || '*' ||

Line 3148: to_char(FND_GLOBAL.CONC_PROGRAM_ID) || '*' ||

3144: to_char(FND_GLOBAL.USER_ID) || '*' ||
3145: to_char(FND_GLOBAL.CONC_LOGIN_ID) || '*' ||
3146: to_char(FND_GLOBAL.PROG_APPL_ID) || '*' ||
3147: to_char(null) || '*' ||
3148: to_char(FND_GLOBAL.CONC_PROGRAM_ID) || '*' ||
3149: to_char(l_org_id) || '*' ||
3150: to_char(l_inv_org_id) || '*' ||
3151: to_char(l_approved_discount_type) || '*' ||
3152: to_char(l_approved_discount_value) || '*' ||

Line 3284: FND_GLOBAL.USER_ID, --l_last_updated_by,

3280: 'N', -- l_active_flag
3281: l_order_date, -- from OE order lines/header
3282: sysdate, --l_creation_date,
3283: sysdate, --l_last_update_date,
3284: FND_GLOBAL.USER_ID, --l_last_updated_by,
3285: FND_GLOBAL.CONC_REQUEST_ID, --l_request_id,
3286: FND_GLOBAL.USER_ID, --l_created_by,
3287: --l_created_from,
3288: FND_GLOBAL.CONC_LOGIN_ID, --l_last_update_login,

Line 3285: FND_GLOBAL.CONC_REQUEST_ID, --l_request_id,

3281: l_order_date, -- from OE order lines/header
3282: sysdate, --l_creation_date,
3283: sysdate, --l_last_update_date,
3284: FND_GLOBAL.USER_ID, --l_last_updated_by,
3285: FND_GLOBAL.CONC_REQUEST_ID, --l_request_id,
3286: FND_GLOBAL.USER_ID, --l_created_by,
3287: --l_created_from,
3288: FND_GLOBAL.CONC_LOGIN_ID, --l_last_update_login,
3289: FND_GLOBAL.PROG_APPL_ID, --l_program_application_id,

Line 3286: FND_GLOBAL.USER_ID, --l_created_by,

3282: sysdate, --l_creation_date,
3283: sysdate, --l_last_update_date,
3284: FND_GLOBAL.USER_ID, --l_last_updated_by,
3285: FND_GLOBAL.CONC_REQUEST_ID, --l_request_id,
3286: FND_GLOBAL.USER_ID, --l_created_by,
3287: --l_created_from,
3288: FND_GLOBAL.CONC_LOGIN_ID, --l_last_update_login,
3289: FND_GLOBAL.PROG_APPL_ID, --l_program_application_id,
3290: null, --l_program_update_date,

Line 3288: FND_GLOBAL.CONC_LOGIN_ID, --l_last_update_login,

3284: FND_GLOBAL.USER_ID, --l_last_updated_by,
3285: FND_GLOBAL.CONC_REQUEST_ID, --l_request_id,
3286: FND_GLOBAL.USER_ID, --l_created_by,
3287: --l_created_from,
3288: FND_GLOBAL.CONC_LOGIN_ID, --l_last_update_login,
3289: FND_GLOBAL.PROG_APPL_ID, --l_program_application_id,
3290: null, --l_program_update_date,
3291: FND_GLOBAL.CONC_PROGRAM_ID, --l_program_id,
3292: l_inv_org_id,

Line 3289: FND_GLOBAL.PROG_APPL_ID, --l_program_application_id,

3285: FND_GLOBAL.CONC_REQUEST_ID, --l_request_id,
3286: FND_GLOBAL.USER_ID, --l_created_by,
3287: --l_created_from,
3288: FND_GLOBAL.CONC_LOGIN_ID, --l_last_update_login,
3289: FND_GLOBAL.PROG_APPL_ID, --l_program_application_id,
3290: null, --l_program_update_date,
3291: FND_GLOBAL.CONC_PROGRAM_ID, --l_program_id,
3292: l_inv_org_id,
3293: 'Y',

Line 3291: FND_GLOBAL.CONC_PROGRAM_ID, --l_program_id,

3287: --l_created_from,
3288: FND_GLOBAL.CONC_LOGIN_ID, --l_last_update_login,
3289: FND_GLOBAL.PROG_APPL_ID, --l_program_application_id,
3290: null, --l_program_update_date,
3291: FND_GLOBAL.CONC_PROGRAM_ID, --l_program_id,
3292: l_inv_org_id,
3293: 'Y',
3294:
3295: l_approved_discount_type,

Line 3374: last_updated_by = FND_GLOBAL.USER_ID,

3370: plan_curr_amount_remaining = 0,
3371: univ_curr_amount_remaining = 0,
3372: fund_request_amount_remaining = 0,
3373: last_update_date = sysdate,
3374: last_updated_by = FND_GLOBAL.USER_ID,
3375: object_version_number = object_version_number + 1
3376: WHERE utilization_id in
3377: (SELECT utilization_id
3378: FROM ozf_sd_batch_lines_all

Line 3530: last_updated_by = FND_GLOBAL.USER_ID,

3526: UPDATE OZF_SD_BATCH_HEADERS_ALL
3527: SET status_code = 'CLOSED',
3528: claim_id = l_claim_id,
3529: last_update_date = sysdate,
3530: last_updated_by = FND_GLOBAL.USER_ID,
3531: object_version_number = object_version_number + 1
3532: WHERE batch_id = l_batch_id;
3533:
3534: OZF_SD_UTIL_PVT.SD_RAISE_EVENT(l_batch_id, 'CLAIM', l_return_status); -- Raising lifecycle event for claim

Line 3830: last_updated_by = fnd_global.user_id

3826: END
3827: ),
3828: object_version_number = object_version_number + 1,
3829: last_update_date = sysdate,
3830: last_updated_by = fnd_global.user_id
3831: WHERE batch_id = batch_rec.batch_id
3832: AND batch_line_number IN (SELECT BLN.BATCH_LINE_NUMBER
3833: FROM ozf_sd_batch_lines_all BLN,
3834: ozf_funds_utilized_all_b FU

Line 3889: last_updated_by = FND_GLOBAL.USER_ID,

3885: UPDATE OZF_SD_BATCH_HEADERS_ALL
3886: SET status_code = 'CLOSED',
3887: claim_id = l_claim_id,
3888: last_update_date = sysdate,
3889: last_updated_by = FND_GLOBAL.USER_ID,
3890: object_version_number = object_version_number + 1
3891: WHERE batch_id = batch_rec.BATCH_ID
3892: AND status_code = 'PENDING_CLAIM';
3893:

Line 3902: last_updated_by = fnd_global.user_id,

3898: ROLLBACK TO BEFORE_INVOKE_CLAIM;
3899: UPDATE ozf_sd_batch_headers_all
3900: SET status_code = 'PENDING_CLAIM',
3901: last_update_date = sysdate,
3902: last_updated_by = fnd_global.user_id,
3903: object_version_number = object_version_number + 1
3904: WHERE batch_id = batch_rec.BATCH_ID;
3905: END IF;
3906:

Line 3916: last_updated_by = fnd_global.user_id,

3912: ROLLBACK TO BEFORE_INVOKE_CLAIM;
3913: UPDATE ozf_sd_batch_headers_all
3914: SET status_code = 'PENDING_CLAIM',
3915: last_update_date = sysdate,
3916: last_updated_by = fnd_global.user_id,
3917: object_version_number = object_version_number + 1
3918: WHERE batch_id = batch_rec.BATCH_ID;
3919: END IF;
3920: