DBA Data[Home] [Help]

APPS.HZ_FORMAT_PHONE_V2PUB dependencies on FND_API

Line 42: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

38: * @rep:displayname Parse Phone Number
39: * @rep:doccd 120hztig.pdf Phone Parsing and Formatting APIs, Oracle Trading Community Architecture Technical Implementation Guide
40: */
41: PROCEDURE phone_parse (
42: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
43: p_raw_phone_number IN VARCHAR2 := fnd_api.g_miss_char,
44: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,
45: x_phone_country_code OUT NOCOPY VARCHAR2,
46: x_phone_area_code OUT NOCOPY VARCHAR2,

Line 43: p_raw_phone_number IN VARCHAR2 := fnd_api.g_miss_char,

39: * @rep:doccd 120hztig.pdf Phone Parsing and Formatting APIs, Oracle Trading Community Architecture Technical Implementation Guide
40: */
41: PROCEDURE phone_parse (
42: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
43: p_raw_phone_number IN VARCHAR2 := fnd_api.g_miss_char,
44: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,
45: x_phone_country_code OUT NOCOPY VARCHAR2,
46: x_phone_area_code OUT NOCOPY VARCHAR2,
47: x_phone_number OUT NOCOPY VARCHAR2,

Line 44: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,

40: */
41: PROCEDURE phone_parse (
42: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
43: p_raw_phone_number IN VARCHAR2 := fnd_api.g_miss_char,
44: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,
45: x_phone_country_code OUT NOCOPY VARCHAR2,
46: x_phone_area_code OUT NOCOPY VARCHAR2,
47: x_phone_number OUT NOCOPY VARCHAR2,
48: x_mobile_flag OUT NOCOPY VARCHAR2,

Line 54: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

50: x_msg_count OUT NOCOPY NUMBER,
51: x_msg_data OUT NOCOPY VARCHAR2 );
52:
53: PROCEDURE phone_display(
54: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
55: p_contact_point_id IN NUMBER,
56: x_formatted_phone_number OUT NOCOPY VARCHAR2,
57: x_return_status OUT NOCOPY VARCHAR2,
58: x_msg_count OUT NOCOPY NUMBER,

Line 71: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

67: * @rep:displayname Format Phone Number
68: * @rep:doccd 120hztig.pdf Phone Parsing and Formatting APIs, Oracle Trading Community Architecture Technical Implementation Guide
69: */
70: PROCEDURE phone_display(
71: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
72: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,
73: p_phone_country_code IN VARCHAR2 := fnd_api.g_miss_char,
74: p_phone_area_code IN VARCHAR2 := fnd_api.g_miss_char,
75: p_phone_number IN VARCHAR2 := fnd_api.g_miss_char,

Line 72: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,

68: * @rep:doccd 120hztig.pdf Phone Parsing and Formatting APIs, Oracle Trading Community Architecture Technical Implementation Guide
69: */
70: PROCEDURE phone_display(
71: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
72: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,
73: p_phone_country_code IN VARCHAR2 := fnd_api.g_miss_char,
74: p_phone_area_code IN VARCHAR2 := fnd_api.g_miss_char,
75: p_phone_number IN VARCHAR2 := fnd_api.g_miss_char,
76: x_formatted_phone_number OUT NOCOPY VARCHAR2,

Line 73: p_phone_country_code IN VARCHAR2 := fnd_api.g_miss_char,

69: */
70: PROCEDURE phone_display(
71: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
72: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,
73: p_phone_country_code IN VARCHAR2 := fnd_api.g_miss_char,
74: p_phone_area_code IN VARCHAR2 := fnd_api.g_miss_char,
75: p_phone_number IN VARCHAR2 := fnd_api.g_miss_char,
76: x_formatted_phone_number OUT NOCOPY VARCHAR2,
77: x_return_status OUT NOCOPY VARCHAR2,

Line 74: p_phone_area_code IN VARCHAR2 := fnd_api.g_miss_char,

70: PROCEDURE phone_display(
71: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
72: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,
73: p_phone_country_code IN VARCHAR2 := fnd_api.g_miss_char,
74: p_phone_area_code IN VARCHAR2 := fnd_api.g_miss_char,
75: p_phone_number IN VARCHAR2 := fnd_api.g_miss_char,
76: x_formatted_phone_number OUT NOCOPY VARCHAR2,
77: x_return_status OUT NOCOPY VARCHAR2,
78: x_msg_count OUT NOCOPY NUMBER,

Line 75: p_phone_number IN VARCHAR2 := fnd_api.g_miss_char,

71: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
72: p_territory_code IN VARCHAR2 := fnd_api.g_miss_char,
73: p_phone_country_code IN VARCHAR2 := fnd_api.g_miss_char,
74: p_phone_area_code IN VARCHAR2 := fnd_api.g_miss_char,
75: p_phone_number IN VARCHAR2 := fnd_api.g_miss_char,
76: x_formatted_phone_number OUT NOCOPY VARCHAR2,
77: x_return_status OUT NOCOPY VARCHAR2,
78: x_msg_count OUT NOCOPY NUMBER,
79: x_msg_data OUT NOCOPY VARCHAR2 );

Line 83: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

79: x_msg_data OUT NOCOPY VARCHAR2 );
80:
81:
82: PROCEDURE check_mobile_phone (
83: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
84: p_phone_country_code IN VARCHAR2 := fnd_api.g_miss_char,
85: p_phone_area_code IN VARCHAR2 := fnd_api.g_miss_char,
86: p_phone_number IN VARCHAR2 := fnd_api.g_miss_char,
87: x_mobile_flag OUT NOCOPY VARCHAR2,

Line 84: p_phone_country_code IN VARCHAR2 := fnd_api.g_miss_char,

80:
81:
82: PROCEDURE check_mobile_phone (
83: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
84: p_phone_country_code IN VARCHAR2 := fnd_api.g_miss_char,
85: p_phone_area_code IN VARCHAR2 := fnd_api.g_miss_char,
86: p_phone_number IN VARCHAR2 := fnd_api.g_miss_char,
87: x_mobile_flag OUT NOCOPY VARCHAR2,
88: x_return_status OUT NOCOPY VARCHAR2,

Line 85: p_phone_area_code IN VARCHAR2 := fnd_api.g_miss_char,

81:
82: PROCEDURE check_mobile_phone (
83: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
84: p_phone_country_code IN VARCHAR2 := fnd_api.g_miss_char,
85: p_phone_area_code IN VARCHAR2 := fnd_api.g_miss_char,
86: p_phone_number IN VARCHAR2 := fnd_api.g_miss_char,
87: x_mobile_flag OUT NOCOPY VARCHAR2,
88: x_return_status OUT NOCOPY VARCHAR2,
89: x_msg_count OUT NOCOPY NUMBER,

Line 86: p_phone_number IN VARCHAR2 := fnd_api.g_miss_char,

82: PROCEDURE check_mobile_phone (
83: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
84: p_phone_country_code IN VARCHAR2 := fnd_api.g_miss_char,
85: p_phone_area_code IN VARCHAR2 := fnd_api.g_miss_char,
86: p_phone_number IN VARCHAR2 := fnd_api.g_miss_char,
87: x_mobile_flag OUT NOCOPY VARCHAR2,
88: x_return_status OUT NOCOPY VARCHAR2,
89: x_msg_count OUT NOCOPY NUMBER,
90: x_msg_data OUT NOCOPY VARCHAR2);

Line 94: p_display_purpose IN VARCHAR2 := fnd_api.g_true

90: x_msg_data OUT NOCOPY VARCHAR2);
91:
92: FUNCTION get_formatted_phone(
93: p_contact_point_id IN NUMBER,
94: p_display_purpose IN VARCHAR2 := fnd_api.g_true
95: ) RETURN VARCHAR2;
96:
97:
98: /**

Line 112: * When the value is FND_API.G_TRUE, return

108: * p_phone_number phone number
109: * p_phone_extension phone extension
110: * p_phone_line_type phone line type
111: * p_display_purpose If the return is for display purpose.
112: * When the value is FND_API.G_TRUE, return
113: * formatted phone number (phone line type)
114: *
115: * RETURNS : VARCHAR2
116: *