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.POS_BULKLOAD_ENTITIES dependencies on POS_SUPP_PROF_EXT_INTF

Line 887: INSERT INTO POS_SUPP_PROF_EXT_INTF

883: --Bug 16384042 Here also need to use DataLevel from outer cursor
884: -- Here we call Resolve_PK_VALUES to get PK for party site and Supplier Site level
885: IF c_attr_grp_rec.data_level_id = G_POS_SUPP_LEVEL_ID THEN
886: --IF p_entity_name = 'SUPP' THEN
887: INSERT INTO POS_SUPP_PROF_EXT_INTF
888: (
889: DATA_SET_ID ,
890: TRANSACTION_ID ,
891: PARTY_ID ,

Line 926: INSERT INTO POS_SUPP_PROF_EXT_INTF

922: -- Write_conclog('PK1_VALUE: '||l_usr_attr_data_tbl(i).PK2_ID);
923: ELSIF c_attr_grp_rec.data_level_id = G_POS_SUPP_ADDR_LEVEL_ID THEN
924: Write_Conclog('Before Inserting into Ext intf for Party Site level');
925:
926: INSERT INTO POS_SUPP_PROF_EXT_INTF
927: (
928: DATA_SET_ID ,
929: TRANSACTION_ID ,
930: PARTY_ID ,

Line 964: INSERT INTO POS_SUPP_PROF_EXT_INTF

960: ELSIF c_attr_grp_rec.data_level_id = G_POS_SUPP_ADDR_SITE_LEVEL_ID THEN
961:
962: Write_Conclog('Before Insreting into Ext Intf for Supplier Site level' );
963:
964: INSERT INTO POS_SUPP_PROF_EXT_INTF
965: (
966: DATA_SET_ID ,
967: TRANSACTION_ID ,
968: PARTY_ID ,

Line 1019: --processing of Site Attributes from POS_SUPP_PROF_EXT_INTF

1015: Write_Conclog('Error while processing Load User Attributes data API '||SQLCODE || ':'||SQLERRM);
1016: END LOAD_USERATTR_INTF;
1017: -----------------------end of load_userattr_intf---------------------------
1018: -------------------------------------------------------------------------------
1019: --processing of Site Attributes from POS_SUPP_PROF_EXT_INTF
1020: --------------------------------------------------------------------------------
1021: PROCEDURE PROCESS_USER_ATTRS_DATA(
1022: ERRBUF OUT NOCOPY VARCHAR2
1023: ,RETCODE OUT NOCOPY VARCHAR2

Line 1035: CURSOR c_pos_supp_prof_ext_intf is

1031: l_msg_count NUMBER;
1032: l_msg_data VARCHAR2(1000);
1033: l_rel_sql VARCHAR2(100);
1034: l_cnt NUMBER := 0;
1035: CURSOR c_pos_supp_prof_ext_intf is
1036: select count(*) from POS_SUPP_PROF_EXT_INTF
1037: WHERE PROCESS_STATUS = G_PS_TO_BE_PROCESSED
1038: AND DATA_SET_ID = p_data_set_id;
1039: BEGIN

Line 1036: select count(*) from POS_SUPP_PROF_EXT_INTF

1032: l_msg_data VARCHAR2(1000);
1033: l_rel_sql VARCHAR2(100);
1034: l_cnt NUMBER := 0;
1035: CURSOR c_pos_supp_prof_ext_intf is
1036: select count(*) from POS_SUPP_PROF_EXT_INTF
1037: WHERE PROCESS_STATUS = G_PS_TO_BE_PROCESSED
1038: AND DATA_SET_ID = p_data_set_id;
1039: BEGIN
1040:

Line 1050: Open c_pos_supp_prof_ext_intf;

1046: l_debug_level := 0; --Since Debug log is not opened, donot open Debug log for User-Attrs also.
1047: END IF;
1048:
1049: l_user_attrs_return_status := FND_API.G_RET_STS_SUCCESS;
1050: Open c_pos_supp_prof_ext_intf;
1051: fetch c_pos_supp_prof_ext_intf into l_cnt;
1052: Close c_pos_supp_prof_ext_intf;
1053: IF l_cnt > 0 THEN
1054: UPDATE POS_SUPP_PROF_EXT_INTF

Line 1051: fetch c_pos_supp_prof_ext_intf into l_cnt;

1047: END IF;
1048:
1049: l_user_attrs_return_status := FND_API.G_RET_STS_SUCCESS;
1050: Open c_pos_supp_prof_ext_intf;
1051: fetch c_pos_supp_prof_ext_intf into l_cnt;
1052: Close c_pos_supp_prof_ext_intf;
1053: IF l_cnt > 0 THEN
1054: UPDATE POS_SUPP_PROF_EXT_INTF
1055: SET PROCESS_STATUS = G_PS_IN_PROCESS

Line 1052: Close c_pos_supp_prof_ext_intf;

1048:
1049: l_user_attrs_return_status := FND_API.G_RET_STS_SUCCESS;
1050: Open c_pos_supp_prof_ext_intf;
1051: fetch c_pos_supp_prof_ext_intf into l_cnt;
1052: Close c_pos_supp_prof_ext_intf;
1053: IF l_cnt > 0 THEN
1054: UPDATE POS_SUPP_PROF_EXT_INTF
1055: SET PROCESS_STATUS = G_PS_IN_PROCESS
1056: ,REQUEST_ID = G_REQUEST_ID

Line 1054: UPDATE POS_SUPP_PROF_EXT_INTF

1050: Open c_pos_supp_prof_ext_intf;
1051: fetch c_pos_supp_prof_ext_intf into l_cnt;
1052: Close c_pos_supp_prof_ext_intf;
1053: IF l_cnt > 0 THEN
1054: UPDATE POS_SUPP_PROF_EXT_INTF
1055: SET PROCESS_STATUS = G_PS_IN_PROCESS
1056: ,REQUEST_ID = G_REQUEST_ID
1057: ,PROGRAM_APPLICATION_ID = G_PROGAM_APPLICATION_ID
1058: ,PROGRAM_ID = G_PROGAM_ID

Line 1078: fnd_stats.gather_table_stats('POS','POS_SUPP_PROF_EXT_INTF',cascade=>true,percent=>30);

1074:
1075: -- Bug 12747017 Adding gather stats to improve performance, only doing it when volume are large. Ref Implementation:RRSIMINB.pls
1076: IF l_cnt > 1000 THEN --hard-code threshold value 1000 here may need to use profile option in future
1077: Write_Conclog('Before Gathering Stats... l_cnt = '||l_cnt);
1078: fnd_stats.gather_table_stats('POS','POS_SUPP_PROF_EXT_INTF',cascade=>true,percent=>30);
1079: fnd_stats.gather_table_stats('POS','POS_SUPP_PROF_EXT_B',cascade=>true,percent=>30);
1080: fnd_stats.gather_table_stats('POS','POS_SUPP_PROF_EXT_TL',cascade=>true,percent=>30);
1081: Write_Conclog('Done Gathering Stats....');
1082: END IF;

Line 1092: ,p_interface_table_name => 'POS_SUPP_PROF_EXT_INTF' --IN VARCHAR2

1088: ,p_application_id => 177 --IN NUMBER
1089: ,p_attr_group_type => 'POS_SUPP_PROFMGMT_GROUP' --IN VARCHAR2
1090: ,p_object_name => 'HZ_PARTIES' --IN VARCHAR2
1091: ,p_hz_party_id => G_HZ_PARTY_ID
1092: ,p_interface_table_name => 'POS_SUPP_PROF_EXT_INTF' --IN VARCHAR2
1093: ,p_data_set_id => p_data_set_id --IN NUMBER
1094: ,p_entity_id => 0 --G_ENTITY_ID --IN NUMBER
1095: ,p_entity_index => 0 --l_entity_index_counter --IN NUMBER
1096: ,p_entity_code => 'HZ_PARTIES' --IN VARCHAR2

Line 1135: DELETE FROM POS_SUPP_PROF_EXT_INTF

1131: -----------------------------------------------
1132: -- Delete all successful rows from the table --
1133: -- (they're the only rows still in process) --
1134: -----------------------------------------------
1135: DELETE FROM POS_SUPP_PROF_EXT_INTF
1136: WHERE DATA_SET_ID = p_data_set_id
1137: AND PROCESS_STATUS = G_PS_IN_PROCESS;
1138: ELSE
1139: ----------------------------------------------

Line 1143: UPDATE POS_SUPP_PROF_EXT_INTF

1139: ----------------------------------------------
1140: -- Mark all rows we've processed as success --
1141: -- if they weren't marked as failure above --
1142: ----------------------------------------------
1143: UPDATE POS_SUPP_PROF_EXT_INTF
1144: SET PROCESS_STATUS = G_PS_SUCCESS
1145: WHERE DATA_SET_ID = p_data_set_id
1146: AND PROCESS_STATUS = G_PS_IN_PROCESS;
1147: END IF; -- p_purge_successful_lines

Line 1180: Open c_pos_supp_prof_ext_intf;

1176: ----------------------------------------
1177: -- Mark all rows in process as errors --
1178: ----------------------------------------
1179: l_cnt := 0;
1180: Open c_pos_supp_prof_ext_intf;
1181: fetch c_pos_supp_prof_ext_intf into l_cnt;
1182: Close c_pos_supp_prof_ext_intf;
1183: IF l_cnt > 0 THEN
1184: UPDATE POS_SUPP_PROF_EXT_INTF

Line 1181: fetch c_pos_supp_prof_ext_intf into l_cnt;

1177: -- Mark all rows in process as errors --
1178: ----------------------------------------
1179: l_cnt := 0;
1180: Open c_pos_supp_prof_ext_intf;
1181: fetch c_pos_supp_prof_ext_intf into l_cnt;
1182: Close c_pos_supp_prof_ext_intf;
1183: IF l_cnt > 0 THEN
1184: UPDATE POS_SUPP_PROF_EXT_INTF
1185: SET PROCESS_STATUS = G_PS_GENERIC_ERROR

Line 1182: Close c_pos_supp_prof_ext_intf;

1178: ----------------------------------------
1179: l_cnt := 0;
1180: Open c_pos_supp_prof_ext_intf;
1181: fetch c_pos_supp_prof_ext_intf into l_cnt;
1182: Close c_pos_supp_prof_ext_intf;
1183: IF l_cnt > 0 THEN
1184: UPDATE POS_SUPP_PROF_EXT_INTF
1185: SET PROCESS_STATUS = G_PS_GENERIC_ERROR
1186: WHERE DATA_SET_ID = p_data_set_id

Line 1184: UPDATE POS_SUPP_PROF_EXT_INTF

1180: Open c_pos_supp_prof_ext_intf;
1181: fetch c_pos_supp_prof_ext_intf into l_cnt;
1182: Close c_pos_supp_prof_ext_intf;
1183: IF l_cnt > 0 THEN
1184: UPDATE POS_SUPP_PROF_EXT_INTF
1185: SET PROCESS_STATUS = G_PS_GENERIC_ERROR
1186: WHERE DATA_SET_ID = p_data_set_id
1187: AND PROCESS_STATUS = G_PS_IN_PROCESS;
1188: END IF;