10: (
11: p_org_id IN NUMBER
12: ) RETURN VARCHAR2 IS
13:
14: x_auto_acct_flag po_system_parameters_all.global_attribute3%type;
15:
16: BEGIN
17:
18: BEGIN
19:
20: /* Y-Yes; N-No */
21: Select global_attribute3
22: Into x_auto_acct_flag
23: From po_system_parameters_all
24: Where nvl(org_id,-99) = nvl(p_org_id,-99);
25: Exception
26: when others THEN
27: x_auto_acct_flag := NULL;
39: (
40: p_org_id IN NUMBER
41: ) RETURN VARCHAR2 IS
42:
43: x_po_import_req_flag po_system_parameters_all.global_attribute4%type;
44:
45: BEGIN
46:
47: BEGIN
48:
49: /* Y-Yes; N-No */
50: Select global_attribute4
51: Into x_po_import_req_flag
52: From po_system_parameters_all
53: Where nvl(org_id,-99) = nvl(p_org_id,-99);
54: Exception
55: when others THEN
56: x_po_import_req_flag := NULL;