APPS.PQH_RBC_RATE_RETRIEVAL dependencies on PQH_RBC_RATE_RETRIEVAL

Line 1: Package Body pqh_rbc_rate_retrieval as

1: Package Body pqh_rbc_rate_retrieval as
2: /* $Header: pqrbcpkg.pkb 120.10.12010000.1 2008/07/28 13:06:28 appldev ship $ */
3: --
4: g_package varchar2(33) := 'pqh_rbc_rate_retrieval.'; -- Global package name
5: --

Line 4: g_package varchar2(33) := 'pqh_rbc_rate_retrieval.'; -- Global package name

1: Package Body pqh_rbc_rate_retrieval as
2: /* $Header: pqrbcpkg.pkb 120.10.12010000.1 2008/07/28 13:06:28 appldev ship $ */
3: --
4: g_package varchar2(33) := 'pqh_rbc_rate_retrieval.'; -- Global package name
5: --
6: g_person_id number(15):= null;
7: g_assignment_id number(15):= null;
8: g_element_type_id number(15):= null;

Line 1236: l_sql_stmt := l_sql_stmt || 'pqh_rbc_rate_retrieval.g_entry_val_tbl('||to_char(l_val_cnt)||').col_value := pqh_rbc_rate_retrieval.g_entry_rec.'||l_tc_ovrrd_col||';';

1232: l_val_cnt := l_val_cnt + 1;
1233: l_tc_ovrrd_col := 'ATTRIBUTE'||to_char(l_temp_cnt);
1234: g_entry_val_tbl(l_val_cnt).column_name := l_tc_ovrrd_col;
1235: l_sql_stmt := 'Begin ';
1236: l_sql_stmt := l_sql_stmt || 'pqh_rbc_rate_retrieval.g_entry_val_tbl('||to_char(l_val_cnt)||').col_value := pqh_rbc_rate_retrieval.g_entry_rec.'||l_tc_ovrrd_col||';';
1237: l_sql_stmt := l_sql_stmt || 'End;';
1238: EXECUTE IMMEDIATE l_sql_stmt;
1239: --
1240: hr_utility.set_location(l_sql_stmt,100);

Line 1251: l_sql_stmt := l_sql_stmt || 'pqh_rbc_rate_retrieval.g_entry_val_tbl('||to_char(l_val_cnt)||').col_value := pqh_rbc_rate_retrieval.g_entry_rec.'||l_tc_ovrrd_col||';';

1247: l_val_cnt := l_val_cnt + 1;
1248: l_tc_ovrrd_col := 'ENTRY_INFORMATION'||to_char(l_temp_cnt);
1249: g_entry_val_tbl(l_val_cnt).column_name := l_tc_ovrrd_col;
1250: l_sql_stmt := 'Begin ';
1251: l_sql_stmt := l_sql_stmt || 'pqh_rbc_rate_retrieval.g_entry_val_tbl('||to_char(l_val_cnt)||').col_value := pqh_rbc_rate_retrieval.g_entry_rec.'||l_tc_ovrrd_col||';';
1252: l_sql_stmt := l_sql_stmt || 'End;';
1253: EXECUTE IMMEDIATE l_sql_stmt;
1254: --
1255: hr_utility.set_location(l_sql_stmt,90);

Line 1262: l_cost_allocation_keyflex_id := pqh_rbc_rate_retrieval.g_entry_rec.cost_allocation_keyflex_id;

1258: End loop;
1259: --
1260: -- Add Cost allocation flexfield segments.
1261: --
1262: l_cost_allocation_keyflex_id := pqh_rbc_rate_retrieval.g_entry_rec.cost_allocation_keyflex_id;
1263: --
1264: If l_cost_allocation_keyflex_id is not null then
1265: Open csr_kflx(l_cost_allocation_keyflex_id);
1266: Fetch csr_kflx into g_ckf_rec;

Line 1275: l_sql_stmt := l_sql_stmt || 'pqh_rbc_rate_retrieval.g_entry_val_tbl('||to_char(l_val_cnt)||').col_value := pqh_rbc_rate_retrieval.g_ckf_rec.'||l_tc_ovrrd_col||';';

1271: l_val_cnt := l_val_cnt + 1;
1272: l_tc_ovrrd_col := 'SEGMENT'||to_char(l_temp_cnt);
1273: g_entry_val_tbl(l_val_cnt).column_name := l_tc_ovrrd_col;
1274: l_sql_stmt := 'Begin ';
1275: l_sql_stmt := l_sql_stmt || 'pqh_rbc_rate_retrieval.g_entry_val_tbl('||to_char(l_val_cnt)||').col_value := pqh_rbc_rate_retrieval.g_ckf_rec.'||l_tc_ovrrd_col||';';
1276: l_sql_stmt := l_sql_stmt || 'End;';
1277: EXECUTE IMMEDIATE l_sql_stmt;
1278: --
1279: hr_utility.set_location(l_sql_stmt,90);

Line 1937: End pqh_rbc_rate_retrieval;

1933: Return l_rate;
1934: --
1935: End get_ele_entry_rbc_rate;
1936: --
1937: End pqh_rbc_rate_retrieval;