APPS.PN_VAREN_PVT dependencies on PN_VAR_LINE_DEFAULTS_ALL

Line 518: FROM pn_var_line_defaults_all

514:
515: CURSOR exists_line_cur
516: IS
517: SELECT line_default_id
518: FROM pn_var_line_defaults_all
519: WHERE var_rent_id = p_var_rent_id;
520:
521: CURSOR exists_hd_def_cur
522: IS

Line 1473: l_line_default_id pn_var_line_defaults_all.line_default_id%TYPE := NULL;

1469: p_variable_rent_lines_rec_type IN OUT NOCOPY variable_rent_lines_rec_type
1470: , x_return_status OUT NOCOPY VARCHAR2
1471: )
1472: IS
1473: l_line_default_id pn_var_line_defaults_all.line_default_id%TYPE := NULL;
1474: l_line_num pn_var_line_defaults_all.line_num%TYPE;
1475: -- l_line_start_date would be same a variable rent commencement_date
1476: l_line_start_date pn_var_line_defaults_all.line_start_date%TYPE;
1477: -- l_end_date would be same a variable rent termination_date

Line 1474: l_line_num pn_var_line_defaults_all.line_num%TYPE;

1470: , x_return_status OUT NOCOPY VARCHAR2
1471: )
1472: IS
1473: l_line_default_id pn_var_line_defaults_all.line_default_id%TYPE := NULL;
1474: l_line_num pn_var_line_defaults_all.line_num%TYPE;
1475: -- l_line_start_date would be same a variable rent commencement_date
1476: l_line_start_date pn_var_line_defaults_all.line_start_date%TYPE;
1477: -- l_end_date would be same a variable rent termination_date
1478: l_line_end_date pn_var_line_defaults_all.line_end_date%TYPE;

Line 1476: l_line_start_date pn_var_line_defaults_all.line_start_date%TYPE;

1472: IS
1473: l_line_default_id pn_var_line_defaults_all.line_default_id%TYPE := NULL;
1474: l_line_num pn_var_line_defaults_all.line_num%TYPE;
1475: -- l_line_start_date would be same a variable rent commencement_date
1476: l_line_start_date pn_var_line_defaults_all.line_start_date%TYPE;
1477: -- l_end_date would be same a variable rent termination_date
1478: l_line_end_date pn_var_line_defaults_all.line_end_date%TYPE;
1479: l_agreement_template_id pn_var_line_defaults_all.agreement_template_id%TYPE;
1480: l_processed_flag pn_var_line_defaults_all.processed_flag%TYPE := NULL;

Line 1478: l_line_end_date pn_var_line_defaults_all.line_end_date%TYPE;

1474: l_line_num pn_var_line_defaults_all.line_num%TYPE;
1475: -- l_line_start_date would be same a variable rent commencement_date
1476: l_line_start_date pn_var_line_defaults_all.line_start_date%TYPE;
1477: -- l_end_date would be same a variable rent termination_date
1478: l_line_end_date pn_var_line_defaults_all.line_end_date%TYPE;
1479: l_agreement_template_id pn_var_line_defaults_all.agreement_template_id%TYPE;
1480: l_processed_flag pn_var_line_defaults_all.processed_flag%TYPE := NULL;
1481: l_var_rent_exist NUMBER;
1482: l_var_rent_id pn_var_rents_all.var_rent_id%TYPE;

Line 1479: l_agreement_template_id pn_var_line_defaults_all.agreement_template_id%TYPE;

1475: -- l_line_start_date would be same a variable rent commencement_date
1476: l_line_start_date pn_var_line_defaults_all.line_start_date%TYPE;
1477: -- l_end_date would be same a variable rent termination_date
1478: l_line_end_date pn_var_line_defaults_all.line_end_date%TYPE;
1479: l_agreement_template_id pn_var_line_defaults_all.agreement_template_id%TYPE;
1480: l_processed_flag pn_var_line_defaults_all.processed_flag%TYPE := NULL;
1481: l_var_rent_exist NUMBER;
1482: l_var_rent_id pn_var_rents_all.var_rent_id%TYPE;
1483: BEGIN

Line 1480: l_processed_flag pn_var_line_defaults_all.processed_flag%TYPE := NULL;

1476: l_line_start_date pn_var_line_defaults_all.line_start_date%TYPE;
1477: -- l_end_date would be same a variable rent termination_date
1478: l_line_end_date pn_var_line_defaults_all.line_end_date%TYPE;
1479: l_agreement_template_id pn_var_line_defaults_all.agreement_template_id%TYPE;
1480: l_processed_flag pn_var_line_defaults_all.processed_flag%TYPE := NULL;
1481: l_var_rent_exist NUMBER;
1482: l_var_rent_id pn_var_rents_all.var_rent_id%TYPE;
1483: BEGIN
1484: -- NULL;

Line 1595: -- not used in pn_var_line_defaults_all

1591: , x_var_rent_id => p_variable_rent_lines_rec_type.var_rent_id
1592: , x_sales_type_code => p_variable_rent_lines_rec_type.sales_channel_code
1593: , x_item_category_code => p_variable_rent_lines_rec_type.item_category_code
1594: , x_line_template_id => NULL
1595: -- not used in pn_var_line_defaults_all
1596: , x_agreement_template_id => l_agreement_template_id
1597: , x_line_start_date => l_line_start_date
1598: , x_line_end_date => l_line_end_date
1599: , x_processed_flag => l_processed_flag

Line 5446: UPDATE pn_var_line_defaults_all

5442: END;
5443: END LOOP;--p_breakpoint_header_tbl
5444:
5445: BEGIN
5446: UPDATE pn_var_line_defaults_all
5447: SET line_start_date = (SELECT MIN(bkhd_start_date)
5448: FROM pn_var_bkhd_defaults_all
5449: WHERE line_default_id = p_variable_rent_lines_tbl(i).line_default_id
5450: AND org_id = g_org_id

Line 9904: FROM pn_var_line_defaults_all

9900: IS
9901: SELECT COUNT (*)
9902: FROM pn_var_bkhd_defaults_all
9903: WHERE line_default_id IN (SELECT line_default_id
9904: FROM pn_var_line_defaults_all
9905: WHERE var_rent_id = p_var_rent_id);
9906:
9907: CURSOR c_vol_histexist --(p_chg_cal_var_rent_id number)
9908: IS

Line 10277: DELETE pn_var_line_defaults_all

10273:
10274: DELETE pn_var_bkhd_defaults_all
10275: WHERE var_rent_id = l_varentid;
10276:
10277: DELETE pn_var_line_defaults_all
10278: WHERE var_rent_id = l_varentid;
10279:
10280: DELETE pn_var_constr_defaults_all
10281: WHERE var_rent_id = l_varentid;

Line 10660: FROM pn_var_line_defaults_all

10656: , attribute13
10657: , attribute14
10658: , attribute15
10659: , org_id
10660: FROM pn_var_line_defaults_all
10661: -- WHERE var_rent_id = p_upd_var_rent_rec.var_rent_id; -- Commented by Vivek on 09-DEC-2010
10662: WHERE line_default_id = p_line_default_id -- Added by Vivek on 09DEC-2010
10663: AND var_rent_id = p_var_rent_id;
10664: