APPS.ZX_TPI_PLUGIN_PKG dependencies on DUAL

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

304: 'APPS','ZX',l_pack_name,1,(g_counter-1),'TRUE',dummy);
305:
306: END create_third_party_pkg_spec;
307: /*------------------------------------------------------------------------*/
308: /* Creating the individual package body for the api owner */
309: /*------------------------------------------------------------------------*/
310:
311: PROCEDURE create_main_router_body (p_prvidx IN NUMBER)
312: IS

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

347:
348: l_break := FALSE;
349:
350: /* -------------------------------------------------------------------------- */
351: /* Check to see if the individual data transfer mode is PLS */
352: /* -------------------------------------------------------------------------- */
353:
354: -- l_pls is for the first iteration
355:

Line 531: FROM dual

527: /* category */
528: /*-----------------------------------------------------------------------*/
529: Begin
530: SELECT 'Y' into l_exists
531: FROM dual
532: WHERE exists
533: ( SELECT api_owner_id
534: FROM zx_api_owner_statuses
535: WHERE

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

544:
545:
546: --Initialize;
547: /* -------------------------------------------------------------------------- */
548: /* Fetching the individual cursors into record of tables. */
549: /* -------------------------------------------------------------------------- */
550:
551: IF p_api_owner_id is NOT NULL THEN
552: l_exists_in_owner_statuses := 'Y';

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

649:
650: l_break := FALSE;
651:
652: /*------------------------------------------------------------------------*/
653: /* Generating the individual provider package */
654: /* to call the service category services for different service types */
655: /*------------------------------------------------------------------------*/
656:
657: IF t_prv.api_owner_id.LAST < 0 THEN

Line 689: /* individual package specification */

685:
686: g_counter := 1;
687: /*------------------------------------------------------------------------*/
688: /* IF distinct statuses are not GENERATED then only generate the */
689: /* individual package specification */
690: /*------------------------------------------------------------------------*/
691:
692: print_debug('-- CG: create_third_party ');
693: create_third_party_pkg_spec;

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

691:
692: print_debug('-- CG: create_third_party ');
693: create_third_party_pkg_spec;
694: /* ---------------------------------------------------------------------------
695: Looping through the record of tables again for generating the individual
696: service type procedures
697: ----------------------------------------------------------------------------*/
698:
699: g_counter := 1;