98: to_postal_code in varchar2,
99: start_date in date,
100: end_date in date) return number IS
101:
102: CURSOR ar_sales_tax_s_c is
103: select ar_sales_tax_s.nextval + arp_standard.sequence_offset
104: from dual;
105:
106: sales_tax_id NUMBER;
99: start_date in date,
100: end_date in date) return number IS
101:
102: CURSOR ar_sales_tax_s_c is
103: select ar_sales_tax_s.nextval + arp_standard.sequence_offset
104: from dual;
105:
106: sales_tax_id NUMBER;
107:
112: IF PG_DEBUG = 'Y' THEN
113: arp_util_tax.debug( '>> INS_SALES_TAX' );
114: END IF;
115:
116: OPEN ar_sales_tax_s_c;
117: FETCH ar_sales_tax_s_c into sales_tax_id;
118: CLOSE ar_sales_tax_s_c;
119:
120: insert into ar_sales_tax(
113: arp_util_tax.debug( '>> INS_SALES_TAX' );
114: END IF;
115:
116: OPEN ar_sales_tax_s_c;
117: FETCH ar_sales_tax_s_c into sales_tax_id;
118: CLOSE ar_sales_tax_s_c;
119:
120: insert into ar_sales_tax(
121: SALES_TAX_ID,
114: END IF;
115:
116: OPEN ar_sales_tax_s_c;
117: FETCH ar_sales_tax_s_c into sales_tax_id;
118: CLOSE ar_sales_tax_s_c;
119:
120: insert into ar_sales_tax(
121: SALES_TAX_ID,
122: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
746: -- So we do not want to delete it,intead, set enabled to 'N'
747: -- (This part is added because the AR foreign key constraint
748: -- is not shipped to customers )
749: --
750: UPDATE ar_sales_tax SET enabled_flag = 'N',
751: last_update_date = sysdate,
752: last_updated_by = arp_standard.profile.user_id
753: WHERE rowid = tax_rate_rec.rowid;
754: END IF;
794: start_date,
795: end_date,
796: enabled_flag)
797: select
798: AR_SALES_TAX_S.NEXTVAL+arp_standard.sequence_offset,
799: sysdate,
800: arp_standard.profile.user_id,
801: null,
802: arp_standard.profile.user_id,
875: start_date,
876: end_date,
877: enabled_flag)
878: select
879: AR_SALES_TAX_S.NEXTVAL+arp_standard.sequence_offset,
880: sysdate,
881: arp_standard.profile.user_id,
882: null,
883: arp_standard.profile.user_id,
1010: -- So we do not want to delete it,intead, set enabled to 'N'
1011: -- (This part is added because the AR foreign key constraint
1012: -- is not shipped to customers )
1013: --
1014: UPDATE ar_sales_tax SET enabled_flag = 'N',
1015: last_update_date = sysdate,
1016: last_updated_by = arp_standard.profile.user_id
1017: WHERE rowid = tax.rowid;
1018: END IF;
1917: start_date,
1918: end_date,
1919: enabled_flag)
1920: select
1921: AR_SALES_TAX_S.NEXTVAL+arp_standard.sequence_offset,
1922: sysdate,
1923: arp_standard.profile.user_id,
1924: null,
1925: arp_standard.profile.user_id,