DBA Data[Home] [Help]

APPS.GMS_RES_MAP dependencies on PO_VENDORS

Line 156: l_vendor_name PO_VENDORS.VENDOR_NAME%TYPE;

152: l_person_name varchar2(100);
153: l_job_title varchar2(100);
154: -- The length of l_vendor_name has been changed for utf8 changes for AP schema. Refer bug 2614745.
155: --l_vendor_name varchar2(100);
156: l_vendor_name PO_VENDORS.VENDOR_NAME%TYPE;
157: l_event_type varchar2(100);
158: l_parent_rlmi number(30);
159:
160: -- ## Following Cursor pulls up all the resource types for that resource list

Line 534: from po_vendors

530: -- The select statement has been changed for utf8 changes for AP schema.
531: -- Refer bug 2614745
532: Select vendor_name
533: into l_vendor_name
534: from po_vendors
535: where vendor_id = l_vendor_id;
536:
537: End if;
538:

Line 1172: l_vendor_name PO_VENDORS.VENDOR_NAME%TYPE;

1168: l_person_name varchar2(100);
1169: l_job_title varchar2(100);
1170: -- The length of varaible l_vendor_name has been changed for utf8 changes for AP schema. refer bug 2614745.
1171: --l_vendor_name varchar2(100);
1172: l_vendor_name PO_VENDORS.VENDOR_NAME%TYPE;
1173: l_event_type varchar2(100);
1174: l_parent_rlmi number(30);
1175:
1176: -- ## Following Cursor pulls up all the resource types for that resource list

Line 1437: from po_vendors

1433: --Select substrb(vendor_name,1,100)
1434: -- The select statement has been changed for utf8 changes for AP schema. refer bug 2614745.
1435: Select vendor_name
1436: into l_vendor_name
1437: from po_vendors
1438: where vendor_id = x_vendor_id;
1439:
1440: End if;
1441: