APPS.FND_REQUEST dependencies on FND_DEBUG_RULES

Line 4292: -- get_fnd_debug_rules_sequence

4288: return TRUE;
4289: end;
4290:
4291: -- Name
4292: -- get_fnd_debug_rules_sequence
4293: -- Purpose
4294: -- Called to obtain the next sequence value for fnd_debug_rules table
4295: --
4296: -- Arguments

Line 4294: -- Called to obtain the next sequence value for fnd_debug_rules table

4290:
4291: -- Name
4292: -- get_fnd_debug_rules_sequence
4293: -- Purpose
4294: -- Called to obtain the next sequence value for fnd_debug_rules table
4295: --
4296: -- Arguments
4297: -- none
4298: --

Line 4299: function get_fnd_debug_rules_sequence return number is

4295: --
4296: -- Arguments
4297: -- none
4298: --
4299: function get_fnd_debug_rules_sequence return number is
4300:
4301: l_sequence number;
4302: dual_no_rows exception;
4303: dual_too_many_rows exception;

Line 4308: select fnd_debug_rules_s.nextval

4304:
4305: begin
4306:
4307: begin
4308: select fnd_debug_rules_s.nextval
4309: into l_sequence
4310: from sys.dual;
4311:
4312: exception

Line 4326: -- update_fnd_debug_rules_req_id

4322: end;
4323:
4324:
4325: -- Name
4326: -- update_fnd_debug_rules_req_id
4327: -- Purpose
4328: -- Called to set the request id for the specific fnd_debug_rule_id
4329: --
4330: -- Arguments

Line 4332: -- fnd_debug_rule_id - the specific row in fnd_debug_rules to get updated

4328: -- Called to set the request id for the specific fnd_debug_rule_id
4329: --
4330: -- Arguments
4331: -- request_id - the actual request id that debug options is being set for.
4332: -- fnd_debug_rule_id - the specific row in fnd_debug_rules to get updated
4333: --
4334: function update_fnd_debug_rules_req_id (
4335: req_id IN number,
4336: fnd_debug_rule_id IN number )

Line 4334: function update_fnd_debug_rules_req_id (

4330: -- Arguments
4331: -- request_id - the actual request id that debug options is being set for.
4332: -- fnd_debug_rule_id - the specific row in fnd_debug_rules to get updated
4333: --
4334: function update_fnd_debug_rules_req_id (
4335: req_id IN number,
4336: fnd_debug_rule_id IN number )
4337: return boolean is
4338: begin

Line 4341: update fnd_debug_rules

4337: return boolean is
4338: begin
4339:
4340: begin
4341: update fnd_debug_rules
4342: set request_id = req_id
4343: where debug_rule_id = fnd_debug_rule_id;
4344:
4345: exception

Line 4351: 'ROUTINE', 'update_fnd_debug_rules_req_id', FALSE);

4347: fnd_message.set_name ('FND', 'SQL-Generic error');
4348: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
4349: fnd_message.set_token ('REASON', sqlerrm, FALSE);
4350: fnd_message.set_token (
4351: 'ROUTINE', 'update_fnd_debug_rules_req_id', FALSE);
4352: return FALSE;
4353: end;
4354:
4355: commit;

Line 4360: -- delete_fnd_debug_rules_id

4356: return TRUE;
4357: end;
4358:
4359: -- Name
4360: -- delete_fnd_debug_rules_id
4361: -- Purpose
4362: -- Called to delete the specific fnd_debug_rule_id from fnd_debug_rules
4363: -- and fnd_debug_rules_options
4364: --

Line 4362: -- Called to delete the specific fnd_debug_rule_id from fnd_debug_rules

4358:
4359: -- Name
4360: -- delete_fnd_debug_rules_id
4361: -- Purpose
4362: -- Called to delete the specific fnd_debug_rule_id from fnd_debug_rules
4363: -- and fnd_debug_rules_options
4364: --
4365: -- Arguments
4366: -- fnd_debug_rule_id - the specific sequence number to be deleted

Line 4363: -- and fnd_debug_rules_options

4359: -- Name
4360: -- delete_fnd_debug_rules_id
4361: -- Purpose
4362: -- Called to delete the specific fnd_debug_rule_id from fnd_debug_rules
4363: -- and fnd_debug_rules_options
4364: --
4365: -- Arguments
4366: -- fnd_debug_rule_id - the specific sequence number to be deleted
4367: --

Line 4368: function delete_fnd_debug_rules_id (

4364: --
4365: -- Arguments
4366: -- fnd_debug_rule_id - the specific sequence number to be deleted
4367: --
4368: function delete_fnd_debug_rules_id (
4369: fnd_debug_rule_id IN number )
4370: return boolean is
4371: l_count_rows number;
4372: begin

Line 4375: from fnd_debug_rules

4371: l_count_rows number;
4372: begin
4373: select count(*)
4374: into l_count_rows
4375: from fnd_debug_rules
4376: where debug_rule_id = fnd_debug_rule_id;
4377:
4378: if (l_count_rows > 0) then
4379: delete from fnd_debug_rules

Line 4379: delete from fnd_debug_rules

4375: from fnd_debug_rules
4376: where debug_rule_id = fnd_debug_rule_id;
4377:
4378: if (l_count_rows > 0) then
4379: delete from fnd_debug_rules
4380: where debug_rule_id = fnd_debug_rule_id;
4381: end if;
4382:
4383: select count(*)