DBA Data[Home] [Help]

APPS.PO_CORE_S dependencies on FND_APPLICATION

Line 754: Product Id will be derived from FND_APPLICATION table

750:
751: ALGORITHM : Use fnd_installation.get function to retreive
752: the status of product installation.
753: Function expects product id to be passed
754: Product Id will be derived from FND_APPLICATION table
755: Product Product Id
756: -------- -----------
757: INV 401
758: PO 201

Line 777: --Retreive product id from fnd_application based on product name

773: x_status VARCHAR2(1);
774: x_org VARCHAR2(1);
775: x_temp_product_name varchar2(10);
776: begin
777: --Retreive product id from fnd_application based on product name
778: x_progress := 10;
779:
780: select application_id
781: into x_app_id

Line 782: from fnd_application

778: x_progress := 10;
779:
780: select application_id
781: into x_app_id
782: from fnd_application
783: where application_short_name = x_product_name ;
784:
785: --get product installation status
786: x_progress := 20;