DBA Data[Home] [Help]

APPS.EGO_VS_BULKLOAD_PVT dependencies on EGO_METADATA_PUB

Line 2884: PROCEDURE Populate_VS_Interface ( p_valueset_tbl IN Ego_Metadata_Pub.Value_Set_Tbl,

2880:
2881: --------------------------------------------------------------------------------
2882: -- Procedure to populate data back to value set interface table.
2883: --------------------------------------------------------------------------------
2884: PROCEDURE Populate_VS_Interface ( p_valueset_tbl IN Ego_Metadata_Pub.Value_Set_Tbl,
2885: x_return_status OUT NOCOPY VARCHAR2,
2886: x_return_msg OUT NOCOPY VARCHAR2)
2887: IS
2888:

Line 2943: PROCEDURE Populate_VS_Val_Interface ( p_valueset_val_tbl IN Ego_Metadata_Pub.Value_Set_Value_Tbl,

2939: --------------------------------------------------------------------------------
2940: -- Procedure to populate data back to value interface table.
2941: --------------------------------------------------------------------------------
2942:
2943: PROCEDURE Populate_VS_Val_Interface ( p_valueset_val_tbl IN Ego_Metadata_Pub.Value_Set_Value_Tbl,
2944: x_return_status OUT NOCOPY VARCHAR2,
2945: x_return_msg OUT NOCOPY VARCHAR2)
2946: IS
2947:

Line 2995: PROCEDURE Populate_VS_Val_Tl_Interface (p_valueset_val_tl_tbl IN Ego_Metadata_Pub.Value_Set_Value_Tl_Tbl,

2991:
2992: --------------------------------------------------------------------------------
2993: -- Procedure to populate data back to value interface table.
2994: --------------------------------------------------------------------------------
2995: PROCEDURE Populate_VS_Val_Tl_Interface (p_valueset_val_tl_tbl IN Ego_Metadata_Pub.Value_Set_Value_Tl_Tbl,
2996: x_return_status OUT NOCOPY VARCHAR2,
2997: x_return_msg OUT NOCOPY VARCHAR2)
2998: IS
2999:

Line 3875: l_valueset_tab Ego_Metadata_Pub.Value_Set_Tbl;--:= Value_Set_Tbl();

3871:
3872: l_api_name VARCHAR2(100) := 'Import_Value_Set_Intf';
3873:
3874:
3875: l_valueset_tab Ego_Metadata_Pub.Value_Set_Tbl;--:= Value_Set_Tbl();
3876: l_valueset_val_tab Ego_Metadata_Pub.Value_Set_Value_Tbl;--:= Value_Set_Tbl();
3877: l_valueset_val_tl_tbl Ego_Metadata_Pub.Value_Set_Value_Tl_Tbl;
3878: l_return_status VARCHAR2(10);
3879: l_msg_count NUMBER;

Line 3876: l_valueset_val_tab Ego_Metadata_Pub.Value_Set_Value_Tbl;--:= Value_Set_Tbl();

3872: l_api_name VARCHAR2(100) := 'Import_Value_Set_Intf';
3873:
3874:
3875: l_valueset_tab Ego_Metadata_Pub.Value_Set_Tbl;--:= Value_Set_Tbl();
3876: l_valueset_val_tab Ego_Metadata_Pub.Value_Set_Value_Tbl;--:= Value_Set_Tbl();
3877: l_valueset_val_tl_tbl Ego_Metadata_Pub.Value_Set_Value_Tl_Tbl;
3878: l_return_status VARCHAR2(10);
3879: l_msg_count NUMBER;
3880: l_return_msg VARCHAR2(1000);

Line 3877: l_valueset_val_tl_tbl Ego_Metadata_Pub.Value_Set_Value_Tl_Tbl;

3873:
3874:
3875: l_valueset_tab Ego_Metadata_Pub.Value_Set_Tbl;--:= Value_Set_Tbl();
3876: l_valueset_val_tab Ego_Metadata_Pub.Value_Set_Value_Tbl;--:= Value_Set_Tbl();
3877: l_valueset_val_tl_tbl Ego_Metadata_Pub.Value_Set_Value_Tl_Tbl;
3878: l_return_status VARCHAR2(10);
3879: l_msg_count NUMBER;
3880: l_return_msg VARCHAR2(1000);
3881:

Line 3888: l_vs_val_rec Ego_Metadata_Pub.Value_Set_Value_Tbl;

3884: l_err_message_name VARCHAR2(50);
3885: l_err_message_text VARCHAR2(500);
3886:
3887: -- Variables for record type
3888: l_vs_val_rec Ego_Metadata_Pub.Value_Set_Value_Tbl;
3889: l_valueset_rec Ego_Metadata_Pub.Value_Set_Tbl;
3890:
3891: l_install_lang VARCHAR2(10);
3892: l_nls_language VARCHAR2(100);

Line 3889: l_valueset_rec Ego_Metadata_Pub.Value_Set_Tbl;

3885: l_err_message_text VARCHAR2(500);
3886:
3887: -- Variables for record type
3888: l_vs_val_rec Ego_Metadata_Pub.Value_Set_Value_Tbl;
3889: l_valueset_rec Ego_Metadata_Pub.Value_Set_Tbl;
3890:
3891: l_install_lang VARCHAR2(10);
3892: l_nls_language VARCHAR2(100);
3893: l_dynamic_sql VARCHAR2(1000);

Line 5604: p_value_set_tbl IN OUT NOCOPY Ego_Metadata_Pub.Value_Set_Tbl,

5600: -- Procedure to process value set
5601: --------------------------------------------------------------------------------
5602: PROCEDURE Process_Value_Set (
5603: p_api_version IN NUMBER,
5604: p_value_set_tbl IN OUT NOCOPY Ego_Metadata_Pub.Value_Set_Tbl,
5605: p_set_process_id IN NUMBER,
5606: p_commit IN BOOLEAN DEFAULT FALSE,
5607: x_return_status OUT NOCOPY VARCHAR2,
5608: x_msg_count OUT NOCOPY NUMBER,

Line 7108: p_value_set_val_tbl IN OUT NOCOPY Ego_Metadata_Pub.Value_Set_Value_Tbl,

7104:
7105: -- Procedure to process value set
7106: PROCEDURE Process_Value_Set_Value (
7107: p_api_version IN NUMBER,
7108: p_value_set_val_tbl IN OUT NOCOPY Ego_Metadata_Pub.Value_Set_Value_Tbl,
7109: p_value_set_val_tl_tbl IN OUT NOCOPY Ego_Metadata_Pub.Value_Set_Value_Tl_Tbl,
7110: p_set_process_id IN NUMBER,
7111: p_commit IN BOOLEAN DEFAULT FALSE,
7112: x_return_status OUT NOCOPY VARCHAR2,

Line 7109: p_value_set_val_tl_tbl IN OUT NOCOPY Ego_Metadata_Pub.Value_Set_Value_Tl_Tbl,

7105: -- Procedure to process value set
7106: PROCEDURE Process_Value_Set_Value (
7107: p_api_version IN NUMBER,
7108: p_value_set_val_tbl IN OUT NOCOPY Ego_Metadata_Pub.Value_Set_Value_Tbl,
7109: p_value_set_val_tl_tbl IN OUT NOCOPY Ego_Metadata_Pub.Value_Set_Value_Tl_Tbl,
7110: p_set_process_id IN NUMBER,
7111: p_commit IN BOOLEAN DEFAULT FALSE,
7112: x_return_status OUT NOCOPY VARCHAR2,
7113: x_msg_count OUT NOCOPY NUMBER,

Line 9012: p_value_set_val_tbl IN OUT NOCOPY Ego_Metadata_Pub.Value_Set_Value_Tbl,

9008:
9009: -- Procedure to process value set
9010: PROCEDURE Process_Isolate_Value (
9011: p_api_version IN NUMBER,
9012: p_value_set_val_tbl IN OUT NOCOPY Ego_Metadata_Pub.Value_Set_Value_Tbl,
9013: p_value_set_val_tl_tbl IN OUT NOCOPY Ego_Metadata_Pub.Value_Set_Value_Tl_Tbl,
9014: p_set_process_id IN NUMBER,
9015: p_commit IN BOOLEAN DEFAULT FALSE,
9016: x_return_status OUT NOCOPY VARCHAR2,

Line 9013: p_value_set_val_tl_tbl IN OUT NOCOPY Ego_Metadata_Pub.Value_Set_Value_Tl_Tbl,

9009: -- Procedure to process value set
9010: PROCEDURE Process_Isolate_Value (
9011: p_api_version IN NUMBER,
9012: p_value_set_val_tbl IN OUT NOCOPY Ego_Metadata_Pub.Value_Set_Value_Tbl,
9013: p_value_set_val_tl_tbl IN OUT NOCOPY Ego_Metadata_Pub.Value_Set_Value_Tl_Tbl,
9014: p_set_process_id IN NUMBER,
9015: p_commit IN BOOLEAN DEFAULT FALSE,
9016: x_return_status OUT NOCOPY VARCHAR2,
9017: x_msg_count OUT NOCOPY NUMBER,

Line 10551: p_value_set_tbl IN OUT NOCOPY Ego_Metadata_Pub.Value_Set_Tbl,

10547:
10548: -- Procedure to process child value set
10549: PROCEDURE Process_Child_Value_Set (
10550: p_api_version IN NUMBER,
10551: p_value_set_tbl IN OUT NOCOPY Ego_Metadata_Pub.Value_Set_Tbl,
10552: p_valueset_val_tab IN OUT NOCOPY Ego_Metadata_Pub.Value_Set_Value_Tbl,
10553: p_set_process_id IN NUMBER,
10554: p_commit IN BOOLEAN DEFAULT FALSE,
10555: x_return_status OUT NOCOPY VARCHAR2,

Line 10552: p_valueset_val_tab IN OUT NOCOPY Ego_Metadata_Pub.Value_Set_Value_Tbl,

10548: -- Procedure to process child value set
10549: PROCEDURE Process_Child_Value_Set (
10550: p_api_version IN NUMBER,
10551: p_value_set_tbl IN OUT NOCOPY Ego_Metadata_Pub.Value_Set_Tbl,
10552: p_valueset_val_tab IN OUT NOCOPY Ego_Metadata_Pub.Value_Set_Value_Tbl,
10553: p_set_process_id IN NUMBER,
10554: p_commit IN BOOLEAN DEFAULT FALSE,
10555: x_return_status OUT NOCOPY VARCHAR2,
10556: x_msg_count OUT NOCOPY NUMBER,