DBA Data[Home] [Help]

APPS.QA_SS_IMPORT_WF dependencies on HR_ALL_ORGANIZATION_UNITS

Line 249: x_org_name hr_all_organization_units.name%type;

245: x_po_number VARCHAR2(30) := 'PO Number not available';
246: x_itemtype VARCHAR2(8);
247: x_org_id NUMBER;
248: x_org_code VARCHAR2(3);
249: x_org_name hr_all_organization_units.name%type;
250:
251: BEGIN
252:
253:

Line 416: x_org_name hr_all_organization_units.name%type;

412: x_cimdf VARCHAR2(200);
413: x_cursor_plan_name VARCHAR2(60);
414: x_org_id NUMBER;
415: x_org_code VARCHAR2(3);
416: x_org_name hr_all_organization_units.name%type;
417:
418:
419: BEGIN
420: IF (funcmode='RUN') THEN

Line 664: x_org_name hr_all_organization_units.name%type;

660: --
661:
662: FUNCTION get_org_name (org_id IN NUMBER) RETURN VARCHAR2 IS
663:
664: x_org_name hr_all_organization_units.name%type;
665: x_cursor_org_id NUMBER;
666:
667: -- Bug 4958774. SQL Repository Fix SQL ID: 15008551
668: cursor c(x_cursor_org_id NUMBER) IS