DBA Data[Home] [Help]

APPS.OZF_SD_BATCH_PVT dependencies on FND_GLOBAL

Line 1077: last_updated_by = FND_GLOBAL.USER_ID,

1073: UPDATE ozf_sd_batch_headers_all
1074: SET status_code = 'CLOSED',
1075: claim_id = l_claim_id,
1076: last_update_date = sysdate,
1077: last_updated_by = FND_GLOBAL.USER_ID,
1078: object_version_number = object_version_number + 1
1079: WHERE batch_id = l_batch_id;
1080: ELSE
1081: IF OZF_DEBUG_HIGH_ON THEN

Line 1273: FND_GLOBAL.USER_ID, --las_updated_by

1269: 'D', -- Value can be Debit or Credit. defaulted to Credit
1270: 'NEW', --default status for new batches
1271: sysdate,
1272: sysdate,
1273: FND_GLOBAL.USER_ID, --las_updated_by
1274: FND_GLOBAL.CONC_REQUEST_ID, --? conc program id
1275: FND_GLOBAL.USER_ID, --created by
1276: null, --created from --??
1277: FND_GLOBAL.CONC_LOGIN_ID, -- last_update_login

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

1270: 'NEW', --default status for new batches
1271: sysdate,
1272: sysdate,
1273: FND_GLOBAL.USER_ID, --las_updated_by
1274: FND_GLOBAL.CONC_REQUEST_ID, --? conc program id
1275: FND_GLOBAL.USER_ID, --created by
1276: null, --created from --??
1277: FND_GLOBAL.CONC_LOGIN_ID, -- last_update_login
1278: FND_GLOBAL.PROG_APPL_ID, -- program app id

Line 1275: FND_GLOBAL.USER_ID, --created by

1271: sysdate,
1272: sysdate,
1273: FND_GLOBAL.USER_ID, --las_updated_by
1274: FND_GLOBAL.CONC_REQUEST_ID, --? conc program id
1275: FND_GLOBAL.USER_ID, --created by
1276: null, --created from --??
1277: FND_GLOBAL.CONC_LOGIN_ID, -- last_update_login
1278: FND_GLOBAL.PROG_APPL_ID, -- program app id
1279: sysdate,

Line 1277: FND_GLOBAL.CONC_LOGIN_ID, -- last_update_login

1273: FND_GLOBAL.USER_ID, --las_updated_by
1274: FND_GLOBAL.CONC_REQUEST_ID, --? conc program id
1275: FND_GLOBAL.USER_ID, --created by
1276: null, --created from --??
1277: FND_GLOBAL.CONC_LOGIN_ID, -- last_update_login
1278: FND_GLOBAL.PROG_APPL_ID, -- program app id
1279: sysdate,
1280: FND_GLOBAL.CONC_PROGRAM_ID, --program id
1281: null, --l_transfer_type to be updated when batch is exported

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

1274: FND_GLOBAL.CONC_REQUEST_ID, --? conc program id
1275: FND_GLOBAL.USER_ID, --created by
1276: null, --created from --??
1277: FND_GLOBAL.CONC_LOGIN_ID, -- last_update_login
1278: FND_GLOBAL.PROG_APPL_ID, -- program app id
1279: sysdate,
1280: FND_GLOBAL.CONC_PROGRAM_ID, --program id
1281: null, --l_transfer_type to be updated when batch is exported
1282: l_org_id --default batch Org ID

Line 1280: FND_GLOBAL.CONC_PROGRAM_ID, --program id

1276: null, --created from --??
1277: FND_GLOBAL.CONC_LOGIN_ID, -- last_update_login
1278: FND_GLOBAL.PROG_APPL_ID, -- program app id
1279: sysdate,
1280: FND_GLOBAL.CONC_PROGRAM_ID, --program id
1281: null, --l_transfer_type to be updated when batch is exported
1282: l_org_id --default batch Org ID
1283: );
1284: END Create_Batch_Header;

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

1867: to_char(l_univ_curr_amount_remaining) || '*' ||
1868: to_char(l_amount_remaining) || '*' ||
1869: to_char('Y') || '*' || to_char(l_order_date) || '*' ||
1870: to_char(sysdate) || '*' || to_char(sysdate) || '*' ||
1871: to_char(FND_GLOBAL.USER_ID) || '*' ||
1872: to_char(FND_GLOBAL.CONC_REQUEST_ID) || '*' ||
1873: to_char(FND_GLOBAL.USER_ID) || '*' ||
1874: to_char(FND_GLOBAL.CONC_LOGIN_ID) || '*' ||
1875: to_char(FND_GLOBAL.PROG_APPL_ID) || '*' ||

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

1868: to_char(l_amount_remaining) || '*' ||
1869: to_char('Y') || '*' || to_char(l_order_date) || '*' ||
1870: to_char(sysdate) || '*' || to_char(sysdate) || '*' ||
1871: to_char(FND_GLOBAL.USER_ID) || '*' ||
1872: to_char(FND_GLOBAL.CONC_REQUEST_ID) || '*' ||
1873: to_char(FND_GLOBAL.USER_ID) || '*' ||
1874: to_char(FND_GLOBAL.CONC_LOGIN_ID) || '*' ||
1875: to_char(FND_GLOBAL.PROG_APPL_ID) || '*' ||
1876: to_char(null) || '*' ||

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

1869: to_char('Y') || '*' || to_char(l_order_date) || '*' ||
1870: to_char(sysdate) || '*' || to_char(sysdate) || '*' ||
1871: to_char(FND_GLOBAL.USER_ID) || '*' ||
1872: to_char(FND_GLOBAL.CONC_REQUEST_ID) || '*' ||
1873: to_char(FND_GLOBAL.USER_ID) || '*' ||
1874: to_char(FND_GLOBAL.CONC_LOGIN_ID) || '*' ||
1875: to_char(FND_GLOBAL.PROG_APPL_ID) || '*' ||
1876: to_char(null) || '*' ||
1877: to_char(FND_GLOBAL.CONC_PROGRAM_ID) || '*' ||

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

1870: to_char(sysdate) || '*' || to_char(sysdate) || '*' ||
1871: to_char(FND_GLOBAL.USER_ID) || '*' ||
1872: to_char(FND_GLOBAL.CONC_REQUEST_ID) || '*' ||
1873: to_char(FND_GLOBAL.USER_ID) || '*' ||
1874: to_char(FND_GLOBAL.CONC_LOGIN_ID) || '*' ||
1875: to_char(FND_GLOBAL.PROG_APPL_ID) || '*' ||
1876: to_char(null) || '*' ||
1877: to_char(FND_GLOBAL.CONC_PROGRAM_ID) || '*' ||
1878: to_char(l_org_id) || '*' ||

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

1871: to_char(FND_GLOBAL.USER_ID) || '*' ||
1872: to_char(FND_GLOBAL.CONC_REQUEST_ID) || '*' ||
1873: to_char(FND_GLOBAL.USER_ID) || '*' ||
1874: to_char(FND_GLOBAL.CONC_LOGIN_ID) || '*' ||
1875: to_char(FND_GLOBAL.PROG_APPL_ID) || '*' ||
1876: to_char(null) || '*' ||
1877: to_char(FND_GLOBAL.CONC_PROGRAM_ID) || '*' ||
1878: to_char(l_org_id) || '*' ||
1879: to_char(l_inv_org_id));

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

1873: to_char(FND_GLOBAL.USER_ID) || '*' ||
1874: to_char(FND_GLOBAL.CONC_LOGIN_ID) || '*' ||
1875: to_char(FND_GLOBAL.PROG_APPL_ID) || '*' ||
1876: to_char(null) || '*' ||
1877: to_char(FND_GLOBAL.CONC_PROGRAM_ID) || '*' ||
1878: to_char(l_org_id) || '*' ||
1879: to_char(l_inv_org_id));
1880: END IF;
1881:

Line 1985: FND_GLOBAL.USER_ID, --l_last_updated_by,

1981: 'N', -- l_active_flag
1982: l_order_date, -- from OE order lines/header
1983: sysdate, --l_creation_date,
1984: sysdate, --l_last_update_date,
1985: FND_GLOBAL.USER_ID, --l_last_updated_by,
1986: FND_GLOBAL.CONC_REQUEST_ID, --l_request_id,
1987: FND_GLOBAL.USER_ID, --l_created_by,
1988: --l_created_from,
1989: FND_GLOBAL.CONC_LOGIN_ID, --l_last_update_login,

Line 1986: FND_GLOBAL.CONC_REQUEST_ID, --l_request_id,

1982: l_order_date, -- from OE order lines/header
1983: sysdate, --l_creation_date,
1984: sysdate, --l_last_update_date,
1985: FND_GLOBAL.USER_ID, --l_last_updated_by,
1986: FND_GLOBAL.CONC_REQUEST_ID, --l_request_id,
1987: FND_GLOBAL.USER_ID, --l_created_by,
1988: --l_created_from,
1989: FND_GLOBAL.CONC_LOGIN_ID, --l_last_update_login,
1990: FND_GLOBAL.PROG_APPL_ID, --l_program_application_id,

Line 1987: FND_GLOBAL.USER_ID, --l_created_by,

1983: sysdate, --l_creation_date,
1984: sysdate, --l_last_update_date,
1985: FND_GLOBAL.USER_ID, --l_last_updated_by,
1986: FND_GLOBAL.CONC_REQUEST_ID, --l_request_id,
1987: FND_GLOBAL.USER_ID, --l_created_by,
1988: --l_created_from,
1989: FND_GLOBAL.CONC_LOGIN_ID, --l_last_update_login,
1990: FND_GLOBAL.PROG_APPL_ID, --l_program_application_id,
1991: null, --l_program_update_date,

Line 1989: FND_GLOBAL.CONC_LOGIN_ID, --l_last_update_login,

1985: FND_GLOBAL.USER_ID, --l_last_updated_by,
1986: FND_GLOBAL.CONC_REQUEST_ID, --l_request_id,
1987: FND_GLOBAL.USER_ID, --l_created_by,
1988: --l_created_from,
1989: FND_GLOBAL.CONC_LOGIN_ID, --l_last_update_login,
1990: FND_GLOBAL.PROG_APPL_ID, --l_program_application_id,
1991: null, --l_program_update_date,
1992: FND_GLOBAL.CONC_PROGRAM_ID, --l_program_id,
1993: l_inv_org_id,

Line 1990: FND_GLOBAL.PROG_APPL_ID, --l_program_application_id,

1986: FND_GLOBAL.CONC_REQUEST_ID, --l_request_id,
1987: FND_GLOBAL.USER_ID, --l_created_by,
1988: --l_created_from,
1989: FND_GLOBAL.CONC_LOGIN_ID, --l_last_update_login,
1990: FND_GLOBAL.PROG_APPL_ID, --l_program_application_id,
1991: null, --l_program_update_date,
1992: FND_GLOBAL.CONC_PROGRAM_ID, --l_program_id,
1993: l_inv_org_id,
1994: 'Y');

Line 1992: FND_GLOBAL.CONC_PROGRAM_ID, --l_program_id,

1988: --l_created_from,
1989: FND_GLOBAL.CONC_LOGIN_ID, --l_last_update_login,
1990: FND_GLOBAL.PROG_APPL_ID, --l_program_application_id,
1991: null, --l_program_update_date,
1992: FND_GLOBAL.CONC_PROGRAM_ID, --l_program_id,
1993: l_inv_org_id,
1994: 'Y');
1995:
1996: IF OZF_DEBUG_LOW_ON THEN

Line 2049: last_updated_by = FND_GLOBAL.USER_ID,

2045: acctd_amount_remaining = 0,
2046: plan_curr_amount_remaining = 0,
2047: univ_curr_amount_remaining = 0,
2048: last_update_date = sysdate,
2049: last_updated_by = FND_GLOBAL.USER_ID,
2050: object_version_number = object_version_number + 1
2051: WHERE utilization_id in
2052: (SELECT utilization_id
2053: FROM ozf_sd_batch_lines_all

Line 2198: last_updated_by = FND_GLOBAL.USER_ID,

2194: UPDATE OZF_SD_BATCH_HEADERS_ALL
2195: SET status_code = 'CLOSED',
2196: claim_id = l_claim_id,
2197: last_update_date = sysdate,
2198: last_updated_by = FND_GLOBAL.USER_ID,
2199: object_version_number = object_version_number + 1
2200: WHERE batch_id = l_batch_id;
2201:
2202: OZF_SD_UTIL_PVT.SD_RAISE_EVENT(l_batch_id, 'CLAIM', l_return_status); -- Raising lifecycle event for claim