DBA Data[Home] [Help]

APPS.GMD_ACTIVITIES_PUB dependencies on GMD_ACTIVITIES

Line 1: PACKAGE GMD_ACTIVITIES_PUB AUTHID CURRENT_USER AS

1: PACKAGE GMD_ACTIVITIES_PUB AUTHID CURRENT_USER AS
2: /* $Header: GMDPACTS.pls 115.4 2004/04/16 14:35:33 srsriran noship $ */
3: /*#
4: * This interface is used to create, update and delete Activities.
5: * This package defines and implements the procedures and datatypes

Line 12: * @rep:category BUSINESS_ENTITY GMD_ACTIVITIES_PUB

8: * @rep:product GMD
9: * @rep:lifecycle active
10: * @rep:displayname Activities package
11: * @rep:compatibility S
12: * @rep:category BUSINESS_ENTITY GMD_ACTIVITIES_PUB
13: */
14:
15:
16: TYPE activities_rec_type IS RECORD

Line 18: ACTIVITY gmd_activities.activity%type

14:
15:
16: TYPE activities_rec_type IS RECORD
17: (
18: ACTIVITY gmd_activities.activity%type
19: ,COST_ANALYSIS_CODE gmd_activities.cost_analysis_code%type
20: ,DELETE_MARK gmd_activities.delete_mark%type DEFAULT 0
21: ,TEXT_CODE gmd_activities.text_code%type
22: ,TRANS_CNT gmd_activities.trans_cnt%type

Line 19: ,COST_ANALYSIS_CODE gmd_activities.cost_analysis_code%type

15:
16: TYPE activities_rec_type IS RECORD
17: (
18: ACTIVITY gmd_activities.activity%type
19: ,COST_ANALYSIS_CODE gmd_activities.cost_analysis_code%type
20: ,DELETE_MARK gmd_activities.delete_mark%type DEFAULT 0
21: ,TEXT_CODE gmd_activities.text_code%type
22: ,TRANS_CNT gmd_activities.trans_cnt%type
23: ,ACTIVITY_DESC gmd_activities.activity_desc%type

Line 20: ,DELETE_MARK gmd_activities.delete_mark%type DEFAULT 0

16: TYPE activities_rec_type IS RECORD
17: (
18: ACTIVITY gmd_activities.activity%type
19: ,COST_ANALYSIS_CODE gmd_activities.cost_analysis_code%type
20: ,DELETE_MARK gmd_activities.delete_mark%type DEFAULT 0
21: ,TEXT_CODE gmd_activities.text_code%type
22: ,TRANS_CNT gmd_activities.trans_cnt%type
23: ,ACTIVITY_DESC gmd_activities.activity_desc%type
24:

Line 21: ,TEXT_CODE gmd_activities.text_code%type

17: (
18: ACTIVITY gmd_activities.activity%type
19: ,COST_ANALYSIS_CODE gmd_activities.cost_analysis_code%type
20: ,DELETE_MARK gmd_activities.delete_mark%type DEFAULT 0
21: ,TEXT_CODE gmd_activities.text_code%type
22: ,TRANS_CNT gmd_activities.trans_cnt%type
23: ,ACTIVITY_DESC gmd_activities.activity_desc%type
24:
25: );

Line 22: ,TRANS_CNT gmd_activities.trans_cnt%type

18: ACTIVITY gmd_activities.activity%type
19: ,COST_ANALYSIS_CODE gmd_activities.cost_analysis_code%type
20: ,DELETE_MARK gmd_activities.delete_mark%type DEFAULT 0
21: ,TEXT_CODE gmd_activities.text_code%type
22: ,TRANS_CNT gmd_activities.trans_cnt%type
23: ,ACTIVITY_DESC gmd_activities.activity_desc%type
24:
25: );
26:

Line 23: ,ACTIVITY_DESC gmd_activities.activity_desc%type

19: ,COST_ANALYSIS_CODE gmd_activities.cost_analysis_code%type
20: ,DELETE_MARK gmd_activities.delete_mark%type DEFAULT 0
21: ,TEXT_CODE gmd_activities.text_code%type
22: ,TRANS_CNT gmd_activities.trans_cnt%type
23: ,ACTIVITY_DESC gmd_activities.activity_desc%type
24:
25: );
26:
27:

Line 28: TYPE gmd_activities_tbl_type IS TABLE OF activities_rec_type INDEX BY BINARY_INTEGER;

24:
25: );
26:
27:
28: TYPE gmd_activities_tbl_type IS TABLE OF activities_rec_type INDEX BY BINARY_INTEGER;
29:
30:
31: TYPE update_table_rec_type IS RECORD
32: (

Line 44: * Call is made to insert_activity API of GMD_ACTIVITIES_PVT package

40:
41: /*#
42: * Insert a new Activity
43: * This is a PL/SQL procedure to insert a new Activity
44: * Call is made to insert_activity API of GMD_ACTIVITIES_PVT package
45: * @param p_api_version API version field
46: * @param p_init_msg_list Flag to check if message list intialized
47: * @param p_commit Flag to check for commit
48: * @param p_activity_tbl Table structure of Activities table

Line 62: , p_activity_tbl IN gmd_activities_pub.gmd_activities_tbl_type

58: (
59: p_api_version IN NUMBER DEFAULT 1
60: , p_init_msg_list IN BOOLEAN DEFAULT TRUE
61: , p_commit IN BOOLEAN DEFAULT FALSE
62: , p_activity_tbl IN gmd_activities_pub.gmd_activities_tbl_type
63: , x_message_count OUT NOCOPY NUMBER
64: , x_message_list OUT NOCOPY VARCHAR2
65: , x_return_status OUT NOCOPY VARCHAR2
66: );

Line 71: * Call is made to update_activity API of GMD_ACTIVITIES_PVT package

67:
68: /*#
69: * Update an Activity
70: * This is a PL/SQL procedure to update an Activity
71: * Call is made to update_activity API of GMD_ACTIVITIES_PVT package
72: * @param p_api_version API version field
73: * @param p_init_msg_list Flag to check if message list intialized
74: * @param p_commit Flag to check for commit
75: * @param p_activity Field to pass activities

Line 90: , p_activity IN gmd_activities.activity%TYPE

86: (
87: p_api_version IN NUMBER DEFAULT 1
88: , p_init_msg_list IN BOOLEAN DEFAULT TRUE
89: , p_commit IN BOOLEAN DEFAULT FALSE
90: , p_activity IN gmd_activities.activity%TYPE
91: , p_update_table IN gmd_activities_pub.update_tbl_type
92: , x_message_count OUT NOCOPY NUMBER
93: , x_message_list OUT NOCOPY VARCHAR2
94: , x_return_status OUT NOCOPY VARCHAR2

Line 91: , p_update_table IN gmd_activities_pub.update_tbl_type

87: p_api_version IN NUMBER DEFAULT 1
88: , p_init_msg_list IN BOOLEAN DEFAULT TRUE
89: , p_commit IN BOOLEAN DEFAULT FALSE
90: , p_activity IN gmd_activities.activity%TYPE
91: , p_update_table IN gmd_activities_pub.update_tbl_type
92: , x_message_count OUT NOCOPY NUMBER
93: , x_message_list OUT NOCOPY VARCHAR2
94: , x_return_status OUT NOCOPY VARCHAR2
95: );

Line 100: * Call is made to delete_activity API of GMD_ACTIVITIES_PVT package

96:
97: /*#
98: * Delete an Activity
99: * This is a PL/SQL procedure to delete an Activity
100: * Call is made to delete_activity API of GMD_ACTIVITIES_PVT package
101: * @param p_api_version API version field
102: * @param p_init_msg_list Flag to check if message list intialized
103: * @param p_commit Flag to check for commit
104: * @param p_activity Field to pass activities

Line 117: , p_activity IN gmd_activities.activity%TYPE

113: PROCEDURE delete_activity (
114: p_api_version IN NUMBER DEFAULT 1
115: , p_init_msg_list IN BOOLEAN DEFAULT TRUE
116: , p_commit IN BOOLEAN DEFAULT FALSE
117: , p_activity IN gmd_activities.activity%TYPE
118: , x_message_count OUT NOCOPY NUMBER
119: , x_message_list OUT NOCOPY VARCHAR2
120: , x_return_status OUT NOCOPY VARCHAR2
121: );

Line 123: END GMD_ACTIVITIES_PUB;

119: , x_message_list OUT NOCOPY VARCHAR2
120: , x_return_status OUT NOCOPY VARCHAR2
121: );
122:
123: END GMD_ACTIVITIES_PUB;