APPS.GMD_RECIPE_MIGRATION dependencies on FND_PROFILE

Line 324: TRIM (fnd_profile.value_specific ('GEMMS_DEFAULT_ORGN' ,

320:
321: /* Define the creation and owner orgn values from profile values */
322:
323: l_creation_orgn_code :=
324: TRIM (fnd_profile.value_specific ('GEMMS_DEFAULT_ORGN' ,
325: l_created_by ));
326: l_owner_orgn_code :=
327: TRIM (fnd_profile.value_specific ('GEMMS_DEFAULT_ORGN' ,
328: l_owner_id ));

Line 327: TRIM (fnd_profile.value_specific ('GEMMS_DEFAULT_ORGN' ,

323: l_creation_orgn_code :=
324: TRIM (fnd_profile.value_specific ('GEMMS_DEFAULT_ORGN' ,
325: l_created_by ));
326: l_owner_orgn_code :=
327: TRIM (fnd_profile.value_specific ('GEMMS_DEFAULT_ORGN' ,
328: l_owner_id ));
329:
330: INSERT INTO gmd_recipes_b (recipe_id, recipe_no, recipe_version, owner_orgn_code, creation_orgn_code,
331: formula_id, routing_id, recipe_status, calculate_step_quantity, owner_id,

Line 457: TRIM (fnd_profile.value_specific ('GEMMS_DEFAULT_ORGN' ,

453:
454: /* Define the creation and owner orgn values from profile values */
455:
456: l_creation_orgn_code :=
457: TRIM (fnd_profile.value_specific ('GEMMS_DEFAULT_ORGN' ,
458: l_created_by ));
459: l_owner_orgn_code :=
460: TRIM (fnd_profile.value_specific ( 'GEMMS_DEFAULT_ORGN' ,
461: l_owner_id ));

Line 460: TRIM (fnd_profile.value_specific ( 'GEMMS_DEFAULT_ORGN' ,

456: l_creation_orgn_code :=
457: TRIM (fnd_profile.value_specific ('GEMMS_DEFAULT_ORGN' ,
458: l_created_by ));
459: l_owner_orgn_code :=
460: TRIM (fnd_profile.value_specific ( 'GEMMS_DEFAULT_ORGN' ,
461: l_owner_id ));
462:
463: /* Insert into the recipe header table */
464: IF ( x_return_status = 'S' )