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_PUB_FWK_PK dependencies on DBMS_SQL

Line 2567: l_pk1_vals dbms_sql.varchar2_table;

2563: FUNCTION getBatchEntities (p_batch_id IN NUMBER)
2564: return TBL_OF_BAT_ENT_OBJ_TYPE
2565: IS
2566: l_counter number;
2567: l_pk1_vals dbms_sql.varchar2_table;
2568: l_pk2_vals dbms_sql.varchar2_table;
2569: l_pk3_vals dbms_sql.varchar2_table;
2570: l_pk4_vals dbms_sql.varchar2_table;
2571: l_pk5_vals dbms_sql.varchar2_table;

Line 2568: l_pk2_vals dbms_sql.varchar2_table;

2564: return TBL_OF_BAT_ENT_OBJ_TYPE
2565: IS
2566: l_counter number;
2567: l_pk1_vals dbms_sql.varchar2_table;
2568: l_pk2_vals dbms_sql.varchar2_table;
2569: l_pk3_vals dbms_sql.varchar2_table;
2570: l_pk4_vals dbms_sql.varchar2_table;
2571: l_pk5_vals dbms_sql.varchar2_table;
2572: l_batch_entities TBL_OF_BAT_ENT_OBJ_TYPE;

Line 2569: l_pk3_vals dbms_sql.varchar2_table;

2565: IS
2566: l_counter number;
2567: l_pk1_vals dbms_sql.varchar2_table;
2568: l_pk2_vals dbms_sql.varchar2_table;
2569: l_pk3_vals dbms_sql.varchar2_table;
2570: l_pk4_vals dbms_sql.varchar2_table;
2571: l_pk5_vals dbms_sql.varchar2_table;
2572: l_batch_entities TBL_OF_BAT_ENT_OBJ_TYPE;
2573: begin

Line 2570: l_pk4_vals dbms_sql.varchar2_table;

2566: l_counter number;
2567: l_pk1_vals dbms_sql.varchar2_table;
2568: l_pk2_vals dbms_sql.varchar2_table;
2569: l_pk3_vals dbms_sql.varchar2_table;
2570: l_pk4_vals dbms_sql.varchar2_table;
2571: l_pk5_vals dbms_sql.varchar2_table;
2572: l_batch_entities TBL_OF_BAT_ENT_OBJ_TYPE;
2573: begin
2574: -- build entities

Line 2571: l_pk5_vals dbms_sql.varchar2_table;

2567: l_pk1_vals dbms_sql.varchar2_table;
2568: l_pk2_vals dbms_sql.varchar2_table;
2569: l_pk3_vals dbms_sql.varchar2_table;
2570: l_pk4_vals dbms_sql.varchar2_table;
2571: l_pk5_vals dbms_sql.varchar2_table;
2572: l_batch_entities TBL_OF_BAT_ENT_OBJ_TYPE;
2573: begin
2574: -- build entities
2575: select PK1_VALUE, PK2_VALUE, PK3_VALUE, PK4_VALUE, PK5_VALUE

Line 2928: l_batch_entity_obj_ids dbms_sql.number_table;

2924: l_pub_params TBL_OF_BAT_PARAM_TYPE;
2925: l_target_systems TBL_OF_BAT_SYS_CODE_TYPE;
2926: l_counter number;
2927: l_batch_status varchar2(1) := C_STATUS_DRAFT; -- draft status
2928: l_batch_entity_obj_ids dbms_sql.number_table;
2929: l_pub_type varchar2(10);
2930: l_expl_date date;
2931:
2932: l_token EGO_UTIL_PK.token_tbl;

Line 3424: p_batch_names IN dbms_sql.varchar2_table,

3420: -- ICC: oracle.apps.ego.item.syncItemCatalogCategory
3421: -- AG: oracle.apps.ego.extfwk.syncAttributeGroup
3422: -- VS: oracle.apps.ego.extfwk.syncValueSet
3423: PROCEDURE publish_batch (p_api_version IN NUMBER,
3424: p_batch_names IN dbms_sql.varchar2_table,
3425: p_batch_ids IN dbms_sql.number_table,
3426: x_return_status OUT NOCOPY VARCHAR2,
3427: x_msg_count OUT NOCOPY NUMBER,
3428: x_msg_data OUT NOCOPY VARCHAR2

Line 3425: p_batch_ids IN dbms_sql.number_table,

3421: -- AG: oracle.apps.ego.extfwk.syncAttributeGroup
3422: -- VS: oracle.apps.ego.extfwk.syncValueSet
3423: PROCEDURE publish_batch (p_api_version IN NUMBER,
3424: p_batch_names IN dbms_sql.varchar2_table,
3425: p_batch_ids IN dbms_sql.number_table,
3426: x_return_status OUT NOCOPY VARCHAR2,
3427: x_msg_count OUT NOCOPY NUMBER,
3428: x_msg_data OUT NOCOPY VARCHAR2
3429: )

Line 3432: --l_batch_names dbms_sql.varchar2_table ;

3428: x_msg_data OUT NOCOPY VARCHAR2
3429: )
3430: IS
3431: l_module_name varchar2(50) := 'EGO_PUB_FWK_PK.publish_batch';
3432: --l_batch_names dbms_sql.varchar2_table ;
3433: --l_batch_ids dbms_sql.number_table ;
3434: l_batch_name varchar2(50);
3435: l_batch_id number;
3436: l_batch_type number;

Line 3433: --l_batch_ids dbms_sql.number_table ;

3429: )
3430: IS
3431: l_module_name varchar2(50) := 'EGO_PUB_FWK_PK.publish_batch';
3432: --l_batch_names dbms_sql.varchar2_table ;
3433: --l_batch_ids dbms_sql.number_table ;
3434: l_batch_name varchar2(50);
3435: l_batch_id number;
3436: l_batch_type number;
3437: l_batch_entities TBL_OF_BAT_ENT_OBJ_TYPE;

Line 3651: l_system_codes dbms_sql.varchar2_table;

3647: l_auto_release VARCHAR2(30);
3648: l_pub_params TBL_OF_BAT_PARAM_TYPE;
3649: l_batch_entities TBL_OF_BAT_ENT_OBJ_TYPE;
3650: l_target_systems TBL_OF_BAT_SYS_CODE_TYPE;
3651: l_system_codes dbms_sql.varchar2_table;
3652: l_param_types dbms_sql.number_table;
3653: l_param_names dbms_sql.varchar2_table;
3654: l_param_data_types dbms_sql.number_table;
3655: l_param_date_vals dbms_sql.date_table;

Line 3652: l_param_types dbms_sql.number_table;

3648: l_pub_params TBL_OF_BAT_PARAM_TYPE;
3649: l_batch_entities TBL_OF_BAT_ENT_OBJ_TYPE;
3650: l_target_systems TBL_OF_BAT_SYS_CODE_TYPE;
3651: l_system_codes dbms_sql.varchar2_table;
3652: l_param_types dbms_sql.number_table;
3653: l_param_names dbms_sql.varchar2_table;
3654: l_param_data_types dbms_sql.number_table;
3655: l_param_date_vals dbms_sql.date_table;
3656: l_param_char_vals dbms_sql.varchar2_table;

Line 3653: l_param_names dbms_sql.varchar2_table;

3649: l_batch_entities TBL_OF_BAT_ENT_OBJ_TYPE;
3650: l_target_systems TBL_OF_BAT_SYS_CODE_TYPE;
3651: l_system_codes dbms_sql.varchar2_table;
3652: l_param_types dbms_sql.number_table;
3653: l_param_names dbms_sql.varchar2_table;
3654: l_param_data_types dbms_sql.number_table;
3655: l_param_date_vals dbms_sql.date_table;
3656: l_param_char_vals dbms_sql.varchar2_table;
3657: l_param_num_vals dbms_sql.number_table;

Line 3654: l_param_data_types dbms_sql.number_table;

3650: l_target_systems TBL_OF_BAT_SYS_CODE_TYPE;
3651: l_system_codes dbms_sql.varchar2_table;
3652: l_param_types dbms_sql.number_table;
3653: l_param_names dbms_sql.varchar2_table;
3654: l_param_data_types dbms_sql.number_table;
3655: l_param_date_vals dbms_sql.date_table;
3656: l_param_char_vals dbms_sql.varchar2_table;
3657: l_param_num_vals dbms_sql.number_table;
3658: l_counter number;

Line 3655: l_param_date_vals dbms_sql.date_table;

3651: l_system_codes dbms_sql.varchar2_table;
3652: l_param_types dbms_sql.number_table;
3653: l_param_names dbms_sql.varchar2_table;
3654: l_param_data_types dbms_sql.number_table;
3655: l_param_date_vals dbms_sql.date_table;
3656: l_param_char_vals dbms_sql.varchar2_table;
3657: l_param_num_vals dbms_sql.number_table;
3658: l_counter number;
3659:

Line 3656: l_param_char_vals dbms_sql.varchar2_table;

3652: l_param_types dbms_sql.number_table;
3653: l_param_names dbms_sql.varchar2_table;
3654: l_param_data_types dbms_sql.number_table;
3655: l_param_date_vals dbms_sql.date_table;
3656: l_param_char_vals dbms_sql.varchar2_table;
3657: l_param_num_vals dbms_sql.number_table;
3658: l_counter number;
3659:
3660: l_token EGO_UTIL_PK.token_tbl;

Line 3657: l_param_num_vals dbms_sql.number_table;

3653: l_param_names dbms_sql.varchar2_table;
3654: l_param_data_types dbms_sql.number_table;
3655: l_param_date_vals dbms_sql.date_table;
3656: l_param_char_vals dbms_sql.varchar2_table;
3657: l_param_num_vals dbms_sql.number_table;
3658: l_counter number;
3659:
3660: l_token EGO_UTIL_PK.token_tbl;
3661: l_err_msg varchar2(2000) := null;

Line 3806: p_batch_names IN dbms_sql.varchar2_table,

3802: x_msg_data := l_err_msg;
3803: end copy_batch;
3804:
3805: PROCEDURE delete_batch (p_api_version IN NUMBER,
3806: p_batch_names IN dbms_sql.varchar2_table,
3807: p_batch_ids IN dbms_sql.number_table,
3808: p_purge_days IN NUMBER,
3809: x_con_req_id OUT NOCOPY NUMBER,
3810: x_return_status OUT NOCOPY VARCHAR2,

Line 3807: p_batch_ids IN dbms_sql.number_table,

3803: end copy_batch;
3804:
3805: PROCEDURE delete_batch (p_api_version IN NUMBER,
3806: p_batch_names IN dbms_sql.varchar2_table,
3807: p_batch_ids IN dbms_sql.number_table,
3808: p_purge_days IN NUMBER,
3809: x_con_req_id OUT NOCOPY NUMBER,
3810: x_return_status OUT NOCOPY VARCHAR2,
3811: x_msg_count OUT NOCOPY NUMBER,