eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_DISTRIBUTION_LISTS_PVT dependencies on FND_API

Line 5: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

1: PACKAGE PA_DISTRIBUTION_LISTS_PVT AUTHID CURRENT_USER AS
2: /* $Header: PATDSLVS.pls 120.1 2005/08/19 17:03:59 mwasowic noship $ */
3: procedure CREATE_DIST_LIST (
4: p_api_version IN NUMBER := 1.0,
5: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
6: p_commit IN VARCHAR2 := FND_API.g_false,
7: p_validate_only IN VARCHAR2 := FND_API.g_true,
8: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
9: P_LIST_ID in OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 6: p_commit IN VARCHAR2 := FND_API.g_false,

2: /* $Header: PATDSLVS.pls 120.1 2005/08/19 17:03:59 mwasowic noship $ */
3: procedure CREATE_DIST_LIST (
4: p_api_version IN NUMBER := 1.0,
5: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
6: p_commit IN VARCHAR2 := FND_API.g_false,
7: p_validate_only IN VARCHAR2 := FND_API.g_true,
8: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
9: P_LIST_ID in OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
10: P_NAME in VARCHAR2,

Line 7: p_validate_only IN VARCHAR2 := FND_API.g_true,

3: procedure CREATE_DIST_LIST (
4: p_api_version IN NUMBER := 1.0,
5: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
6: p_commit IN VARCHAR2 := FND_API.g_false,
7: p_validate_only IN VARCHAR2 := FND_API.g_true,
8: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
9: P_LIST_ID in OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
10: P_NAME in VARCHAR2,
11: P_DESCRIPTION in VARCHAR2,

Line 8: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

4: p_api_version IN NUMBER := 1.0,
5: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
6: p_commit IN VARCHAR2 := FND_API.g_false,
7: p_validate_only IN VARCHAR2 := FND_API.g_true,
8: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
9: P_LIST_ID in OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
10: P_NAME in VARCHAR2,
11: P_DESCRIPTION in VARCHAR2,
12: P_RECORD_VERSION_NUMBER in NUMBER := 1,

Line 25: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

21: ) ;
22:
23: procedure UPDATE_DIST_LIST (
24: p_api_version IN NUMBER := 1.0,
25: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
26: p_commit IN VARCHAR2 := FND_API.g_false,
27: p_validate_only IN VARCHAR2 := FND_API.g_true,
28: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
29: P_LIST_ID in NUMBER,

Line 26: p_commit IN VARCHAR2 := FND_API.g_false,

22:
23: procedure UPDATE_DIST_LIST (
24: p_api_version IN NUMBER := 1.0,
25: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
26: p_commit IN VARCHAR2 := FND_API.g_false,
27: p_validate_only IN VARCHAR2 := FND_API.g_true,
28: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
29: P_LIST_ID in NUMBER,
30: P_NAME in VARCHAR2,

Line 27: p_validate_only IN VARCHAR2 := FND_API.g_true,

23: procedure UPDATE_DIST_LIST (
24: p_api_version IN NUMBER := 1.0,
25: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
26: p_commit IN VARCHAR2 := FND_API.g_false,
27: p_validate_only IN VARCHAR2 := FND_API.g_true,
28: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
29: P_LIST_ID in NUMBER,
30: P_NAME in VARCHAR2,
31: P_DESCRIPTION in VARCHAR2,

Line 28: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

24: p_api_version IN NUMBER := 1.0,
25: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
26: p_commit IN VARCHAR2 := FND_API.g_false,
27: p_validate_only IN VARCHAR2 := FND_API.g_true,
28: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
29: P_LIST_ID in NUMBER,
30: P_NAME in VARCHAR2,
31: P_DESCRIPTION in VARCHAR2,
32: P_RECORD_VERSION_NUMBER in NUMBER,

Line 43: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

39: ) ;
40:
41: procedure DELETE_DIST_LIST (
42: p_api_version IN NUMBER := 1.0,
43: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
44: p_commit IN VARCHAR2 := FND_API.g_false,
45: p_validate_only IN VARCHAR2 := FND_API.g_true,
46: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
47: P_LIST_ID in NUMBER,

Line 44: p_commit IN VARCHAR2 := FND_API.g_false,

40:
41: procedure DELETE_DIST_LIST (
42: p_api_version IN NUMBER := 1.0,
43: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
44: p_commit IN VARCHAR2 := FND_API.g_false,
45: p_validate_only IN VARCHAR2 := FND_API.g_true,
46: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
47: P_LIST_ID in NUMBER,
48: P_DELETE_LIST_ITEM_FLAG in VARCHAR2 default 'N',

Line 45: p_validate_only IN VARCHAR2 := FND_API.g_true,

41: procedure DELETE_DIST_LIST (
42: p_api_version IN NUMBER := 1.0,
43: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
44: p_commit IN VARCHAR2 := FND_API.g_false,
45: p_validate_only IN VARCHAR2 := FND_API.g_true,
46: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
47: P_LIST_ID in NUMBER,
48: P_DELETE_LIST_ITEM_FLAG in VARCHAR2 default 'N',
49: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 46: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

42: p_api_version IN NUMBER := 1.0,
43: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
44: p_commit IN VARCHAR2 := FND_API.g_false,
45: p_validate_only IN VARCHAR2 := FND_API.g_true,
46: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
47: P_LIST_ID in NUMBER,
48: P_DELETE_LIST_ITEM_FLAG in VARCHAR2 default 'N',
49: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
50: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 55: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

51: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
52: ) ;
53: procedure CREATE_DIST_LIST_ITEM (
54: p_api_version IN NUMBER := 1.0,
55: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
56: p_commit IN VARCHAR2 := FND_API.g_false,
57: p_validate_only IN VARCHAR2 := FND_API.g_true,
58: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
59: P_LIST_ITEM_ID in OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895

Line 56: p_commit IN VARCHAR2 := FND_API.g_false,

52: ) ;
53: procedure CREATE_DIST_LIST_ITEM (
54: p_api_version IN NUMBER := 1.0,
55: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
56: p_commit IN VARCHAR2 := FND_API.g_false,
57: p_validate_only IN VARCHAR2 := FND_API.g_true,
58: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
59: P_LIST_ITEM_ID in OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
60: P_LIST_ID in NUMBER:= null,

Line 57: p_validate_only IN VARCHAR2 := FND_API.g_true,

53: procedure CREATE_DIST_LIST_ITEM (
54: p_api_version IN NUMBER := 1.0,
55: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
56: p_commit IN VARCHAR2 := FND_API.g_false,
57: p_validate_only IN VARCHAR2 := FND_API.g_true,
58: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
59: P_LIST_ITEM_ID in OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
60: P_LIST_ID in NUMBER:= null,
61: P_RECIPIENT_TYPE in VARCHAR2:= null,

Line 58: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

54: p_api_version IN NUMBER := 1.0,
55: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
56: p_commit IN VARCHAR2 := FND_API.g_false,
57: p_validate_only IN VARCHAR2 := FND_API.g_true,
58: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
59: P_LIST_ITEM_ID in OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
60: P_LIST_ID in NUMBER:= null,
61: P_RECIPIENT_TYPE in VARCHAR2:= null,
62: P_RECIPIENT_ID in VARCHAR2:= null,

Line 78: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

74: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
75: ) ;
76: procedure UPDATE_DIST_LIST_ITEM (
77: p_api_version IN NUMBER := 1.0,
78: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
79: p_commit IN VARCHAR2 := FND_API.g_false,
80: p_validate_only IN VARCHAR2 := FND_API.g_true,
81: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
82: P_LIST_ITEM_ID in NUMBER := null,

Line 79: p_commit IN VARCHAR2 := FND_API.g_false,

75: ) ;
76: procedure UPDATE_DIST_LIST_ITEM (
77: p_api_version IN NUMBER := 1.0,
78: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
79: p_commit IN VARCHAR2 := FND_API.g_false,
80: p_validate_only IN VARCHAR2 := FND_API.g_true,
81: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
82: P_LIST_ITEM_ID in NUMBER := null,
83: P_LIST_ID in NUMBER := null,

Line 80: p_validate_only IN VARCHAR2 := FND_API.g_true,

76: procedure UPDATE_DIST_LIST_ITEM (
77: p_api_version IN NUMBER := 1.0,
78: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
79: p_commit IN VARCHAR2 := FND_API.g_false,
80: p_validate_only IN VARCHAR2 := FND_API.g_true,
81: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
82: P_LIST_ITEM_ID in NUMBER := null,
83: P_LIST_ID in NUMBER := null,
84: P_RECIPIENT_TYPE in VARCHAR2 := null,

Line 81: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

77: p_api_version IN NUMBER := 1.0,
78: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
79: p_commit IN VARCHAR2 := FND_API.g_false,
80: p_validate_only IN VARCHAR2 := FND_API.g_true,
81: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
82: P_LIST_ITEM_ID in NUMBER := null,
83: P_LIST_ID in NUMBER := null,
84: P_RECIPIENT_TYPE in VARCHAR2 := null,
85: P_RECIPIENT_ID in VARCHAR2 := null,

Line 99: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,

95: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
96: ) ;
97: procedure DELETE_DIST_LIST_ITEM (
98: p_api_version IN NUMBER := 1.0,
99: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
100: p_commit IN VARCHAR2 := FND_API.g_false,
101: p_validate_only IN VARCHAR2 := FND_API.g_true,
102: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
103: P_LIST_ITEM_ID in NUMBER,

Line 100: p_commit IN VARCHAR2 := FND_API.g_false,

96: ) ;
97: procedure DELETE_DIST_LIST_ITEM (
98: p_api_version IN NUMBER := 1.0,
99: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
100: p_commit IN VARCHAR2 := FND_API.g_false,
101: p_validate_only IN VARCHAR2 := FND_API.g_true,
102: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
103: P_LIST_ITEM_ID in NUMBER,
104: P_RECORD_VERSION_NUMBER in NUMBER := 1,

Line 101: p_validate_only IN VARCHAR2 := FND_API.g_true,

97: procedure DELETE_DIST_LIST_ITEM (
98: p_api_version IN NUMBER := 1.0,
99: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
100: p_commit IN VARCHAR2 := FND_API.g_false,
101: p_validate_only IN VARCHAR2 := FND_API.g_true,
102: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
103: P_LIST_ITEM_ID in NUMBER,
104: P_RECORD_VERSION_NUMBER in NUMBER := 1,
105: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 102: p_max_msg_count IN NUMBER := FND_API.g_miss_num,

98: p_api_version IN NUMBER := 1.0,
99: p_init_msg_list IN VARCHAR2 := fnd_api.g_true,
100: p_commit IN VARCHAR2 := FND_API.g_false,
101: p_validate_only IN VARCHAR2 := FND_API.g_true,
102: p_max_msg_count IN NUMBER := FND_API.g_miss_num,
103: P_LIST_ITEM_ID in NUMBER,
104: P_RECORD_VERSION_NUMBER in NUMBER := 1,
105: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
106: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895