APPS.PN_VAR_DEFAULTS_PKG dependencies on PN_VAR_BKDT_DEFAULTS_ALL

Line 58: select * from pn_var_bkdt_defaults_all

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
59: where bkhd_default_id = p_bkhd_def_id;
60:
61: begin
62:

Line 176: INSERT into pn_var_bkdt_defaults_all (

172:
173: l_bkdtNum := l_bkdtNum+1;
174:
175:
176: INSERT into pn_var_bkdt_defaults_all (
177: bkdt_default_id,
178: bkdt_detail_num,
179: bkhd_default_id,
180: bkdt_start_date,

Line 569: from pn_var_bkdt_defaults_all

565: group_bkpt_vol_end,
566: bkpt_rate,
567: org_id,
568: annual_basis_amount --03-NOV-2003 */
569: from pn_var_bkdt_defaults_all
570: where bkhd_default_id = p_head_default_id
571: and NVL(processed_flag,0) <> 1;
572:
573: CURSOR c_rep_periods(p_period_id NUMBER)

Line 646: FROM pn_var_bkdt_defaults_all

642: group_bkpt_vol_end,
643: bkpt_rate,
644: org_id,
645: annual_basis_amount --03-NOV-2003 */
646: FROM pn_var_bkdt_defaults_all
647: WHERE bkhd_default_id = p_head_default_id;
648:
649: CURSOR header_defaults_cur(p_var_rent_id NUMBER)
650: IS

Line 904: UPDATE pn_var_bkdt_defaults_all

900: l_bkhd_end_date := l_period_end;
901: END IF;
902:
903: IF c_head_rec.break_type = 'NATURAL' THEN
904: UPDATE pn_var_bkdt_defaults_all
905: SET processed_flag = 1
906: WHERE var_rent_id = l_var_rent_id
907: AND bkdt_default_id = c_det_rec.bkdt_default_id;
908: END IF;

Line 1071: UPDATE pn_var_bkdt_defaults_all

1067: IF l_bkhd_end_date is NULL OR l_period_end > l_bkhd_end_date THEN
1068: l_bkhd_end_date := l_period_end;
1069: END IF;
1070:
1071: UPDATE pn_var_bkdt_defaults_all
1072: SET processed_flag = 1
1073: WHERE var_rent_id = l_var_rent_id
1074: AND bkdt_default_id = c_det_rec.bkdt_default_id;
1075: END IF;

Line 1095: UPDATE pn_var_bkdt_defaults_all

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
1094: /* DBMS_OUTPUT.PUT_LINE(' Step1'); */
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,

Line 1114: FROM pn_var_bkdt_defaults_all

1110: --Set the header flag to 1 if all detail records are processed
1111: l_cnt := 0;
1112: SELECT COUNT(*)
1113: INTO l_cnt
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

Line 1201: UPDATE pn_var_bkdt_defaults_all

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
1202: SET processed_flag = 0
1203: WHERE var_rent_id = X_VAR_RENT_ID;
1204:
1205: --COMMIT;

Line 1262: UPDATE pn_var_bkdt_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:
1262: UPDATE pn_var_bkdt_defaults_all
1263: SET processed_flag = 0
1264: WHERE var_rent_id = X_VAR_RENT_ID
1265: AND bkhd_default_id = x_bkhd_default_id;
1266: --COMMIT;

Line 1343: delete from pn_var_bkdt_defaults_all

1339: ) IS
1340:
1341: begin
1342:
1343: delete from pn_var_bkdt_defaults_all
1344: where bkhd_default_id = X_BKHD_DEFAULT_ID;
1345:
1346: --commit;
1347:

Line 1978: from pn_var_bkdt_defaults_all

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),
1981: bkhd_end_date = (select max(bkdt_end_date)
1982: from pn_var_bkdt_defaults_all

Line 1982: from pn_var_bkdt_defaults_all

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),
1981: bkhd_end_date = (select max(bkdt_end_date)
1982: from pn_var_bkdt_defaults_all
1983: where var_rent_id = X_VAR_RENT_ID
1984: and bkhd_default_id = X_BKHD_DEFAULT_ID)
1985: WHERE var_rent_id = X_VAR_RENT_ID
1986: AND bkhd_default_id = X_BKHD_DEFAULT_ID;

Line 2091: FROM pn_var_bkdt_defaults_all

2087: ,p_start_date DATE
2088: ,p_end_date DATE)
2089: IS
2090: SELECT *
2091: FROM pn_var_bkdt_defaults_all
2092: WHERE bkhd_default_id = p_head_default_id
2093: AND bkdt_start_date <= p_end_date
2094: AND bkdt_end_date >= p_start_date;
2095:

Line 2125: from pn_var_bkdt_defaults_all

2121: IS
2122: SELECT 'x' bkdt_exists
2123: FROM DUAL
2124: WHERE EXISTS (SELECT null
2125: from pn_var_bkdt_defaults_all
2126: where bkhd_default_id = p_bkhd_def_id);
2127:
2128: BEGIN
2129: