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.PQP_GB_T1_PENSION_EXTRACTS dependencies on BEN_EXT_RSLT

Line 4672: ,ben_ext_rslt rslt

4668: -- Cursor declaration
4669: CURSOR csr_person_reported IS
4670: SELECT 'Y'
4671: FROM pqp_extract_attributes pqea
4672: ,ben_ext_rslt rslt
4673: ,ben_ext_rslt_dtl rdtl
4674: ,ben_ext_rcd drcd
4675: WHERE pqea.ext_dfn_type = g_extract_type
4676: AND rslt.ext_dfn_id = pqea.ext_dfn_id

Line 4673: ,ben_ext_rslt_dtl rdtl

4669: CURSOR csr_person_reported IS
4670: SELECT 'Y'
4671: FROM pqp_extract_attributes pqea
4672: ,ben_ext_rslt rslt
4673: ,ben_ext_rslt_dtl rdtl
4674: ,ben_ext_rcd drcd
4675: WHERE pqea.ext_dfn_type = g_extract_type
4676: AND rslt.ext_dfn_id = pqea.ext_dfn_id
4677: -- Bugfix 3073562:GAP1:GAP2, now using master bg id

Line 4697: FROM ben_ext_rslt_dtl rdtl1

4693: )
4694: -- match the header element
4695: AND EXISTS
4696: ( SELECT 'Y'
4697: FROM ben_ext_rslt_dtl rdtl1
4698: WHERE rdtl1.business_group_id = g_master_bg_id
4699: AND EXISTS
4700: ( SELECT 'Y'
4701: FROM ben_ext_rcd drcd1

Line 12529: l_withdrawal_conf ben_ext_rslt_dtl.val_15%TYPE := ' ';

12525: (p_assignment_id IN NUMBER
12526: ) RETURN VARCHAR2
12527: IS
12528:
12529: l_withdrawal_conf ben_ext_rslt_dtl.val_15%TYPE := ' ';
12530: l_proc_name varchar2(60) := g_proc_name || 'get_tp1_withdrawal_conf';
12531:
12532: BEGIN
12533:

Line 14012: l_london_allowance ben_ext_rslt_dtl.val_21%TYPE;

14008: l_temp_date DATE;
14009: l_temp_date_primary DATE;
14010: l_temp_sfgrade pqp_assignment_attributes_f.tp_safeguarded_grade%TYPE;
14011: l_new_sfgrade pqp_assignment_attributes_f.tp_safeguarded_grade%TYPE;
14012: l_london_allowance ben_ext_rslt_dtl.val_21%TYPE;
14013: l_sp_allowance ben_ext_rslt_dtl.val_22%TYPE;
14014: l_contract_indicator ben_ext_rslt_dtl.val_23%TYPE;
14015: l_rowcount NUMBER:=0;
14016: l_pqp_asg_attributes_up csr_pqp_asg_attributes_up%ROWTYPE;

Line 14013: l_sp_allowance ben_ext_rslt_dtl.val_22%TYPE;

14009: l_temp_date_primary DATE;
14010: l_temp_sfgrade pqp_assignment_attributes_f.tp_safeguarded_grade%TYPE;
14011: l_new_sfgrade pqp_assignment_attributes_f.tp_safeguarded_grade%TYPE;
14012: l_london_allowance ben_ext_rslt_dtl.val_21%TYPE;
14013: l_sp_allowance ben_ext_rslt_dtl.val_22%TYPE;
14014: l_contract_indicator ben_ext_rslt_dtl.val_23%TYPE;
14015: l_rowcount NUMBER:=0;
14016: l_pqp_asg_attributes_up csr_pqp_asg_attributes_up%ROWTYPE;
14017: l_asg_details csr_asg_details_up%ROWTYPE;

Line 14014: l_contract_indicator ben_ext_rslt_dtl.val_23%TYPE;

14010: l_temp_sfgrade pqp_assignment_attributes_f.tp_safeguarded_grade%TYPE;
14011: l_new_sfgrade pqp_assignment_attributes_f.tp_safeguarded_grade%TYPE;
14012: l_london_allowance ben_ext_rslt_dtl.val_21%TYPE;
14013: l_sp_allowance ben_ext_rslt_dtl.val_22%TYPE;
14014: l_contract_indicator ben_ext_rslt_dtl.val_23%TYPE;
14015: l_rowcount NUMBER:=0;
14016: l_pqp_asg_attributes_up csr_pqp_asg_attributes_up%ROWTYPE;
14017: l_asg_details csr_asg_details_up%ROWTYPE;
14018: l_temp_location_id per_all_assignments_f.location_id%TYPE;

Line 14074: -- ben_ext_rslt_dtl where the data element will be stored.

14070:
14071: -- PS : The serial numbers below are calcualted as
14072: -- (actual position of the data element) + 1
14073: -- This serial number gives us the column name in the table
14074: -- ben_ext_rslt_dtl where the data element will be stored.
14075: -- E.g. Salary Scale will be stored in column val_11
14076:
14077: -- Bugfix 3803760:FTSUPPLY
14078: -- Set the effective assignments as of effective start date

Line 14868: PROCEDURE upd_rslt_dtl(p_dtl_rec IN ben_ext_rslt_dtl%ROWTYPE)

14864: p_dtl_rec := l_dtl_rec_nc;
14865: RAISE;
14866: END; -- recalc_data_elements
14867:
14868: PROCEDURE upd_rslt_dtl(p_dtl_rec IN ben_ext_rslt_dtl%ROWTYPE)
14869: IS
14870:
14871: l_proc_name VARCHAR2(61):=
14872: g_proc_name||'upd_rslt_dtl';

Line 14878: UPDATE ben_ext_rslt_dtl

14874: BEGIN -- upd_rslt_dtl
14875:
14876: debug_enter(l_proc_name);
14877:
14878: UPDATE ben_ext_rslt_dtl
14879: SET VAL_01 = p_dtl_rec.VAL_01
14880: ,VAL_02 = p_dtl_rec.VAL_02
14881: ,VAL_03 = p_dtl_rec.VAL_03
14882: ,VAL_04 = p_dtl_rec.VAL_04

Line 14968: PROCEDURE ins_rslt_dtl(p_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE)

14964: debug_exit(' Others in '||l_proc_name);
14965: RAISE;
14966: END; -- upd_rslt_dtl
14967:
14968: PROCEDURE ins_rslt_dtl(p_dtl_rec IN OUT NOCOPY ben_ext_rslt_dtl%ROWTYPE)
14969: IS
14970:
14971:
14972: -- nocopy changes

Line 14973: l_dtl_rec_nc ben_ext_rslt_dtl%ROWTYPE;

14969: IS
14970:
14971:
14972: -- nocopy changes
14973: l_dtl_rec_nc ben_ext_rslt_dtl%ROWTYPE;
14974:
14975:
14976: l_proc_name VARCHAR2(61):=
14977: g_proc_name||'ins_rslt_dtl';

Line 14986: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO p_dtl_rec.ext_rslt_dtl_id FROM dual;

14982:
14983: -- nocopy changes
14984: l_dtl_rec_nc := p_dtl_rec;
14985:
14986: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO p_dtl_rec.ext_rslt_dtl_id FROM dual;
14987:
14988: INSERT INTO ben_ext_rslt_dtl
14989: (EXT_RSLT_DTL_ID
14990: ,EXT_RSLT_ID

Line 14988: INSERT INTO ben_ext_rslt_dtl

14984: l_dtl_rec_nc := p_dtl_rec;
14985:
14986: SELECT ben_ext_rslt_dtl_s.NEXTVAL INTO p_dtl_rec.ext_rslt_dtl_id FROM dual;
14987:
14988: INSERT INTO ben_ext_rslt_dtl
14989: (EXT_RSLT_DTL_ID
14990: ,EXT_RSLT_ID
14991: ,BUSINESS_GROUP_ID
14992: ,EXT_RCD_ID

Line 16725: DELETE BEN_EXT_RSLT_DTL

16721: l_prev_rec := l_cur_rec;
16722: END LOOP;
16723: -- delete the last record
16724: debug('Deleting record:'||l_prev_rec.val_26);
16725: DELETE BEN_EXT_RSLT_DTL
16726: WHERE EXT_RSLT_ID = l_prev_rec.ext_rslt_id
16727: AND PERSON_ID = l_prev_rec.person_id
16728: AND VAL_26 = l_prev_rec.val_26;
16729: END IF;

Line 17079: FROM ben_ext_rslt_dtl dtl

17075: FETCH csr_ext_rcd_id INTO l_ext_dtl_rcd_id;
17076: CLOSE csr_ext_rcd_id;
17077:
17078: DELETE
17079: FROM ben_ext_rslt_dtl dtl
17080: WHERE dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id
17081: AND dtl.ext_rcd_id = l_ext_dtl_rcd_id
17082: AND dtl.val_01 = 'DELETE';
17083:

Line 17099: (p_ext_rslt_id IN ben_ext_rslt_dtl.ext_rslt_id%TYPE

17095: --
17096: -- type1_post_proc_rule
17097: --
17098: FUNCTION type1_post_proc_rule
17099: (p_ext_rslt_id IN ben_ext_rslt_dtl.ext_rslt_id%TYPE
17100: ) RETURN VARCHAR2
17101: IS
17102:
17103: -- Variable Declaration