[Home] [Help]
31: select ood.organization_code,
32: ood.organization_name
33: into X_org_code,
34: X_org_name
35: from org_organization_definitions ood
36: where ood.organization_id(+) = X_org_id;
37:
38: exception
39:
85: x_progress := '010';
86:
87: SELECT count(1)
88: INTO x_org_count
89: FROM org_organization_definitions ood
90: WHERE ood.set_of_books_id = x_sob_id
91: AND ood.organization_id = x_org_id
92: AND nvl(ood.disable_date, trunc(sysdate + 1)) > trunc(sysdate);
93:
265: x_progress := '010';
266:
267: SELECT count(1)
268: INTO x_org_count
269: FROM org_organization_definitions ood
270: WHERE ood.set_of_books_id = x_sob_id
271: AND ood.organization_id = x_src_org_id
272: AND nvl(ood.disable_date, trunc(sysdate + 1)) > trunc(sysdate);
273:
520: organization_code
521: INTO x_date_table(x_organization_id).v_enable_date,
522: x_date_table(x_organization_id).v_disable_date,
523: x_date_table(x_organization_id).v_organization_code
524: FROM org_organization_definitions
525: WHERE organization_id = x_organization_id;
526: ELSE
527: SELECT user_definition_enable_date,
528: disable_date,
529: organization_code
530: INTO x_date_table(x_organization_id).v_enable_date,
531: x_date_table(x_organization_id).v_disable_date,
532: x_date_table(x_organization_id).v_organization_code
533: FROM org_organization_definitions
534: WHERE organization_id = x_organization_id AND
535: organization_code = x_organization_code;
536: END IF;
537: END IF;
565:
566:
567:
568: /*
569: X_sql_str := 'SELECT user_definition_enable_date, disable_date FROM org_organization_definitions WHERE ';
570:
571: IF p_org_record.organization_code IS NULL and
572: p_org_record.organization_id IS NULL THEN
573: