APPS.AP_VENDORS_PKG dependencies on AP_PRODUCT_SETUP

Line 192: from ap_product_setup;

188: from financials_system_parameters; */
189:
190: select supplier_numbering_method
191: into l_supplier_numbering_method
192: from ap_product_setup;
193:
194: if (nvl(l_supplier_numbering_method,'AUTOMATIC') = 'AUTOMATIC') then
195:
196: debug_info := 'assign automatic Vendor number';

Line 216: FROM ap_product_setup ;

212: -- Bug 6830122. Replacing following two statements with
213: -- autonomus transactions
214: /*SELECT next_auto_supplier_num
215: INTO x_segment1
216: FROM ap_product_setup ;
217:
218: UPDATE ap_product_setup
219: SET next_auto_supplier_num = next_auto_supplier_num + 1;*/
220: x_segment1 := Update_Product_Setup;

Line 218: UPDATE ap_product_setup

214: /*SELECT next_auto_supplier_num
215: INTO x_segment1
216: FROM ap_product_setup ;
217:
218: UPDATE ap_product_setup
219: SET next_auto_supplier_num = next_auto_supplier_num + 1;*/
220: x_segment1 := Update_Product_Setup;
221:
222: end if;

Line 555: from ap_product_setup;

551: BEGIN
552:
553: select supplier_numbering_method
554: into l_supplier_numbering_method
555: from ap_product_setup;
556:
557: if (nvl(l_supplier_numbering_method,'AUTOMATIC') = 'AUTOMATIC') then
558:
559: debug_info := 'assign automatic Vendor number';

Line 566: FROM ap_product_setup ;

562: -- autonomus transactions
563:
564: /*SELECT next_auto_supplier_num
565: INTO l_segment1
566: FROM ap_product_setup ;
567:
568: UPDATE ap_product_setup
569: SET next_auto_supplier_num = next_auto_supplier_num + 1;*/
570: l_segment1 := Update_Product_Setup;

Line 568: UPDATE ap_product_setup

564: /*SELECT next_auto_supplier_num
565: INTO l_segment1
566: FROM ap_product_setup ;
567:
568: UPDATE ap_product_setup
569: SET next_auto_supplier_num = next_auto_supplier_num + 1;*/
570: l_segment1 := Update_Product_Setup;
571:
572: end if;

Line 2258: CURSOR ap_product_setup_c is

2254:
2255: FUNCTION Update_Product_Setup return number is
2256: PRAGMA AUTONOMOUS_TRANSACTION;
2257:
2258: CURSOR ap_product_setup_c is
2259: SELECT next_auto_supplier_num
2260: FROM ap_product_setup
2261: FOR UPDATE OF next_auto_supplier_num;
2262:

Line 2260: FROM ap_product_setup

2256: PRAGMA AUTONOMOUS_TRANSACTION;
2257:
2258: CURSOR ap_product_setup_c is
2259: SELECT next_auto_supplier_num
2260: FROM ap_product_setup
2261: FOR UPDATE OF next_auto_supplier_num;
2262:
2263: l_segment1 ap_product_setup.next_auto_supplier_num%type;
2264:

Line 2263: l_segment1 ap_product_setup.next_auto_supplier_num%type;

2259: SELECT next_auto_supplier_num
2260: FROM ap_product_setup
2261: FOR UPDATE OF next_auto_supplier_num;
2262:
2263: l_segment1 ap_product_setup.next_auto_supplier_num%type;
2264:
2265: BEGIN
2266:
2267: Open ap_product_setup_c;

Line 2267: Open ap_product_setup_c;

2263: l_segment1 ap_product_setup.next_auto_supplier_num%type;
2264:
2265: BEGIN
2266:
2267: Open ap_product_setup_c;
2268: Fetch ap_product_setup_c into l_segment1;
2269:
2270: If(ap_product_setup_c%notfound) Then
2271: RAISE NO_DATA_FOUND;

Line 2268: Fetch ap_product_setup_c into l_segment1;

2264:
2265: BEGIN
2266:
2267: Open ap_product_setup_c;
2268: Fetch ap_product_setup_c into l_segment1;
2269:
2270: If(ap_product_setup_c%notfound) Then
2271: RAISE NO_DATA_FOUND;
2272: End if;

Line 2270: If(ap_product_setup_c%notfound) Then

2266:
2267: Open ap_product_setup_c;
2268: Fetch ap_product_setup_c into l_segment1;
2269:
2270: If(ap_product_setup_c%notfound) Then
2271: RAISE NO_DATA_FOUND;
2272: End if;
2273: Close ap_product_setup_c;
2274:

Line 2273: Close ap_product_setup_c;

2269:
2270: If(ap_product_setup_c%notfound) Then
2271: RAISE NO_DATA_FOUND;
2272: End if;
2273: Close ap_product_setup_c;
2274:
2275: UPDATE ap_product_setup
2276: SET next_auto_supplier_num = next_auto_supplier_num + 1;
2277: commit;

Line 2275: UPDATE ap_product_setup

2271: RAISE NO_DATA_FOUND;
2272: End if;
2273: Close ap_product_setup_c;
2274:
2275: UPDATE ap_product_setup
2276: SET next_auto_supplier_num = next_auto_supplier_num + 1;
2277: commit;
2278:
2279: return l_segment1;