APPS.OKS_IMPORT_VALIDATE dependencies on OKS_NOTES_INTERFACE

Line 5557: ,'OKS_NOTES_INTERFACE'

5553: ,ERROR_MSG
5554: ,MSG_TOKENS)
5555: VALUES (G_WORKER_REQ_ID
5556: ,HEADER_INTERFACE_ROWID
5557: ,'OKS_NOTES_INTERFACE'
5558: ,NOTES_INTERFACE_ID
5559: ,'OKS_IMP_NTINT_INVALID_NTSTAT'
5560: ,NULL)
5561: WHEN (NOTE_TYPE_VALID='N') THEN

Line 5571: ,'OKS_NOTES_INTERFACE'

5567: ,ERROR_MSG
5568: ,MSG_TOKENS)
5569: VALUES (G_WORKER_REQ_ID
5570: ,HEADER_INTERFACE_ROWID
5571: ,'OKS_NOTES_INTERFACE'
5572: ,NOTES_INTERFACE_ID
5573: ,'OKS_IMP_NTINT_INVALID_NTTYPE'
5574: ,NULL)
5575: WHEN (ENTERED_BY_VALID ='N') THEN

Line 5585: ,'OKS_NOTES_INTERFACE'

5581: ,ERROR_MSG
5582: ,MSG_TOKENS)
5583: VALUES (G_WORKER_REQ_ID
5584: ,HEADER_INTERFACE_ROWID
5585: ,'OKS_NOTES_INTERFACE'
5586: ,NOTES_INTERFACE_ID
5587: ,'OKS_IMP_NTINT_INVALID_USR'
5588: ,NULL)
5589: WHEN (ENTERED_DT_VALID ='N') THEN

Line 5599: ,'OKS_NOTES_INTERFACE'

5595: ,ERROR_MSG
5596: ,MSG_TOKENS)
5597: VALUES (G_WORKER_REQ_ID
5598: ,HEADER_INTERFACE_ROWID
5599: ,'OKS_NOTES_INTERFACE'
5600: ,NOTES_INTERFACE_ID
5601: ,'OKS_IMP_NTINT_INVALID_ENTDT'
5602: ,NULL)
5603: WHEN (NOTES IS NULL ) THEN

Line 5613: ,'OKS_NOTES_INTERFACE'

5609: ,ERROR_MSG
5610: ,MSG_TOKENS)
5611: VALUES (G_WORKER_REQ_ID
5612: ,HEADER_INTERFACE_ROWID
5613: ,'OKS_NOTES_INTERFACE'
5614: ,NOTES_INTERFACE_ID
5615: ,'OKS_IMP_NTINT_INVALID_NOTES'
5616: ,NULL)
5617:

Line 5643: FROM OKS_NOTES_INTERFACE ONI

5639: ,(CASE WHEN ONI.ENTERED_DATE > SYSDATE THEN 'N'
5640: ELSE 'Y'
5641: END) ENTERED_DT_VALID
5642:
5643: FROM OKS_NOTES_INTERFACE ONI
5644: ,OKS_INT_HEADER_STG_TEMP OHSTG
5645: ,FND_LOOKUPS NTSTATUS
5646: ,FND_LOOKUPS NTTYPE
5647: ,FND_USER USR

Line 5670: ,'OKS_NOTES_INTERFACE'

5666: ,ERROR_MSG
5667: ,MSG_TOKENS)
5668: VALUES (G_WORKER_REQ_ID
5669: ,HEADER_INTERFACE_ROWID
5670: ,'OKS_NOTES_INTERFACE'
5671: ,NOTES_INTERFACE_ID
5672: ,'OKS_IMP_NTINT_INVALID_NTSTAT'
5673: ,NULL)
5674: WHEN (NOTE_TYPE_VALID='N') THEN

Line 5684: ,'OKS_NOTES_INTERFACE'

5680: ,ERROR_MSG
5681: ,MSG_TOKENS)
5682: VALUES (G_WORKER_REQ_ID
5683: ,HEADER_INTERFACE_ROWID
5684: ,'OKS_NOTES_INTERFACE'
5685: ,NOTES_INTERFACE_ID
5686: ,'OKS_IMP_NTINT_INVALID_NTTYPE'
5687: ,NULL)
5688: WHEN (ENTERED_BY_VALID ='N') THEN

Line 5698: ,'OKS_NOTES_INTERFACE'

5694: ,ERROR_MSG
5695: ,MSG_TOKENS)
5696: VALUES (G_WORKER_REQ_ID
5697: ,HEADER_INTERFACE_ROWID
5698: ,'OKS_NOTES_INTERFACE'
5699: ,NOTES_INTERFACE_ID
5700: ,'OKS_IMP_NTINT_INVALID_USR'
5701: ,NULL)
5702: WHEN (ENTERED_DT_VALID ='N') THEN

Line 5712: ,'OKS_NOTES_INTERFACE'

5708: ,ERROR_MSG
5709: ,MSG_TOKENS)
5710: VALUES (G_WORKER_REQ_ID
5711: ,HEADER_INTERFACE_ROWID
5712: ,'OKS_NOTES_INTERFACE'
5713: ,NOTES_INTERFACE_ID
5714: ,'OKS_IMP_NTINT_INVALID_ENTDT'
5715: ,NULL)
5716: WHEN (NOTES IS NULL ) THEN

Line 5726: ,'OKS_NOTES_INTERFACE'

5722: ,ERROR_MSG
5723: ,MSG_TOKENS)
5724: VALUES (G_WORKER_REQ_ID
5725: ,HEADER_INTERFACE_ROWID
5726: ,'OKS_NOTES_INTERFACE'
5727: ,NOTES_INTERFACE_ID
5728: ,'OKS_IMP_NTINT_INVALID_NOTES'
5729: ,NULL)
5730:

Line 5756: FROM OKS_NOTES_INTERFACE ONI

5752: ,(CASE WHEN ONI.ENTERED_DATE > SYSDATE THEN 'N'
5753: ELSE 'Y'
5754: END) ENTERED_DT_VALID
5755:
5756: FROM OKS_NOTES_INTERFACE ONI
5757: ,OKS_INT_LINE_STG_TEMP OLSTG
5758: ,FND_LOOKUPS NTSTATUS
5759: ,FND_LOOKUPS NTTYPE
5760: ,FND_USER USR

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

5768:
5769:
5770: IF G_STMT_LOG THEN
5771:
5772: SELECT count(1) INTO l_line_notes_count FROM OKS_NOTES_INTERFACE ONI
5773: WHERE EXISTS (SELECT 'X' FROM OKS_INT_LINE_STG_TEMP
5774: WHERE LINE_INTERFACE_ID = ONI.LINE_INTERFACE_ID);
5775:
5776: SELECT count(1) INTO l_header_notes_count FROM OKS_NOTES_INTERFACE ONI

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

5772: SELECT count(1) INTO l_line_notes_count FROM OKS_NOTES_INTERFACE ONI
5773: WHERE EXISTS (SELECT 'X' FROM OKS_INT_LINE_STG_TEMP
5774: WHERE LINE_INTERFACE_ID = ONI.LINE_INTERFACE_ID);
5775:
5776: SELECT count(1) INTO l_header_notes_count FROM OKS_NOTES_INTERFACE ONI
5777: WHERE EXISTS (SELECT 'X' FROM OKS_INT_HEADER_STG_TEMP
5778: WHERE HEADER_INTERFACE_ID = ONI.HEADER_INTERFACE_ID)
5779: AND ONI.LINE_INTERFACE_ID IS NULL;
5780: