69: PROCEDURE explode_wms_lpn(
70: p_lpn_id IN NUMBER,
71: p_org_id IN NUMBER,
72: x_content_table OUT NOCOPY WMS_CONTAINER_PUB.WMS_CONTAINER_TBL_TYPE,
73: x_elements OUT NOCOPY qa_txn_grp.ElementsArray,
74: x_element_ids OUT NOCOPY CtxElemIdTab) IS
75:
76: msg_count NUMBER;
77: msg_data VARCHAR2(2000);
194: Item VARCHAR2(40);
195: ApplicablePlanCtx VARCHAR2(1000);
196: ApplicablePlanCtxId VARCHAR2(1000);
197:
198: elements qa_txn_grp.ElementsArray;
199: element_ids CtxElemIdTab;
200:
201: CURSOR AvailablePlans(txn_number NUMBER, orgID NUMBER) IS
202: SELECT qpt.plan_transaction_id, qp.plan_id
298:
299: END evaluate_triggers;
300:
301:
302: FUNCTION triggers_matched(p_plan_txn_id IN NUMBER, elements IN qa_txn_grp.ElementsArray)
303: RETURN VARCHAR2 IS
304:
305: BEGIN
306: