APPS.ZX_TPI_PLUGIN_PKG dependencies on DUAL

Line 334: /* Creating the individual package body for the api owner */

330: l_oracle_username,'ZX',l_pack_name,1,(g_counter-1),'TRUE',dummy);
331:
332: END create_third_party_pkg_spec;
333: /*------------------------------------------------------------------------*/
334: /* Creating the individual package body for the api owner */
335: /*------------------------------------------------------------------------*/
336:
337: PROCEDURE create_main_router_body (p_prvidx IN NUMBER)
338: IS

Line 377: /* Check to see if the individual data transfer mode is PLS */

373:
374: l_break := FALSE;
375:
376: /* -------------------------------------------------------------------------- */
377: /* Check to see if the individual data transfer mode is PLS */
378: /* -------------------------------------------------------------------------- */
379:
380: -- l_pls is for the first iteration
381:

Line 557: FROM dual

553: /* category */
554: /*-----------------------------------------------------------------------*/
555: Begin
556: SELECT 'Y' into l_exists
557: FROM dual
558: WHERE exists
559: ( SELECT api_owner_id
560: FROM zx_api_owner_statuses
561: WHERE

Line 574: /* Fetching the individual cursors into record of tables. */

570:
571:
572: --Initialize;
573: /* -------------------------------------------------------------------------- */
574: /* Fetching the individual cursors into record of tables. */
575: /* -------------------------------------------------------------------------- */
576:
577: IF p_api_owner_id is NOT NULL THEN
578: l_exists_in_owner_statuses := 'Y';

Line 679: /* Generating the individual provider package */

675:
676: l_break := FALSE;
677:
678: /*------------------------------------------------------------------------*/
679: /* Generating the individual provider package */
680: /* to call the service category services for different service types */
681: /*------------------------------------------------------------------------*/
682:
683: IF t_prv.api_owner_id.LAST < 0 THEN

Line 718: /* individual package specification */

714:
715: g_counter := 1;
716: /*------------------------------------------------------------------------*/
717: /* IF distinct statuses are not GENERATED then only generate the */
718: /* individual package specification */
719: /*------------------------------------------------------------------------*/
720:
721: print_debug('-- CG: create_third_party ');
722: create_third_party_pkg_spec;

Line 724: Looping through the record of tables again for generating the individual

720:
721: print_debug('-- CG: create_third_party ');
722: create_third_party_pkg_spec;
723: /* ---------------------------------------------------------------------------
724: Looping through the record of tables again for generating the individual
725: service type procedures
726: ----------------------------------------------------------------------------*/
727:
728: g_counter := 1;