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.IBE_MERGE_PVT dependencies on IBE_ORD_ONECLICK_ALL

Line 88: | Account merge procedure for the table, IBE_ORD_ONECLICK_ALL

84: |
85: | PROCEDURE
86: | acc_merge_oneclick
87: | DESCRIPTION :
88: | Account merge procedure for the table, IBE_ORD_ONECLICK_ALL
89: |
90: |
91: |--------------------------------------------------------------*/
92: procedure acc_merge_oneclick (

Line 103: IBE_ORD_ONECLICK_ALL.ORD_ONECLICK_ID%TYPE

99: INDEX BY BINARY_INTEGER;
100: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
101:
102: TYPE ORD_ONECLICK_ID_LIST_TYPE IS TABLE OF
103: IBE_ORD_ONECLICK_ALL.ORD_ONECLICK_ID%TYPE
104: INDEX BY BINARY_INTEGER;
105: PRIMARY_KEY_ID_LIST ORD_ONECLICK_ID_LIST_TYPE;
106:
107: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF

Line 108: IBE_ORD_ONECLICK_ALL.CUST_ACCOUNT_ID%TYPE

104: INDEX BY BINARY_INTEGER;
105: PRIMARY_KEY_ID_LIST ORD_ONECLICK_ID_LIST_TYPE;
106:
107: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF
108: IBE_ORD_ONECLICK_ALL.CUST_ACCOUNT_ID%TYPE
109: INDEX BY BINARY_INTEGER;
110: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
111: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
112:

Line 114: IBE_ORD_ONECLICK_ALL.PARTY_ID%TYPE

110: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
111: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
112:
113: TYPE PARTY_ID_LIST_TYPE IS TABLE OF
114: IBE_ORD_ONECLICK_ALL.PARTY_ID%TYPE
115: INDEX BY BINARY_INTEGER;
116: NUM_COL2_ORIG_LIST PARTY_ID_LIST_TYPE;
117: NUM_COL2_NEW_LIST PARTY_ID_LIST_TYPE;
118: l_acct_id number;

Line 120: l_ord_oneclick_id IBE_ORD_ONECLICK_ALL.ORD_ONECLICK_ID%TYPE;

116: NUM_COL2_ORIG_LIST PARTY_ID_LIST_TYPE;
117: NUM_COL2_NEW_LIST PARTY_ID_LIST_TYPE;
118: l_acct_id number;
119: l_profile_val VARCHAR2(30);
120: l_ord_oneclick_id IBE_ORD_ONECLICK_ALL.ORD_ONECLICK_ID%TYPE;
121:
122: --cursor to get party, account ID and primary key for shopping lists
123: CURSOR merged_records IS
124: SELECT distinct CUSTOMER_MERGE_HEADER_ID

Line 128: FROM IBE_ORD_ONECLICK_ALL yt, ra_customer_merges m

124: SELECT distinct CUSTOMER_MERGE_HEADER_ID
125: ,yt.ord_oneclick_id
126: ,yt.CUST_ACCOUNT_ID
127: ,yt.party_id
128: FROM IBE_ORD_ONECLICK_ALL yt, ra_customer_merges m
129: WHERE
130: yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID
131: AND m.process_flag = 'N'
132: AND m.request_id = req_id

Line 169: select HZ_CUSTOMER_MERGE_LOG_s.nextval,'IBE_ORD_ONECLICK_ALL',MERGE_HEADER_ID_LIST(I)

165: DEL_COL4,DEL_COL5,DEL_COL6,DEL_COL7,DEL_COL8,DEL_COL9,DEL_COL10,DEL_COL11,DEL_COL12,
166: DEL_COL13,DEL_COL14,DEL_COL15,DEL_COL16,DEL_COL17,DEL_COL18,DEL_COL19,DEL_COL20,DEL_COL21,
167: DEL_COL22,DEL_COL23,DEL_COL24,DEL_COL25,DEL_COL26,DEL_COL27,DEL_COL28,DEL_COL29,DEL_COL30,
168: DEL_COL31,DEL_COL32,DEL_COL33,DEL_COL34,DEL_COL35,ACTION_FLAG,CREATED_BY,CREATION_DATE,LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,LAST_UPDATED_BY)
169: select HZ_CUSTOMER_MERGE_LOG_s.nextval,'IBE_ORD_ONECLICK_ALL',MERGE_HEADER_ID_LIST(I)
170: ,req_id,ORD_ONECLICK_ID,OBJECT_VERSION_NUMBER, CUST_ACCOUNT_ID, PARTY_ID, CREATED_BY, CREATION_DATE,
171: LAST_UPDATED_BY,LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, ENABLED_FLAG, FREIGHT_CODE, PAYMENT_ID,
172: BILL_TO_PTY_SITE_ID, SHIP_TO_PTY_SITE_ID,ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3,
173: ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11,

Line 178: from IBE_ORD_ONECLICK_ALL where ORD_ONECLICK_ID=PRIMARY_KEY_ID_LIST(I);

174: ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, SECURITY_GROUP_ID, REQUEST_ID, PROGRAM_ID,
175: PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE, ORG_ID, 'D',hz_utility_pub.CREATED_BY,
176: hz_utility_pub.CREATION_DATE, hz_utility_pub.LAST_UPDATE_LOGIN, hz_utility_pub.LAST_UPDATE_DATE,
177: hz_utility_pub.LAST_UPDATED_BY
178: from IBE_ORD_ONECLICK_ALL where ORD_ONECLICK_ID=PRIMARY_KEY_ID_LIST(I);
179: end if;
180: delete IBE_ORD_ONECLICK_ALL
181: where ORD_ONECLICK_ID=PRIMARY_KEY_ID_LIST(I);
182:

Line 180: delete IBE_ORD_ONECLICK_ALL

176: hz_utility_pub.CREATION_DATE, hz_utility_pub.LAST_UPDATE_LOGIN, hz_utility_pub.LAST_UPDATE_DATE,
177: hz_utility_pub.LAST_UPDATED_BY
178: from IBE_ORD_ONECLICK_ALL where ORD_ONECLICK_ID=PRIMARY_KEY_ID_LIST(I);
179: end if;
180: delete IBE_ORD_ONECLICK_ALL
181: where ORD_ONECLICK_ID=PRIMARY_KEY_ID_LIST(I);
182:
183: END LOOP;
184: --fix 2899235: do not transfer exp chkout setting

Line 796: IBE_Util.Debug('IBE_MERGE_PVT.CUSTOMER_MERGE - updating IBE_ORD_ONECLICK_ALL table');

792: g_count := sql%rowcount;
793: arp_message.set_name('AR','AR_ROWS_UPDATED');
794: arp_message.set_token('NUM_ROWS',to_char(g_count));
795:
796: IBE_Util.Debug('IBE_MERGE_PVT.CUSTOMER_MERGE - updating IBE_ORD_ONECLICK_ALL table');
797: /* 4/8/02
798: If oneclick table already has entry for the merge to account, ignore and do nothing
799: */
800: acc_merge_oneclick(request_id,set_number,process_mode);

Line 802: arp_message.set_token('TABLE_NAME','IBE_ORD_ONECLICK_ALL',FALSE);

798: If oneclick table already has entry for the merge to account, ignore and do nothing
799: */
800: acc_merge_oneclick(request_id,set_number,process_mode);
801: arp_message.set_name('AR','AR_UPDATING_TABLE');
802: arp_message.set_token('TABLE_NAME','IBE_ORD_ONECLICK_ALL',FALSE);
803: g_count := sql%rowcount;
804:
805:
806: /* account merge for shared quote

Line 995: | IBE_ORD_ONECLICK_ALL table and will be called from party |

991: | When in ERP Parties are merged the |
992: | The Foriegn keys to party_id and other columns |
993: | should also be updated in iStore tables. |
994: | This procedure will update |
995: | IBE_ORD_ONECLICK_ALL table and will be called from party |
996: | Merge concurrent program. |
997: | DESCRIPTION |
998: | |
999: | REQUIRES |

Line 1027: IBE_ORD_ONECLICK_ALL

1023: IS
1024:
1025: Cursor C1 is
1026: Select 'X' from
1027: IBE_ORD_ONECLICK_ALL
1028: where party_id = p_from_fk_id
1029: for update nowait;
1030:
1031: Cursor C2 is

Line 1033: IBE_ORD_ONECLICK_ALL

1029: for update nowait;
1030:
1031: Cursor C2 is
1032: Select 'X' from
1033: IBE_ORD_ONECLICK_ALL
1034: Where bill_to_pty_site_id = p_from_fk_id
1035: Or ship_to_pty_site_id = p_from_fk_id
1036: for update nowait;
1037:

Line 1038: l_ord_oneclick_id IBE_ORD_ONECLICK_ALL.ORD_ONECLICK_ID%TYPE;

1034: Where bill_to_pty_site_id = p_from_fk_id
1035: Or ship_to_pty_site_id = p_from_fk_id
1036: for update nowait;
1037:
1038: l_ord_oneclick_id IBE_ORD_ONECLICK_ALL.ORD_ONECLICK_ID%TYPE;
1039: l_merge_reason_code VARCHAR2(30);
1040: l_count NUMBER(10) := 0;
1041: RESOURCE_BUSY EXCEPTION;
1042: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);

Line 1097: delete IBE_ORD_ONECLICK_ALL

1093:
1094: if p_parent_entity_name = 'HZ_PARTIES' Then
1095:
1096: --fix 2899235: delete only, don't change
1097: delete IBE_ORD_ONECLICK_ALL
1098: where party_id = p_from_fk_id;
1099:
1100:
1101: /* Begin

Line 1104: from ibe_ord_oneclick_all

1100:
1101: /* Begin
1102: select ord_oneclick_id
1103: into l_ord_oneclick_id
1104: from ibe_ord_oneclick_all
1105: where party_id = p_to_fk_id
1106: and rownum = 1;
1107: exception
1108:

Line 1118: arp_message.set_token('TABLE_NAME', 'IBE_ORD_ONECLICK_ALL', FALSE);

1114:
1115: -- Lock the table and update the record(s).
1116:
1117: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1118: arp_message.set_token('TABLE_NAME', 'IBE_ORD_ONECLICK_ALL', FALSE);
1119:
1120: Open C1;
1121: Close C1;
1122:

Line 1124: arp_message.set_token('TABLE_NAME', 'IBE_ORD_ONECLICK_ALL', FALSE);

1120: Open C1;
1121: Close C1;
1122:
1123: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
1124: arp_message.set_token('TABLE_NAME', 'IBE_ORD_ONECLICK_ALL', FALSE);
1125:
1126:
1127: -- 4/8/02
1128: -- If updating party_id results in uniqueness violation, means oneclick already has

Line 1132: UPDATE IBE_ORD_ONECLICK_ALL SET

1128: -- If updating party_id results in uniqueness violation, means oneclick already has
1129: -- setting for express checkout, do nothing.
1130:
1131: BEGIN
1132: UPDATE IBE_ORD_ONECLICK_ALL SET
1133: party_id = p_to_fk_id,
1134: last_update_date = hz_utility_pub.last_update_date,
1135: last_updated_by = hz_utility_pub.user_id,
1136: last_update_login = hz_utility_pub.last_update_login

Line 1150: delete IBE_ORD_ONECLICK_ALL

1146: Return;
1147:
1148: Else
1149: --fix 2781213
1150: delete IBE_ORD_ONECLICK_ALL
1151: where party_id = p_from_fk_id;
1152:
1153: return;
1154:

Line 1163: arp_message.set_token('TABLE_NAME', 'IBE_ORD_ONECLICK_ALL', FALSE);

1159:
1160: -- Lock the table and update the record(s).
1161:
1162: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1163: arp_message.set_token('TABLE_NAME', 'IBE_ORD_ONECLICK_ALL', FALSE);
1164:
1165: Open C1;
1166: Close C1;
1167:

Line 1169: arp_message.set_token('TABLE_NAME', 'IBE_ORD_ONECLICK_ALL', FALSE);

1165: Open C1;
1166: Close C1;
1167:
1168: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
1169: arp_message.set_token('TABLE_NAME', 'IBE_ORD_ONECLICK_ALL', FALSE);
1170:
1171: UPDATE IBE_ORD_ONECLICK_ALL SET
1172: bill_to_pty_site_id = decode(bill_to_pty_site_id,p_from_fk_id,p_to_fk_id,bill_to_pty_site_id),
1173: ship_to_pty_site_id = decode(ship_to_pty_site_id,p_from_fk_id,p_to_fk_id,ship_to_pty_site_id),

Line 1171: UPDATE IBE_ORD_ONECLICK_ALL SET

1167:
1168: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
1169: arp_message.set_token('TABLE_NAME', 'IBE_ORD_ONECLICK_ALL', FALSE);
1170:
1171: UPDATE IBE_ORD_ONECLICK_ALL SET
1172: bill_to_pty_site_id = decode(bill_to_pty_site_id,p_from_fk_id,p_to_fk_id,bill_to_pty_site_id),
1173: ship_to_pty_site_id = decode(ship_to_pty_site_id,p_from_fk_id,p_to_fk_id,ship_to_pty_site_id),
1174: last_update_date = hz_utility_pub.last_update_date,
1175: last_updated_by = hz_utility_pub.user_id,

Line 1196: 'on table IBE_ORD_ONECLICK_ALL');

1192: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_ONECLICK()-');
1193: Exception
1194: When RESOURCE_BUSY Then
1195: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK; Could not obtain lock'||
1196: 'on table IBE_ORD_ONECLICK_ALL');
1197: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_ONECLICK; Could not obtain lock'||
1198: 'on table IBE_ORD_ONECLICK_ALL');
1199: x_return_status := FND_API.G_RET_STS_ERROR;
1200: raise;

Line 1198: 'on table IBE_ORD_ONECLICK_ALL');

1194: When RESOURCE_BUSY Then
1195: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK; Could not obtain lock'||
1196: 'on table IBE_ORD_ONECLICK_ALL');
1197: IBE_UTIL.debug('IBE_MERGE_PVT.MERGE_ONECLICK; Could not obtain lock'||
1198: 'on table IBE_ORD_ONECLICK_ALL');
1199: x_return_status := FND_API.G_RET_STS_ERROR;
1200: raise;
1201: When Others Then
1202: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK'||sqlerrm);