APPS.PFT_AR_ENGINE_PVT dependencies on FEM_PL_TEMP_OBJECTS

Line 3464: from fem_pl_temp_objects

3460: ------------------------------------------------------------------------------
3461: begin
3462: select 'Y'
3463: into l_object_exists_flag
3464: from fem_pl_temp_objects
3465: where request_id = p_request_rec.request_id
3466: and object_id = p_rule_rec.act_rate_obj_id
3467: and object_type = 'SEQUENCE'
3468: and object_name = p_rule_rec.rate_sequence_name;

Line 3481: delete from fem_pl_temp_objects

3477: -- Temporary sequence is in the default APPS schema as GSCC does not
3478: -- allow hardcoded schemas.
3479: execute immediate 'drop sequence '||p_rule_rec.rate_sequence_name;
3480:
3481: delete from fem_pl_temp_objects
3482: where request_id = p_request_rec.request_id
3483: and object_id = p_rule_rec.act_rate_obj_id
3484: and object_type = 'SEQUENCE'
3485: and object_name = p_rule_rec.rate_sequence_name;

Line 3509: from fem_pl_temp_objects

3505: ------------------------------------------------------------------------------
3506: begin
3507: select 'Y'
3508: into l_object_exists_flag
3509: from fem_pl_temp_objects
3510: where request_id = p_request_rec.request_id
3511: and object_id = p_rule_rec.act_rate_obj_id
3512: and object_type = 'SEQUENCE'
3513: and object_name = p_rule_rec.drv_sequence_name;

Line 3526: delete from fem_pl_temp_objects

3522: -- Temporary sequence is in the default APPS schema as GSCC does not
3523: -- allow hardcoded schemas.
3524: execute immediate 'drop sequence '||p_rule_rec.drv_sequence_name;
3525:
3526: delete from fem_pl_temp_objects
3527: where request_id = p_request_rec.request_id
3528: and object_id = p_rule_rec.act_rate_obj_id
3529: and object_type = 'SEQUENCE'
3530: and object_name = p_rule_rec.drv_sequence_name;