APPS.AMW_SETUP_RISK_TYPES_PKG dependencies on AMW_SETUP_RISK_TYPES_PKG

Line 1: PACKAGE BODY AMW_SETUP_RISK_TYPES_PKG as

1: PACKAGE BODY AMW_SETUP_RISK_TYPES_PKG as
2: /* $Header: amwtrtpb.pls 120.3 2006/08/23 19:06:19 npanandi noship $ */
3:
4:
5: -- ===============================================================

Line 7: -- AMW_SETUP_RISK_TYPES_PKG

3:
4:
5: -- ===============================================================
6: -- Package name
7: -- AMW_SETUP_RISK_TYPES_PKG
8: -- Purpose
9: --
10: -- History
11: -- 07/06/2004 tsho Creates

Line 396: AMW_SETUP_RISK_TYPES_PKG.UPDATE_ROW (

392: /*** 06.06.06 npanandi: AppsRe bug 5282548 --- added begin clause
393: to handle updates/inserts
394: ***/
395: begin
396: AMW_SETUP_RISK_TYPES_PKG.UPDATE_ROW (
397: X_SETUP_RISK_TYPE_ID => X_SETUP_RISK_TYPE_ID,
398: X_RISK_TYPE_CODE => X_RISK_TYPE_CODE,
399: /*** X_PARENT_SETUP_RISK_TYPE_ID => X_PARENT_SETUP_RISK_TYPE_ID, ***/
400: X_PARENT_SETUP_RISK_TYPE_ID => l_parent_setup_risk_type_id,

Line 413: AMW_SETUP_RISK_TYPES_PKG.INSERT_ROW(

409: X_SETUP_RISK_TYPE_NAME => X_SETUP_RISK_TYPE_NAME,
410: X_SETUP_RISK_TYPE_DESCRIPTION => X_SETUP_RISK_TYPE_DESCRIPTION);
411: exception
412: when no_data_found then
413: AMW_SETUP_RISK_TYPES_PKG.INSERT_ROW(
414: X_ROWID => l_row_id,
415: /*** 06.06.06 npanandi: the insert row here should take seeded
416: setupRiskTypeId, NOT any sequence generated one
417: X_SETUP_RISK_TYPE_ID => l_setup_risk_type_id, **/

Line 454: AMW_SETUP_RISK_TYPES_PKG.UPDATE_ROW (

450: select SETUP_RISK_TYPE_ID into l_setup_risk_type_id
451: from AMW_SETUP_RISK_TYPES_B
452: where SETUP_RISK_TYPE_ID = X_SETUP_RISK_TYPE_ID;
453:
454: AMW_SETUP_RISK_TYPES_PKG.UPDATE_ROW (
455: X_SETUP_RISK_TYPE_ID => X_SETUP_RISK_TYPE_ID,
456: X_RISK_TYPE_CODE => X_RISK_TYPE_CODE,
457: X_PARENT_SETUP_RISK_TYPE_ID => X_PARENT_SETUP_RISK_TYPE_ID,
458: X_START_DATE => X_START_DATE,

Line 477: AMW_SETUP_RISK_TYPES_PKG.INSERT_ROW(

473: select AMW_SETUP_RISK_TYPE_S.nextval into l_setup_risk_type_id
474: from dual;
475: */
476:
477: AMW_SETUP_RISK_TYPES_PKG.INSERT_ROW(
478: X_ROWID => l_row_id,
479: X_SETUP_RISK_TYPE_ID => X_SETUP_RISK_TYPE_ID,
480: X_RISK_TYPE_CODE => X_RISK_TYPE_CODE,
481: X_PARENT_SETUP_RISK_TYPE_ID => X_PARENT_SETUP_RISK_TYPE_ID,

Line 655: end AMW_SETUP_RISK_TYPES_PKG;

651: /**05.31.2006 npanandi: bug 5259681 fix ends***/
652:
653:
654: -- ----------------------------------------------------------------------
655: end AMW_SETUP_RISK_TYPES_PKG;