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 154: STANDARD_TERMS,

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

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

269: DECODE( X_PROFILE_CLASS_ID, FND_API.G_MISS_NUM, NULL, X_PROFILE_CLASS_ID ),
270: DECODE( X_SITE_USE_ID, FND_API.G_MISS_NUM, NULL, X_SITE_USE_ID ),
271: DECODE( X_CREDIT_RATING, FND_API.G_MISS_CHAR, NULL, X_CREDIT_RATING ),
272: DECODE( X_RISK_CODE, FND_API.G_MISS_CHAR, NULL, X_RISK_CODE ),
273: DECODE( X_STANDARD_TERMS, FND_API.G_MISS_NUM, NULL, NULL, l_profile_class_rec.standard_terms, X_STANDARD_TERMS ),
274: DECODE( X_OVERRIDE_TERMS, FND_API.G_MISS_CHAR, NULL, NULL, l_profile_class_rec.override_terms, X_OVERRIDE_TERMS ),
275: --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 ),
276: 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 ),
277: 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 429: X_STANDARD_TERMS IN NUMBER,

425: X_PROFILE_CLASS_ID IN NUMBER,
426: X_SITE_USE_ID IN NUMBER,
427: X_CREDIT_RATING IN VARCHAR2,
428: X_RISK_CODE IN VARCHAR2,
429: X_STANDARD_TERMS IN NUMBER,
430: X_OVERRIDE_TERMS IN VARCHAR2,
431: X_DUNNING_LETTER_SET_ID IN NUMBER,
432: X_INTEREST_PERIOD_DAYS IN NUMBER,
433: X_PAYMENT_GRACE_DAYS IN NUMBER,

Line 560: 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 ),

556: PROFILE_CLASS_ID = DECODE( X_PROFILE_CLASS_ID, NULL, PROFILE_CLASS_ID, FND_API.G_MISS_NUM, NULL, X_PROFILE_CLASS_ID ),
557: SITE_USE_ID = DECODE( X_SITE_USE_ID, NULL, SITE_USE_ID, FND_API.G_MISS_NUM, NULL, X_SITE_USE_ID ),
558: CREDIT_RATING = DECODE( X_CREDIT_RATING, NULL, CREDIT_RATING, FND_API.G_MISS_CHAR, NULL, X_CREDIT_RATING ),
559: RISK_CODE = DECODE( X_RISK_CODE, NULL, RISK_CODE, FND_API.G_MISS_CHAR, NULL, X_RISK_CODE ),
560: 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 ),
561: 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 ),
562: --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 ),
563: DUNNING_LETTER_SET_ID = DECODE( X_DUNNING_LETTER_SET_ID, NULL, DECODE( l_profile_class_updated, 'N', DUNNING_LETTER_SET_ID,
564: 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 701: X_STANDARD_TERMS IN NUMBER,

697: X_PROFILE_CLASS_ID IN NUMBER,
698: X_SITE_USE_ID IN NUMBER,
699: X_CREDIT_RATING IN VARCHAR2,
700: X_RISK_CODE IN VARCHAR2,
701: X_STANDARD_TERMS IN NUMBER,
702: X_OVERRIDE_TERMS IN VARCHAR2,
703: X_DUNNING_LETTER_SET_ID IN NUMBER,
704: X_INTEREST_PERIOD_DAYS IN NUMBER,
705: X_PAYMENT_GRACE_DAYS IN NUMBER,

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

880: AND ( X_CREDIT_RATING IS NULL ) ) )
881: AND ( ( Recinfo.RISK_CODE = X_RISK_CODE )
882: OR ( ( Recinfo.RISK_CODE IS NULL )
883: AND ( X_RISK_CODE IS NULL ) ) )
884: AND ( ( Recinfo.STANDARD_TERMS = X_STANDARD_TERMS )
885: OR ( ( Recinfo.STANDARD_TERMS IS NULL )
886: AND ( X_STANDARD_TERMS IS NULL ) ) )
887: AND ( ( Recinfo.OVERRIDE_TERMS = X_OVERRIDE_TERMS )
888: OR ( ( Recinfo.OVERRIDE_TERMS IS NULL )

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

881: AND ( ( Recinfo.RISK_CODE = X_RISK_CODE )
882: OR ( ( Recinfo.RISK_CODE IS NULL )
883: AND ( X_RISK_CODE IS NULL ) ) )
884: AND ( ( Recinfo.STANDARD_TERMS = X_STANDARD_TERMS )
885: OR ( ( Recinfo.STANDARD_TERMS IS NULL )
886: AND ( X_STANDARD_TERMS IS NULL ) ) )
887: AND ( ( Recinfo.OVERRIDE_TERMS = X_OVERRIDE_TERMS )
888: OR ( ( Recinfo.OVERRIDE_TERMS IS NULL )
889: AND ( X_OVERRIDE_TERMS IS NULL ) ) )

Line 886: AND ( X_STANDARD_TERMS IS NULL ) ) )

882: OR ( ( Recinfo.RISK_CODE IS NULL )
883: AND ( X_RISK_CODE IS NULL ) ) )
884: AND ( ( Recinfo.STANDARD_TERMS = X_STANDARD_TERMS )
885: OR ( ( Recinfo.STANDARD_TERMS IS NULL )
886: AND ( X_STANDARD_TERMS IS NULL ) ) )
887: AND ( ( Recinfo.OVERRIDE_TERMS = X_OVERRIDE_TERMS )
888: OR ( ( Recinfo.OVERRIDE_TERMS IS NULL )
889: AND ( X_OVERRIDE_TERMS IS NULL ) ) )
890: AND ( ( Recinfo.DUNNING_LETTER_SET_ID = X_DUNNING_LETTER_SET_ID )

Line 1194: X_STANDARD_TERMS OUT NOCOPY NUMBER,

1190: X_PROFILE_CLASS_ID OUT NOCOPY NUMBER,
1191: X_SITE_USE_ID OUT NOCOPY NUMBER,
1192: X_CREDIT_RATING OUT NOCOPY VARCHAR2,
1193: X_RISK_CODE OUT NOCOPY VARCHAR2,
1194: X_STANDARD_TERMS OUT NOCOPY NUMBER,
1195: X_OVERRIDE_TERMS OUT NOCOPY VARCHAR2,
1196: X_DUNNING_LETTER_SET_ID OUT NOCOPY NUMBER,
1197: X_INTEREST_PERIOD_DAYS OUT NOCOPY NUMBER,
1198: X_PAYMENT_GRACE_DAYS OUT NOCOPY NUMBER,

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

1302: NVL( PROFILE_CLASS_ID, FND_API.G_MISS_NUM ),
1303: NVL( SITE_USE_ID, FND_API.G_MISS_NUM ),
1304: NVL( CREDIT_RATING, FND_API.G_MISS_CHAR ),
1305: NVL( RISK_CODE, FND_API.G_MISS_CHAR ),
1306: NVL( STANDARD_TERMS, FND_API.G_MISS_NUM ),
1307: NVL( OVERRIDE_TERMS, FND_API.G_MISS_CHAR ),
1308: NVL( DUNNING_LETTER_SET_ID, FND_API.G_MISS_NUM ),
1309: NVL( INTEREST_PERIOD_DAYS, FND_API.G_MISS_NUM ),
1310: NVL( PAYMENT_GRACE_DAYS, FND_API.G_MISS_NUM ),

Line 1414: X_STANDARD_TERMS,

1410: X_PROFILE_CLASS_ID,
1411: X_SITE_USE_ID,
1412: X_CREDIT_RATING,
1413: X_RISK_CODE,
1414: X_STANDARD_TERMS,
1415: X_OVERRIDE_TERMS,
1416: X_DUNNING_LETTER_SET_ID,
1417: X_INTEREST_PERIOD_DAYS,
1418: X_PAYMENT_GRACE_DAYS,