APPS.PA_PROJECT_REQUEST_PVT dependencies on PA_VARCHAR2_30_TBL_TYPE

Line 468: x_field_names OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE, --File.Sql.39 bug 4440895

464:
465: PROCEDURE get_quick_entry_defaults (
466: p_request_id IN NUMBER,
467: p_template_id IN NUMBER,
468: x_field_names OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE, --File.Sql.39 bug 4440895
469: x_field_values OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE, --File.Sql.39 bug 4440895
470: x_field_types OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE, --File.Sql.39 bug 4440895
471: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
472: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 470: x_field_types OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE, --File.Sql.39 bug 4440895

466: p_request_id IN NUMBER,
467: p_template_id IN NUMBER,
468: x_field_names OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE, --File.Sql.39 bug 4440895
469: x_field_values OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE, --File.Sql.39 bug 4440895
470: x_field_types OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE, --File.Sql.39 bug 4440895
471: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
472: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
473: x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
474:

Line 630: x_field_names := SYSTEM.PA_VARCHAR2_30_TBL_TYPE('NAME');

626: CLOSE cur_quick_entry_def;
627: END IF;
628:
629: debug('After close');
630: x_field_names := SYSTEM.PA_VARCHAR2_30_TBL_TYPE('NAME');
631: x_field_values := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE(l_name);
632: x_field_types := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(null);
633:
634: debug('After init of tables');

Line 632: x_field_types := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(null);

628:
629: debug('After close');
630: x_field_names := SYSTEM.PA_VARCHAR2_30_TBL_TYPE('NAME');
631: x_field_values := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE(l_name);
632: x_field_types := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(null);
633:
634: debug('After init of tables');
635: x_field_names.extend(9);
636: x_field_values.extend(9);