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.PN_VAR_DEFAULTS_PKG dependencies on PN_VAR_BKHD_DEFAULTS_ALL

Line 54: select * from pn_var_bkhd_defaults_all

50: select * from pn_var_line_defaults_all
51: where var_rent_id = l_old_rentid;
52:
53: cursor c_get_bkhddef (p_line_def_id NUMBER) is
54: select * from pn_var_bkhd_defaults_all
55: where line_default_id = p_line_def_id;
56:
57: cursor c_get_bkdtdef (p_bkhd_def_id NUMBER) is
58: select * from pn_var_bkdt_defaults_all

Line 121: insert into pn_var_bkhd_defaults_all (

117:
118: l_bkdtNum := 0;
119: l_bkhdNum := l_bkhdNum + 1;
120:
121: insert into pn_var_bkhd_defaults_all (
122: bkhd_default_id,
123: bkhd_detail_num,
124: line_default_id,
125: bkhd_start_date,

Line 552: from pn_var_bkhd_defaults_all

548: bkpt_head_template_id,
549: agreement_template_id,
550: last_update_login,
551: org_id*/
552: from pn_var_bkhd_defaults_all
553: where line_default_id = p_line_default_id
554: and NVL(processed_flag,0) <> 1;
555:
556: CURSOR c_bkdets (p_head_default_id NUMBER)

Line 629: FROM pn_var_bkhd_defaults_all

625: bkpt_head_template_id,
626: agreement_template_id,
627: last_update_login,
628: org_id */
629: FROM pn_var_bkhd_defaults_all
630: WHERE line_default_id = p_line_default_id
631: AND break_type = 'NATURAL';
632:
633: CURSOR c_bkdets_natural (p_head_default_id NUMBER)

Line 652: FROM pn_var_bkhd_defaults_all

648:
649: CURSOR header_defaults_cur(p_var_rent_id NUMBER)
650: IS
651: SELECT bkhd_default_id
652: FROM pn_var_bkhd_defaults_all
653: WHERE var_rent_id = p_var_rent_id;
654: --AND break_type = 'NATURAL';
655:
656: BEGIN

Line 1089: UPDATE pn_var_bkhd_defaults_all

1085:
1086: END LOOP;
1087: END LOOP;
1088:
1089: UPDATE pn_var_bkhd_defaults_all
1090: SET bkpt_update_flag = 'N'
1091: WHERE var_rent_id = x_var_rent_id;
1092:
1093: --For Artificial, Update only the ones which made it to pn_var_bkpts_head_all

Line 1099: FROM pn_var_bkhd_defaults_all a,

1095: UPDATE pn_var_bkdt_defaults_all
1096: SET processed_flag = 1
1097: WHERE var_rent_id = l_var_rent_id
1098: AND bkhd_default_id IN (SELECT a.bkhd_default_id
1099: FROM pn_var_bkhd_defaults_all a,
1100: pn_var_bkpts_head_all b
1101: WHERE a.var_rent_id = b.var_rent_id
1102: AND a.var_rent_id = l_var_rent_id
1103: AND a.bkhd_default_id = b.bkhd_default_id

Line 1118: UPDATE pn_var_bkhd_defaults_all

1114: FROM pn_var_bkdt_defaults_all
1115: WHERE bkhd_default_id = i.bkhd_default_id
1116: AND NVL(processed_flag,0) <> 1;
1117: IF l_cnt = 0 THEN
1118: UPDATE pn_var_bkhd_defaults_all
1119: SET processed_flag = 1
1120: WHERE var_rent_id = l_var_rent_id
1121: AND bkhd_default_id = i.bkhd_default_id;
1122: /* DBMS_OUTPUT.PUT_LINE(' Step3'); */

Line 1124: UPDATE pn_var_bkhd_defaults_all

1120: WHERE var_rent_id = l_var_rent_id
1121: AND bkhd_default_id = i.bkhd_default_id;
1122: /* DBMS_OUTPUT.PUT_LINE(' Step3'); */
1123: ELSE
1124: UPDATE pn_var_bkhd_defaults_all
1125: SET processed_flag = 0
1126: WHERE var_rent_id = l_var_rent_id
1127: AND bkhd_default_id = i.bkhd_default_id;
1128: /* DBMS_OUTPUT.PUT_LINE(' Step4'); */

Line 1197: UPDATE pn_var_bkhd_defaults_all

1193: UPDATE pn_var_line_defaults_all
1194: SET processed_flag = 0
1195: WHERE var_rent_id = X_VAR_RENT_ID;
1196:
1197: UPDATE pn_var_bkhd_defaults_all
1198: SET processed_flag = 0
1199: WHERE var_rent_id = X_VAR_RENT_ID;
1200:
1201: UPDATE pn_var_bkdt_defaults_all

Line 1257: UPDATE pn_var_bkhd_defaults_all

1253: UPDATE pn_var_line_defaults_all
1254: SET processed_flag = 0
1255: WHERE var_rent_id = X_VAR_RENT_ID;
1256:
1257: UPDATE pn_var_bkhd_defaults_all
1258: SET processed_flag = 0
1259: WHERE var_rent_id = X_VAR_RENT_ID
1260: AND bkhd_default_id = x_bkhd_default_id;
1261:

Line 1976: UPDATE pn_var_bkhd_defaults_all

1972: IS
1973:
1974: begin
1975:
1976: UPDATE pn_var_bkhd_defaults_all
1977: SET bkhd_start_date = (select min(bkdt_start_date)
1978: from pn_var_bkdt_defaults_all
1979: where var_rent_id = X_VAR_RENT_ID
1980: and bkhd_default_id = X_BKHD_DEFAULT_ID),

Line 1990: from pn_var_bkhd_defaults_all

1986: AND bkhd_default_id = X_BKHD_DEFAULT_ID;
1987:
1988: UPDATE pn_var_line_defaults_all
1989: SET line_start_date = (select min(bkhd_start_date)
1990: from pn_var_bkhd_defaults_all
1991: where var_rent_id = X_VAR_RENT_ID
1992: and line_default_id = X_LINE_DEFAULT_ID),
1993: line_end_date = (select max(bkhd_end_date)
1994: from pn_var_bkhd_defaults_all

Line 1994: from pn_var_bkhd_defaults_all

1990: from pn_var_bkhd_defaults_all
1991: where var_rent_id = X_VAR_RENT_ID
1992: and line_default_id = X_LINE_DEFAULT_ID),
1993: line_end_date = (select max(bkhd_end_date)
1994: from pn_var_bkhd_defaults_all
1995: where var_rent_id = X_VAR_RENT_ID
1996: and line_default_id = X_LINE_DEFAULT_ID)
1997: WHERE var_rent_id = X_VAR_RENT_ID
1998: AND line_default_id = X_LINE_DEFAULT_ID;

Line 2077: FROM pn_var_bkhd_defaults_all

2073: ,p_start_date DATE
2074: ,p_end_date DATE)
2075: IS
2076: SELECT *
2077: FROM pn_var_bkhd_defaults_all
2078: WHERE line_default_id = p_line_default_id
2079: AND bkhd_start_date <= p_end_date
2080: AND bkhd_end_date >= p_start_date;
2081:

Line 2114: FROM pn_var_bkhd_defaults_all

2110:
2111: CURSOR find_if_bkhd_exists_cur (p_line_def_id NUMBER)
2112: IS
2113: SELECT bkhd_default_id
2114: FROM pn_var_bkhd_defaults_all
2115: WHERE line_default_id = p_line_def_id;
2116:
2117: /* Cursor to check if a breakpoint detail default exists for
2118: a breakpoint Header default */

Line 2359: UPDATE pn_var_bkhd_defaults_all

2355: END LOOP; /* line_def_rec */
2356:
2357: END LOOP; /* per_rec */
2358:
2359: UPDATE pn_var_bkhd_defaults_all
2360: SET bkpt_update_flag = 'N'
2361: WHERE var_rent_id = l_var_rent_id;
2362:
2363: UPDATE pn_var_lines_all