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.AS_IMPORT_SL_PVT dependencies on AS_IMPORT_INTERFACE

Line 6: cursor imptype is select * from as_import_interface;

2: /* $Header: asxslimb.pls 120.10.12020000.3 2013/05/21 08:34:58 snsarava ship $ */
3:
4: --impView as_imp_sl_v%rowtype;
5: --subtype leadImpView is impView%Type;
6: cursor imptype is select * from as_import_interface;
7: subtype leadImpType is impType%rowtype;
8:
9: cursor cptype is select * from as_imp_cnt_pnt_interface;
10: subtype cntPntType is cptype%rowtype;

Line 154: -- Updates the as_import_interface table

150:
151: --------------------------------------------------------
152: -- name: writeBak
153: -- scope: private
154: -- Updates the as_import_interface table
155: --------------------------------------------------------
156: procedure writeBak(
157: pI IN leadImpType,
158: G_return_status OUT NOCOPY varchar2)

Line 162: update as_import_interface

158: G_return_status OUT NOCOPY varchar2)
159: IS
160: BEGIN
161: if (pI.load_status = G_LOAD_STATUS_SUCC) then
162: update as_import_interface
163: set load_status = G_LOAD_STATUS_SUCC,
164: party_id = pI.party_id,
165: party_site_id = pI.party_site_id,
166: location_id = pI.location_id,

Line 193: update as_import_interface

189: assign_to_person_id = pI.assign_to_person_id
190: where import_interface_id = pI.import_interface_id;
191: --where rowid = pI.rowid;
192: elsif (pI.load_status = G_LOAD_STATUS_ERR) then
193: update as_import_interface
194: set load_status = G_LOAD_STATUS_ERR,
195: -- ffang 101001, bug 2044483, if error, don't update those ids/flags
196: -- party_id = pI.party_id,
197: -- party_site_id = pI.party_site_id,

Line 216: update as_import_interface

212: program_update_date = sysdate
213: where import_interface_id = pI.import_interface_id;
214: --where rowid = pI.rowid;
215: elsif (pI.load_status = G_LOAD_STATUS_UNEXP_ERR) then
216: update as_import_interface
217: set load_status = G_LOAD_STATUS_UNEXP_ERR,
218: -- ffang 101001, bug 2044483, if error, don't update those ids/flags
219: -- party_id = pI.party_id,
220: -- party_site_id = pI.party_site_id,

Line 239: update as_import_interface

235: program_update_date = sysdate
236: where import_interface_id = pI.import_interface_id;
237: --where rowid = pI.rowid;
238: elsif (pI.load_status = 'DUPLICATE') then
239: update as_import_interface
240: set load_status = 'DUPLICATE', sales_lead_id = pI.sales_lead_id
241: where import_interface_id = pI.import_interface_id;
242: else
243: G_return_status := FND_API.G_RET_STS_ERROR;

Line 1271: -- inserts contact point (in as_import_interface) for pary and party site

1267: --------------------------------------------------------
1268: -- name: do_create_contact_points_old
1269: -- scope: private
1270: -- calls HZ_CONTACT_POINT_V2PUB.do_create_contact_points
1271: -- inserts contact point (in as_import_interface) for pary and party site
1272: ----------------------------------------------------------
1273: procedure do_create_contact_points_old(
1274: pI IN OUT NOCOPY leadImpType,
1275: l_dup_phone IN VARCHAR2,

Line 2460: -- promotion_code is not given, populate it in as_import_interface

2456: p_token2_value => pI.promotion_code );
2457: RAISE FND_API.G_EXC_ERROR;
2458: END IF;
2459: ELSE
2460: -- promotion_code is not given, populate it in as_import_interface
2461: -- swkhanna 05/28/02
2462: pI.promotion_code := UPPER(l_temp_promotion_code);
2463: END IF;
2464:

Line 2612: -- but also in as_import_interface

2608: l_sales_lead_line_tbl(l_index).offer_id := LL.offer_id;
2609: END LOOP;
2610:
2611: -- ffang 091201, support not only the lines in as_imp_lines_interface
2612: -- but also in as_import_interface
2613: -- Sales lead line 1 in as_import_interface
2614: G_SL_LINE_COUNT := 0;
2615: IF pI.category_id_1 IS NOT NULL OR (pI.inventory_item_id_1 IS NOT NULL AND pI.organization_id_1 IS NOT NULL) THEN
2616: l_index := l_index + 1;

Line 2613: -- Sales lead line 1 in as_import_interface

2609: END LOOP;
2610:
2611: -- ffang 091201, support not only the lines in as_imp_lines_interface
2612: -- but also in as_import_interface
2613: -- Sales lead line 1 in as_import_interface
2614: G_SL_LINE_COUNT := 0;
2615: IF pI.category_id_1 IS NOT NULL OR (pI.inventory_item_id_1 IS NOT NULL AND pI.organization_id_1 IS NOT NULL) THEN
2616: l_index := l_index + 1;
2617:

Line 2635: -- Sales lead line 2 in as_import_interface

2631: l_sales_lead_line_tbl(l_index).offer_id:= pI.offer_id_1;
2632: G_SL_LINE_COUNT := 1;
2633: END IF;
2634:
2635: -- Sales lead line 2 in as_import_interface
2636: IF pI.category_id_2 IS NOT NULL OR (pI.inventory_item_id_2 IS NOT NULL AND pI.organization_id_2 IS NOT NULL) THEN
2637: l_index := l_index + 1;
2638:
2639: -- l_sales_lead_line_tbl(l_index).status_code := pI.status_code_2;

Line 2656: -- Sales lead line 3 in as_import_interface

2652: l_sales_lead_line_tbl(l_index).offer_id := pI.offer_id_2;
2653: G_SL_LINE_COUNT := 2;
2654: END IF;
2655:
2656: -- Sales lead line 3 in as_import_interface
2657: IF pI.category_id_3 IS NOT NULL OR (pI.inventory_item_id_3 IS NOT NULL AND pI.organization_id_3 IS NOT NULL) THEN
2658: l_index := l_index + 1;
2659:
2660: -- l_sales_lead_line_tbl(l_index).status_code := pI.status_code_3;

Line 2677: -- Sales lead line 4 in as_import_interface

2673: l_sales_lead_line_tbl(l_index).offer_id := pI.offer_id_3;
2674: G_SL_LINE_COUNT := 3;
2675: END IF;
2676:
2677: -- Sales lead line 4 in as_import_interface
2678: IF pI.category_id_4 IS NOT NULL OR (pI.inventory_item_id_4 IS NOT NULL AND pI.organization_id_4 IS NOT NULL) THEN
2679: l_index := l_index + 1;
2680:
2681: -- l_sales_lead_line_tbl(l_index).status_code := pI.status_code_4;

Line 2698: -- Sales lead line 5 in as_import_interface

2694: l_sales_lead_line_tbl(l_index).offer_id := pI.offer_id_4;
2695: G_SL_LINE_COUNT := 4;
2696: END IF;
2697:
2698: -- Sales lead line 5 in as_import_interface
2699: IF pI.category_id_5 IS NOT NULL OR (pI.inventory_item_id_5 IS NOT NULL AND pI.organization_id_5 IS NOT NULL) THEN
2700: l_index := l_index + 1;
2701:
2702: -- l_sales_lead_line_tbl(l_index).status_code := pI.status_code_5;

Line 2900: -- For the lines in as_import_interface

2896:
2897: Begin
2898: write_log(3, 'do_create_interest:Start');
2899:
2900: -- For the lines in as_import_interface
2901: write_log(3, 'G_SL_LINE_COUNT: ' || G_SL_LINE_COUNT);
2902: For i IN 1..G_SL_LINE_COUNT Loop
2903: l_classification_tbl(i).customer_id := pI.party_id;
2904: l_classification_tbl(i).address_id := pI.party_site_id;

Line 3253: from as_import_interface s, hz_parties p, hz_party_sites ps

3249: p.last_update_date, s.address_key, s.country,
3250: nvl(ps.identifying_address_flag, 'N')
3251: identifying_address_flag,
3252: ps.location_id, ps.party_site_id
3253: from as_import_interface s, hz_parties p, hz_party_sites ps
3254: where s.load_status = 'NEW'
3255: and s.import_interface_id = p_interface_id
3256: and p.customer_key (+) = s.customer_key
3257: and p.party_type (+) = s.party_type

Line 4080: select * from as_import_interface --as_imp_sl_v

4076: l_group_id number;
4077:
4078: -- Bugfix for concurrency control
4079: cursor c_main (l_parent_request_id number, l_child_request_id number) is
4080: select * from as_import_interface --as_imp_sl_v
4081: where request_id = l_parent_request_id
4082: and child_request_id = l_child_request_id
4083: and load_status = 'RUNNING'
4084: and source_system = p_source_system;

Line 4548: UPDATE as_import_interface

4544: -- If the lead creation is successful, update the import record with sales_lead_id
4545: -- so that the marketing_score (lead_score) attribute can be used in rule engine
4546: If G_return_status = FND_API.G_RET_STS_SUCCESS Then
4547: /* --redundent update..after purge project this update is not needed
4548: UPDATE as_import_interface
4549: SET sales_lead_id = I.sales_lead_id
4550: WHERE import_interface_id = I.import_interface_id;
4551: */
4552: UPDATE aml_interaction_leads

Line 4622: --writing bak to as_import_interface

4618: INTO l_curr_time
4619: FROM dual;
4620: write_log(3, 'End Create - Process Lead time: '||l_curr_time);
4621:
4622: --writing bak to as_import_interface
4623: I.load_status := G_LOAD_STATUS_SUCC;
4624: writeBak(I, G_return_status);
4625: IF ((G_return_status <> FND_API.G_RET_STS_SUCCESS) AND
4626: (G_return_status <> 'W'))

Line 4851: UPDATE as_import_interface

4847:
4848: if p_batch_id > 0 then
4849: write_log(3, 'batch_id is found ');
4850: -- Update load_status to RUNNING
4851: UPDATE as_import_interface
4852: SET load_status = 'RUNNING', request_id = l_request_id,
4853: child_request_id = ceil(ROWNUM/decode(l_batch_size,0,ROWNUM,l_batch_size))
4854: WHERE batch_id = p_batch_id
4855: AND source_system = p_source_system

Line 4860: UPDATE as_import_interface

4856: AND load_status = 'NEW'
4857: AND decode(source_system,'INTERACTION',interaction_score,l_interaction_threshold) >= l_interaction_threshold;
4858: else
4859: write_log(3, 'batch_id is null ');
4860: UPDATE as_import_interface
4861: SET load_status = 'RUNNING', request_id = l_request_id,
4862: child_request_id = ceil(ROWNUM/decode(l_batch_size,0,ROWNUM,l_batch_size))
4863: WHERE source_system = p_source_system
4864: AND load_status = 'NEW'