APPS.HZ_PHONE_FORMATS_PKG dependencies on FND_API

Line 38: decode(p_PHONE_FORMAT_STYLE, FND_API.G_MISS_CHAR, NULL, p_PHONE_FORMAT_STYLE),

34: LAST_UPDATE_DATE,
35: LAST_UPDATED_BY,
36: OBJECT_VERSION_NUMBER ) VALUES(
37: p_TERRITORY_CODE,
38: decode(p_PHONE_FORMAT_STYLE, FND_API.G_MISS_CHAR, NULL, p_PHONE_FORMAT_STYLE),
39: decode(p_COUNTRY_CODE_DISPLAY_FLAG, FND_API.G_MISS_CHAR, NULL,
40: p_COUNTRY_CODE_DISPLAY_FLAG),
41: decode(p_AREA_CODE_SIZE, FND_API.G_MISS_NUM, NULL, p_AREA_CODE_SIZE),
42: decode(p_FORMAT_NAME, FND_API.G_MISS_CHAR, NULL, p_FORMAT_NAME),

Line 39: decode(p_COUNTRY_CODE_DISPLAY_FLAG, FND_API.G_MISS_CHAR, NULL,

35: LAST_UPDATED_BY,
36: OBJECT_VERSION_NUMBER ) VALUES(
37: p_TERRITORY_CODE,
38: decode(p_PHONE_FORMAT_STYLE, FND_API.G_MISS_CHAR, NULL, p_PHONE_FORMAT_STYLE),
39: decode(p_COUNTRY_CODE_DISPLAY_FLAG, FND_API.G_MISS_CHAR, NULL,
40: p_COUNTRY_CODE_DISPLAY_FLAG),
41: decode(p_AREA_CODE_SIZE, FND_API.G_MISS_NUM, NULL, p_AREA_CODE_SIZE),
42: decode(p_FORMAT_NAME, FND_API.G_MISS_CHAR, NULL, p_FORMAT_NAME),
43: decode(p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),

Line 41: decode(p_AREA_CODE_SIZE, FND_API.G_MISS_NUM, NULL, p_AREA_CODE_SIZE),

37: p_TERRITORY_CODE,
38: decode(p_PHONE_FORMAT_STYLE, FND_API.G_MISS_CHAR, NULL, p_PHONE_FORMAT_STYLE),
39: decode(p_COUNTRY_CODE_DISPLAY_FLAG, FND_API.G_MISS_CHAR, NULL,
40: p_COUNTRY_CODE_DISPLAY_FLAG),
41: decode(p_AREA_CODE_SIZE, FND_API.G_MISS_NUM, NULL, p_AREA_CODE_SIZE),
42: decode(p_FORMAT_NAME, FND_API.G_MISS_CHAR, NULL, p_FORMAT_NAME),
43: decode(p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
44: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
45: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),

Line 42: decode(p_FORMAT_NAME, FND_API.G_MISS_CHAR, NULL, p_FORMAT_NAME),

38: decode(p_PHONE_FORMAT_STYLE, FND_API.G_MISS_CHAR, NULL, p_PHONE_FORMAT_STYLE),
39: decode(p_COUNTRY_CODE_DISPLAY_FLAG, FND_API.G_MISS_CHAR, NULL,
40: p_COUNTRY_CODE_DISPLAY_FLAG),
41: decode(p_AREA_CODE_SIZE, FND_API.G_MISS_NUM, NULL, p_AREA_CODE_SIZE),
42: decode(p_FORMAT_NAME, FND_API.G_MISS_CHAR, NULL, p_FORMAT_NAME),
43: decode(p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
44: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
45: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),
46: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),

Line 43: decode(p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),

39: decode(p_COUNTRY_CODE_DISPLAY_FLAG, FND_API.G_MISS_CHAR, NULL,
40: p_COUNTRY_CODE_DISPLAY_FLAG),
41: decode(p_AREA_CODE_SIZE, FND_API.G_MISS_NUM, NULL, p_AREA_CODE_SIZE),
42: decode(p_FORMAT_NAME, FND_API.G_MISS_CHAR, NULL, p_FORMAT_NAME),
43: decode(p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
44: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
45: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),
46: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
47: decode(p_last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),

Line 44: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),

40: p_COUNTRY_CODE_DISPLAY_FLAG),
41: decode(p_AREA_CODE_SIZE, FND_API.G_MISS_NUM, NULL, p_AREA_CODE_SIZE),
42: decode(p_FORMAT_NAME, FND_API.G_MISS_CHAR, NULL, p_FORMAT_NAME),
43: decode(p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
44: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
45: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),
46: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
47: decode(p_last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
48: decode(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),

Line 45: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),

41: decode(p_AREA_CODE_SIZE, FND_API.G_MISS_NUM, NULL, p_AREA_CODE_SIZE),
42: decode(p_FORMAT_NAME, FND_API.G_MISS_CHAR, NULL, p_FORMAT_NAME),
43: decode(p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
44: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
45: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),
46: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
47: decode(p_last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
48: decode(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
49: 1

Line 46: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),

42: decode(p_FORMAT_NAME, FND_API.G_MISS_CHAR, NULL, p_FORMAT_NAME),
43: decode(p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
44: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
45: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),
46: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
47: decode(p_last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
48: decode(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
49: 1
50: );

Line 47: decode(p_last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),

43: decode(p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION),
44: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
45: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),
46: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
47: decode(p_last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
48: decode(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
49: 1
50: );
51:

Line 48: decode(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),

44: decode(p_created_by, FND_API.G_MISS_NUM, NULL, p_created_by),
45: decode(p_creation_date, FND_API.G_MISS_DATE, to_date(NULL), p_creation_date),
46: decode(p_last_update_login,FND_API.G_MISS_NUM, NULL, p_last_update_login),
47: decode(p_last_update_date, FND_API.G_MISS_DATE, to_date(NULL), p_last_update_date),
48: decode(p_last_updated_by, FND_API.G_MISS_NUM, NULL, p_last_updated_by),
49: 1
50: );
51:
52: OPEN C;

Line 82: TERRITORY_CODE = decode(p_TERRITORY_CODE, FND_API.G_MISS_CHAR,

78:
79: l_object_version_number := NVL(p_object_version_number, 1) + 1;
80: UPDATE HZ_PHONE_FORMATS
81: SET
82: TERRITORY_CODE = decode(p_TERRITORY_CODE, FND_API.G_MISS_CHAR,
83: TERRITORY_CODE, p_TERRITORY_CODE),
84: PHONE_FORMAT_STYLE = decode(p_PHONE_FORMAT_STYLE, FND_API.G_MISS_CHAR,
85: PHONE_FORMAT_STYLE, p_PHONE_FORMAT_STYLE),
86: COUNTRY_CODE_DISPLAY_FLAG = decode(p_COUNTRY_CODE_DISPLAY_FLAG,

Line 84: PHONE_FORMAT_STYLE = decode(p_PHONE_FORMAT_STYLE, FND_API.G_MISS_CHAR,

80: UPDATE HZ_PHONE_FORMATS
81: SET
82: TERRITORY_CODE = decode(p_TERRITORY_CODE, FND_API.G_MISS_CHAR,
83: TERRITORY_CODE, p_TERRITORY_CODE),
84: PHONE_FORMAT_STYLE = decode(p_PHONE_FORMAT_STYLE, FND_API.G_MISS_CHAR,
85: PHONE_FORMAT_STYLE, p_PHONE_FORMAT_STYLE),
86: COUNTRY_CODE_DISPLAY_FLAG = decode(p_COUNTRY_CODE_DISPLAY_FLAG,
87: FND_API.G_MISS_CHAR, COUNTRY_CODE_DISPLAY_FLAG, p_COUNTRY_CODE_DISPLAY_FLAG),
88: AREA_CODE_SIZE = decode(p_AREA_CODE_SIZE, FND_API.G_MISS_NUM,

Line 87: FND_API.G_MISS_CHAR, COUNTRY_CODE_DISPLAY_FLAG, p_COUNTRY_CODE_DISPLAY_FLAG),

83: TERRITORY_CODE, p_TERRITORY_CODE),
84: PHONE_FORMAT_STYLE = decode(p_PHONE_FORMAT_STYLE, FND_API.G_MISS_CHAR,
85: PHONE_FORMAT_STYLE, p_PHONE_FORMAT_STYLE),
86: COUNTRY_CODE_DISPLAY_FLAG = decode(p_COUNTRY_CODE_DISPLAY_FLAG,
87: FND_API.G_MISS_CHAR, COUNTRY_CODE_DISPLAY_FLAG, p_COUNTRY_CODE_DISPLAY_FLAG),
88: AREA_CODE_SIZE = decode(p_AREA_CODE_SIZE, FND_API.G_MISS_NUM,
89: AREA_CODE_SIZE, p_AREA_CODE_SIZE),
90: FORMAT_NAME = decode(p_FORMAT_NAME, FND_API.G_MISS_CHAR,
91: FORMAT_NAME, p_FORMAT_NAME),

Line 88: AREA_CODE_SIZE = decode(p_AREA_CODE_SIZE, FND_API.G_MISS_NUM,

84: PHONE_FORMAT_STYLE = decode(p_PHONE_FORMAT_STYLE, FND_API.G_MISS_CHAR,
85: PHONE_FORMAT_STYLE, p_PHONE_FORMAT_STYLE),
86: COUNTRY_CODE_DISPLAY_FLAG = decode(p_COUNTRY_CODE_DISPLAY_FLAG,
87: FND_API.G_MISS_CHAR, COUNTRY_CODE_DISPLAY_FLAG, p_COUNTRY_CODE_DISPLAY_FLAG),
88: AREA_CODE_SIZE = decode(p_AREA_CODE_SIZE, FND_API.G_MISS_NUM,
89: AREA_CODE_SIZE, p_AREA_CODE_SIZE),
90: FORMAT_NAME = decode(p_FORMAT_NAME, FND_API.G_MISS_CHAR,
91: FORMAT_NAME, p_FORMAT_NAME),
92: DESCRIPTION = decode(p_DESCRIPTION, FND_API.G_MISS_CHAR,

Line 90: FORMAT_NAME = decode(p_FORMAT_NAME, FND_API.G_MISS_CHAR,

86: COUNTRY_CODE_DISPLAY_FLAG = decode(p_COUNTRY_CODE_DISPLAY_FLAG,
87: FND_API.G_MISS_CHAR, COUNTRY_CODE_DISPLAY_FLAG, p_COUNTRY_CODE_DISPLAY_FLAG),
88: AREA_CODE_SIZE = decode(p_AREA_CODE_SIZE, FND_API.G_MISS_NUM,
89: AREA_CODE_SIZE, p_AREA_CODE_SIZE),
90: FORMAT_NAME = decode(p_FORMAT_NAME, FND_API.G_MISS_CHAR,
91: FORMAT_NAME, p_FORMAT_NAME),
92: DESCRIPTION = decode(p_DESCRIPTION, FND_API.G_MISS_CHAR,
93: DESCRIPTION, p_DESCRIPTION),
94: -- bug 3032780

Line 92: DESCRIPTION = decode(p_DESCRIPTION, FND_API.G_MISS_CHAR,

88: AREA_CODE_SIZE = decode(p_AREA_CODE_SIZE, FND_API.G_MISS_NUM,
89: AREA_CODE_SIZE, p_AREA_CODE_SIZE),
90: FORMAT_NAME = decode(p_FORMAT_NAME, FND_API.G_MISS_CHAR,
91: FORMAT_NAME, p_FORMAT_NAME),
92: DESCRIPTION = decode(p_DESCRIPTION, FND_API.G_MISS_CHAR,
93: DESCRIPTION, p_DESCRIPTION),
94: -- bug 3032780
95: /*
96: CREATED_BY = decode(p_created_by,FND_API.G_MISS_NUM,

Line 96: CREATED_BY = decode(p_created_by,FND_API.G_MISS_NUM,

92: DESCRIPTION = decode(p_DESCRIPTION, FND_API.G_MISS_CHAR,
93: DESCRIPTION, p_DESCRIPTION),
94: -- bug 3032780
95: /*
96: CREATED_BY = decode(p_created_by,FND_API.G_MISS_NUM,
97: CREATED_BY, p_created_by),
98: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE,
99: CREATION_DATE,p_CREATION_DATE),
100: */

Line 98: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE,

94: -- bug 3032780
95: /*
96: CREATED_BY = decode(p_created_by,FND_API.G_MISS_NUM,
97: CREATED_BY, p_created_by),
98: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE,
99: CREATION_DATE,p_CREATION_DATE),
100: */
101: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,
102: LAST_UPDATE_LOGIN,p_LAST_UPDATE_LOGIN),

Line 101: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,

97: CREATED_BY, p_created_by),
98: CREATION_DATE = decode(p_CREATION_DATE, FND_API.G_MISS_DATE,
99: CREATION_DATE,p_CREATION_DATE),
100: */
101: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,
102: LAST_UPDATE_LOGIN,p_LAST_UPDATE_LOGIN),
103: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
104: LAST_UPDATE_DATE,p_LAST_UPDATE_DATE),
105: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,

Line 103: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,

99: CREATION_DATE,p_CREATION_DATE),
100: */
101: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,
102: LAST_UPDATE_LOGIN,p_LAST_UPDATE_LOGIN),
103: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
104: LAST_UPDATE_DATE,p_LAST_UPDATE_DATE),
105: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,
106: LAST_UPDATED_BY,p_LAST_UPDATED_BY),
107: OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,

Line 105: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,

101: LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,
102: LAST_UPDATE_LOGIN,p_LAST_UPDATE_LOGIN),
103: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
104: LAST_UPDATE_DATE,p_LAST_UPDATE_DATE),
105: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,
106: LAST_UPDATED_BY,p_LAST_UPDATED_BY),
107: OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
108: OBJECT_VERSION_NUMBER,l_object_version_number)
109: WHERE rowid = p_RowId;

Line 107: OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,

103: LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
104: LAST_UPDATE_DATE,p_LAST_UPDATE_DATE),
105: LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,
106: LAST_UPDATED_BY,p_LAST_UPDATED_BY),
107: OBJECT_VERSION_NUMBER = decode(l_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,
108: OBJECT_VERSION_NUMBER,l_object_version_number)
109: WHERE rowid = p_RowId;
110:
111: p_OBJECT_VERSION_NUMBER := l_OBJECT_VERSION_NUMBER;