APPS.ARP_STAX_MINUS99 dependencies on AR_SALES_TAX_S

Line 102: CURSOR ar_sales_tax_s_c is

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;

Line 103: select ar_sales_tax_s.nextval + arp_standard.sequence_offset

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:

Line 116: OPEN ar_sales_tax_s_c;

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(

Line 117: FETCH ar_sales_tax_s_c into sales_tax_id;

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,

Line 118: CLOSE ar_sales_tax_s_c;

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,

Line 750: UPDATE ar_sales_tax SET enabled_flag = 'N',

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;

Line 798: AR_SALES_TAX_S.NEXTVAL+arp_standard.sequence_offset,

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,

Line 879: AR_SALES_TAX_S.NEXTVAL+arp_standard.sequence_offset,

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,

Line 1014: UPDATE ar_sales_tax SET enabled_flag = 'N',

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;

Line 1921: AR_SALES_TAX_S.NEXTVAL+arp_standard.sequence_offset,

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,