[Home] [Help]
202: END;
203:
204: IF l_category_set_id IS NULL THEN
205:
206: SELECT MTL_CATEGORY_SETS_S.NEXTVAL into l_next_val from dual;
207: -- Assuming Master Organization Control level
208: -- Bug 6441455, X_CONTROL_LEVEL - Passing 2 for Org control
209:
210: MTL_CATEGORY_SETS_PKG.INSERT_ROW (
403: WHERE category_set_id = 1100000209;
404: IF l_count = 0 THEN
405: l_next_val := 1100000209;
406: ELSE
407: SELECT MTL_CATEGORY_SETS_S.NEXTVAL into l_next_val from dual;
408: END IF;
409: ELSIF p_category_set_name = 'INTENDED_USE' THEN
410: -- check if set id 1100000211 is not used
411: SELECT count(*)
414: WHERE category_set_id = 1100000211;
415: IF l_count = 0 THEN
416: l_next_val := 1100000211;
417: ELSE
418: SELECT MTL_CATEGORY_SETS_S.NEXTVAL into l_next_val from dual;
419: END IF;
420: ELSE
421: SELECT MTL_CATEGORY_SETS_S.NEXTVAL into l_next_val from dual;
422: END IF;
417: ELSE
418: SELECT MTL_CATEGORY_SETS_S.NEXTVAL into l_next_val from dual;
419: END IF;
420: ELSE
421: SELECT MTL_CATEGORY_SETS_S.NEXTVAL into l_next_val from dual;
422: END IF;
423:
424: -- Assuming Master Organization Control level
425: -- Bug 6441455, X_CONTROL_LEVEL - Passing 2 for Org control
756:
757: /* Create Codes under Product Category Statistical Code */
758: arp_util_tax.debug( 'Creating the Statistical Code.. ');
759:
760: --select zx_fc_codes_b_s.nextval into l_fc_id from dual;
761:
762: FIRST_LEVEL_FC_CODE_INSERT('PRODUCT_CATEGORY','STATISTICAL_CODE','Statistical Code',NULL,l_fc_id);
763:
764: FC_CODE_FROM_FND_LOOKUP('PRODUCT_CATEGORY','JGZZ_STATISTICAL_CODE',NULL,l_fc_id,'STATISTICAL_CODE','Statistical Code',2);
1801: V_effective_from,
1802: V_effective_to,
1803: V_language,
1804: V_RECORD_TYPE
1805: FROM DUAl;
1806:
1807: FIRST_LEVEL_FC_CODE_INSERT('PRODUCT_CATEGORY','WINE CIGARETTE','Wine Cigarette','TW',l_fc_id);
1808:
1809:
2063: G_DELIMITER;
2064:
2065: CLOSE G_C_GET_TYPES_INFO;
2066:
2067: --select zx_fc_codes_b_s.nextval into x_fc_id from dual;
2068:
2069: INSERT
2070: INTO ZX_FC_CODES_B (
2071: classification_type_code,
2096: fnd_global.user_id,
2097: SYSDATE,
2098: FND_GLOBAL.CONC_LOGIN_ID,
2099: 1
2100: FROM DUAL
2101: WHERE NOT EXISTS
2102: (select NULL from ZX_FC_CODES_B Codes where
2103: codes.classification_type_code = p_classification_type_code
2104: and codes.parent_classification_id is null
3151: fnd_global.user_id,
3152: SYSDATE,
3153: FND_GLOBAL.CONC_LOGIN_ID,
3154: 1
3155: FROM dual
3156: WHERE NOT EXISTS
3157: (SELECT null from ZX_FC_TYPES_B
3158: WHERE classification_type_code = p_classification_type_code
3159: and classification_type_categ_code = 'PRODUCT_FISCAL_CLASS')
3245: SYSDATE,
3246: FND_GLOBAL.USER_ID,
3247: FND_GLOBAL.CONC_LOGIN_ID,
3248: 1
3249: FROM dual
3250: WHERE NOT EXISTS
3251: (SELECT null from ZX_DETERMINING_FACTORS_B
3252: WHERE DETERMINING_FACTOR_CODE = p_classification_type_code
3253: AND DETERMINING_FACTOR_CLASS_CODE = 'PRODUCT_FISCAL_CLASS')
3343: fnd_global.user_id,
3344: SYSDATE,
3345: FND_GLOBAL.CONC_LOGIN_ID,
3346: 1
3347: FROM dual
3348: WHERE NOT EXISTS
3349: (SELECT null from ZX_FC_TYPES_B
3350: WHERE classification_type_code = p_classification_type_code
3351: and classification_type_categ_code = 'PARTY_FISCAL_CLASS')
3437: SYSDATE,
3438: FND_GLOBAL.USER_ID,
3439: FND_GLOBAL.CONC_LOGIN_ID,
3440: 1
3441: FROM dual
3442: WHERE NOT EXISTS
3443: (SELECT null from ZX_DETERMINING_FACTORS_B
3444: WHERE DETERMINING_FACTOR_CODE = p_classification_type_code
3445: AND DETERMINING_FACTOR_CLASS_CODE = 'PARTY_FISCAL_CLASS')