APPS.GHG_TRANSACTIONS_API_PKG dependencies on FND_PROFILE

Line 247: PROCEDURE create_transaction (p_org_id NUMBER DEFAULT FND_PROFILE.value('ORG_ID'),

243:
244: /* End of Procedure validate_transaction_inputs */
245:
246:
247: PROCEDURE create_transaction (p_org_id NUMBER DEFAULT FND_PROFILE.value('ORG_ID'),
248: p_batch_type VARCHAR2 DEFAULT NULL,
249: p_batch_sub_type VARCHAR2 DEFAULT NULL,
250: p_batch_number VARCHAR2 DEFAULT NULL,
251: p_batch_description VARCHAR2 DEFAULT NULL,

Line 573: AND upper(end_user_column_name) = fnd_profile.value('GHG_FACTOR_BREAK_REGION');

569: AND exists (select 1
570: from GHG_organizations fac
571: where fac.ghg_organization_id = v_facility_id
572: and fac.location_id = hr.location_id)
573: AND upper(end_user_column_name) = fnd_profile.value('GHG_FACTOR_BREAK_REGION');
574: EXCEPTION
575: WHEN NO_DATA_FOUND THEN
576: v_emission_location := 'ALL';
577: END;

Line 766: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),

762: x_reversal_date => NULL,
763: x_reversed_transact_batch_id => NULL,
764: x_org_id => p_org_id,
765: x_set_of_books_id => v_set_of_books_id,
766: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
767: x_creation_date => SYSDATE,
768: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
769: x_last_update_date => SYSDATE,
770: x_last_update_login => -1,

Line 768: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),

764: x_org_id => p_org_id,
765: x_set_of_books_id => v_set_of_books_id,
766: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
767: x_creation_date => SYSDATE,
768: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
769: x_last_update_date => SYSDATE,
770: x_last_update_login => -1,
771: x_called_from_api => 'Y');
772:

Line 800: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),

796: x_description => p_emission_description,
797: x_org_id => p_org_id,
798: x_set_of_books_id => v_set_of_books_id,
799: x_emission_line_number => v_max_line_no,
800: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
801: x_creation_date => SYSDATE,
802: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
803: x_last_update_date => SYSDATE,
804: x_last_update_login => -1,

Line 802: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),

798: x_set_of_books_id => v_set_of_books_id,
799: x_emission_line_number => v_max_line_no,
800: x_created_by => nvl(fnd_profile.value('USER_ID'),-1),
801: x_creation_date => SYSDATE,
802: x_last_updated_by => nvl(fnd_profile.value('USER_ID'),-1),
803: x_last_update_date => SYSDATE,
804: x_last_update_login => -1,
805: x_commit_flag => p_commit_flag,
806: -- x_emission_rate_id => -1,

Line 976: v_emission_uom_class VARCHAR2(20) :=fnd_profile.value('GHG_EMISSION_UOM_CLASS');

972: v_uom_class VARCHAR2(20);
973: v_final_conv_rate NUMBER DEFAULT 1;
974: v_conv_rate NUMBER;
975: v_emission_conv_rate NUMBER;
976: v_emission_uom_class VARCHAR2(20) :=fnd_profile.value('GHG_EMISSION_UOM_CLASS');
977: v_emission_uom VARCHAR2(20) := fnd_profile.value('GHG_EMISSION_UOM');
978:
979: procedure write_to_log(msg varchar2) is
980: begin

Line 977: v_emission_uom VARCHAR2(20) := fnd_profile.value('GHG_EMISSION_UOM');

973: v_final_conv_rate NUMBER DEFAULT 1;
974: v_conv_rate NUMBER;
975: v_emission_conv_rate NUMBER;
976: v_emission_uom_class VARCHAR2(20) :=fnd_profile.value('GHG_EMISSION_UOM_CLASS');
977: v_emission_uom VARCHAR2(20) := fnd_profile.value('GHG_EMISSION_UOM');
978:
979: procedure write_to_log(msg varchar2) is
980: begin
981: fnd_file.put_line(fnd_file.log, msg);

Line 1000: v_dblink := fnd_profile.value('GHG_DW_DBLINK');

996: -- Set Org Context
997: -----------------------------------------------------------------------------------------
998: -- mo_global.set_policy_context_server(p_access_mode => 'S',p_org_id => p_org_id);
999:
1000: v_dblink := fnd_profile.value('GHG_DW_DBLINK');
1001:
1002: if v_dblink is null then
1003: FND_MESSAGE.SET_NAME('GHG', 'GHG_DW_DB_LINK_MISSING');
1004: RAISE raise_error;