APPS.GMD_SPREAD_FETCH_PKG dependencies on FND_PROFILE

Line 238: l_user_id := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));

234: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
235: BEGIN
236: gmd_debug.log_initialize ('simul');
237: /* Inserting the item and lot data from batch material tables to temp tables*/
238: l_user_id := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
239: IF (V_batch_id IS NOT NULL) THEN
240: OPEN Cur_get_batch;
241: LOOP
242: l_line_id := l_line_id + 1;

Line 762: l_category_set_id := TO_NUMBER (FND_PROFILE.VALUE ('GMD_TECH_CATG_SET'));

758: l_rec Cur_get_folder_cols%ROWTYPE;
759: l_count11 number;
760: BEGIN
761: DELETE FROM gmd_technical_parameter_gtmp;
762: l_category_set_id := TO_NUMBER (FND_PROFILE.VALUE ('GMD_TECH_CATG_SET'));
763: IF (V_folder_name IS NOT NULL) THEN
764: OPEN Cur_get_folder_cols;
765: LOOP
766: FETCH Cur_get_folder_cols INTO l_rec;

Line 938: l_user_id := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));

934:
935: create_mo_line_err EXCEPTION;
936: setup_failure EXCEPTION;
937: BEGIN
938: l_user_id := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
939: IF NOT (gme_common_pvt.setup(P_org_id => V_orgn_id)) THEN
940: RAISE setup_failure;
941: END IF;
942: /* Inserting the item and lot data for the item entered in the form*/

Line 1239: l_user_id := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));

1235: x_text_tab text_table;
1236: x_cnt NUMBER default 0;
1237: BEGIN
1238: /* saving the data to spreadsheet tables from temp tables*/
1239: l_user_id := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
1240: IF (V_sprd_id IS NOT NULL) THEN
1241: X_sprd_id := V_sprd_id;
1242: UPDATE lm_sprd_fls
1243: SET lab_organization_id = V_orgn_id,

Line 1660: l_density := fnd_profile.VALUE ('LM$DENSITY');

1656: l_value NUMBER;
1657: l_tech_parm_id NUMBER;
1658:
1659: BEGIN
1660: l_density := fnd_profile.VALUE ('LM$DENSITY');
1661:
1662: OPEN cur_get_param (l_density);
1663: FETCH cur_get_param INTO l_tech_parm_id;
1664: CLOSE cur_get_param;