APPS.PER_SE_POSTALCODE_UPLOAD dependencies on PER_BUSINESS_GROUPS

Line 8: g_bg_id per_business_groups.business_group_id%TYPE;

4:
5: -- Global package name
6: g_package CONSTANT VARCHAR2 (33) := 'POST_SE_UPLOAD';
7: g_proc CONSTANT VARCHAR2 (33) :='error';
8: g_bg_id per_business_groups.business_group_id%TYPE;
9: g_view_application_id FND_LOOKUP_TYPES.view_application_id%type;
10: g_security_group_id PER_BUSINESS_GROUPS.business_group_id%type;
11: --l_original_desc fnd_lookup_values.description%type;
12:

Line 10: g_security_group_id PER_BUSINESS_GROUPS.business_group_id%type;

6: g_package CONSTANT VARCHAR2 (33) := 'POST_SE_UPLOAD';
7: g_proc CONSTANT VARCHAR2 (33) :='error';
8: g_bg_id per_business_groups.business_group_id%TYPE;
9: g_view_application_id FND_LOOKUP_TYPES.view_application_id%type;
10: g_security_group_id PER_BUSINESS_GROUPS.business_group_id%type;
11: --l_original_desc fnd_lookup_values.description%type;
12:
13: -- File Handling variables
14: l_file_type UTL_FILE.file_type;

Line 66: ,p_business_group_id IN per_business_groups.business_group_id%TYPE

62: PROCEDURE READ_FILE(
63: errbuf OUT NOCOPY VARCHAR2
64: ,retcode OUT NOCOPY NUMBER
65: ,p_filename IN VARCHAR2
66: ,p_business_group_id IN per_business_groups.business_group_id%TYPE
67: )
68: is
69: l_filename VARCHAR2 (240);
70:

Line 267: select SECURITY_GROUP_ID into g_security_group_id from per_business_groups where business_group_id = g_bg_id;

263: BEGIN
264: l_update_flag:='N';
265: g_view_application_id := 3;
266: begin
267: select SECURITY_GROUP_ID into g_security_group_id from per_business_groups where business_group_id = g_bg_id;
268: exception
269: when others then
270: g_security_group_id := 0;
271: end;