DBA Data[Home] [Help]

APPS.WSM_SERIAL_SUPPORT_PVT dependencies on INV_LOT_SEL_ATTR

Line 1401: inv_lot_sel_attr.is_enabled( 'Serial Attributes',

1397: end if;
1398: end if;
1399:
1400: IF (g_wms_installed=1 AND
1401: inv_lot_sel_attr.is_enabled( 'Serial Attributes',
1402: p_organization_id,
1403: p_inventory_item_id) >= 2) OR
1404: (inv_lot_sel_attr.is_dff_required('MTL_SERIAL_NUMBERS',
1405: 'INV',

Line 1404: (inv_lot_sel_attr.is_dff_required('MTL_SERIAL_NUMBERS',

1400: IF (g_wms_installed=1 AND
1401: inv_lot_sel_attr.is_enabled( 'Serial Attributes',
1402: p_organization_id,
1403: p_inventory_item_id) >= 2) OR
1404: (inv_lot_sel_attr.is_dff_required('MTL_SERIAL_NUMBERS',
1405: 'INV',
1406: p_organization_id,
1407: p_inventory_item_id) = 1 ) THEN
1408:

Line 1650: inv_lot_sel_attr.is_enabled( 'Serial Attributes',

1646: end if;
1647: end if;
1648:
1649: IF (g_wms_installed=1 AND
1650: inv_lot_sel_attr.is_enabled( 'Serial Attributes',
1651: p_organization_id,
1652: p_inventory_item_id) >= 2) OR
1653: (inv_lot_sel_attr.is_dff_required('MTL_SERIAL_NUMBERS',
1654: 'INV',

Line 1653: (inv_lot_sel_attr.is_dff_required('MTL_SERIAL_NUMBERS',

1649: IF (g_wms_installed=1 AND
1650: inv_lot_sel_attr.is_enabled( 'Serial Attributes',
1651: p_organization_id,
1652: p_inventory_item_id) >= 2) OR
1653: (inv_lot_sel_attr.is_dff_required('MTL_SERIAL_NUMBERS',
1654: 'INV',
1655: p_organization_id,
1656: p_inventory_item_id) = 1 ) THEN
1657:

Line 2030: l_serial_attributes_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

2026: x_error_msg OUT NOCOPY VARCHAR2
2027: )
2028:
2029: IS
2030: l_serial_attributes_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
2031: l_desc_attributes_tbl inv_serial_number_attr.char_table;
2032:
2033: l_miss_char VARCHAR2(1) := FND_API.G_MISS_CHAR;
2034: l_attribute_category VARCHAR2(30);

Line 2120: INV_LOT_SEL_ATTR.get_context_code ( context_value => l_ser_context,

2116:
2117: l_stmt_num := 41;
2118: IF p_serial_attr_context IS NULL THEN
2119: -- The calling program hasnt passed the value...
2120: INV_LOT_SEL_ATTR.get_context_code ( context_value => l_ser_context,
2121: org_id => p_organization_id ,
2122: item_id => p_inventory_item_id,
2123: flex_name => 'Serial Attributes'
2124: );

Line 2450: p_serial_attributes_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type,

2446: p_serial_desc_attr_tbl IN inv_serial_number_attr.char_table,
2447: p_attribute_category IN VARCHAR2,
2448: p_update_serial_attr IN NUMBER DEFAULT NULL,
2449: p_update_desc_attr IN NUMBER,
2450: p_serial_attributes_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type,
2451: x_return_status OUT NOCOPY VARCHAR2,
2452: x_error_count OUT NOCOPY NUMBER,
2453: x_error_msg OUT NOCOPY VARCHAR2
2454: ) IS

Line 6110: INV_LOT_SEL_ATTR.get_context_code ( context_value => l_parent_job_ser_context,

6106: IF l_update_serial_attr = 1 then
6107:
6108: l_parent_job_ser_context := null;
6109:
6110: INV_LOT_SEL_ATTR.get_context_code ( context_value => l_parent_job_ser_context,
6111: org_id => p_organization_id ,
6112: item_id => l_inventory_item_id,
6113: flex_name => 'Serial Attributes'
6114: );

Line 6499: INV_LOT_SEL_ATTR.get_context_code ( context_value => l_child_job_ser_context,

6495: -- populate message about the serial attributes being cleared...
6496: l_stmt_num := 149;
6497: l_child_job_ser_context := null;
6498:
6499: INV_LOT_SEL_ATTR.get_context_code ( context_value => l_child_job_ser_context,
6500: org_id => p_organization_id ,
6501: item_id => p_resulting_jobs_tbl(l_index).primary_item_id,
6502: flex_name => 'Serial Attributes'
6503: );

Line 6829: INV_LOT_SEL_ATTR.get_context_code ( context_value => l_parent_job_ser_context,

6825: IF g_wms_installed = 1 then
6826:
6827: l_parent_job_ser_context := null;
6828:
6829: INV_LOT_SEL_ATTR.get_context_code ( context_value => l_parent_job_ser_context,
6830: org_id => p_organization_id ,
6831: item_id => p_starting_jobs_tbl(l_rep_job_index).primary_item_id,
6832: flex_name => 'Serial Attributes'
6833: );

Line 6906: INV_LOT_SEL_ATTR.get_context_code ( context_value => l_context ,

6902: -- first check is to see the item id....
6903: if p_starting_jobs_tbl(l_index).primary_item_id <> p_resulting_jobs_tbl(p_resulting_jobs_tbl.first).primary_item_id then
6904: -- have to check the context and populate the warning message...
6905: l_context := null;
6906: INV_LOT_SEL_ATTR.get_context_code ( context_value => l_context ,
6907: org_id => p_organization_id ,
6908: item_id => p_starting_jobs_tbl(l_index).primary_item_id ,
6909: -- ST : Fix for bug 5161024 : l_inventory_item_id ,
6910: flex_name => 'Serial Attributes'

Line 7058: INV_LOT_SEL_ATTR.get_context_code ( context_value => l_parent_job_ser_context ,

7054: IF g_wms_installed = 1 then
7055:
7056: l_parent_job_ser_context := null;
7057:
7058: INV_LOT_SEL_ATTR.get_context_code ( context_value => l_parent_job_ser_context ,
7059: org_id => p_organization_id ,
7060: item_id => p_starting_jobs_tbl(p_starting_jobs_tbl.first).primary_item_id,
7061: flex_name => 'Serial Attributes'
7062: );

Line 7065: INV_LOT_SEL_ATTR.get_context_code ( context_value => l_context ,

7061: flex_name => 'Serial Attributes'
7062: );
7063: l_context := null;
7064:
7065: INV_LOT_SEL_ATTR.get_context_code ( context_value => l_context ,
7066: org_id => p_organization_id ,
7067: item_id => p_resulting_jobs_tbl(p_resulting_jobs_tbl.first).primary_item_id,
7068: flex_name => 'Serial Attributes'
7069: );