DBA Data[Home] [Help]

APPS.OKC_REP_CONTRACT_IMP_PVT dependencies on FND_GLOBAL

Line 23: l_user_id := FND_GLOBAL.user_id();

19: l_user_id NUMBER;
20:
21: BEGIN
22: l_api_name := 'Update_contract_usages';
23: l_user_id := FND_GLOBAL.user_id();
24:
25: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
26: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
27: 'Entered OKC_REP_CONTRACT_IMP_PVT.'||l_api_name);

Line 113: l_user_id := FND_GLOBAL.user_id();

109: l_user_id NUMBER;
110:
111: BEGIN
112: l_api_name := 'delete_contract_usages';
113: l_user_id := FND_GLOBAL.user_id();
114:
115: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
116: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
117: 'Entered OKC_REP_CONTRACT_IMP_PVT.'||l_api_name);

Line 721: l_request_id okc_rep_imp_contracts_t.request_id%TYPE := fnd_global.conc_request_id;

717: l_where_clause VARCHAR2(2000);
718: l_update_query VARCHAR2(5000);
719: l_row_notfound BOOLEAN := FALSE;
720: l_organization_name HR_ORGANIZATION_UNITS.NAME%TYPE;
721: l_request_id okc_rep_imp_contracts_t.request_id%TYPE := fnd_global.conc_request_id;
722: l_contract_type VARCHAR2(30);
723:
724: l_return_status VARCHAR2(1);
725: l_msg_count NUMBER;

Line 1179: l_user_id := FND_GLOBAL.user_id();

1175: --l_return_status VARCHAR2(1);
1176:
1177: BEGIN
1178: l_api_name := 'create_contract';
1179: l_user_id := FND_GLOBAL.user_id();
1180:
1181: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1182: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1183: 'Entered OKC_REP_CONTRACT_IMP_PUB.'||l_api_name);

Line 1483: l_user_id := FND_GLOBAL.user_id();

1479:
1480:
1481: BEGIN
1482: l_api_name := 'create_new_contract_version';
1483: l_user_id := FND_GLOBAL.user_id();
1484:
1485: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1486: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1487: 'Entered OKC_REP_CONTRACT_IMP_PVT.'||l_api_name);

Line 1517: last_updated_by = FND_GLOBAL.user_id(),

1513:
1514: --update the version and status of the record in okc_rep_contracts_all
1515: UPDATE okc_rep_contracts_all SET contract_version_num = contract_version_num +1,
1516: contract_status_code = 'DRAFT',
1517: last_updated_by = FND_GLOBAL.user_id(),
1518: last_update_login = FND_GLOBAL.user_id(),
1519: last_update_date = SYSDATE,
1520: run_id = okc_rep_import_run_id_s.NEXTVAL
1521: WHERE contract_id = p_contract_id;

Line 1518: last_update_login = FND_GLOBAL.user_id(),

1514: --update the version and status of the record in okc_rep_contracts_all
1515: UPDATE okc_rep_contracts_all SET contract_version_num = contract_version_num +1,
1516: contract_status_code = 'DRAFT',
1517: last_updated_by = FND_GLOBAL.user_id(),
1518: last_update_login = FND_GLOBAL.user_id(),
1519: last_update_date = SYSDATE,
1520: run_id = okc_rep_import_run_id_s.NEXTVAL
1521: WHERE contract_id = p_contract_id;
1522:

Line 1662: l_user_id := FND_GLOBAL.user_id();

1658: c_contract_id_cur contract_id_cur;
1659:
1660: BEGIN
1661: l_api_name := 'create_new_contract_version';
1662: l_user_id := FND_GLOBAL.user_id();
1663:
1664: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1665: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1666: 'Entered OKC_REP_CONTRACT_IMP_PUB.'||l_api_name);

Line 1808: -- l_user_id := FND_GLOBAL.user_id();

1804:
1805: BEGIN
1806:
1807: l_api_name := 'check_contract_exists';
1808: -- l_user_id := FND_GLOBAL.user_id();
1809:
1810: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1811: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1812: 'Entered OKC_REP_CONTRACT_IMP_PUB.'||l_api_name);

Line 1979: p_user_id => fnd_global.user_id,

1975: p_init_msg_list => FND_API.G_FALSE,
1976: p_contract_id => l_contract_id,
1977: p_contract_version => contract_rec.contract_version_num,
1978: p_status_code => G_STATUS_SIGNED,
1979: p_user_id => fnd_global.user_id,
1980: p_note => NULL,
1981: x_msg_data => x_msg_data,
1982: x_msg_count => x_msg_count,
1983: x_return_status => x_return_status);

Line 2271: -- l_user_id := FND_GLOBAL.user_id();

2267:
2268: BEGIN
2269:
2270: l_api_name := 'check_contract_exists';
2271: -- l_user_id := FND_GLOBAL.user_id();
2272:
2273: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2274: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2275: 'Entered OKC_REP_CONTRACT_IMP_PUB.'||l_api_name);

Line 2967: g_conc_request_id := FND_GLOBAL.conc_request_id;

2963: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Entered OKC_REP_CONTRACT_IMP_PVT.' || l_api_name);
2964: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Input parameter p_purge_and_rerun: ' || p_purge_and_rerun);
2965: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Input parameter p_simulate: ' || p_simulate);
2966:
2967: g_conc_request_id := FND_GLOBAL.conc_request_id;
2968: g_conc_program_id := FND_GLOBAL.conc_program_id;
2969: g_conc_login_id := FND_GLOBAL.conc_login_id;
2970: g_prog_appl_id := FND_GLOBAL.prog_appl_id;
2971:

Line 2968: g_conc_program_id := FND_GLOBAL.conc_program_id;

2964: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Input parameter p_purge_and_rerun: ' || p_purge_and_rerun);
2965: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Input parameter p_simulate: ' || p_simulate);
2966:
2967: g_conc_request_id := FND_GLOBAL.conc_request_id;
2968: g_conc_program_id := FND_GLOBAL.conc_program_id;
2969: g_conc_login_id := FND_GLOBAL.conc_login_id;
2970: g_prog_appl_id := FND_GLOBAL.prog_appl_id;
2971:
2972: FND_FILE.PUT_LINE(FND_FILE.LOG, 'g_conc_request_id:' || g_conc_request_id);

Line 2969: g_conc_login_id := FND_GLOBAL.conc_login_id;

2965: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Input parameter p_simulate: ' || p_simulate);
2966:
2967: g_conc_request_id := FND_GLOBAL.conc_request_id;
2968: g_conc_program_id := FND_GLOBAL.conc_program_id;
2969: g_conc_login_id := FND_GLOBAL.conc_login_id;
2970: g_prog_appl_id := FND_GLOBAL.prog_appl_id;
2971:
2972: FND_FILE.PUT_LINE(FND_FILE.LOG, 'g_conc_request_id:' || g_conc_request_id);
2973: FND_FILE.PUT_LINE(FND_FILE.LOG, 'g_conc_program_id:' || g_conc_program_id);

Line 2970: g_prog_appl_id := FND_GLOBAL.prog_appl_id;

2966:
2967: g_conc_request_id := FND_GLOBAL.conc_request_id;
2968: g_conc_program_id := FND_GLOBAL.conc_program_id;
2969: g_conc_login_id := FND_GLOBAL.conc_login_id;
2970: g_prog_appl_id := FND_GLOBAL.prog_appl_id;
2971:
2972: FND_FILE.PUT_LINE(FND_FILE.LOG, 'g_conc_request_id:' || g_conc_request_id);
2973: FND_FILE.PUT_LINE(FND_FILE.LOG, 'g_conc_program_id:' || g_conc_program_id);
2974: FND_FILE.PUT_LINE(FND_FILE.LOG, 'g_conc_login_id:' || g_conc_login_id);