DBA Data[Home] [Help]

APPS.AHL_AVF_OPER_VSTS_PVT dependencies on MO_GLOBAL

Line 1691: AND NVL(hou.operating_unit,mo_global.get_current_org_id()) = mo_global.get_current_org_id();

1687: IS
1688: SELECT 'X'
1689: FROM org_organization_definitions hou
1690: WHERE hou.organization_id = c_org_id
1691: AND NVL(hou.operating_unit,mo_global.get_current_org_id()) = mo_global.get_current_org_id();
1692: l_is_org_in_curr_OU VARCHAR2(1);
1693:
1694: BEGIN
1695:

Line 4146: AND NVL(hou.operating_unit,mo_global.get_current_org_id()) = mo_global.get_current_org_id();

4142: IS
4143: SELECT 'X'
4144: FROM org_organization_definitions hou
4145: WHERE hou.organization_id = c_org_id
4146: AND NVL(hou.operating_unit,mo_global.get_current_org_id()) = mo_global.get_current_org_id();
4147:
4148: -- Cursor to get the visit Number from visit_id
4149: CURSOR get_visit_number(c_visit_id IN NUMBER) IS
4150: SELECT visit_number

Line 4241: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'mo_global.get_current_org_id() --@>'||mo_global.get_current_org_id());

4237: IF (l_log_statement >= l_log_current_level) THEN
4238: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_start_date --@>'||cast(l_start_date as timestamp));
4239: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_end_date --@>'||cast(l_end_date as timestamp));
4240: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'p_present_time --@>'||cast(p_present_time as timestamp));
4241: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'mo_global.get_current_org_id() --@>'||mo_global.get_current_org_id());
4242: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_visit_rec.ORGANIZATION_ID --@>'||l_visit_rec.ORGANIZATION_ID);
4243: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_is_org_in_curr_OU --@>'||l_is_org_in_curr_OU);
4244: END IF;
4245:

Line 4406: AND NVL(hou.operating_unit,mo_global.get_current_org_id()) = mo_global.get_current_org_id();

4402: IS
4403: SELECT 'X'
4404: FROM org_organization_definitions hou
4405: WHERE hou.organization_id = c_org_id
4406: AND NVL(hou.operating_unit,mo_global.get_current_org_id()) = mo_global.get_current_org_id();
4407:
4408: -- Cursor to get the visit Number from visit_id
4409: CURSOR get_visit_number(c_visit_id IN NUMBER) IS
4410: SELECT visit_number

Line 4501: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'mo_global.get_current_org_id() --@>'||mo_global.get_current_org_id());

4497: IF (l_log_statement >= l_log_current_level) THEN
4498: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_start_date --@>'||cast(l_start_date as timestamp));
4499: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_end_date --@>'||cast(l_end_date as timestamp));
4500: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'p_present_time --@>'||cast(p_present_time as timestamp));
4501: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'mo_global.get_current_org_id() --@>'||mo_global.get_current_org_id());
4502: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_visit_rec.ORGANIZATION_ID --@>'||l_visit_rec.ORGANIZATION_ID);
4503: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_is_org_in_curr_OU --@>'||l_is_org_in_curr_OU);
4504: END IF;
4505:

Line 4662: AND NVL(hou.operating_unit,mo_global.get_current_org_id()) = mo_global.get_current_org_id();

4658: IS
4659: SELECT 'X'
4660: FROM org_organization_definitions hou
4661: WHERE hou.organization_id = c_org_id
4662: AND NVL(hou.operating_unit,mo_global.get_current_org_id()) = mo_global.get_current_org_id();
4663:
4664: -- Cursor to get the visit Number from visit_id
4665: CURSOR get_visit_number(c_visit_id IN NUMBER) IS
4666: SELECT visit_number

Line 4798: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'mo_global.get_current_org_id() --@>'||mo_global.get_current_org_id());

4794: IF (l_log_statement >= l_log_current_level) THEN
4795: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_start_date --@>'||cast(l_start_date as timestamp));
4796: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_end_date --@>'||cast(l_end_date as timestamp));
4797: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'p_present_time --@>'||cast(p_present_time as timestamp));
4798: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'mo_global.get_current_org_id() --@>'||mo_global.get_current_org_id());
4799: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_visit_rec.ORGANIZATION_ID --@>'||l_visit_rec.ORGANIZATION_ID);
4800: fnd_log.string(l_log_statement, L_DEBUG_KEY , 'l_is_org_in_curr_OU --@>'||l_is_org_in_curr_OU);
4801: END IF;
4802:

Line 5081: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());

5077: fnd_file.put_line(fnd_file.log, 'p_oper_flag -> '|| p_oper_flag);
5078: fnd_file.put_line(fnd_file.log, 'fnd_global.USER_ID -> '|| fnd_global.USER_ID);
5079: fnd_file.put_line(fnd_file.log, 'fnd_global.RESP_ID -> '||fnd_global.RESP_ID);
5080: fnd_file.put_line(fnd_file.log, 'fnd_global.PROG_APPL_ID -> '|| fnd_global.PROG_APPL_ID);
5081: fnd_file.put_line(fnd_file.log, 'mo_global.get_current_org_id -> '|| mo_global.get_current_org_id());
5082:
5083:
5084: IF p_oper_flag = 'C' THEN
5085: