APPS.PQP_COPY_UDT dependencies on PAY_USER_TABLES

Line 68: FROM pay_user_tables

64: FUNCTION copy_table(p_curr_put_id IN NUMBER) RETURN NUMBER IS
65:
66: CURSOR c_user_table IS
67: SELECT *
68: FROM pay_user_tables
69: WHERE user_table_id = p_curr_put_id;
70:
71: r_user_table c_user_table%ROWTYPE;
72:

Line 75: l_new_user_table_name pay_user_tables.user_table_name%TYPE;

71: r_user_table c_user_table%ROWTYPE;
72:
73: l_new_put_id NUMBER(9);
74: l_row_id VARCHAR2(18) := NULL;
75: l_new_user_table_name pay_user_tables.user_table_name%TYPE;
76:
77: l_proc VARCHAR2(72) := g_package||'copy_table';
78:
79: BEGIN

Line 101: -- Insert new row in PAY_USER_TABLES

97:
98: -- Add prefix to user table name
99: l_new_user_table_name := g_udt_prefix||'_'||r_user_table.user_table_name;
100:
101: -- Insert new row in PAY_USER_TABLES
102: pay_user_tables_pkg.insert_row
103: (p_rowid => l_row_id -- IN OUT
104: ,p_user_table_id => l_new_put_id -- IN OUT
105: ,p_business_group_id => g_target_bg_id

Line 102: pay_user_tables_pkg.insert_row

98: -- Add prefix to user table name
99: l_new_user_table_name := g_udt_prefix||'_'||r_user_table.user_table_name;
100:
101: -- Insert new row in PAY_USER_TABLES
102: pay_user_tables_pkg.insert_row
103: (p_rowid => l_row_id -- IN OUT
104: ,p_user_table_id => l_new_put_id -- IN OUT
105: ,p_business_group_id => g_target_bg_id
106: ,p_legislation_code => NULL

Line 412: -- Copy PAY_USER_TABLES data

408: -- Set package variables
409: g_target_bg_id := p_business_group_id;
410: g_udt_prefix := upper(p_udt_prefix);
411:
412: -- Copy PAY_USER_TABLES data
413: l_new_put_id := copy_table(p_curr_put_id => p_curr_udt_id);
414:
415: -- Copy PAY_USER_COLUMNS data
416: copy_columns(p_curr_put_id => p_curr_udt_id