DBA Data[Home] [Help] [Dependency Information]

TYPE: APPS.HZ_CUST_PROFILE_AMT_OBJ

Object Details
Object Name: HZ_CUST_PROFILE_AMT_OBJ
Object Type: TYPE
Owner: APPS
Subobject Name:
Status: VALID
Type Details
Type Code: OBJECT
Predefined: NO
Incomplete: NO
Attributes
Name Datatype Length Prcn
ACTION_TYPE VARCHAR2 (30)
COMMON_OBJ_ID VARCHAR2 (255)
CUST_ACCT_PROFILE_AMT_ID NUMBER

CUST_ACCT_PROFILE_ID NUMBER

CURRENCY_CODE VARCHAR2 (15)
TRX_CREDIT_LIMIT NUMBER

OVERALL_CREDIT_LIMIT NUMBER

MIN_DUNNING_AMOUNT NUMBER

MIN_DUNNING_INVOICE_AMOUNT NUMBER

MAX_INTEREST_CHARGE NUMBER

MIN_STATEMENT_AMOUNT NUMBER

AUTO_REC_MIN_RECEIPT_AMOUNT NUMBER

INTEREST_RATE NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
MIN_FC_BALANCE_AMOUNT NUMBER

MIN_FC_INVOICE_AMOUNT NUMBER

CUST_ACCT_ID NUMBER

SITE_USE_ID NUMBER

EXPIRATION_DATE DATE

JGZZ_ATTRIBUTE_CATEGORY VARCHAR2 (30)
JGZZ_ATTRIBUTE1 VARCHAR2 (150)
JGZZ_ATTRIBUTE2 VARCHAR2 (150)
JGZZ_ATTRIBUTE3 VARCHAR2 (150)
JGZZ_ATTRIBUTE4 VARCHAR2 (150)
JGZZ_ATTRIBUTE5 VARCHAR2 (150)
JGZZ_ATTRIBUTE6 VARCHAR2 (150)
JGZZ_ATTRIBUTE7 VARCHAR2 (150)
JGZZ_ATTRIBUTE8 VARCHAR2 (150)
JGZZ_ATTRIBUTE9 VARCHAR2 (150)
JGZZ_ATTRIBUTE10 VARCHAR2 (150)
JGZZ_ATTRIBUTE11 VARCHAR2 (150)
JGZZ_ATTRIBUTE12 VARCHAR2 (150)
JGZZ_ATTRIBUTE13 VARCHAR2 (150)
JGZZ_ATTRIBUTE14 VARCHAR2 (150)
JGZZ_ATTRIBUTE15 VARCHAR2 (150)
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
PROGRAM_UPDATE_DATE DATE

CREATED_BY_MODULE VARCHAR2 (150)
CREATED_BY_NAME VARCHAR2 (100)
CREATION_DATE DATE

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY_NAME VARCHAR2 (100)
EXCHANGE_RATE_TYPE VARCHAR2 (30)
MIN_FC_INVOICE_OVERDUE_TYPE VARCHAR2 (30)
MIN_FC_INVOICE_PERCENT NUMBER

MIN_FC_BALANCE_OVERDUE_TYPE VARCHAR2 (30)
MIN_FC_BALANCE_PERCENT NUMBER

INTEREST_TYPE VARCHAR2 (30)
INTEREST_FIXED_AMOUNT NUMBER

INTEREST_SCHEDULE_ID NUMBER

PENALTY_TYPE VARCHAR2 (30)
PENALTY_RATE NUMBER

MIN_INTEREST_CHARGE NUMBER

PENALTY_FIXED_AMOUNT NUMBER

PENALTY_SCHEDULE_ID NUMBER

Methods
Name Parameters Result
CREATE_OBJECT P_CUST_ACCT_PROFILE_AMT_ID(NUMBER)
P_CURRENCY_CODE(VARCHAR2)
P_TRX_CREDIT_LIMIT(NUMBER)
P_OVERALL_CREDIT_LIMIT(NUMBER)
P_MIN_DUNNING_AMOUNT(NUMBER)
P_MIN_DUNNING_INVOICE_AMOUNT(NUMBER)
P_MAX_INTEREST_CHARGE(NUMBER)
P_MIN_STATEMENT_AMOUNT(NUMBER)
P_AUTO_REC_MIN_RECEIPT_AMOUNT(NUMBER)
P_INTEREST_RATE(NUMBER)
P_ATTRIBUTE_CATEGORY(VARCHAR2)
P_ATTRIBUTE1(VARCHAR2)
P_ATTRIBUTE2(VARCHAR2)
P_ATTRIBUTE3(VARCHAR2)
P_ATTRIBUTE4(VARCHAR2)
P_ATTRIBUTE5(VARCHAR2)
P_ATTRIBUTE6(VARCHAR2)
P_ATTRIBUTE7(VARCHAR2)
P_ATTRIBUTE8(VARCHAR2)
P_ATTRIBUTE9(VARCHAR2)
P_ATTRIBUTE10(VARCHAR2)
P_ATTRIBUTE11(VARCHAR2)
P_ATTRIBUTE12(VARCHAR2)
P_ATTRIBUTE13(VARCHAR2)
P_ATTRIBUTE14(VARCHAR2)
P_ATTRIBUTE15(VARCHAR2)
P_MIN_FC_BALANCE_AMOUNT(NUMBER)
P_MIN_FC_INVOICE_AMOUNT(NUMBER)
P_EXPIRATION_DATE(DATE)
P_JGZZ_ATTRIBUTE_CATEGORY(VARCHAR2)
P_JGZZ_ATTRIBUTE1(VARCHAR2)
P_JGZZ_ATTRIBUTE2(VARCHAR2)
P_JGZZ_ATTRIBUTE3(VARCHAR2)
P_JGZZ_ATTRIBUTE4(VARCHAR2)
P_JGZZ_ATTRIBUTE5(VARCHAR2)
P_JGZZ_ATTRIBUTE6(VARCHAR2)
P_JGZZ_ATTRIBUTE7(VARCHAR2)
P_JGZZ_ATTRIBUTE8(VARCHAR2)
P_JGZZ_ATTRIBUTE9(VARCHAR2)
P_JGZZ_ATTRIBUTE10(VARCHAR2)
P_JGZZ_ATTRIBUTE11(VARCHAR2)
P_JGZZ_ATTRIBUTE12(VARCHAR2)
P_JGZZ_ATTRIBUTE13(VARCHAR2)
P_JGZZ_ATTRIBUTE14(VARCHAR2)
P_JGZZ_ATTRIBUTE15(VARCHAR2)
P_GLOBAL_ATTRIBUTE1(VARCHAR2)
P_GLOBAL_ATTRIBUTE2(VARCHAR2)
P_GLOBAL_ATTRIBUTE3(VARCHAR2)
P_GLOBAL_ATTRIBUTE4(VARCHAR2)
P_GLOBAL_ATTRIBUTE5(VARCHAR2)
P_GLOBAL_ATTRIBUTE6(VARCHAR2)
P_GLOBAL_ATTRIBUTE7(VARCHAR2)
P_GLOBAL_ATTRIBUTE8(VARCHAR2)
P_GLOBAL_ATTRIBUTE9(VARCHAR2)
P_GLOBAL_ATTRIBUTE10(VARCHAR2)
P_GLOBAL_ATTRIBUTE11(VARCHAR2)
P_GLOBAL_ATTRIBUTE12(VARCHAR2)
P_GLOBAL_ATTRIBUTE13(VARCHAR2)
P_GLOBAL_ATTRIBUTE14(VARCHAR2)
P_GLOBAL_ATTRIBUTE15(VARCHAR2)
P_GLOBAL_ATTRIBUTE16(VARCHAR2)
P_GLOBAL_ATTRIBUTE17(VARCHAR2)
P_GLOBAL_ATTRIBUTE18(VARCHAR2)
P_GLOBAL_ATTRIBUTE19(VARCHAR2)
P_GLOBAL_ATTRIBUTE20(VARCHAR2)
P_GLOBAL_ATTRIBUTE_CATEGORY(VARCHAR2)
P_EXCHANGE_RATE_TYPE(VARCHAR2)
P_MIN_FC_INVOICE_OVERDUE_TYPE(VARCHAR2)
P_MIN_FC_INVOICE_PERCENT(NUMBER)
P_MIN_FC_BALANCE_OVERDUE_TYPE(VARCHAR2)
P_MIN_FC_BALANCE_PERCENT(NUMBER)
P_INTEREST_TYPE(VARCHAR2)
P_INTEREST_FIXED_AMOUNT(NUMBER)
P_INTEREST_SCHEDULE_ID(NUMBER)
P_PENALTY_TYPE(VARCHAR2)
P_PENALTY_RATE(NUMBER)
P_MIN_INTEREST_CHARGE(NUMBER)
P_PENALTY_FIXED_AMOUNT(NUMBER)
P_PENALTY_SCHEDULE_ID(NUMBER)
 HZ_CUST_PROFILE_AMT_OBJ

Dependencies

[top of page]

APPS.HZ_CUST_PROFILE_AMT_OBJ references the following:

SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
APPS.HZ_CUST_PROFILE_AMT_OBJ is referenced by following:

SchemaAPPS
Package BodyHZ_CUST_ACCT_BO_PVT - show dependent code
TYPE BODYHZ_CUST_PROFILE_AMT_OBJ
TYPEHZ_CUST_PROFILE_AMT_OBJ_TBL
Package BodyHZ_EXTRACT_ACCT_SITE_BO_PVT - show dependent code
Package BodyHZ_EXTRACT_CUST_ACCT_BO_PVT - show dependent code
Package BodyHZ_EXTRACT_ORG_CUST_BO_PVT - show dependent code
Package BodyHZ_EXTRACT_PERSON_CUST_BO_PVT - show dependent code