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.EGO_AG_BULKLOAD_PVT dependencies on EGO_METADATA_PUB

Line 2943: (p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,

2939: p_agdl_tbl IN OUT NOCOPY Data level plsql table
2940: p_commit IN Pass true to commit within the API
2941: x_return_status OUT NOCOPY parameter that returns the status*/
2942: PROCEDURE process_attr_groups
2943: (p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,
2944: p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,
2945: p_commit IN BOOLEAN DEFAULT true,
2946: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
2947: IS

Line 2944: p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,

2940: p_commit IN Pass true to commit within the API
2941: x_return_status OUT NOCOPY parameter that returns the status*/
2942: PROCEDURE process_attr_groups
2943: (p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,
2944: p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,
2945: p_commit IN BOOLEAN DEFAULT true,
2946: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
2947: IS
2948:

Line 3001: (p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,

2997: Used in the interface and API flow.
2998: p_ag_tbl IN OUT NOCOPY Attribute groups plsql table
2999: x_return_status OUT NOCOPY parameter that returns the status*/
3000: PROCEDURE Process_ag
3001: (p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,
3002: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
3003: IS
3004: x_ag_id NUMBER;
3005: x_errorcode NUMBER;

Line 3212: (p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,

3208: Used in the interface and API flow.
3209: p_agdl_tbl IN OUT NOCOPY Attribute group data level plsql table
3210: x_return_status OUT NOCOPY parameter that returns the status*/
3211: PROCEDURE Process_dl
3212: (p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,
3213: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
3214: IS
3215: x_msg_count NUMBER;
3216: x_msg_data VARCHAR2(2000);

Line 3439: (p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,

3435: p_attr_tbl IN OUT NOCOPY Attributes plsql table
3436: p_commit IN Pass true to commit within the API
3437: x_return_status OUT NOCOPY parameter that returns the status*/
3438: PROCEDURE process_attribute
3439: (p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,
3440: p_commit IN BOOLEAN DEFAULT true,
3441: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
3442: IS
3443:

Line 3487: (p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,

3483: Used in the interface and API flow.
3484: p_attr_tbl IN OUT NOCOPY Attributes plsql table
3485: x_return_status OUT NOCOPY parameter that returns the status*/
3486: PROCEDURE Process_attr
3487: (p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,
3488: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
3489: IS
3490: x_errorcode NUMBER;
3491: x_msg_count NUMBER;

Line 3728: l_ego_ag_tbl ego_metadata_pub.ego_attr_groups_tbl;

3724: FROM ego_attr_group_cols_intf
3725: WHERE process_status = G_PROCESS_RECORD
3726: AND (p_set_process_id IS NULL OR set_process_id = p_set_process_id);
3727:
3728: l_ego_ag_tbl ego_metadata_pub.ego_attr_groups_tbl;
3729: l_ego_agdl_tbl ego_metadata_pub.ego_attr_groups_dl_tbl;
3730: l_ego_attr_tbl ego_metadata_pub.ego_attr_group_cols_tbl;
3731:
3732: lv_proc VARCHAR2(30) := 'import_ag_intf';

Line 3729: l_ego_agdl_tbl ego_metadata_pub.ego_attr_groups_dl_tbl;

3725: WHERE process_status = G_PROCESS_RECORD
3726: AND (p_set_process_id IS NULL OR set_process_id = p_set_process_id);
3727:
3728: l_ego_ag_tbl ego_metadata_pub.ego_attr_groups_tbl;
3729: l_ego_agdl_tbl ego_metadata_pub.ego_attr_groups_dl_tbl;
3730: l_ego_attr_tbl ego_metadata_pub.ego_attr_group_cols_tbl;
3731:
3732: lv_proc VARCHAR2(30) := 'import_ag_intf';
3733: BEGIN

Line 3730: l_ego_attr_tbl ego_metadata_pub.ego_attr_group_cols_tbl;

3726: AND (p_set_process_id IS NULL OR set_process_id = p_set_process_id);
3727:
3728: l_ego_ag_tbl ego_metadata_pub.ego_attr_groups_tbl;
3729: l_ego_agdl_tbl ego_metadata_pub.ego_attr_groups_dl_tbl;
3730: l_ego_attr_tbl ego_metadata_pub.ego_attr_group_cols_tbl;
3731:
3732: lv_proc VARCHAR2(30) := 'import_ag_intf';
3733: BEGIN
3734: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Entered import_ag_intf.');

Line 3842: (p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,

3838: Used in the API flow.
3839: p_ag_tbl IN OUT NOCOPY Attribute group plsql table
3840: x_return_status OUT NOCOPY parameter that returns the status*/
3841: PROCEDURE Value_to_id_ag_tbl
3842: (p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,
3843: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
3844: IS
3845: lv_smt NUMBER;
3846:

Line 3928: (p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,

3924: data level plsql tables. Used in the API flow.
3925: p_agdl_tbl IN OUT NOCOPY Attribute group data level plsql table
3926: x_return_status OUT NOCOPY parameter that returns the status*/
3927: PROCEDURE Value_to_id_dl_tbl
3928: (p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,
3929: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
3930: IS
3931: lv_smt NUMBER;
3932: lv_flag VARCHAR2(1);

Line 4136: (p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,

4132: Used in the API flow.
4133: p_attr_tbl IN OUT NOCOPY Attributes plsql table
4134: x_return_status OUT NOCOPY parameter that returns the status*/
4135: PROCEDURE Value_to_id_attr_tbl
4136: (p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,
4137: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
4138: IS
4139: lv_smt NUMBER; --Statement counter
4140: lv_proc VARCHAR2(30) := 'Value_to_id_attr_tbl';

Line 4341: (p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,

4337: Used in the Interface and API flow.
4338: p_ag_tbl IN OUT NOCOPY Attribute group plsql table
4339: x_return_status OUT NOCOPY parameter that returns the status*/
4340: PROCEDURE Common_ag_validations
4341: (p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,
4342: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
4343: IS
4344: lv_smt NUMBER; --Statement counter
4345: lv_proc VARCHAR2(30) := 'Common_ag_validations';

Line 4481: (p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,

4477: Used in the Interface and API flow.
4478: p_agdl_tbl IN OUT NOCOPY Attribute group plsql table
4479: x_return_status OUT NOCOPY parameter that returns the status*/
4480: PROCEDURE Common_dl_validations
4481: (p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,
4482: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
4483: IS
4484: lv_smt NUMBER; --Statement counter
4485: lv_proc VARCHAR2(30) := 'Common_dl_validations';

Line 4639: (p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,

4635: Used in the Interface and API flow.
4636: p_attr_tbl IN OUT NOCOPY Attribute group plsql table
4637: x_return_status OUT NOCOPY parameter that returns the status*/
4638: PROCEDURE Common_attr_validations
4639: (p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,
4640: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
4641: IS
4642: lv_smt NUMBER; --Statement counter
4643: lv_proc VARCHAR2(30) := 'Common_attr_validations';

Line 5195: (p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,

5191: Used in the API flow.
5192: p_ag_tbl IN OUT NOCOPY Attribute group plsql table
5193: x_return_status OUT NOCOPY parameter that returns the status*/
5194: PROCEDURE Additional_agdl_validations
5195: (p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,
5196: p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,
5197: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
5198: IS
5199: lv_smt NUMBER; --Statement counter

Line 5196: p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,

5192: p_ag_tbl IN OUT NOCOPY Attribute group plsql table
5193: x_return_status OUT NOCOPY parameter that returns the status*/
5194: PROCEDURE Additional_agdl_validations
5195: (p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,
5196: p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,
5197: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
5198: IS
5199: lv_smt NUMBER; --Statement counter
5200: lv_flag VARCHAR2(1);

Line 5901: (p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,

5897: Used in the API flow.
5898: p_attr_tbl IN OUT NOCOPY Attributes plsql table
5899: x_return_status OUT NOCOPY parameter that returns the status*/
5900: PROCEDURE Additional_attr_validations
5901: (p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,
5902: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
5903: IS
5904: lv_smt NUMBER; --Statement counter
5905: lv_proc VARCHAR2(30) := 'Additional_attr_validations';

Line 6115: (p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,

6111: Used in the interface flow.
6112: p_ag_tbl IN OUT NOCOPY Attribute group plsql table
6113: x_return_status OUT NOCOPY parameter that returns the status*/
6114: PROCEDURE update_intf_attr_groups
6115: (p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,
6116: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
6117: IS
6118: lv_proc VARCHAR2(30) := 'update_intf_attr_groups';
6119: trans_id dbms_sql.number_table;

Line 6151: (p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,

6147: Used in the interface flow.
6148: p_agdl_tbl IN OUT NOCOPY Attribute group data level plsql table
6149: x_return_status OUT NOCOPY parameter that returns the status*/
6150: PROCEDURE update_intf_data_level
6151: (p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,
6152: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
6153: IS
6154: lv_proc VARCHAR2(30) := 'update_intf_data_level';
6155: trans_id dbms_sql.number_table;

Line 6188: (p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,

6184: Used in the Interface flow.
6185: p_attr_tbl IN OUT NOCOPY Attributes plsql table
6186: x_return_status OUT NOCOPY parameter that returns the status*/
6187: PROCEDURE update_intf_attribute
6188: (p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,
6189: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
6190: IS
6191: lv_proc VARCHAR2(30) := 'update_intf_attribute';
6192: trans_id dbms_sql.number_table;

Line 6319: p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,

6315: p_ag_tbl IN OUT NOCOPY Attribute groups plsql table
6316: x_return_status OUT NOCOPY parameter that returns the status
6317: x_return_msg OUT NOCOPY parameter that returns the error message*/
6318: PROCEDURE handle_null_ag(
6319: p_ag_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_tbl,
6320: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
6321: IS
6322: lv_display_name VARCHAR2(40); /*Added for bug 9738246*/
6323: lv_num_of_cols NUMBER;

Line 6424: p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,

6420: p_agdl_tbl IN OUT NOCOPY Attribute group data level plsql table
6421: x_return_status OUT NOCOPY parameter that returns the status
6422: x_return_msg OUT NOCOPY parameter that returns the error message*/
6423: PROCEDURE handle_null_dl(
6424: p_agdl_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_groups_dl_tbl,
6425: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
6426: IS
6427: lv_defaulting VARCHAR2(1);
6428: lv_view_privilege_id NUMBER;

Line 6508: p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,

6504: p_attr_tbl IN OUT NOCOPY Attributes plsql table
6505: x_return_status OUT NOCOPY parameter that returns the status
6506: x_return_msg OUT NOCOPY parameter that returns the error message*/
6507: PROCEDURE handle_null_attr(
6508: p_attr_tbl IN OUT NOCOPY ego_metadata_pub.ego_attr_group_cols_tbl,
6509: x_return_status OUT NOCOPY VARCHAR2, x_return_msg OUT NOCOPY VARCHAR2)
6510: IS
6511: lv_value_set_id NUMBER;
6512: lv_default_value VARCHAR2(2000); /*Added for bug 9738246 */