27: --try to wait for S-Lock on Interface Tables before proceeding to request_price
28: lock_result := Request_Pricing_Lock;
29:
30: --clear the interface tables stat info
31: QP_PREQ_GRP.G_INT_LINES_NO := 0;
32: QP_PREQ_GRP.G_INT_LDETS_NO := 0;
33: QP_PREQ_GRP.G_INT_ATTRS_NO := 0;
34: QP_PREQ_GRP.G_INT_RELS_NO := 0;
35: END IF;
28: lock_result := Request_Pricing_Lock;
29:
30: --clear the interface tables stat info
31: QP_PREQ_GRP.G_INT_LINES_NO := 0;
32: QP_PREQ_GRP.G_INT_LDETS_NO := 0;
33: QP_PREQ_GRP.G_INT_ATTRS_NO := 0;
34: QP_PREQ_GRP.G_INT_RELS_NO := 0;
35: END IF;
36: QP_PREQ_GRP.G_REQUEST_ID := l_request_id;
29:
30: --clear the interface tables stat info
31: QP_PREQ_GRP.G_INT_LINES_NO := 0;
32: QP_PREQ_GRP.G_INT_LDETS_NO := 0;
33: QP_PREQ_GRP.G_INT_ATTRS_NO := 0;
34: QP_PREQ_GRP.G_INT_RELS_NO := 0;
35: END IF;
36: QP_PREQ_GRP.G_REQUEST_ID := l_request_id;
37:
30: --clear the interface tables stat info
31: QP_PREQ_GRP.G_INT_LINES_NO := 0;
32: QP_PREQ_GRP.G_INT_LDETS_NO := 0;
33: QP_PREQ_GRP.G_INT_ATTRS_NO := 0;
34: QP_PREQ_GRP.G_INT_RELS_NO := 0;
35: END IF;
36: QP_PREQ_GRP.G_REQUEST_ID := l_request_id;
37:
38: -- set request_id attribute under namespace 'qp_context'
32: QP_PREQ_GRP.G_INT_LDETS_NO := 0;
33: QP_PREQ_GRP.G_INT_ATTRS_NO := 0;
34: QP_PREQ_GRP.G_INT_RELS_NO := 0;
35: END IF;
36: QP_PREQ_GRP.G_REQUEST_ID := l_request_id;
37:
38: -- set request_id attribute under namespace 'qp_context'
39: DBMS_SESSION.SET_CONTEXT('qp_context', 'request_id', l_request_id);
40:
52:
53: FUNCTION Get_Request_Id return number is
54: l_request_id number;
55: BEGIN
56: l_request_id := nvl(QP_PREQ_GRP.G_REQUEST_ID,fnd_api.g_miss_num);
57: return l_request_id;
58: END Get_Request_id;
59:
60: --needed for HTML Qualifiers UI