eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_PROFILE_UTIL_PKG dependencies on HZ_CODE_ASSIGNMENTS

Line 11: OWNER_TABLE_NAME CONSTANT HZ_CODE_ASSIGNMENTS.OWNER_TABLE_NAME%TYPE := 'HZ_PARTIES';

7: --freight terms, fob.
8: type refCurTyp is Ref Cursor;
9: HZ_FAIL_EXCEPTION EXCEPTION;
10:
11: OWNER_TABLE_NAME CONSTANT HZ_CODE_ASSIGNMENTS.OWNER_TABLE_NAME%TYPE := 'HZ_PARTIES';
12: PON_CLASSIFICATION CONSTANT HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY%TYPE := 'PON_CLASSIFICATION';
13: TRADING_PARTNER CONSTANT HZ_CODE_ASSIGNMENTS.CLASS_CODE%TYPE := 'TRADING_PARTNER';
14: TRADING_PARTNER_USER CONSTANT HZ_CODE_ASSIGNMENTS.CLASS_CODE%TYPE := 'TRADING_PARTNER_USER';
15: PRIMARY_FLAG CONSTANT HZ_CODE_ASSIGNMENTS.PRIMARY_FLAG%TYPE := 'Y';

Line 12: PON_CLASSIFICATION CONSTANT HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY%TYPE := 'PON_CLASSIFICATION';

8: type refCurTyp is Ref Cursor;
9: HZ_FAIL_EXCEPTION EXCEPTION;
10:
11: OWNER_TABLE_NAME CONSTANT HZ_CODE_ASSIGNMENTS.OWNER_TABLE_NAME%TYPE := 'HZ_PARTIES';
12: PON_CLASSIFICATION CONSTANT HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY%TYPE := 'PON_CLASSIFICATION';
13: TRADING_PARTNER CONSTANT HZ_CODE_ASSIGNMENTS.CLASS_CODE%TYPE := 'TRADING_PARTNER';
14: TRADING_PARTNER_USER CONSTANT HZ_CODE_ASSIGNMENTS.CLASS_CODE%TYPE := 'TRADING_PARTNER_USER';
15: PRIMARY_FLAG CONSTANT HZ_CODE_ASSIGNMENTS.PRIMARY_FLAG%TYPE := 'Y';
16: CONTENT_SOURCE_TYPE CONSTANT HZ_CODE_ASSIGNMENTS.CONTENT_SOURCE_TYPE%TYPE := 'USER_ENTERED';

Line 13: TRADING_PARTNER CONSTANT HZ_CODE_ASSIGNMENTS.CLASS_CODE%TYPE := 'TRADING_PARTNER';

9: HZ_FAIL_EXCEPTION EXCEPTION;
10:
11: OWNER_TABLE_NAME CONSTANT HZ_CODE_ASSIGNMENTS.OWNER_TABLE_NAME%TYPE := 'HZ_PARTIES';
12: PON_CLASSIFICATION CONSTANT HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY%TYPE := 'PON_CLASSIFICATION';
13: TRADING_PARTNER CONSTANT HZ_CODE_ASSIGNMENTS.CLASS_CODE%TYPE := 'TRADING_PARTNER';
14: TRADING_PARTNER_USER CONSTANT HZ_CODE_ASSIGNMENTS.CLASS_CODE%TYPE := 'TRADING_PARTNER_USER';
15: PRIMARY_FLAG CONSTANT HZ_CODE_ASSIGNMENTS.PRIMARY_FLAG%TYPE := 'Y';
16: CONTENT_SOURCE_TYPE CONSTANT HZ_CODE_ASSIGNMENTS.CONTENT_SOURCE_TYPE%TYPE := 'USER_ENTERED';
17: APPLICATION_ID CONSTANT HZ_CODE_ASSIGNMENTS.APPLICATION_ID%TYPE := 396;

Line 14: TRADING_PARTNER_USER CONSTANT HZ_CODE_ASSIGNMENTS.CLASS_CODE%TYPE := 'TRADING_PARTNER_USER';

10:
11: OWNER_TABLE_NAME CONSTANT HZ_CODE_ASSIGNMENTS.OWNER_TABLE_NAME%TYPE := 'HZ_PARTIES';
12: PON_CLASSIFICATION CONSTANT HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY%TYPE := 'PON_CLASSIFICATION';
13: TRADING_PARTNER CONSTANT HZ_CODE_ASSIGNMENTS.CLASS_CODE%TYPE := 'TRADING_PARTNER';
14: TRADING_PARTNER_USER CONSTANT HZ_CODE_ASSIGNMENTS.CLASS_CODE%TYPE := 'TRADING_PARTNER_USER';
15: PRIMARY_FLAG CONSTANT HZ_CODE_ASSIGNMENTS.PRIMARY_FLAG%TYPE := 'Y';
16: CONTENT_SOURCE_TYPE CONSTANT HZ_CODE_ASSIGNMENTS.CONTENT_SOURCE_TYPE%TYPE := 'USER_ENTERED';
17: APPLICATION_ID CONSTANT HZ_CODE_ASSIGNMENTS.APPLICATION_ID%TYPE := 396;
18: CREATED_BY_MODULE CONSTANT HZ_CODE_ASSIGNMENTS.CREATED_BY_MODULE%TYPE := 'PON';

Line 15: PRIMARY_FLAG CONSTANT HZ_CODE_ASSIGNMENTS.PRIMARY_FLAG%TYPE := 'Y';

11: OWNER_TABLE_NAME CONSTANT HZ_CODE_ASSIGNMENTS.OWNER_TABLE_NAME%TYPE := 'HZ_PARTIES';
12: PON_CLASSIFICATION CONSTANT HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY%TYPE := 'PON_CLASSIFICATION';
13: TRADING_PARTNER CONSTANT HZ_CODE_ASSIGNMENTS.CLASS_CODE%TYPE := 'TRADING_PARTNER';
14: TRADING_PARTNER_USER CONSTANT HZ_CODE_ASSIGNMENTS.CLASS_CODE%TYPE := 'TRADING_PARTNER_USER';
15: PRIMARY_FLAG CONSTANT HZ_CODE_ASSIGNMENTS.PRIMARY_FLAG%TYPE := 'Y';
16: CONTENT_SOURCE_TYPE CONSTANT HZ_CODE_ASSIGNMENTS.CONTENT_SOURCE_TYPE%TYPE := 'USER_ENTERED';
17: APPLICATION_ID CONSTANT HZ_CODE_ASSIGNMENTS.APPLICATION_ID%TYPE := 396;
18: CREATED_BY_MODULE CONSTANT HZ_CODE_ASSIGNMENTS.CREATED_BY_MODULE%TYPE := 'PON';
19: OBJECT_VERSION_NUMBER CONSTANT HZ_CODE_ASSIGNMENTS.OBJECT_VERSION_NUMBER%TYPE := 0;

Line 16: CONTENT_SOURCE_TYPE CONSTANT HZ_CODE_ASSIGNMENTS.CONTENT_SOURCE_TYPE%TYPE := 'USER_ENTERED';

12: PON_CLASSIFICATION CONSTANT HZ_CODE_ASSIGNMENTS.CLASS_CATEGORY%TYPE := 'PON_CLASSIFICATION';
13: TRADING_PARTNER CONSTANT HZ_CODE_ASSIGNMENTS.CLASS_CODE%TYPE := 'TRADING_PARTNER';
14: TRADING_PARTNER_USER CONSTANT HZ_CODE_ASSIGNMENTS.CLASS_CODE%TYPE := 'TRADING_PARTNER_USER';
15: PRIMARY_FLAG CONSTANT HZ_CODE_ASSIGNMENTS.PRIMARY_FLAG%TYPE := 'Y';
16: CONTENT_SOURCE_TYPE CONSTANT HZ_CODE_ASSIGNMENTS.CONTENT_SOURCE_TYPE%TYPE := 'USER_ENTERED';
17: APPLICATION_ID CONSTANT HZ_CODE_ASSIGNMENTS.APPLICATION_ID%TYPE := 396;
18: CREATED_BY_MODULE CONSTANT HZ_CODE_ASSIGNMENTS.CREATED_BY_MODULE%TYPE := 'PON';
19: OBJECT_VERSION_NUMBER CONSTANT HZ_CODE_ASSIGNMENTS.OBJECT_VERSION_NUMBER%TYPE := 0;
20: ACTIVE_STATUS CONSTANT HZ_CODE_ASSIGNMENTS.STATUS%TYPE := 'A';

Line 17: APPLICATION_ID CONSTANT HZ_CODE_ASSIGNMENTS.APPLICATION_ID%TYPE := 396;

13: TRADING_PARTNER CONSTANT HZ_CODE_ASSIGNMENTS.CLASS_CODE%TYPE := 'TRADING_PARTNER';
14: TRADING_PARTNER_USER CONSTANT HZ_CODE_ASSIGNMENTS.CLASS_CODE%TYPE := 'TRADING_PARTNER_USER';
15: PRIMARY_FLAG CONSTANT HZ_CODE_ASSIGNMENTS.PRIMARY_FLAG%TYPE := 'Y';
16: CONTENT_SOURCE_TYPE CONSTANT HZ_CODE_ASSIGNMENTS.CONTENT_SOURCE_TYPE%TYPE := 'USER_ENTERED';
17: APPLICATION_ID CONSTANT HZ_CODE_ASSIGNMENTS.APPLICATION_ID%TYPE := 396;
18: CREATED_BY_MODULE CONSTANT HZ_CODE_ASSIGNMENTS.CREATED_BY_MODULE%TYPE := 'PON';
19: OBJECT_VERSION_NUMBER CONSTANT HZ_CODE_ASSIGNMENTS.OBJECT_VERSION_NUMBER%TYPE := 0;
20: ACTIVE_STATUS CONSTANT HZ_CODE_ASSIGNMENTS.STATUS%TYPE := 'A';
21:

Line 18: CREATED_BY_MODULE CONSTANT HZ_CODE_ASSIGNMENTS.CREATED_BY_MODULE%TYPE := 'PON';

14: TRADING_PARTNER_USER CONSTANT HZ_CODE_ASSIGNMENTS.CLASS_CODE%TYPE := 'TRADING_PARTNER_USER';
15: PRIMARY_FLAG CONSTANT HZ_CODE_ASSIGNMENTS.PRIMARY_FLAG%TYPE := 'Y';
16: CONTENT_SOURCE_TYPE CONSTANT HZ_CODE_ASSIGNMENTS.CONTENT_SOURCE_TYPE%TYPE := 'USER_ENTERED';
17: APPLICATION_ID CONSTANT HZ_CODE_ASSIGNMENTS.APPLICATION_ID%TYPE := 396;
18: CREATED_BY_MODULE CONSTANT HZ_CODE_ASSIGNMENTS.CREATED_BY_MODULE%TYPE := 'PON';
19: OBJECT_VERSION_NUMBER CONSTANT HZ_CODE_ASSIGNMENTS.OBJECT_VERSION_NUMBER%TYPE := 0;
20: ACTIVE_STATUS CONSTANT HZ_CODE_ASSIGNMENTS.STATUS%TYPE := 'A';
21:
22: PROCEDURE update_organization_start_date(

Line 19: OBJECT_VERSION_NUMBER CONSTANT HZ_CODE_ASSIGNMENTS.OBJECT_VERSION_NUMBER%TYPE := 0;

15: PRIMARY_FLAG CONSTANT HZ_CODE_ASSIGNMENTS.PRIMARY_FLAG%TYPE := 'Y';
16: CONTENT_SOURCE_TYPE CONSTANT HZ_CODE_ASSIGNMENTS.CONTENT_SOURCE_TYPE%TYPE := 'USER_ENTERED';
17: APPLICATION_ID CONSTANT HZ_CODE_ASSIGNMENTS.APPLICATION_ID%TYPE := 396;
18: CREATED_BY_MODULE CONSTANT HZ_CODE_ASSIGNMENTS.CREATED_BY_MODULE%TYPE := 'PON';
19: OBJECT_VERSION_NUMBER CONSTANT HZ_CODE_ASSIGNMENTS.OBJECT_VERSION_NUMBER%TYPE := 0;
20: ACTIVE_STATUS CONSTANT HZ_CODE_ASSIGNMENTS.STATUS%TYPE := 'A';
21:
22: PROCEDURE update_organization_start_date(
23: p_party_id IN NUMBER

Line 20: ACTIVE_STATUS CONSTANT HZ_CODE_ASSIGNMENTS.STATUS%TYPE := 'A';

16: CONTENT_SOURCE_TYPE CONSTANT HZ_CODE_ASSIGNMENTS.CONTENT_SOURCE_TYPE%TYPE := 'USER_ENTERED';
17: APPLICATION_ID CONSTANT HZ_CODE_ASSIGNMENTS.APPLICATION_ID%TYPE := 396;
18: CREATED_BY_MODULE CONSTANT HZ_CODE_ASSIGNMENTS.CREATED_BY_MODULE%TYPE := 'PON';
19: OBJECT_VERSION_NUMBER CONSTANT HZ_CODE_ASSIGNMENTS.OBJECT_VERSION_NUMBER%TYPE := 0;
20: ACTIVE_STATUS CONSTANT HZ_CODE_ASSIGNMENTS.STATUS%TYPE := 'A';
21:
22: PROCEDURE update_organization_start_date(
23: p_party_id IN NUMBER
24: , x_status OUT NOCOPY VARCHAR2