APPS.POA_DBI_ITEMS_PKG dependencies on POA_ITEMS

Line 42: from poa_items

38: end if;
39:
40: SELECT /*+ FIRST_ROWS */ po_item_id
41: into l_item_key
42: from poa_items
43: where item_id = p_item_id
44: and organization_id = l_org_id
45: --and category_id = p_category_id
46: ;

Line 63: from poa_items

59: END IF;
60:
61: select /*+ FIRST_ROWS */ po_item_id
62: into l_item_key
63: from poa_items
64: where item_id is NULL
65: AND organization_id IS null
66: and category_id = p_category_id
67: and description = p_description

Line 78: from poa_items

74: ||' Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), true );
75: END IF;
76: select /*+ FIRST_ROWS */ po_item_id
77: into l_item_key
78: from poa_items
79: where item_id is NULL
80: AND organization_id IS null
81: and vendor_product_num = p_vendor_product_num
82: AND vendor_id = p_vendor_id;

Line 107: --lock table poa_items in exclusive mode;

103: IS
104: pragma AUTONOMOUS_TRANSACTION;
105: l_item_key NUMBER ;
106: begin
107: --lock table poa_items in exclusive mode;
108: insert into poa_items (po_item_id, item_id, organization_id, category_id, vendor_product_num, vendor_id, description)
109: values (poa_items_s.nextval,p_item_id,p_org_id,p_category_id,p_vendor_product_num, p_vendor_id, p_description)
110: returning po_item_id INTO l_item_key;
111: commit;

Line 108: insert into poa_items (po_item_id, item_id, organization_id, category_id, vendor_product_num, vendor_id, description)

104: pragma AUTONOMOUS_TRANSACTION;
105: l_item_key NUMBER ;
106: begin
107: --lock table poa_items in exclusive mode;
108: insert into poa_items (po_item_id, item_id, organization_id, category_id, vendor_product_num, vendor_id, description)
109: values (poa_items_s.nextval,p_item_id,p_org_id,p_category_id,p_vendor_product_num, p_vendor_id, p_description)
110: returning po_item_id INTO l_item_key;
111: commit;
112: return l_item_key;

Line 109: values (poa_items_s.nextval,p_item_id,p_org_id,p_category_id,p_vendor_product_num, p_vendor_id, p_description)

105: l_item_key NUMBER ;
106: begin
107: --lock table poa_items in exclusive mode;
108: insert into poa_items (po_item_id, item_id, organization_id, category_id, vendor_product_num, vendor_id, description)
109: values (poa_items_s.nextval,p_item_id,p_org_id,p_category_id,p_vendor_product_num, p_vendor_id, p_description)
110: returning po_item_id INTO l_item_key;
111: commit;
112: return l_item_key;
113: EXCEPTION

Line 125: POA_DBI_UTIL_PKG.refresh('poa_items_mv');

121:
122: PROCEDURE refresh(Errbuf in out NOCOPY Varchar2,
123: Retcode in out NOCOPY VARCHAR2 ) IS
124: BEGIN
125: POA_DBI_UTIL_PKG.refresh('poa_items_mv');
126: EXCEPTION
127: WHEN OTHERS THEN
128: Errbuf:= Sqlerrm;
129: Retcode:=sqlcode;