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.FLM_KANBAN_PUB dependencies on MTL_PULL_SEQ_SUPPLIERS

Line 228: mydebug('Inserting into MTL_PULL_SEQ_SUPPLIERS table.');

224:
225: BEGIN
226: FND_MSG_PUB.Initialize;
227:
228: mydebug('Inserting into MTL_PULL_SEQ_SUPPLIERS table.');
229:
230: INSERT INTO MTL_PULL_SEQ_SUPPLIERS
231: (pull_sequence_id,
232: organization_id,

Line 230: INSERT INTO MTL_PULL_SEQ_SUPPLIERS

226: FND_MSG_PUB.Initialize;
227:
228: mydebug('Inserting into MTL_PULL_SEQ_SUPPLIERS table.');
229:
230: INSERT INTO MTL_PULL_SEQ_SUPPLIERS
231: (pull_sequence_id,
232: organization_id,
233: supplier_id,
234: supplier_site_id,

Line 276: PROCEDURE insert_supplier_row(p_supplier_rec IN MTL_PULL_SEQ_SUPPLIERS%ROWTYPE)

272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
273:
274: END insert_supplier_row;
275:
276: PROCEDURE insert_supplier_row(p_supplier_rec IN MTL_PULL_SEQ_SUPPLIERS%ROWTYPE)
277: IS
278: l_supplier_rec MTL_PULL_SEQ_SUPPLIERS%ROWTYPE := p_supplier_rec;
279: l_return_status VARCHAR2(1);
280: BEGIN

Line 278: l_supplier_rec MTL_PULL_SEQ_SUPPLIERS%ROWTYPE := p_supplier_rec;

274: END insert_supplier_row;
275:
276: PROCEDURE insert_supplier_row(p_supplier_rec IN MTL_PULL_SEQ_SUPPLIERS%ROWTYPE)
277: IS
278: l_supplier_rec MTL_PULL_SEQ_SUPPLIERS%ROWTYPE := p_supplier_rec;
279: l_return_status VARCHAR2(1);
280: BEGIN
281: FND_MSG_PUB.Initialize;
282:

Line 348: mydebug('Updating MTL_PULL_SEQ_SUPPLIERS table.');

344: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
345: BEGIN
346: FND_MSG_PUB.Initialize;
347:
348: mydebug('Updating MTL_PULL_SEQ_SUPPLIERS table.');
349: -- Fix bug 12419603. Should allow user to update supplier site, only supplier should NOT be updated
350: -- because supplier_id is the primary key of the MTL_PULL_SEQ_SUPPLIERS table
351: UPDATE MTL_PULL_SEQ_SUPPLIERS
352: SET supplier_site_id = p_supplier_site_id,

Line 350: -- because supplier_id is the primary key of the MTL_PULL_SEQ_SUPPLIERS table

346: FND_MSG_PUB.Initialize;
347:
348: mydebug('Updating MTL_PULL_SEQ_SUPPLIERS table.');
349: -- Fix bug 12419603. Should allow user to update supplier site, only supplier should NOT be updated
350: -- because supplier_id is the primary key of the MTL_PULL_SEQ_SUPPLIERS table
351: UPDATE MTL_PULL_SEQ_SUPPLIERS
352: SET supplier_site_id = p_supplier_site_id,
353: sourcing_percentage = p_sourcing_percentage,
354: last_update_date = p_last_update_date,

Line 351: UPDATE MTL_PULL_SEQ_SUPPLIERS

347:
348: mydebug('Updating MTL_PULL_SEQ_SUPPLIERS table.');
349: -- Fix bug 12419603. Should allow user to update supplier site, only supplier should NOT be updated
350: -- because supplier_id is the primary key of the MTL_PULL_SEQ_SUPPLIERS table
351: UPDATE MTL_PULL_SEQ_SUPPLIERS
352: SET supplier_site_id = p_supplier_site_id,
353: sourcing_percentage = p_sourcing_percentage,
354: last_update_date = p_last_update_date,
355: last_updated_by = p_last_updated_by,

Line 390: PROCEDURE update_supplier_row(p_supplier_rec IN MTL_PULL_SEQ_SUPPLIERS%ROWTYPE)

386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387:
388: END update_supplier_row;
389:
390: PROCEDURE update_supplier_row(p_supplier_rec IN MTL_PULL_SEQ_SUPPLIERS%ROWTYPE)
391: IS
392: l_supplier_rec MTL_PULL_SEQ_SUPPLIERS%ROWTYPE := p_supplier_rec;
393: l_return_status VARCHAR2(1);
394: BEGIN

Line 392: l_supplier_rec MTL_PULL_SEQ_SUPPLIERS%ROWTYPE := p_supplier_rec;

388: END update_supplier_row;
389:
390: PROCEDURE update_supplier_row(p_supplier_rec IN MTL_PULL_SEQ_SUPPLIERS%ROWTYPE)
391: IS
392: l_supplier_rec MTL_PULL_SEQ_SUPPLIERS%ROWTYPE := p_supplier_rec;
393: l_return_status VARCHAR2(1);
394: BEGIN
395: FND_MSG_PUB.Initialize;
396:

Line 454: DELETE FROM MTL_PULL_SEQ_SUPPLIERS

450: FND_MSG_PUB.Initialize;
451:
452: mydebug('In procedure delete_supplier_row.');
453:
454: DELETE FROM MTL_PULL_SEQ_SUPPLIERS
455: WHERE pull_sequence_id = p_pull_sequence_id
456: AND supplier_id = p_supplier_id;
457:
458: if (SQL%NOTFOUND) then

Line 1145: FROM MTL_PULL_SEQ_SUPPLIERS

1141: l_count number;
1142: BEGIN
1143: SELECT COUNT(*)
1144: INTO l_count
1145: FROM MTL_PULL_SEQ_SUPPLIERS
1146: WHERE pull_sequence_id = p_pull_seq_rec.pull_sequence_id;
1147:
1148: IF l_count > 0 THEN
1149: p_pull_seq_rec.supplier_id := null;

Line 3782: from mtl_pull_seq_suppliers

3778: --Unique constaint for pull_sequence_id and supplier_id combination; Added for Bug 12533212
3779: if l_transaction_type IN (FLM_KANBAN_MASSLOAD.KANBAN_ADD) then
3780: select count(*)
3781: into l_supplier_count
3782: from mtl_pull_seq_suppliers
3783: where pull_sequence_id = p_supplier_rec.pull_sequence_id
3784: and supplier_id = p_supplier_rec.supplier_id;
3785:
3786: if(l_supplier_count > 0) then

Line 3796: --Fix bug 12419603, should only check mtl_pull_seq_suppliers based on

3792: end if;
3793:
3794: if l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE then
3795: begin
3796: --Fix bug 12419603, should only check mtl_pull_seq_suppliers based on
3797: --supplier_id during update of pull seq since supplier_id is the primary key
3798: --of mtl_pull_seq_suppliers table
3799: select 1 into l_supplier_count
3800: from mtl_pull_seq_suppliers

Line 3798: --of mtl_pull_seq_suppliers table

3794: if l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE then
3795: begin
3796: --Fix bug 12419603, should only check mtl_pull_seq_suppliers based on
3797: --supplier_id during update of pull seq since supplier_id is the primary key
3798: --of mtl_pull_seq_suppliers table
3799: select 1 into l_supplier_count
3800: from mtl_pull_seq_suppliers
3801: where pull_sequence_id = p_supplier_rec.pull_sequence_id
3802: and supplier_id = p_supplier_rec.supplier_id;

Line 3800: from mtl_pull_seq_suppliers

3796: --Fix bug 12419603, should only check mtl_pull_seq_suppliers based on
3797: --supplier_id during update of pull seq since supplier_id is the primary key
3798: --of mtl_pull_seq_suppliers table
3799: select 1 into l_supplier_count
3800: from mtl_pull_seq_suppliers
3801: where pull_sequence_id = p_supplier_rec.pull_sequence_id
3802: and supplier_id = p_supplier_rec.supplier_id;
3803: --and nvl(supplier_site_id,-1) = nvl(p_supplier_rec.supplier_site_id,-1);
3804: exception

Line 3823: from mtl_pull_seq_suppliers

3819: end if;
3820: -- Fix bug 12419603, derive sourcing_percentage if it's not provided during update
3821: if l_transaction_type = FLM_KANBAN_MASSLOAD.KANBAN_CHANGE then
3822: select sourcing_percentage into l_sourcing_percentage
3823: from mtl_pull_seq_suppliers
3824: where pull_sequence_id = p_supplier_rec.pull_sequence_id
3825: and supplier_id = p_supplier_rec.supplier_id;
3826: p_supplier_rec.sourcing_percentage := l_sourcing_percentage;
3827: end if;

Line 4128: v_supplier_rec MTL_PULL_SEQ_SUPPLIERS%ROWTYPE;

4124: l_creation_date DATE;
4125: l_created_by NUMBER;
4126: l_last_update_login NUMBER;
4127:
4128: v_supplier_rec MTL_PULL_SEQ_SUPPLIERS%ROWTYPE;
4129:
4130: BEGIN
4131:
4132: mydebug('In process_suppliers procedure.');