3: -- Global constant holding the package name
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Delayed_Requests_PVT';
6:
7: g_delayed_requests QP_QUALIFIER_RULES_PUB.Request_Tbl_Type;
8: g_requesting_entities QP_QUALIFIER_RULES_PUB.Requesting_Entity_Tbl_Type;
9: G_MAX_REQUESTS NUMBER := 1000; --2502849
10: /* Local Procedures */
11: /* Local procedure to check if a request exists for a given entity, request
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_Delayed_Requests_PVT';
6:
7: g_delayed_requests QP_QUALIFIER_RULES_PUB.Request_Tbl_Type;
8: g_requesting_entities QP_QUALIFIER_RULES_PUB.Requesting_Entity_Tbl_Type;
9: G_MAX_REQUESTS NUMBER := 1000; --2502849
10: /* Local Procedures */
11: /* Local procedure to check if a request exists for a given entity, request
12: return the result in p_request_search_result which is set to FND_API.G_TRUE
126: (p_request_ind IN Number
127: ,p_delete IN Varchar2 default FND_API.G_FALSE
128: ,x_return_status OUT NOCOPY VARCHAR2)
129: IS
130: l_request_rec QP_QUALIFIER_RULES_PUB.request_rec_type;
131: l_request_type VARCHAR2(30);
132: l_return_status VARCHAR2(1);
133: l_entity_id NUMBER;
134: l_entity_code Varchar2(30);
133: l_entity_id NUMBER;
134: l_entity_code Varchar2(30);
135: l_req_entity_ind number;
136: l_set_index NUMBER;
137: l_set_request QP_QUALIFIER_RULES_PUB.request_tbl_type;
138: l_deleted_options_tbl QP_QUALIFIER_RULES_PUB.request_tbl_type;
139: l_updated_options_tbl QP_QUALIFIER_RULES_PUB.request_tbl_type;
140: l_d_index NUMBER;
141: l_u_index NUMBER;
134: l_entity_code Varchar2(30);
135: l_req_entity_ind number;
136: l_set_index NUMBER;
137: l_set_request QP_QUALIFIER_RULES_PUB.request_tbl_type;
138: l_deleted_options_tbl QP_QUALIFIER_RULES_PUB.request_tbl_type;
139: l_updated_options_tbl QP_QUALIFIER_RULES_PUB.request_tbl_type;
140: l_d_index NUMBER;
141: l_u_index NUMBER;
142: K NUMBER;
135: l_req_entity_ind number;
136: l_set_index NUMBER;
137: l_set_request QP_QUALIFIER_RULES_PUB.request_tbl_type;
138: l_deleted_options_tbl QP_QUALIFIER_RULES_PUB.request_tbl_type;
139: l_updated_options_tbl QP_QUALIFIER_RULES_PUB.request_tbl_type;
140: l_d_index NUMBER;
141: l_u_index NUMBER;
142: K NUMBER;
143: I NUMBER := 1;
961: l_request_search_rslt VARCHAR2(1);
962: l_return_status VARCHAR2(1);
963: l_request_ind NUMBER;
964: l_req_entity_ind NUMBER;
965: l_request QP_QUALIFIER_RULES_PUB.REQUEST_REC_TYPE;
966: l_req_entity QP_QUALIFIER_RULES_PUB.Requesting_Entity_Rec_Type;
967: BEGIN
968:
969: oe_debug_pub.add('Entering Procedure Log_Request in Package QP_Delayed_Requests_Pvt');
962: l_return_status VARCHAR2(1);
963: l_request_ind NUMBER;
964: l_req_entity_ind NUMBER;
965: l_request QP_QUALIFIER_RULES_PUB.REQUEST_REC_TYPE;
966: l_req_entity QP_QUALIFIER_RULES_PUB.Requesting_Entity_Rec_Type;
967: BEGIN
968:
969: oe_debug_pub.add('Entering Procedure Log_Request in Package QP_Delayed_Requests_Pvt');
970: oe_debug_pub.add('log_request_type'||p_request_type);