APPS.OKS_IMPORT_VALIDATE dependencies on OKS_NOTES_INTERFACE

Line 5413: ,'OKS_NOTES_INTERFACE'

5409: ,ERROR_MSG
5410: ,MSG_TOKENS)
5411: VALUES (G_WORKER_REQ_ID
5412: ,HEADER_INTERFACE_ROWID
5413: ,'OKS_NOTES_INTERFACE'
5414: ,NOTES_INTERFACE_ID
5415: ,'OKS_IMP_NTINT_INVALID_NTSTAT'
5416: ,NULL)
5417: WHEN (NOTE_TYPE_VALID='N') THEN

Line 5427: ,'OKS_NOTES_INTERFACE'

5423: ,ERROR_MSG
5424: ,MSG_TOKENS)
5425: VALUES (G_WORKER_REQ_ID
5426: ,HEADER_INTERFACE_ROWID
5427: ,'OKS_NOTES_INTERFACE'
5428: ,NOTES_INTERFACE_ID
5429: ,'OKS_IMP_NTINT_INVALID_NTTYPE'
5430: ,NULL)
5431: WHEN (ENTERED_BY_VALID ='N') THEN

Line 5441: ,'OKS_NOTES_INTERFACE'

5437: ,ERROR_MSG
5438: ,MSG_TOKENS)
5439: VALUES (G_WORKER_REQ_ID
5440: ,HEADER_INTERFACE_ROWID
5441: ,'OKS_NOTES_INTERFACE'
5442: ,NOTES_INTERFACE_ID
5443: ,'OKS_IMP_NTINT_INVALID_USR'
5444: ,NULL)
5445: WHEN (ENTERED_DT_VALID ='N') THEN

Line 5455: ,'OKS_NOTES_INTERFACE'

5451: ,ERROR_MSG
5452: ,MSG_TOKENS)
5453: VALUES (G_WORKER_REQ_ID
5454: ,HEADER_INTERFACE_ROWID
5455: ,'OKS_NOTES_INTERFACE'
5456: ,NOTES_INTERFACE_ID
5457: ,'OKS_IMP_NTINT_INVALID_ENTDT'
5458: ,NULL)
5459: WHEN (NOTES IS NULL ) THEN

Line 5469: ,'OKS_NOTES_INTERFACE'

5465: ,ERROR_MSG
5466: ,MSG_TOKENS)
5467: VALUES (G_WORKER_REQ_ID
5468: ,HEADER_INTERFACE_ROWID
5469: ,'OKS_NOTES_INTERFACE'
5470: ,NOTES_INTERFACE_ID
5471: ,'OKS_IMP_NTINT_INVALID_NOTES'
5472: ,NULL)
5473:

Line 5499: FROM OKS_NOTES_INTERFACE ONI

5495: ,(CASE WHEN ONI.ENTERED_DATE > SYSDATE THEN 'N'
5496: ELSE 'Y'
5497: END) ENTERED_DT_VALID
5498:
5499: FROM OKS_NOTES_INTERFACE ONI
5500: ,OKS_INT_HEADER_STG_TEMP OHSTG
5501: ,FND_LOOKUPS NTSTATUS
5502: ,FND_LOOKUPS NTTYPE
5503: ,FND_USER USR

Line 5526: ,'OKS_NOTES_INTERFACE'

5522: ,ERROR_MSG
5523: ,MSG_TOKENS)
5524: VALUES (G_WORKER_REQ_ID
5525: ,HEADER_INTERFACE_ROWID
5526: ,'OKS_NOTES_INTERFACE'
5527: ,NOTES_INTERFACE_ID
5528: ,'OKS_IMP_NTINT_INVALID_NTSTAT'
5529: ,NULL)
5530: WHEN (NOTE_TYPE_VALID='N') THEN

Line 5540: ,'OKS_NOTES_INTERFACE'

5536: ,ERROR_MSG
5537: ,MSG_TOKENS)
5538: VALUES (G_WORKER_REQ_ID
5539: ,HEADER_INTERFACE_ROWID
5540: ,'OKS_NOTES_INTERFACE'
5541: ,NOTES_INTERFACE_ID
5542: ,'OKS_IMP_NTINT_INVALID_NTTYPE'
5543: ,NULL)
5544: WHEN (ENTERED_BY_VALID ='N') THEN

Line 5554: ,'OKS_NOTES_INTERFACE'

5550: ,ERROR_MSG
5551: ,MSG_TOKENS)
5552: VALUES (G_WORKER_REQ_ID
5553: ,HEADER_INTERFACE_ROWID
5554: ,'OKS_NOTES_INTERFACE'
5555: ,NOTES_INTERFACE_ID
5556: ,'OKS_IMP_NTINT_INVALID_USR'
5557: ,NULL)
5558: WHEN (ENTERED_DT_VALID ='N') THEN

Line 5568: ,'OKS_NOTES_INTERFACE'

5564: ,ERROR_MSG
5565: ,MSG_TOKENS)
5566: VALUES (G_WORKER_REQ_ID
5567: ,HEADER_INTERFACE_ROWID
5568: ,'OKS_NOTES_INTERFACE'
5569: ,NOTES_INTERFACE_ID
5570: ,'OKS_IMP_NTINT_INVALID_ENTDT'
5571: ,NULL)
5572: WHEN (NOTES IS NULL ) THEN

Line 5582: ,'OKS_NOTES_INTERFACE'

5578: ,ERROR_MSG
5579: ,MSG_TOKENS)
5580: VALUES (G_WORKER_REQ_ID
5581: ,HEADER_INTERFACE_ROWID
5582: ,'OKS_NOTES_INTERFACE'
5583: ,NOTES_INTERFACE_ID
5584: ,'OKS_IMP_NTINT_INVALID_NOTES'
5585: ,NULL)
5586:

Line 5612: FROM OKS_NOTES_INTERFACE ONI

5608: ,(CASE WHEN ONI.ENTERED_DATE > SYSDATE THEN 'N'
5609: ELSE 'Y'
5610: END) ENTERED_DT_VALID
5611:
5612: FROM OKS_NOTES_INTERFACE ONI
5613: ,OKS_INT_LINE_STG_TEMP OLSTG
5614: ,FND_LOOKUPS NTSTATUS
5615: ,FND_LOOKUPS NTTYPE
5616: ,FND_USER USR

Line 5628: SELECT count(1) INTO l_line_notes_count FROM OKS_NOTES_INTERFACE ONI

5624:
5625:
5626: IF G_STMT_LOG THEN
5627:
5628: SELECT count(1) INTO l_line_notes_count FROM OKS_NOTES_INTERFACE ONI
5629: WHERE EXISTS (SELECT 'X' FROM OKS_INT_LINE_STG_TEMP
5630: WHERE LINE_INTERFACE_ID = ONI.LINE_INTERFACE_ID);
5631:
5632: SELECT count(1) INTO l_header_notes_count FROM OKS_NOTES_INTERFACE ONI

Line 5632: SELECT count(1) INTO l_header_notes_count FROM OKS_NOTES_INTERFACE ONI

5628: SELECT count(1) INTO l_line_notes_count FROM OKS_NOTES_INTERFACE ONI
5629: WHERE EXISTS (SELECT 'X' FROM OKS_INT_LINE_STG_TEMP
5630: WHERE LINE_INTERFACE_ID = ONI.LINE_INTERFACE_ID);
5631:
5632: SELECT count(1) INTO l_header_notes_count FROM OKS_NOTES_INTERFACE ONI
5633: WHERE EXISTS (SELECT 'X' FROM OKS_INT_HEADER_STG_TEMP
5634: WHERE HEADER_INTERFACE_ID = ONI.HEADER_INTERFACE_ID)
5635: AND ONI.LINE_INTERFACE_ID IS NULL;
5636: