APPS.BOMPCHDU dependencies on BOMPCHDU

Line 1: package body BOMPCHDU as

1: package body BOMPCHDU as
2: /* $Header: BOMCHDUB.pls 115.3 99/07/16 05:11:38 porting shi $ */
3: /*============================================================================+
4: | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |
5: | All rights reserved. |

Line 14: | BOMPCHDU.is_base_demand_row -- Checks whether a given row in |

10: | DESCRIPTION : |
11: | This file creates packaged functions that check for matching |
12: | configurations. |
13: | |
14: | BOMPCHDU.is_base_demand_row -- Checks whether a given row in |
15: | mtl_demand has already been found to be a duplicate. |
16: | |
17: | BOMPCHDU.bomfchdu_check_dupl_config -- Checks through each |
18: | row in mtl_demand which has been marked to be processed. |

Line 17: | BOMPCHDU.bomfchdu_check_dupl_config -- Checks through each |

13: | |
14: | BOMPCHDU.is_base_demand_row -- Checks whether a given row in |
15: | mtl_demand has already been found to be a duplicate. |
16: | |
17: | BOMPCHDU.bomfchdu_check_dupl_config -- Checks through each |
18: | row in mtl_demand which has been marked to be processed. |
19: | Depending on profile settings, it may call a custom function |
20: | for pre-existing configurations or use the matching function |
21: | from match and reserve. Then, it does an in batch match on |

Line 24: | BOMPCHDU.existing_dupl_match -- for a given demand_id, it |

20: | for pre-existing configurations or use the matching function |
21: | from match and reserve. Then, it does an in batch match on |
22: | the configurations. |
23: | |
24: | BOMPCHDU.existing_dupl_match -- for a given demand_id, it |
25: | searches BOM ATO Configurations for a matching configuration. |
26: | |
27: | BOMPCHDU.check_dupl_batch_match -- for a given demand_id, it |
28: | checks the other rows to be processed whether any has an |

Line 27: | BOMPCHDU.check_dupl_batch_match -- for a given demand_id, it |

23: | |
24: | BOMPCHDU.existing_dupl_match -- for a given demand_id, it |
25: | searches BOM ATO Configurations for a matching configuration. |
26: | |
27: | BOMPCHDU.check_dupl_batch_match -- for a given demand_id, it |
28: | checks the other rows to be processed whether any has an |
29: | identical configuration. If any of the other rows are |
30: | identical, their dupl_config_demand_id or dupl_config_item_id |
31: | is updated accordingly. |

Line 157: status := BOMPCHDU.is_base_demand_row(

153: ** Search whether this row has already been found
154: ** to be a duplicate
155: */
156: sql_stmt_num :=8;
157: status := BOMPCHDU.is_base_demand_row(
158: l_demand_id,
159: error_message,
160: message_name,
161: table_name);

Line 197: status := BOMPCHDU.existing_dupl_match(

193: ** Match and Reserve, so use new
194: ** existing_dupl_match to check for existing
195: ** configuration in BAC */
196:
197: status := BOMPCHDU.existing_dupl_match(
198: l_demand_id,
199: l_config_item_id,
200: error_message,
201: message_name,

Line 217: status := BOMPCHDU.check_dupl_batch_match(

213: ** if they match.
214: */
215: sql_stmt_num :=21;
216: if (nobatch=0) then
217: status := BOMPCHDU.check_dupl_batch_match(
218: l_demand_id,
219: l_config_item_id,
220: l_demand_source_line,
221: error_message,

Line 361: error_message := 'BOMPCHDU' || to_char(stmt_num) || ':' ||

357: return (1);
358:
359: exception
360: when NO_MODEL_FOUND THEN
361: error_message := 'BOMPCHDU' || to_char(stmt_num) || ':' ||
362: substrb(sqlerrm,1,150);
363: message_name := 'BOM_ATO_PROCESS_ERROR';
364: table_name := 'MTL_DEMAND';
365: return (0);

Line 372: error_message := 'BOMPCHDU' || to_char(stmt_num) || ':' ||

368:
369: return(0);
370: when OTHERS THEN
371:
372: error_message := 'BOMPCHDU' || to_char(stmt_num) || ':' ||
373: substrb(sqlerrm,1,150);
374: message_name := 'BOM_ATO_PROCESS_ERROR';
375: table_name := 'SO_LINES_ALL';
376: return(0);

Line 464: error_message := 'BOMPCHDU:' || to_char(stmt_num) || ':' ||

460:
461: exception
462: when NO_MODEL_FOUND THEN
463:
464: error_message := 'BOMPCHDU:' || to_char(stmt_num) || ':' ||
465: substrb(sqlerrm,1,150);
466: message_name := 'BOM_ATO_PROCESS_ERROR';
467: table_name := 'MTL_DEMAND';
468: return (0);

Line 475: error_message := 'BOMPCHDU' || to_char(stmt_num) || ':' ||

471:
472: return(0);
473: when OTHERS THEN
474:
475: error_message := 'BOMPCHDU' || to_char(stmt_num) || ':' ||
476: substrb(sqlerrm,1,150);
477: message_name := 'BOM_ATO_PROCESS_ERROR';
478: table_name := 'SO_LINES_ALL';
479: return(0);

Line 484: end BOMPCHDU;

480: end;
481:
482:
483:
484: end BOMPCHDU;