DBA Data[Home] [Help]

APPS.QA_SS_IMPORT_WF dependencies on HR_ALL_ORGANIZATION_UNITS

Line 261: x_org_name hr_all_organization_units.name%type;

257: x_po_number VARCHAR2(80) := 'PO Number not available';
258: x_itemtype VARCHAR2(8);
259: x_org_id NUMBER;
260: x_org_code VARCHAR2(3);
261: x_org_name hr_all_organization_units.name%type;
262:
263: BEGIN
264:
265:

Line 438: x_org_name hr_all_organization_units.name%type;

434: x_cimdf VARCHAR2(200);
435: x_cursor_plan_name VARCHAR2(60);
436: x_org_id NUMBER;
437: x_org_code VARCHAR2(3);
438: x_org_name hr_all_organization_units.name%type;
439:
440:
441: BEGIN
442: IF (funcmode='RUN') THEN

Line 694: x_org_name hr_all_organization_units.name%type;

690: --
691:
692: FUNCTION get_org_name (org_id IN NUMBER) RETURN VARCHAR2 IS
693:
694: x_org_name hr_all_organization_units.name%type;
695: x_cursor_org_id NUMBER;
696:
697: -- Bug 4958774. SQL Repository Fix SQL ID: 15008551
698: cursor c(x_cursor_org_id NUMBER) IS