APPS.AR_MEMO_LINES_PKG dependencies on AR_MEMO_LINES_ALL_B

Line 64: cursor C is select ROWID from AR_MEMO_LINES_ALL_B

60: X_LAST_UPDATE_LOGIN in NUMBER,
61: X_TAX_PRODUCT_CATEGORY in VARCHAR2
62: ) is
63: -- SSA chnages anukumar X_ORG_ID NUMBER;
64: cursor C is select ROWID from AR_MEMO_LINES_ALL_B
65: where MEMO_LINE_ID = X_MEMO_LINE_ID
66: ;
67: begin
68:

Line 83: insert into AR_MEMO_LINES_ALL_B (

79: into X_ORG_ID
80: from dual;
81: */
82:
83: insert into AR_MEMO_LINES_ALL_B (
84: ORG_ID,
85: MEMO_LINE_ID,
86: SET_OF_BOOKS_ID,
87: LINE_TYPE,

Line 350: from AR_MEMO_LINES_ALL_B

346: GLOBAL_ATTRIBUTE18,
347: GLOBAL_ATTRIBUTE19,
348: GLOBAL_ATTRIBUTE20,
349: TAX_PRODUCT_CATEGORY /* ETAX */
350: from AR_MEMO_LINES_ALL_B
351: where MEMO_LINE_ID = X_MEMO_LINE_ID
352: /* SSA chnages anukumer
353: and NVL(ORG_ID,NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',
354: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) =

Line 561: update AR_MEMO_LINES_ALL_B set

557: X_LAST_UPDATE_LOGIN in NUMBER,
558: X_TAX_PRODUCT_CATEGORY in VARCHAR2
559: ) is
560: begin
561: update AR_MEMO_LINES_ALL_B set
562: SET_OF_BOOKS_ID = X_SET_OF_BOOKS_ID,
563: LINE_TYPE = X_LINE_TYPE,
564: START_DATE = X_START_DATE,
565: GL_ID_REV = X_GL_ID_REV,

Line 667: delete from AR_MEMO_LINES_ALL_B

663: if (sql%notfound) then
664: raise no_data_found;
665: end if;
666:
667: delete from AR_MEMO_LINES_ALL_B
668: where MEMO_LINE_ID = X_MEMO_LINE_ID
669: /* SSA chnages anukumar
670: and NVL(ORG_ID,NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',
671: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) =

Line 690: from AR_MEMO_LINES_ALL_B B

686:
687: delete from AR_MEMO_LINES_ALL_TL T
688: where not exists
689: (select NULL
690: from AR_MEMO_LINES_ALL_B B
691: where B.MEMO_LINE_ID = T.MEMO_LINE_ID
692: and NVL(B.ORG_ID,NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',
693: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) =
694: NVL(T.ORG_ID, NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',