APPS.AR_VAT_TAX_PKG dependencies on AR_VAT_TAX_ALL_B

Line 90: cursor C is select ROWID from AR_VAT_TAX_ALL_B

86:
87: l_lookup_type NUMBER;
88: l_fnd_lkp_rowid VARCHAR2(30);
89:
90: cursor C is select ROWID from AR_VAT_TAX_ALL_B
91: where VAT_TAX_ID = X_VAT_TAX_ID
92: ;
93: begin
94:

Line 109: insert into AR_VAT_TAX_ALL_B (

105: SUBSTRB(USERENV('CLIENT_INFO'),1,10)))
106: into X_ORG_ID
107: from dual; */
108:
109: insert into AR_VAT_TAX_ALL_B (
110: ORG_ID,
111: TAX_CONSTRAINT_ID,
112: TAX_CLASS,
113: DISPLAYED_FLAG,

Line 633: from AR_VAT_TAX_ALL_B

629: ORG_ID,
630: TAX_REGIME_CODE,
631: TAX,
632: TAX_STATUS_CODE
633: from AR_VAT_TAX_ALL_B
634: where VAT_TAX_ID = X_VAT_TAX_ID
635: /* and ORG_ID = X_ORG_ID
636: and NVL(ORG_ID,NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',
637: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) =

Line 900: update AR_VAT_TAX_ALL_B set

896: X_TAX in VARCHAR2 DEFAULT NULL,
897: X_TAX_STATUS_CODE in VARCHAR2 DEFAULT NULL
898: ) is
899: begin
900: update AR_VAT_TAX_ALL_B set
901: TAX_CONSTRAINT_ID = X_TAX_CONSTRAINT_ID,
902: TAX_CLASS = X_TAX_CLASS,
903: DISPLAYED_FLAG = X_DISPLAYED_FLAG,
904: ENABLED_FLAG = X_ENABLED_FLAG,

Line 1100: delete from AR_VAT_TAX_ALL_B

1096: if (sql%notfound) then
1097: raise no_data_found;
1098: end if;
1099:
1100: delete from AR_VAT_TAX_ALL_B
1101: where VAT_TAX_ID = X_VAT_TAX_ID;
1102: /* moac yk and NVL(ORG_ID,NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',
1103: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) =
1104: NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',

Line 1118: from AR_VAT_TAX_ALL_B B

1114: begin
1115: delete from AR_VAT_TAX_ALL_TL T
1116: where not exists
1117: (select NULL
1118: from AR_VAT_TAX_ALL_B B
1119: where B.VAT_TAX_ID = T.VAT_TAX_ID
1120: /* moac yk2 and NVL(B.ORG_ID,NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',
1121: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) =
1122: NVL(T.ORG_ID, NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',