APPS.PN_VAR_DEFAULTS_PKG dependencies on PN_VAR_LINE_DEFAULTS_ALL

Line 50: select * from pn_var_line_defaults_all

46: l_bkdtDefId NUMBER := NULL;
47: l_bkdtNum NUMBER := 0;
48:
49: cursor c_get_linedef is
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

Line 75: insert into pn_var_line_defaults_all (

71:
72: l_bkhdNum := 0;
73: l_lineNum := l_lineNum + 1;
74:
75: insert into pn_var_line_defaults_all (
76: line_default_id,
77: line_num,
78: var_rent_id,
79: sales_type_code,

Line 527: FROM pn_var_line_defaults_all

523: line_end_date,
524: line_default_id,
525: created_by,
526: org_id*/
527: FROM pn_var_line_defaults_all
528: WHERE var_rent_id = l_var_rent_id
529: --AND NVL(processed_flag,0) <> 1
530: AND (p_start_date BETWEEN line_start_date AND line_end_date
531: OR p_end_date BETWEEN line_start_date AND line_end_date

Line 739: UPDATE pn_var_line_defaults_all

735: c_line_rec.line_default_id,
736: l_var_rent_id);
737:
738: /*
739: UPDATE pn_var_line_defaults_all
740: SET processed_flag = 1
741: WHERE var_rent_id = l_var_rent_id
742: AND line_default_id = c_line_rec.line_default_id
743: AND line_start_date >= c_period_rec.start_date

Line 1147: | Delete records from the PN_VAR_LINE_DEFAULTS_ALL tables.

1143: | PROCEDURE DELETE_DEFAULT_LINES
1144: |
1145: |
1146: | DESCRIPTION
1147: | Delete records from the PN_VAR_LINE_DEFAULTS_ALL tables.
1148: |
1149: | SCOPE - PUBLIC
1150: |
1151: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 1193: UPDATE pn_var_line_defaults_all

1189: WHERE var_rent_id = X_VAR_RENT_ID;*/
1190:
1191: --COMMIT;
1192:
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

Line 1253: UPDATE pn_var_line_defaults_all

1249: WHERE var_rent_id = X_VAR_RENT_ID
1250: AND bkhd_default_id = x_bkhd_default_id;
1251: -- COMMIT;
1252:
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

Line 1317: | Delete records from the PN_VAR_LINE_DEFAULTS_ALL tables.

1313: | PROCEDURE RESET_DEFAULT_LINES
1314: |
1315: |
1316: | DESCRIPTION
1317: | Delete records from the PN_VAR_LINE_DEFAULTS_ALL tables.
1318: |
1319: | SCOPE - PUBLIC
1320: |
1321: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 1709: FROM pn_var_line_defaults_all

1705: BEGIN
1706:
1707: SELECT 1
1708: INTO l_line_found
1709: FROM pn_var_line_defaults_all
1710: WHERE var_rent_id = p_var_rent_id
1711: AND rownum < 2;
1712:
1713: RETURN l_line_found;

Line 1988: UPDATE pn_var_line_defaults_all

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;
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),

Line 2065: FROM pn_var_line_defaults_all

2061: CURSOR cur_line_def (p_start_date DATE
2062: ,p_end_date DATE)
2063: IS
2064: SELECT *
2065: FROM pn_var_line_defaults_all
2066: WHERE var_rent_id = l_var_rent_id;
2067:
2068:
2069: /* Cursor to fetch all breakpoint header defaults

Line 2209: /* UPDATE PN_VAR_LINES_ALL, using data from PN_VAR_LINE_DEFAULTS_ALL */

2205:
2206:
2207: ELSE
2208:
2209: /* UPDATE PN_VAR_LINES_ALL, using data from PN_VAR_LINE_DEFAULTS_ALL */
2210:
2211: /*dbms_output.put_line('at update');
2212: dbms_output.put_line('l_line_item_id '||l_line_item_id);*/
2213: