6780: RETURN BOOLEAN IS
6781:
6782: CURSOR term_temp_type_cur(p_term_temp_id IN NUMBER) IS
6783: SELECT term_template_type
6784: FROM pn_term_templates_all
6785: WHERE term_template_id = p_term_temp_id;
6786:
6787: CURSOR term_temp_bill_cur(p_term_temp_id IN NUMBER) IS
6788: SELECT payment_purpose_code,
6791: customer_id,
6792: customer_site_use_id,
6793: ap_ar_term_id,
6794: cust_trx_type_id
6795: FROM pn_term_templates_all
6796: WHERE term_template_id = p_term_temp_id;
6797:
6798: CURSOR term_temp_pay_cur(p_term_temp_id IN NUMBER) IS
6799: SELECT payment_purpose_code,
6801: currency_code,
6802: ap_ar_term_id,
6803: vendor_id,
6804: vendor_site_id
6805: FROM pn_term_templates_all
6806: WHERE term_template_id = p_term_temp_id;
6807:
6808: BEGIN
6809:
6880: BEGIN
6881:
6882: SELECT name
6883: INTO l_term_temp_name
6884: FROM pn_term_templates_all
6885: WHERE term_template_id = p_term_temp_id;
6886:
6887: RETURN(l_term_temp_name);
6888: