179: p_module => c_block||'.'||'Engine_master_prep.v_femtop',
180: p_msg_text => v_femtop);
181:
182: v_parent_request_id := fnd_global.conc_request_id;
183: v_femtop := FND_PROFILE.Value_Specific('FEM_FEMTOP');
184:
185: -- Parse the FEM_TOP to find the APPL_TOP and RELEASE components
186: -- we will look for the last occurrence (up to a max of 10 occurrences)
187: -- of '/fem/'
949: ******************************************************/
950:
951:
952: /*Setting Site level for all profiles */
953: v_boolean := FND_PROFILE.save('FEM_LEDGER', v_ledger_id, 'SITE');
954: v_boolean := FND_PROFILE.save('FEM_SIGNAGE_METHOD', NULL, 'SITE');
955: v_boolean := FND_PROFILE.save('FEM_PERIOD', NULL, 'SITE');
956: v_boolean := FND_PROFILE.save('FEM_SEC_FOLDER', NULL, 'SITE');
957: v_boolean := FND_PROFILE.save('FEM_IO_DATA_DEFINITION', NULL, 'SITE');
950:
951:
952: /*Setting Site level for all profiles */
953: v_boolean := FND_PROFILE.save('FEM_LEDGER', v_ledger_id, 'SITE');
954: v_boolean := FND_PROFILE.save('FEM_SIGNAGE_METHOD', NULL, 'SITE');
955: v_boolean := FND_PROFILE.save('FEM_PERIOD', NULL, 'SITE');
956: v_boolean := FND_PROFILE.save('FEM_SEC_FOLDER', NULL, 'SITE');
957: v_boolean := FND_PROFILE.save('FEM_IO_DATA_DEFINITION', NULL, 'SITE');
958: v_boolean := FND_PROFILE.save('FEM_DEFAULT_ACTUALS_DATASET', v_dataset_cd, 'SITE');
951:
952: /*Setting Site level for all profiles */
953: v_boolean := FND_PROFILE.save('FEM_LEDGER', v_ledger_id, 'SITE');
954: v_boolean := FND_PROFILE.save('FEM_SIGNAGE_METHOD', NULL, 'SITE');
955: v_boolean := FND_PROFILE.save('FEM_PERIOD', NULL, 'SITE');
956: v_boolean := FND_PROFILE.save('FEM_SEC_FOLDER', NULL, 'SITE');
957: v_boolean := FND_PROFILE.save('FEM_IO_DATA_DEFINITION', NULL, 'SITE');
958: v_boolean := FND_PROFILE.save('FEM_DEFAULT_ACTUALS_DATASET', v_dataset_cd, 'SITE');
959: v_boolean := FND_PROFILE.save('FEM_DATASET', v_dataset_cd, 'SITE');
952: /*Setting Site level for all profiles */
953: v_boolean := FND_PROFILE.save('FEM_LEDGER', v_ledger_id, 'SITE');
954: v_boolean := FND_PROFILE.save('FEM_SIGNAGE_METHOD', NULL, 'SITE');
955: v_boolean := FND_PROFILE.save('FEM_PERIOD', NULL, 'SITE');
956: v_boolean := FND_PROFILE.save('FEM_SEC_FOLDER', NULL, 'SITE');
957: v_boolean := FND_PROFILE.save('FEM_IO_DATA_DEFINITION', NULL, 'SITE');
958: v_boolean := FND_PROFILE.save('FEM_DEFAULT_ACTUALS_DATASET', v_dataset_cd, 'SITE');
959: v_boolean := FND_PROFILE.save('FEM_DATASET', v_dataset_cd, 'SITE');
960:
953: v_boolean := FND_PROFILE.save('FEM_LEDGER', v_ledger_id, 'SITE');
954: v_boolean := FND_PROFILE.save('FEM_SIGNAGE_METHOD', NULL, 'SITE');
955: v_boolean := FND_PROFILE.save('FEM_PERIOD', NULL, 'SITE');
956: v_boolean := FND_PROFILE.save('FEM_SEC_FOLDER', NULL, 'SITE');
957: v_boolean := FND_PROFILE.save('FEM_IO_DATA_DEFINITION', NULL, 'SITE');
958: v_boolean := FND_PROFILE.save('FEM_DEFAULT_ACTUALS_DATASET', v_dataset_cd, 'SITE');
959: v_boolean := FND_PROFILE.save('FEM_DATASET', v_dataset_cd, 'SITE');
960:
961: /* Setting Appl level for all profiles */
954: v_boolean := FND_PROFILE.save('FEM_SIGNAGE_METHOD', NULL, 'SITE');
955: v_boolean := FND_PROFILE.save('FEM_PERIOD', NULL, 'SITE');
956: v_boolean := FND_PROFILE.save('FEM_SEC_FOLDER', NULL, 'SITE');
957: v_boolean := FND_PROFILE.save('FEM_IO_DATA_DEFINITION', NULL, 'SITE');
958: v_boolean := FND_PROFILE.save('FEM_DEFAULT_ACTUALS_DATASET', v_dataset_cd, 'SITE');
959: v_boolean := FND_PROFILE.save('FEM_DATASET', v_dataset_cd, 'SITE');
960:
961: /* Setting Appl level for all profiles */
962: FOR appl IN c_appl LOOP
955: v_boolean := FND_PROFILE.save('FEM_PERIOD', NULL, 'SITE');
956: v_boolean := FND_PROFILE.save('FEM_SEC_FOLDER', NULL, 'SITE');
957: v_boolean := FND_PROFILE.save('FEM_IO_DATA_DEFINITION', NULL, 'SITE');
958: v_boolean := FND_PROFILE.save('FEM_DEFAULT_ACTUALS_DATASET', v_dataset_cd, 'SITE');
959: v_boolean := FND_PROFILE.save('FEM_DATASET', v_dataset_cd, 'SITE');
960:
961: /* Setting Appl level for all profiles */
962: FOR appl IN c_appl LOOP
963: v_boolean := FND_PROFILE.save('FEM_LEDGER', NULL, 'APPL',appl.application_id);
959: v_boolean := FND_PROFILE.save('FEM_DATASET', v_dataset_cd, 'SITE');
960:
961: /* Setting Appl level for all profiles */
962: FOR appl IN c_appl LOOP
963: v_boolean := FND_PROFILE.save('FEM_LEDGER', NULL, 'APPL',appl.application_id);
964: v_boolean := FND_PROFILE.save('FEM_SIGNAGE_METHOD', NULL, 'APPL', appl.application_id);
965: v_boolean := FND_PROFILE.save('FEM_PERIOD', NULL, 'APPL', appl.application_id);
966: v_boolean := FND_PROFILE.save('FEM_SEC_FOLDER', NULL, 'APPL', appl.application_id);
967: v_boolean := FND_PROFILE.save('FEM_IO_DATA_DEFINITION', NULL, 'APPL', appl.application_id);
960:
961: /* Setting Appl level for all profiles */
962: FOR appl IN c_appl LOOP
963: v_boolean := FND_PROFILE.save('FEM_LEDGER', NULL, 'APPL',appl.application_id);
964: v_boolean := FND_PROFILE.save('FEM_SIGNAGE_METHOD', NULL, 'APPL', appl.application_id);
965: v_boolean := FND_PROFILE.save('FEM_PERIOD', NULL, 'APPL', appl.application_id);
966: v_boolean := FND_PROFILE.save('FEM_SEC_FOLDER', NULL, 'APPL', appl.application_id);
967: v_boolean := FND_PROFILE.save('FEM_IO_DATA_DEFINITION', NULL, 'APPL', appl.application_id);
968: v_boolean := FND_PROFILE.save('FEM_DEFAULT_ACTUALS_DATASET', v_dataset_cd, 'APPL', appl.application_id);
961: /* Setting Appl level for all profiles */
962: FOR appl IN c_appl LOOP
963: v_boolean := FND_PROFILE.save('FEM_LEDGER', NULL, 'APPL',appl.application_id);
964: v_boolean := FND_PROFILE.save('FEM_SIGNAGE_METHOD', NULL, 'APPL', appl.application_id);
965: v_boolean := FND_PROFILE.save('FEM_PERIOD', NULL, 'APPL', appl.application_id);
966: v_boolean := FND_PROFILE.save('FEM_SEC_FOLDER', NULL, 'APPL', appl.application_id);
967: v_boolean := FND_PROFILE.save('FEM_IO_DATA_DEFINITION', NULL, 'APPL', appl.application_id);
968: v_boolean := FND_PROFILE.save('FEM_DEFAULT_ACTUALS_DATASET', v_dataset_cd, 'APPL', appl.application_id);
969: v_boolean := FND_PROFILE.save('FEM_DATASET', v_dataset_cd, 'APPL', appl.application_id);
962: FOR appl IN c_appl LOOP
963: v_boolean := FND_PROFILE.save('FEM_LEDGER', NULL, 'APPL',appl.application_id);
964: v_boolean := FND_PROFILE.save('FEM_SIGNAGE_METHOD', NULL, 'APPL', appl.application_id);
965: v_boolean := FND_PROFILE.save('FEM_PERIOD', NULL, 'APPL', appl.application_id);
966: v_boolean := FND_PROFILE.save('FEM_SEC_FOLDER', NULL, 'APPL', appl.application_id);
967: v_boolean := FND_PROFILE.save('FEM_IO_DATA_DEFINITION', NULL, 'APPL', appl.application_id);
968: v_boolean := FND_PROFILE.save('FEM_DEFAULT_ACTUALS_DATASET', v_dataset_cd, 'APPL', appl.application_id);
969: v_boolean := FND_PROFILE.save('FEM_DATASET', v_dataset_cd, 'APPL', appl.application_id);
970: END LOOP;
963: v_boolean := FND_PROFILE.save('FEM_LEDGER', NULL, 'APPL',appl.application_id);
964: v_boolean := FND_PROFILE.save('FEM_SIGNAGE_METHOD', NULL, 'APPL', appl.application_id);
965: v_boolean := FND_PROFILE.save('FEM_PERIOD', NULL, 'APPL', appl.application_id);
966: v_boolean := FND_PROFILE.save('FEM_SEC_FOLDER', NULL, 'APPL', appl.application_id);
967: v_boolean := FND_PROFILE.save('FEM_IO_DATA_DEFINITION', NULL, 'APPL', appl.application_id);
968: v_boolean := FND_PROFILE.save('FEM_DEFAULT_ACTUALS_DATASET', v_dataset_cd, 'APPL', appl.application_id);
969: v_boolean := FND_PROFILE.save('FEM_DATASET', v_dataset_cd, 'APPL', appl.application_id);
970: END LOOP;
971:
964: v_boolean := FND_PROFILE.save('FEM_SIGNAGE_METHOD', NULL, 'APPL', appl.application_id);
965: v_boolean := FND_PROFILE.save('FEM_PERIOD', NULL, 'APPL', appl.application_id);
966: v_boolean := FND_PROFILE.save('FEM_SEC_FOLDER', NULL, 'APPL', appl.application_id);
967: v_boolean := FND_PROFILE.save('FEM_IO_DATA_DEFINITION', NULL, 'APPL', appl.application_id);
968: v_boolean := FND_PROFILE.save('FEM_DEFAULT_ACTUALS_DATASET', v_dataset_cd, 'APPL', appl.application_id);
969: v_boolean := FND_PROFILE.save('FEM_DATASET', v_dataset_cd, 'APPL', appl.application_id);
970: END LOOP;
971:
972: /* Setting User level for all profiles */
965: v_boolean := FND_PROFILE.save('FEM_PERIOD', NULL, 'APPL', appl.application_id);
966: v_boolean := FND_PROFILE.save('FEM_SEC_FOLDER', NULL, 'APPL', appl.application_id);
967: v_boolean := FND_PROFILE.save('FEM_IO_DATA_DEFINITION', NULL, 'APPL', appl.application_id);
968: v_boolean := FND_PROFILE.save('FEM_DEFAULT_ACTUALS_DATASET', v_dataset_cd, 'APPL', appl.application_id);
969: v_boolean := FND_PROFILE.save('FEM_DATASET', v_dataset_cd, 'APPL', appl.application_id);
970: END LOOP;
971:
972: /* Setting User level for all profiles */
973: FOR userid IN c_user LOOP
970: END LOOP;
971:
972: /* Setting User level for all profiles */
973: FOR userid IN c_user LOOP
974: v_boolean := FND_PROFILE.save('FEM_LEDGER', NULL, 'USER',userid.user_id);
975: v_boolean := FND_PROFILE.save('FEM_SIGNAGE_METHOD', NULL, 'USER', userid.user_id);
976: v_boolean := FND_PROFILE.save('FEM_PERIOD', NULL, 'USER', userid.user_id);
977: v_boolean := FND_PROFILE.save('FEM_SEC_FOLDER', NULL, 'USER', userid.user_id);
978: v_boolean := FND_PROFILE.save('FEM_IO_DATA_DEFINITION', NULL, 'USER', userid.user_id);
971:
972: /* Setting User level for all profiles */
973: FOR userid IN c_user LOOP
974: v_boolean := FND_PROFILE.save('FEM_LEDGER', NULL, 'USER',userid.user_id);
975: v_boolean := FND_PROFILE.save('FEM_SIGNAGE_METHOD', NULL, 'USER', userid.user_id);
976: v_boolean := FND_PROFILE.save('FEM_PERIOD', NULL, 'USER', userid.user_id);
977: v_boolean := FND_PROFILE.save('FEM_SEC_FOLDER', NULL, 'USER', userid.user_id);
978: v_boolean := FND_PROFILE.save('FEM_IO_DATA_DEFINITION', NULL, 'USER', userid.user_id);
979: v_boolean := FND_PROFILE.save('FEM_DEFAULT_ACTUALS_DATASET', v_dataset_cd, 'USER', userid.user_id);
972: /* Setting User level for all profiles */
973: FOR userid IN c_user LOOP
974: v_boolean := FND_PROFILE.save('FEM_LEDGER', NULL, 'USER',userid.user_id);
975: v_boolean := FND_PROFILE.save('FEM_SIGNAGE_METHOD', NULL, 'USER', userid.user_id);
976: v_boolean := FND_PROFILE.save('FEM_PERIOD', NULL, 'USER', userid.user_id);
977: v_boolean := FND_PROFILE.save('FEM_SEC_FOLDER', NULL, 'USER', userid.user_id);
978: v_boolean := FND_PROFILE.save('FEM_IO_DATA_DEFINITION', NULL, 'USER', userid.user_id);
979: v_boolean := FND_PROFILE.save('FEM_DEFAULT_ACTUALS_DATASET', v_dataset_cd, 'USER', userid.user_id);
980: v_boolean := FND_PROFILE.save('FEM_DATASET', v_dataset_cd, 'USER', userid.user_id);
973: FOR userid IN c_user LOOP
974: v_boolean := FND_PROFILE.save('FEM_LEDGER', NULL, 'USER',userid.user_id);
975: v_boolean := FND_PROFILE.save('FEM_SIGNAGE_METHOD', NULL, 'USER', userid.user_id);
976: v_boolean := FND_PROFILE.save('FEM_PERIOD', NULL, 'USER', userid.user_id);
977: v_boolean := FND_PROFILE.save('FEM_SEC_FOLDER', NULL, 'USER', userid.user_id);
978: v_boolean := FND_PROFILE.save('FEM_IO_DATA_DEFINITION', NULL, 'USER', userid.user_id);
979: v_boolean := FND_PROFILE.save('FEM_DEFAULT_ACTUALS_DATASET', v_dataset_cd, 'USER', userid.user_id);
980: v_boolean := FND_PROFILE.save('FEM_DATASET', v_dataset_cd, 'USER', userid.user_id);
981: END LOOP;
974: v_boolean := FND_PROFILE.save('FEM_LEDGER', NULL, 'USER',userid.user_id);
975: v_boolean := FND_PROFILE.save('FEM_SIGNAGE_METHOD', NULL, 'USER', userid.user_id);
976: v_boolean := FND_PROFILE.save('FEM_PERIOD', NULL, 'USER', userid.user_id);
977: v_boolean := FND_PROFILE.save('FEM_SEC_FOLDER', NULL, 'USER', userid.user_id);
978: v_boolean := FND_PROFILE.save('FEM_IO_DATA_DEFINITION', NULL, 'USER', userid.user_id);
979: v_boolean := FND_PROFILE.save('FEM_DEFAULT_ACTUALS_DATASET', v_dataset_cd, 'USER', userid.user_id);
980: v_boolean := FND_PROFILE.save('FEM_DATASET', v_dataset_cd, 'USER', userid.user_id);
981: END LOOP;
982:
975: v_boolean := FND_PROFILE.save('FEM_SIGNAGE_METHOD', NULL, 'USER', userid.user_id);
976: v_boolean := FND_PROFILE.save('FEM_PERIOD', NULL, 'USER', userid.user_id);
977: v_boolean := FND_PROFILE.save('FEM_SEC_FOLDER', NULL, 'USER', userid.user_id);
978: v_boolean := FND_PROFILE.save('FEM_IO_DATA_DEFINITION', NULL, 'USER', userid.user_id);
979: v_boolean := FND_PROFILE.save('FEM_DEFAULT_ACTUALS_DATASET', v_dataset_cd, 'USER', userid.user_id);
980: v_boolean := FND_PROFILE.save('FEM_DATASET', v_dataset_cd, 'USER', userid.user_id);
981: END LOOP;
982:
983: COMMIT;
976: v_boolean := FND_PROFILE.save('FEM_PERIOD', NULL, 'USER', userid.user_id);
977: v_boolean := FND_PROFILE.save('FEM_SEC_FOLDER', NULL, 'USER', userid.user_id);
978: v_boolean := FND_PROFILE.save('FEM_IO_DATA_DEFINITION', NULL, 'USER', userid.user_id);
979: v_boolean := FND_PROFILE.save('FEM_DEFAULT_ACTUALS_DATASET', v_dataset_cd, 'USER', userid.user_id);
980: v_boolean := FND_PROFILE.save('FEM_DATASET', v_dataset_cd, 'USER', userid.user_id);
981: END LOOP;
982:
983: COMMIT;
984: