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 103: | Account merge procedure for the table, IBE_ORD_ONECLICK_ALL

99: |
100: | PROCEDURE
101: | acc_merge_oneclick
102: | DESCRIPTION :
103: | Account merge procedure for the table, IBE_ORD_ONECLICK_ALL
104: |
105: |
106: |--------------------------------------------------------------*/
107: procedure acc_merge_oneclick (

Line 118: IBE_ORD_ONECLICK_ALL.ORD_ONECLICK_ID%TYPE

114: INDEX BY BINARY_INTEGER;
115: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
116:
117: TYPE ORD_ONECLICK_ID_LIST_TYPE IS TABLE OF
118: IBE_ORD_ONECLICK_ALL.ORD_ONECLICK_ID%TYPE
119: INDEX BY BINARY_INTEGER;
120: PRIMARY_KEY_ID_LIST ORD_ONECLICK_ID_LIST_TYPE;
121:
122: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF

Line 123: IBE_ORD_ONECLICK_ALL.CUST_ACCOUNT_ID%TYPE

119: INDEX BY BINARY_INTEGER;
120: PRIMARY_KEY_ID_LIST ORD_ONECLICK_ID_LIST_TYPE;
121:
122: TYPE CUST_ACCOUNT_ID_LIST_TYPE IS TABLE OF
123: IBE_ORD_ONECLICK_ALL.CUST_ACCOUNT_ID%TYPE
124: INDEX BY BINARY_INTEGER;
125: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
126: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
127:

Line 129: IBE_ORD_ONECLICK_ALL.PARTY_ID%TYPE

125: NUM_COL1_ORIG_LIST CUST_ACCOUNT_ID_LIST_TYPE;
126: NUM_COL1_NEW_LIST CUST_ACCOUNT_ID_LIST_TYPE;
127:
128: TYPE PARTY_ID_LIST_TYPE IS TABLE OF
129: IBE_ORD_ONECLICK_ALL.PARTY_ID%TYPE
130: INDEX BY BINARY_INTEGER;
131: NUM_COL2_ORIG_LIST PARTY_ID_LIST_TYPE;
132: NUM_COL2_NEW_LIST PARTY_ID_LIST_TYPE;
133: l_acct_id number;

Line 135: l_ord_oneclick_id IBE_ORD_ONECLICK_ALL.ORD_ONECLICK_ID%TYPE;

131: NUM_COL2_ORIG_LIST PARTY_ID_LIST_TYPE;
132: NUM_COL2_NEW_LIST PARTY_ID_LIST_TYPE;
133: l_acct_id number;
134: l_profile_val VARCHAR2(30);
135: l_ord_oneclick_id IBE_ORD_ONECLICK_ALL.ORD_ONECLICK_ID%TYPE;
136:
137: --cursor to get party, account ID and primary key for shopping lists
138: CURSOR merged_records IS
139: SELECT distinct CUSTOMER_MERGE_HEADER_ID

Line 143: FROM IBE_ORD_ONECLICK_ALL yt, ra_customer_merges m

139: SELECT distinct CUSTOMER_MERGE_HEADER_ID
140: ,yt.ord_oneclick_id
141: ,yt.CUST_ACCOUNT_ID
142: ,yt.party_id
143: FROM IBE_ORD_ONECLICK_ALL yt, ra_customer_merges m
144: WHERE
145: yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID
146: AND m.process_flag = 'N'
147: AND m.request_id = req_id

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

180: DEL_COL4,DEL_COL5,DEL_COL6,DEL_COL7,DEL_COL8,DEL_COL9,DEL_COL10,DEL_COL11,DEL_COL12,
181: DEL_COL13,DEL_COL14,DEL_COL15,DEL_COL16,DEL_COL17,DEL_COL18,DEL_COL19,DEL_COL20,DEL_COL21,
182: DEL_COL22,DEL_COL23,DEL_COL24,DEL_COL25,DEL_COL26,DEL_COL27,DEL_COL28,DEL_COL29,DEL_COL30,
183: 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)
184: select HZ_CUSTOMER_MERGE_LOG_s.nextval,'IBE_ORD_ONECLICK_ALL',MERGE_HEADER_ID_LIST(I)
185: ,req_id,ORD_ONECLICK_ID,OBJECT_VERSION_NUMBER, CUST_ACCOUNT_ID, PARTY_ID, CREATED_BY, CREATION_DATE,
186: LAST_UPDATED_BY,LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, ENABLED_FLAG, FREIGHT_CODE, PAYMENT_ID,
187: BILL_TO_PTY_SITE_ID, SHIP_TO_PTY_SITE_ID,ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3,
188: ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11,

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

189: ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, SECURITY_GROUP_ID, REQUEST_ID, PROGRAM_ID,
190: PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE, ORG_ID, 'D',hz_utility_pub.CREATED_BY,
191: hz_utility_pub.CREATION_DATE, hz_utility_pub.LAST_UPDATE_LOGIN, hz_utility_pub.LAST_UPDATE_DATE,
192: hz_utility_pub.LAST_UPDATED_BY
193: from IBE_ORD_ONECLICK_ALL where ORD_ONECLICK_ID=PRIMARY_KEY_ID_LIST(I);
194: end if;
195: delete IBE_ORD_ONECLICK_ALL
196: where ORD_ONECLICK_ID=PRIMARY_KEY_ID_LIST(I);
197:

Line 195: delete IBE_ORD_ONECLICK_ALL

191: hz_utility_pub.CREATION_DATE, hz_utility_pub.LAST_UPDATE_LOGIN, hz_utility_pub.LAST_UPDATE_DATE,
192: hz_utility_pub.LAST_UPDATED_BY
193: from IBE_ORD_ONECLICK_ALL where ORD_ONECLICK_ID=PRIMARY_KEY_ID_LIST(I);
194: end if;
195: delete IBE_ORD_ONECLICK_ALL
196: where ORD_ONECLICK_ID=PRIMARY_KEY_ID_LIST(I);
197:
198: END LOOP;
199: --fix 2899235: do not transfer exp chkout setting

Line 755: SELECT 'X' from IBE_ORD_ONECLICK_ALL IOO

751: AND RACM.SET_NUMBER = set_number)
752: FOR UPDATE NOWAIT;
753:
754: CURSOR C1 is
755: SELECT 'X' from IBE_ORD_ONECLICK_ALL IOO
756: WHERE IOO.CUST_ACCOUNT_ID IN (SELECT RACM.DUPLICATE_ID
757: FROM RA_CUSTOMER_MERGES RACM
758: WHERE RACM.PROCESS_FLAG='N'
759: AND RACM.REQUEST_ID = request_id

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

820: open C;
821: close C;
822:
823: arp_message.set_name('AR','AR_LOCKING_TABLE');
824: arp_message.set_token('TABLE_NAME','IBE_ORD_ONECLICK_ALL',FALSE);
825:
826: open C1;
827: close C1;
828:

Line 847: /* For updating IBE_ORD_ONECLICK_ALL Table */

843: g_count := sql%rowcount;
844: arp_message.set_name('AR','AR_ROWS_UPDATED');
845: arp_message.set_token('NUM_ROWS',to_char(g_count));
846:
847: /* For updating IBE_ORD_ONECLICK_ALL Table */
848: /* 4/8/02
849: If oneclick table already has entry for the merge to account, ignore and do nothing
850: */
851: acc_merge_oneclick(request_id,set_number,process_mode);

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

849: If oneclick table already has entry for the merge to account, ignore and do nothing
850: */
851: acc_merge_oneclick(request_id,set_number,process_mode);
852: arp_message.set_name('AR','AR_UPDATING_TABLE');
853: arp_message.set_token('TABLE_NAME','IBE_ORD_ONECLICK_ALL',FALSE);
854: g_count := sql%rowcount;
855:
856:
857: /* account merge for shared quote

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

1037: | When in ERP Parties are merged the |
1038: | The Foriegn keys to party_id and other columns |
1039: | should also be updated in iStore tables. |
1040: | This procedure will update |
1041: | IBE_ORD_ONECLICK_ALL table and will be called from party |
1042: | Merge concurrent program. |
1043: | DESCRIPTION |
1044: | |
1045: | REQUIRES |

Line 1073: IBE_ORD_ONECLICK_ALL

1069: IS
1070:
1071: Cursor C1 is
1072: Select 'X' from
1073: IBE_ORD_ONECLICK_ALL
1074: where party_id = p_from_fk_id
1075: for update nowait;
1076:
1077: Cursor C2 is

Line 1079: IBE_ORD_ONECLICK_ALL

1075: for update nowait;
1076:
1077: Cursor C2 is
1078: Select 'X' from
1079: IBE_ORD_ONECLICK_ALL
1080: Where bill_to_pty_site_id = p_from_fk_id
1081: Or ship_to_pty_site_id = p_from_fk_id
1082: for update nowait;
1083:

Line 1084: l_ord_oneclick_id IBE_ORD_ONECLICK_ALL.ORD_ONECLICK_ID%TYPE;

1080: Where bill_to_pty_site_id = p_from_fk_id
1081: Or ship_to_pty_site_id = p_from_fk_id
1082: for update nowait;
1083:
1084: l_ord_oneclick_id IBE_ORD_ONECLICK_ALL.ORD_ONECLICK_ID%TYPE;
1085: l_merge_reason_code VARCHAR2(30);
1086: l_count NUMBER(10) := 0;
1087: RESOURCE_BUSY EXCEPTION;
1088: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);

Line 1142: delete IBE_ORD_ONECLICK_ALL

1138:
1139: if p_parent_entity_name = 'HZ_PARTIES' Then
1140:
1141: --fix 2899235: delete only, don't change
1142: delete IBE_ORD_ONECLICK_ALL
1143: where party_id = p_from_fk_id;
1144:
1145:
1146: /* Begin

Line 1149: from ibe_ord_oneclick_all

1145:
1146: /* Begin
1147: select ord_oneclick_id
1148: into l_ord_oneclick_id
1149: from ibe_ord_oneclick_all
1150: where party_id = p_to_fk_id
1151: and rownum = 1;
1152: exception
1153:

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:
1172: -- 4/8/02
1173: -- If updating party_id results in uniqueness violation, means oneclick already has

Line 1177: UPDATE IBE_ORD_ONECLICK_ALL SET

1173: -- If updating party_id results in uniqueness violation, means oneclick already has
1174: -- setting for express checkout, do nothing.
1175:
1176: BEGIN
1177: UPDATE IBE_ORD_ONECLICK_ALL SET
1178: party_id = p_to_fk_id,
1179: last_update_date = hz_utility_pub.last_update_date,
1180: last_updated_by = hz_utility_pub.user_id,
1181: last_update_login = hz_utility_pub.last_update_login

Line 1195: delete IBE_ORD_ONECLICK_ALL

1191: Return;
1192:
1193: Else
1194: --fix 2781213
1195: delete IBE_ORD_ONECLICK_ALL
1196: where party_id = p_from_fk_id;
1197:
1198: return;
1199:

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

1204:
1205: -- Lock the table and update the record(s).
1206:
1207: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
1208: arp_message.set_token('TABLE_NAME', 'IBE_ORD_ONECLICK_ALL', FALSE);
1209:
1210: Open C1;
1211: Close C1;
1212:

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

1210: Open C1;
1211: Close C1;
1212:
1213: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
1214: arp_message.set_token('TABLE_NAME', 'IBE_ORD_ONECLICK_ALL', FALSE);
1215:
1216: UPDATE IBE_ORD_ONECLICK_ALL SET
1217: bill_to_pty_site_id = decode(bill_to_pty_site_id,p_from_fk_id,p_to_fk_id,bill_to_pty_site_id),
1218: 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 1216: UPDATE IBE_ORD_ONECLICK_ALL SET

1212:
1213: arp_message.set_name('AR', 'AR_UPDATING_TABLE');
1214: arp_message.set_token('TABLE_NAME', 'IBE_ORD_ONECLICK_ALL', FALSE);
1215:
1216: UPDATE IBE_ORD_ONECLICK_ALL SET
1217: bill_to_pty_site_id = decode(bill_to_pty_site_id,p_from_fk_id,p_to_fk_id,bill_to_pty_site_id),
1218: ship_to_pty_site_id = decode(ship_to_pty_site_id,p_from_fk_id,p_to_fk_id,ship_to_pty_site_id),
1219: last_update_date = hz_utility_pub.last_update_date,
1220: last_updated_by = hz_utility_pub.user_id,

Line 1241: 'on table IBE_ORD_ONECLICK_ALL');

1237:
1238: Exception
1239: When RESOURCE_BUSY Then
1240: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK; Could not obtain lock'||
1241: 'on table IBE_ORD_ONECLICK_ALL');
1242: x_return_status := FND_API.G_RET_STS_ERROR;
1243: raise;
1244: When Others Then
1245: arp_message.set_line('IBE_MERGE_PVT.MERGE_ONECLICK'||sqlerrm);