DBA Data[Home] [Help]

APPS.HZ_CUSTOMER_PROFILES_PKG dependencies on STANDARD

Line 23: X_STANDARD_TERMS IN NUMBER,

19: X_PROFILE_CLASS_ID IN NUMBER,
20: X_SITE_USE_ID IN NUMBER,
21: X_CREDIT_RATING IN VARCHAR2,
22: X_RISK_CODE IN VARCHAR2,
23: X_STANDARD_TERMS IN NUMBER,
24: X_OVERRIDE_TERMS IN VARCHAR2,
25: X_DUNNING_LETTER_SET_ID IN NUMBER,
26: X_INTEREST_PERIOD_DAYS IN NUMBER,
27: X_PAYMENT_GRACE_DAYS IN NUMBER,

Line 156: STANDARD_TERMS,

152: PROFILE_CLASS_ID,
153: SITE_USE_ID,
154: CREDIT_RATING,
155: RISK_CODE,
156: STANDARD_TERMS,
157: OVERRIDE_TERMS,
158: DUNNING_LETTER_SET_ID,
159: INTEREST_PERIOD_DAYS,
160: PAYMENT_GRACE_DAYS,

Line 276: DECODE( X_STANDARD_TERMS, FND_API.G_MISS_NUM, NULL, NULL, l_profile_class_rec.standard_terms, X_STANDARD_TERMS ),

272: DECODE( X_PROFILE_CLASS_ID, FND_API.G_MISS_NUM, NULL, X_PROFILE_CLASS_ID ),
273: DECODE( X_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, X_SITE_USE_ID ),
274: DECODE( X_CREDIT_RATING, FND_API.G_MISS_CHAR, NULL, X_CREDIT_RATING ),
275: DECODE( X_RISK_CODE, FND_API.G_MISS_CHAR, NULL, X_RISK_CODE ),
276: DECODE( X_STANDARD_TERMS, FND_API.G_MISS_NUM, NULL, NULL, l_profile_class_rec.standard_terms, X_STANDARD_TERMS ),
277: DECODE( X_OVERRIDE_TERMS, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.override_terms, X_OVERRIDE_TERMS ),
278: --DECODE( X_DUNNING_LETTER_SET_ID, FND_API.G_MISS_NUM, NULL, NULL, l_profile_class_rec.dunning_letter_set_id, X_DUNNING_LETTER_SET_ID ),
279: DECODE( X_DUNNING_LETTER_SET_ID,FND_API.G_MISS_NUM, NULL, NULL,decode(nvl(X_DUNNING_LETTERS,l_profile_class_rec.dunning_letters),'Y',l_profile_class_rec.dunning_letter_set_id,X_DUNNING_LETTER_SET_ID),X_DUNNING_LETTER_SET_ID ),
280: DECODE( X_INTEREST_PERIOD_DAYS, FND_API.G_MISS_NUM, NULL,NULL,decode(nvl(X_INTEREST_CHARGES,l_profile_class_rec.interest_charges),'Y',l_profile_class_rec.interest_period_days,X_INTEREST_PERIOD_DAYS),X_INTEREST_PERIOD_DAYS ),

Line 439: X_STANDARD_TERMS IN NUMBER,

435: X_PROFILE_CLASS_ID IN NUMBER,
436: X_SITE_USE_ID IN NUMBER,
437: X_CREDIT_RATING IN VARCHAR2,
438: X_RISK_CODE IN VARCHAR2,
439: X_STANDARD_TERMS IN NUMBER,
440: X_OVERRIDE_TERMS IN VARCHAR2,
441: X_DUNNING_LETTER_SET_ID IN NUMBER,
442: X_INTEREST_PERIOD_DAYS IN NUMBER,
443: X_PAYMENT_GRACE_DAYS IN NUMBER,

Line 571: STANDARD_TERMS = DECODE( X_STANDARD_TERMS, NULL, DECODE( l_profile_class_updated, 'N', STANDARD_TERMS, l_profile_class_rec.standard_terms ), FND_API.G_MISS_NUM, NULL, X_STANDARD_TERMS ),

567: PROFILE_CLASS_ID = DECODE( X_PROFILE_CLASS_ID, NULL, PROFILE_CLASS_ID, FND_API.G_MISS_NUM, NULL, X_PROFILE_CLASS_ID ),
568: SITE_USE_ID = DECODE( X_SITE_USE_ID, NULL, SITE_USE_ID, FND_API.G_MISS_NUM, NULL, X_SITE_USE_ID ),
569: CREDIT_RATING = DECODE( X_CREDIT_RATING, NULL, CREDIT_RATING, FND_API.G_MISS_CHAR, NULL, X_CREDIT_RATING ),
570: RISK_CODE = DECODE( X_RISK_CODE, NULL, RISK_CODE, FND_API.G_MISS_CHAR, NULL, X_RISK_CODE ),
571: STANDARD_TERMS = DECODE( X_STANDARD_TERMS, NULL, DECODE( l_profile_class_updated, 'N', STANDARD_TERMS, l_profile_class_rec.standard_terms ), FND_API.G_MISS_NUM, NULL, X_STANDARD_TERMS ),
572: OVERRIDE_TERMS = DECODE( X_OVERRIDE_TERMS, NULL, DECODE( l_profile_class_updated, 'N', OVERRIDE_TERMS, l_profile_class_rec.override_terms ), FND_API.G_MISS_CHAR, NULL, X_OVERRIDE_TERMS ),
573: --DUNNING_LETTER_SET_ID = DECODE( X_DUNNING_LETTER_SET_ID, NULL, DECODE( l_profile_class_updated, 'N', DUNNING_LETTER_SET_ID, l_profile_class_rec.dunning_letter_set_id ), FND_API.G_MISS_NUM, NULL, X_DUNNING_LETTER_SET_ID ),
574: DUNNING_LETTER_SET_ID = DECODE( X_DUNNING_LETTER_SET_ID, NULL, DECODE( l_profile_class_updated, 'N', DUNNING_LETTER_SET_ID,
575: decode(nvl(X_DUNNING_LETTERS,l_profile_class_rec.dunning_letters),'Y',l_profile_class_rec.dunning_letter_set_id,X_DUNNING_LETTER_SET_ID)), FND_API.G_MISS_NUM, NULL, X_DUNNING_LETTER_SET_ID ),

Line 714: X_STANDARD_TERMS IN NUMBER,

710: X_PROFILE_CLASS_ID IN NUMBER,
711: X_SITE_USE_ID IN NUMBER,
712: X_CREDIT_RATING IN VARCHAR2,
713: X_RISK_CODE IN VARCHAR2,
714: X_STANDARD_TERMS IN NUMBER,
715: X_OVERRIDE_TERMS IN VARCHAR2,
716: X_DUNNING_LETTER_SET_ID IN NUMBER,
717: X_INTEREST_PERIOD_DAYS IN NUMBER,
718: X_PAYMENT_GRACE_DAYS IN NUMBER,

Line 898: AND ( ( Recinfo.STANDARD_TERMS = X_STANDARD_TERMS )

894: AND ( X_CREDIT_RATING IS NULL ) ) )
895: AND ( ( Recinfo.RISK_CODE = X_RISK_CODE )
896: OR ( ( Recinfo.RISK_CODE IS NULL )
897: AND ( X_RISK_CODE IS NULL ) ) )
898: AND ( ( Recinfo.STANDARD_TERMS = X_STANDARD_TERMS )
899: OR ( ( Recinfo.STANDARD_TERMS IS NULL )
900: AND ( X_STANDARD_TERMS IS NULL ) ) )
901: AND ( ( Recinfo.OVERRIDE_TERMS = X_OVERRIDE_TERMS )
902: OR ( ( Recinfo.OVERRIDE_TERMS IS NULL )

Line 899: OR ( ( Recinfo.STANDARD_TERMS IS NULL )

895: AND ( ( Recinfo.RISK_CODE = X_RISK_CODE )
896: OR ( ( Recinfo.RISK_CODE IS NULL )
897: AND ( X_RISK_CODE IS NULL ) ) )
898: AND ( ( Recinfo.STANDARD_TERMS = X_STANDARD_TERMS )
899: OR ( ( Recinfo.STANDARD_TERMS IS NULL )
900: AND ( X_STANDARD_TERMS IS NULL ) ) )
901: AND ( ( Recinfo.OVERRIDE_TERMS = X_OVERRIDE_TERMS )
902: OR ( ( Recinfo.OVERRIDE_TERMS IS NULL )
903: AND ( X_OVERRIDE_TERMS IS NULL ) ) )

Line 900: AND ( X_STANDARD_TERMS IS NULL ) ) )

896: OR ( ( Recinfo.RISK_CODE IS NULL )
897: AND ( X_RISK_CODE IS NULL ) ) )
898: AND ( ( Recinfo.STANDARD_TERMS = X_STANDARD_TERMS )
899: OR ( ( Recinfo.STANDARD_TERMS IS NULL )
900: AND ( X_STANDARD_TERMS IS NULL ) ) )
901: AND ( ( Recinfo.OVERRIDE_TERMS = X_OVERRIDE_TERMS )
902: OR ( ( Recinfo.OVERRIDE_TERMS IS NULL )
903: AND ( X_OVERRIDE_TERMS IS NULL ) ) )
904: AND ( ( Recinfo.DUNNING_LETTER_SET_ID = X_DUNNING_LETTER_SET_ID )

Line 1211: X_STANDARD_TERMS OUT NOCOPY NUMBER,

1207: X_PROFILE_CLASS_ID OUT NOCOPY NUMBER,
1208: X_SITE_USE_ID OUT NOCOPY NUMBER,
1209: X_CREDIT_RATING OUT NOCOPY VARCHAR2,
1210: X_RISK_CODE OUT NOCOPY VARCHAR2,
1211: X_STANDARD_TERMS OUT NOCOPY NUMBER,
1212: X_OVERRIDE_TERMS OUT NOCOPY VARCHAR2,
1213: X_DUNNING_LETTER_SET_ID OUT NOCOPY NUMBER,
1214: X_INTEREST_PERIOD_DAYS OUT NOCOPY NUMBER,
1215: X_PAYMENT_GRACE_DAYS OUT NOCOPY NUMBER,

Line 1324: NVL( STANDARD_TERMS, FND_API.G_MISS_NUM ),

1320: NVL( PROFILE_CLASS_ID, FND_API.G_MISS_NUM ),
1321: NVL( SITE_USE_ID, FND_API.G_MISS_NUM ),
1322: NVL( CREDIT_RATING, FND_API.G_MISS_CHAR ),
1323: NVL( RISK_CODE, FND_API.G_MISS_CHAR ),
1324: NVL( STANDARD_TERMS, FND_API.G_MISS_NUM ),
1325: NVL( OVERRIDE_TERMS, FND_API.G_MISS_CHAR ),
1326: NVL( DUNNING_LETTER_SET_ID, FND_API.G_MISS_NUM ),
1327: NVL( INTEREST_PERIOD_DAYS, FND_API.G_MISS_NUM ),
1328: NVL( PAYMENT_GRACE_DAYS, FND_API.G_MISS_NUM ),

Line 1433: X_STANDARD_TERMS,

1429: X_PROFILE_CLASS_ID,
1430: X_SITE_USE_ID,
1431: X_CREDIT_RATING,
1432: X_RISK_CODE,
1433: X_STANDARD_TERMS,
1434: X_OVERRIDE_TERMS,
1435: X_DUNNING_LETTER_SET_ID,
1436: X_INTEREST_PERIOD_DAYS,
1437: X_PAYMENT_GRACE_DAYS,