eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ORG_UTILS dependencies on PA_ORG_HIERARCHY_DENORM

Line 125: -- This procedure populates data in pa_org_hierarchy_denorm

121: --
122: -- Procedure
123: -- Create by Ranga Iyengar
124: -- Dated : 02-NOV-2000
125: -- This procedure populates data in pa_org_hierarchy_denorm
126: -- for reporting type of organizations and stores
127: -- parent level and child levels
128: --
129: --

Line 150: p_organization_id IN PA_ORG_HIERARCHY_DENORM.parent_organization_id%TYPE,

146: ,x_err_stack IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
147: );
148: PROCEDURE Check_Org_In_OrgHierarchy
149: (
150: p_organization_id IN PA_ORG_HIERARCHY_DENORM.parent_organization_id%TYPE,
151: p_org_structure_version_id IN PA_ORG_HIERARCHY_DENORM.org_hierarchy_version_id%TYPE,
152: p_org_structure_type IN PA_ORG_HIERARCHY_DENORM.pa_org_use_type%TYPE,
153: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
154: x_error_message_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 151: p_org_structure_version_id IN PA_ORG_HIERARCHY_DENORM.org_hierarchy_version_id%TYPE,

147: );
148: PROCEDURE Check_Org_In_OrgHierarchy
149: (
150: p_organization_id IN PA_ORG_HIERARCHY_DENORM.parent_organization_id%TYPE,
151: p_org_structure_version_id IN PA_ORG_HIERARCHY_DENORM.org_hierarchy_version_id%TYPE,
152: p_org_structure_type IN PA_ORG_HIERARCHY_DENORM.pa_org_use_type%TYPE,
153: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
154: x_error_message_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
155: );

Line 152: p_org_structure_type IN PA_ORG_HIERARCHY_DENORM.pa_org_use_type%TYPE,

148: PROCEDURE Check_Org_In_OrgHierarchy
149: (
150: p_organization_id IN PA_ORG_HIERARCHY_DENORM.parent_organization_id%TYPE,
151: p_org_structure_version_id IN PA_ORG_HIERARCHY_DENORM.org_hierarchy_version_id%TYPE,
152: p_org_structure_type IN PA_ORG_HIERARCHY_DENORM.pa_org_use_type%TYPE,
153: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
154: x_error_message_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
155: );
156:

Line 158: p_org_structure_version_id IN PA_ORG_HIERARCHY_DENORM.org_hierarchy_version_id%TYPE,

154: x_error_message_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
155: );
156:
157: PROCEDURE Check_OrgHierarchy_Type(
158: p_org_structure_version_id IN PA_ORG_HIERARCHY_DENORM.org_hierarchy_version_id%TYPE,
159: p_org_structure_type IN PA_ORG_HIERARCHY_DENORM.pa_org_use_type%TYPE,
160: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
161: x_error_message_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
162: );

Line 159: p_org_structure_type IN PA_ORG_HIERARCHY_DENORM.pa_org_use_type%TYPE,

155: );
156:
157: PROCEDURE Check_OrgHierarchy_Type(
158: p_org_structure_version_id IN PA_ORG_HIERARCHY_DENORM.org_hierarchy_version_id%TYPE,
159: p_org_structure_type IN PA_ORG_HIERARCHY_DENORM.pa_org_use_type%TYPE,
160: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
161: x_error_message_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
162: );
163:

Line 165: p_organization_id IN PA_ORG_HIERARCHY_DENORM.parent_organization_id%TYPE,

161: x_error_message_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
162: );
163:
164: PROCEDURE Check_Org_Type(
165: p_organization_id IN PA_ORG_HIERARCHY_DENORM.parent_organization_id%TYPE,
166: p_org_structure_type IN PA_ORG_HIERARCHY_DENORM.pa_org_use_type%TYPE,
167: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
168: x_error_message_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
169: );

Line 166: p_org_structure_type IN PA_ORG_HIERARCHY_DENORM.pa_org_use_type%TYPE,

162: );
163:
164: PROCEDURE Check_Org_Type(
165: p_organization_id IN PA_ORG_HIERARCHY_DENORM.parent_organization_id%TYPE,
166: p_org_structure_type IN PA_ORG_HIERARCHY_DENORM.pa_org_use_type%TYPE,
167: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
168: x_error_message_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
169: );
170:

Line 173: -- This procedure populates data in pa_org_hierarchy_denorm

169: );
170:
171: --
172: -- Procedure : Populate_Org_Hier_Denorm
173: -- This procedure populates data in pa_org_hierarchy_denorm
174: -- for reporting type of organizations and stores
175: -- parent level and child levels
176: -- This procedure is called by the concurrent process
177: -- "Maintain Project Resources"