APPS.OM_SETUP_VALID_PKG dependencies on FND_DOC_SEQUENCE_CATEGORIES

Line 2220: FROM FND_DOC_SEQUENCE_CATEGORIES fdsc

2216: ORDER BY b.ORG_ID;
2217: ttype ttypes%ROWTYPE;
2218: CURSOR doccats IS
2219: SELECT tta.ORG_ID, fdsc.CODE, fdsc.NAME
2220: FROM FND_DOC_SEQUENCE_CATEGORIES fdsc
2221: , OE_TRANSACTION_TYPES_ALL tta
2222: , OE_TRANSACTION_TYPES_TL ttl
2223: WHERE ttl.NAME = fdsc.NAME
2224: AND tta.TRANSACTION_TYPE_ID = ttl.TRANSACTION_TYPE_ID

Line 2262: FROM FND_DOC_SEQUENCE_CATEGORIES

2258: LOOP
2259: IF ttype.ORG_ID = oulist(i) THEN
2260: SELECT COUNT(NAME)
2261: INTO dscatcnt
2262: FROM FND_DOC_SEQUENCE_CATEGORIES
2263: WHERE NAME = ttype.NAME
2264: AND TABLE_NAME = 'OE_TRANSACTION_TYPES_ALL';
2265: IF dscatcnt = 0 THEN
2266: error_type := 'ERROR';

Line 2967: ,FND_DOC_SEQUENCE_CATEGORIES fdsc

2963: END IF;
2964: SELECT COUNT(wdsc.DOC_SEQUENCE_CATEGORY_ID)
2965: INTO bolcount
2966: FROM WSH_DOC_SEQUENCE_CATEGORIES wdsc
2967: ,FND_DOC_SEQUENCE_CATEGORIES fdsc
2968: WHERE wdsc.CATEGORY_CODE = fdsc.CODE
2969: AND fdsc.NAME = 'BOL';
2970: IF ( bolcount = 0 ) THEN
2971: mesg_name := 'ONT_SETVAL_SHIP_DOC_BOL';

Line 2979: ,FND_DOC_SEQUENCE_CATEGORIES fdsc

2975: END IF;
2976: SELECT COUNT(wdsc.DOC_SEQUENCE_CATEGORY_ID)
2977: INTO pkslpcnt
2978: FROM WSH_DOC_SEQUENCE_CATEGORIES wdsc
2979: ,FND_DOC_SEQUENCE_CATEGORIES fdsc
2980: WHERE wdsc.CATEGORY_CODE = fdsc.CODE
2981: AND fdsc.NAME = 'BOL';
2982: IF ( pkslpcnt = 0 ) THEN
2983: mesg_name := 'ONT_SETVAL_SHIP_DOC_PKSLP';

Line 3024: ,FND_DOC_SEQUENCE_CATEGORIES fdsc

3020: END;
3021: SELECT COUNT(fdsa.DOC_SEQUENCE_ASSIGNMENT_ID)
3022: INTO bolacnt
3023: FROM FND_DOC_SEQUENCE_ASSIGNMENTS fdsa
3024: ,FND_DOC_SEQUENCE_CATEGORIES fdsc
3025: WHERE SET_OF_BOOKS_ID = sob
3026: AND CATEGORY_CODE = fdsc.CODE
3027: AND fdsc.NAME = 'BOL';
3028: SELECT COUNT(fdsa.DOC_SEQUENCE_ASSIGNMENT_ID)

Line 3031: ,FND_DOC_SEQUENCE_CATEGORIES fdsc

3027: AND fdsc.NAME = 'BOL';
3028: SELECT COUNT(fdsa.DOC_SEQUENCE_ASSIGNMENT_ID)
3029: INTO pkslpacnt
3030: FROM FND_DOC_SEQUENCE_ASSIGNMENTS fdsa
3031: ,FND_DOC_SEQUENCE_CATEGORIES fdsc
3032: WHERE SET_OF_BOOKS_ID = sob
3033: AND CATEGORY_CODE = fdsc.CODE
3034: AND fdsc.NAME = 'PKSLP';
3035: IF ( bolacnt > 0 AND pkslpacnt > 0 ) THEN