DBA Data[Home] [Help]

APPS.WSMPPCPD dependencies on BOM_SUB_COMPS_INTERFACE

Line 379: x_rec IN OUT NOCOPY bom_sub_comps_interface%ROWTYPE,

375:
376: =========================================================================== */
377:
378: PROCEDURE insert_substitute_component (
379: x_rec IN OUT NOCOPY bom_sub_comps_interface%ROWTYPE,
380: x_co_product_name IN VARCHAR2,
381: x_alternate_designator IN VARCHAR2,
382: x_component_name IN VARCHAR2,
383: x_comp_start_eff_date IN DATE,

Line 413: INSERT INTO BOM_SUB_COMPS_INTERFACE(

409:
410: x_progress := '020';
411:
412: /* Comment this out since we are using the BOM BO API in Release 11i.2
413: INSERT INTO BOM_SUB_COMPS_INTERFACE(
414: transaction_type,
415: substitute_component_id,
416: last_update_date,
417: last_updated_by,

Line 581: x_rec bom_sub_comps_interface%ROWTYPE;

577:
578: x_progress VARCHAR2(3) := NULL;
579: i NUMBER;
580: e_proc_exception EXCEPTION;
581: x_rec bom_sub_comps_interface%ROWTYPE;
582:
583: CURSOR S IS SELECT *
584: FROM wsm_co_prod_comp_substitutes
585: WHERE co_product_group_id = x_co_product_group_id;

Line 697: x_rec bom_sub_comps_interface%ROWTYPE;

693: x_error_msg IN OUT NOCOPY VARCHAR2) IS
694:
695: x_progress VARCHAR2(3) := NULL;
696: e_proc_exception EXCEPTION;
697: x_rec bom_sub_comps_interface%ROWTYPE;
698:
699: e_comp_exception EXCEPTION;
700: e_check_unique_exception EXCEPTION;
701: e_check_common EXCEPTION;

Line 1181: x_rec bom_sub_comps_interface%ROWTYPE;

1177: x_error_msg IN OUT NOCOPY VARCHAR2) IS
1178:
1179: x_progress VARCHAR2(3) := NULL;
1180: e_proc_exception EXCEPTION;
1181: x_rec bom_sub_comps_interface%ROWTYPE;
1182:
1183: e_comp_exception EXCEPTION;
1184: e_check_unique_exception EXCEPTION;
1185: e_check_common EXCEPTION;