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 792: l_category_set_id := TO_NUMBER (FND_PROFILE.VALUE ('GMD_TECH_CATG_SET'));

788:
789: l_rec Cur_get_folder_cols%ROWTYPE;
790: BEGIN
791: DELETE FROM gmd_technical_parameter_gtmp;
792: l_category_set_id := TO_NUMBER (FND_PROFILE.VALUE ('GMD_TECH_CATG_SET'));
793: IF (V_folder_name IS NOT NULL) THEN
794: OPEN Cur_get_folder_cols;
795: LOOP
796: FETCH Cur_get_folder_cols INTO l_rec;

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

964:
965: create_mo_line_err EXCEPTION;
966: setup_failure EXCEPTION;
967: BEGIN
968: l_user_id := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
969: IF NOT (gme_common_pvt.setup(P_org_id => V_orgn_id)) THEN
970: RAISE setup_failure;
971: END IF;
972: /* Inserting the item and lot data for the item entered in the form*/

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

1269: x_text_tab text_table;
1270: x_cnt NUMBER default 0;
1271: BEGIN
1272: /* saving the data to spreadsheet tables from temp tables*/
1273: l_user_id := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
1274: IF (V_sprd_id IS NOT NULL) THEN
1275: X_sprd_id := V_sprd_id;
1276: UPDATE lm_sprd_fls
1277: SET lab_organization_id = V_orgn_id,

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

1700: l_value NUMBER;
1701: l_tech_parm_id NUMBER;
1702:
1703: BEGIN
1704: l_density := fnd_profile.VALUE ('LM$DENSITY');
1705:
1706: OPEN cur_get_param (l_density);
1707: FETCH cur_get_param INTO l_tech_parm_id;
1708: CLOSE cur_get_param;