DBA Data[Home] [Help]

APPS.AHL_DI_DOC_INDEX_PVT dependencies on FND_APPLICATION

Line 22: Product Id will be derived from FND_APPLICATION table

18:
19: ALGORITHM : Use fnd_installation.get function to retreive
20: the status of product installation.
21: Function expects product id to be passed
22: Product Id will be derived from FND_APPLICATION table
23: Product Product Id
24: -------- -----------
25: INV 401
26: PO 201

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

41: x_status VARCHAR2(1);
42: x_org VARCHAR2(1);
43: x_temp_product_name varchar2(10);
44: BEGIN
45: --Retreive product id from fnd_application based on product name
46: x_progress := 10;
47:
48: SELECT application_id
49: INTO x_app_id

Line 50: FROM fnd_application

46: x_progress := 10;
47:
48: SELECT application_id
49: INTO x_app_id
50: FROM fnd_application
51: WHERE application_short_name = x_product_name ;
52:
53: --get product installation status
54: x_progress := 20;