71: a_deleted_line_id_first AND a_deleted_line_id_last
72: ORDER BY price_book_line_det_id;
73:
74: BEGIN
75: l_user_id := fnd_global.user_id;
76: l_login_id := fnd_global.conc_login_id;
77:
78: --Get the price_book_header_id of the corresponding full price book
79: BEGIN
72: ORDER BY price_book_line_det_id;
73:
74: BEGIN
75: l_user_id := fnd_global.user_id;
76: l_login_id := fnd_global.conc_login_id;
77:
78: --Get the price_book_header_id of the corresponding full price book
79: BEGIN
80: SELECT price_book_header_id
510: l_validated_flag VARCHAR2(1);
511:
512: BEGIN
513:
514: l_user_id := fnd_global.user_id;
515: l_login_id := fnd_global.conc_login_id;
516:
517: --Set Policy Context to 'S' for Single Org, namely, the org on the price book
518: --request of the Price Book being created. Note that republishing should have
511:
512: BEGIN
513:
514: l_user_id := fnd_global.user_id;
515: l_login_id := fnd_global.conc_login_id;
516:
517: --Set Policy Context to 'S' for Single Org, namely, the org on the price book
518: --request of the Price Book being created. Note that republishing should have
519: --access mode of 'M', only creation has access mode 'S'.
1711: fnd_file.put_line(FND_FILE.LOG, errbuf);
1712: RETURN;
1713: END;
1714:
1715: l_user_id := fnd_global.user_id;
1716: l_login_id := fnd_global.login_id;
1717:
1718: --dbms_output.put_line('user id = '||l_user_id);
1719: --Multi-Org Init since Conc Program is run in a different session (check this)
1712: RETURN;
1713: END;
1714:
1715: l_user_id := fnd_global.user_id;
1716: l_login_id := fnd_global.login_id;
1717:
1718: --dbms_output.put_line('user id = '||l_user_id);
1719: --Multi-Org Init since Conc Program is run in a different session (check this)
1720: IF MO_GLOBAL.get_access_mode is null THEN