[Home] [Help]
203: END;
204:
205: IF l_category_set_id IS NULL THEN
206:
207: SELECT MTL_CATEGORY_SETS_S.NEXTVAL into l_next_val from dual;
208: -- Assuming Master Organization Control level
209: -- Bug 6441455, X_CONTROL_LEVEL - Passing 2 for Org control
210:
211: MTL_CATEGORY_SETS_PKG.INSERT_ROW (
392: l_category_set_id := NULL;
393: END;
394:
395: IF l_category_set_id IS NULL THEN
396: SELECT MTL_CATEGORY_SETS_S.NEXTVAL into l_next_val from dual;
397:
398: -- Assuming Master Organization Control level
399: -- Bug 6441455, X_CONTROL_LEVEL - Passing 2 for Org control
400:
743:
744: /* Create Codes under Product Category Statistical Code */
745: arp_util_tax.debug( 'Creating the Statistical Code.. ');
746:
747: --select zx_fc_codes_b_s.nextval into l_fc_id from dual;
748:
749: FIRST_LEVEL_FC_CODE_INSERT('PRODUCT_CATEGORY','STATISTICAL_CODE','Statistical Code',NULL,l_fc_id);
750:
751: FC_CODE_FROM_FND_LOOKUP('PRODUCT_CATEGORY','JGZZ_STATISTICAL_CODE',NULL,l_fc_id,'STATISTICAL_CODE','Statistical Code',2);
1802: V_effective_from,
1803: V_effective_to,
1804: V_language,
1805: V_RECORD_TYPE
1806: FROM DUAl;
1807:
1808: FIRST_LEVEL_FC_CODE_INSERT('PRODUCT_CATEGORY','WINE CIGARETTE','Wine Cigarette','TW',l_fc_id);
1809:
1810:
2070: G_DELIMITER;
2071:
2072: CLOSE G_C_GET_TYPES_INFO;
2073:
2074: --select zx_fc_codes_b_s.nextval into x_fc_id from dual;
2075:
2076: INSERT
2077: INTO ZX_FC_CODES_B (
2078: classification_type_code,
2103: fnd_global.user_id,
2104: SYSDATE,
2105: FND_GLOBAL.CONC_LOGIN_ID,
2106: 1
2107: FROM DUAL
2108: WHERE NOT EXISTS
2109: (select NULL from ZX_FC_CODES_B Codes where
2110: codes.classification_type_code = p_classification_type_code
2111: and codes.parent_classification_id is null
3120: fnd_global.user_id,
3121: SYSDATE,
3122: FND_GLOBAL.CONC_LOGIN_ID,
3123: 1
3124: FROM dual
3125: WHERE NOT EXISTS
3126: (SELECT null from ZX_FC_TYPES_B
3127: WHERE classification_type_code = p_classification_type_code
3128: and classification_type_categ_code = 'PRODUCT_FISCAL_CLASS')
3215: SYSDATE,
3216: FND_GLOBAL.USER_ID,
3217: FND_GLOBAL.CONC_LOGIN_ID,
3218: 1
3219: FROM dual
3220: WHERE NOT EXISTS
3221: (SELECT null from ZX_DETERMINING_FACTORS_B
3222: WHERE DETERMINING_FACTOR_CODE = p_classification_type_code
3223: AND DETERMINING_FACTOR_CLASS_CODE = 'PRODUCT_FISCAL_CLASS')
3314: fnd_global.user_id,
3315: SYSDATE,
3316: FND_GLOBAL.CONC_LOGIN_ID,
3317: 1
3318: FROM dual
3319: WHERE NOT EXISTS
3320: (SELECT null from ZX_FC_TYPES_B
3321: WHERE classification_type_code = p_classification_type_code
3322: and classification_type_categ_code = 'PARTY_FISCAL_CLASS')
3409: SYSDATE,
3410: FND_GLOBAL.USER_ID,
3411: FND_GLOBAL.CONC_LOGIN_ID,
3412: 1
3413: FROM dual
3414: WHERE NOT EXISTS
3415: (SELECT null from ZX_DETERMINING_FACTORS_B
3416: WHERE DETERMINING_FACTOR_CODE = p_classification_type_code
3417: AND DETERMINING_FACTOR_CLASS_CODE = 'PARTY_FISCAL_CLASS')