APPS.PQP_GB_OSP_TEMPLATE dependencies on PAY_USER_TABLES

Line 1182: FROM pay_user_tables

1178:
1179: CURSOR csr_get_udt_id
1180: IS
1181: SELECT user_table_id
1182: FROM pay_user_tables
1183: WHERE user_table_name = p_udt_name
1184: AND (business_group_id = p_bg_id OR
1185: business_group_id IS NULL);
1186:

Line 1189: l_user_table_id pay_user_tables.user_table_id%TYPE;

1185: business_group_id IS NULL);
1186:
1187: l_proc_step NUMBER(20,10);
1188: l_proc_name VARCHAR2(72) := g_package_name || 'get_user_table_id';
1189: l_user_table_id pay_user_tables.user_table_id%TYPE;
1190:
1191: --
1192: BEGIN
1193: --

Line 1389: l_user_table_id pay_user_tables.user_table_id%TYPE;

1385: SELECT pay_user_rows_s.NEXTVAL
1386: FROM dual;
1387:
1388: l_proc_name VARCHAR2(72) := g_package_name || 'create_udt';
1389: l_user_table_id pay_user_tables.user_table_id%TYPE;
1390: l_user_column_id pay_user_columns.user_column_id%TYPE;
1391: l_user_row_id pay_user_rows_f.user_row_id%TYPE;
1392: l_udt_rowid rowid ;
1393: l_udt_cols_rowid rowid;

Line 1411: pay_user_tables_pkg.insert_row

1407: debug(l_proc_name, l_proc_step);
1408: END IF;
1409:
1410:
1411: pay_user_tables_pkg.insert_row
1412: (p_rowid => l_udt_rowid
1413: ,p_user_table_id => l_user_table_id
1414: ,p_business_group_id => p_bg_id
1415: ,p_legislation_code => NULL

Line 3233: l_entudt_id pay_user_tables.user_table_id%TYPE;

3229: l_proc_step NUMBER(20,10);
3230: l_proc_name varchar2(72) := g_package_name || 'delete_user_template';
3231: l_eei_info_id number;
3232: l_ovn_eei number;
3233: l_entudt_id pay_user_tables.user_table_id%TYPE;
3234: l_caludt_id pay_user_tables.user_table_id%TYPE;
3235: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;
3236: -- to delete plan types lookup
3237: l_plan_type_lookup fnd_lookup_types_vl.lookup_type%TYPE;

Line 3234: l_caludt_id pay_user_tables.user_table_id%TYPE;

3230: l_proc_name varchar2(72) := g_package_name || 'delete_user_template';
3231: l_eei_info_id number;
3232: l_ovn_eei number;
3233: l_entudt_id pay_user_tables.user_table_id%TYPE;
3234: l_caludt_id pay_user_tables.user_table_id%TYPE;
3235: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;
3236: -- to delete plan types lookup
3237: l_plan_type_lookup fnd_lookup_types_vl.lookup_type%TYPE;
3238:

Line 3630: FROM pay_user_tables

3626:
3627: CURSOR csr_get_usr_table_id
3628: IS
3629: SELECT rowid
3630: FROM pay_user_tables
3631: WHERE user_table_id = p_udt_id
3632: AND business_group_id = p_business_group_id;
3633:
3634: CURSOR csr_get_usr_col_id

Line 3660: -- Get user_table_id from pay_user_tables

3656: --
3657: debug ('Entering '||l_proc_name, 10);
3658: --
3659:
3660: -- Get user_table_id from pay_user_tables
3661: OPEN csr_get_usr_table_id;
3662: FETCH csr_get_usr_table_id INTO l_rowid;
3663:
3664: IF csr_get_usr_table_id%FOUND THEN

Line 3726: -- Delete pay_user_tables for this table id

3722: END LOOP;
3723: CLOSE csr_get_usr_row_id;
3724:
3725:
3726: -- Delete pay_user_tables for this table id
3727: l_proc_step := 60;
3728: IF g_debug THEN
3729: debug(l_proc_name, l_proc_step);
3730: END IF;

Line 3732: pay_user_tables_pkg.delete_row

3728: IF g_debug THEN
3729: debug(l_proc_name, l_proc_step);
3730: END IF;
3731:
3732: pay_user_tables_pkg.delete_row
3733: (p_rowid => l_rowid
3734: ,p_user_table_id => p_udt_id
3735: );
3736: