7: p_phase_change_flag VARCHAR2,
8: x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type)
9: IS
10: l_org_id NUMBER;
11: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
12: BEGIN
13: oe_debug_pub.add('l_debug_level'||l_debug_level );
14: IF l_debug_level > 0 THEN
15: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_ROW'||p_version );
9: IS
10: l_org_id NUMBER;
11: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
12: BEGIN
13: oe_debug_pub.add('l_debug_level'||l_debug_level );
14: IF l_debug_level > 0 THEN
15: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_ROW'||p_version );
16: oe_debug_pub.add('header' ||p_header_id);
17: oe_debug_pub.add('version' ||p_version);
11: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
12: BEGIN
13: oe_debug_pub.add('l_debug_level'||l_debug_level );
14: IF l_debug_level > 0 THEN
15: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_ROW'||p_version );
16: oe_debug_pub.add('header' ||p_header_id);
17: oe_debug_pub.add('version' ||p_version);
18: oe_debug_pub.add('phase_change_flag' ||p_phase_change_flag);
19: END IF;
12: BEGIN
13: oe_debug_pub.add('l_debug_level'||l_debug_level );
14: IF l_debug_level > 0 THEN
15: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_ROW'||p_version );
16: oe_debug_pub.add('header' ||p_header_id);
17: oe_debug_pub.add('version' ||p_version);
18: oe_debug_pub.add('phase_change_flag' ||p_phase_change_flag);
19: END IF;
20:
13: oe_debug_pub.add('l_debug_level'||l_debug_level );
14: IF l_debug_level > 0 THEN
15: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_ROW'||p_version );
16: oe_debug_pub.add('header' ||p_header_id);
17: oe_debug_pub.add('version' ||p_version);
18: oe_debug_pub.add('phase_change_flag' ||p_phase_change_flag);
19: END IF;
20:
21: l_org_id := OE_GLOBALS.G_ORG_ID;
14: IF l_debug_level > 0 THEN
15: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_ROW'||p_version );
16: oe_debug_pub.add('header' ||p_header_id);
17: oe_debug_pub.add('version' ||p_version);
18: oe_debug_pub.add('phase_change_flag' ||p_phase_change_flag);
19: END IF;
20:
21: l_org_id := OE_GLOBALS.G_ORG_ID;
22:
397: p_version NUMBER,
398: x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type)
399: IS
400: l_org_id NUMBER;
401: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
402: BEGIN
403: IF l_debug_level > 0 THEN
404: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_TRANS_ROW');
405: oe_debug_pub.add('header' ||p_header_id);
400: l_org_id NUMBER;
401: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
402: BEGIN
403: IF l_debug_level > 0 THEN
404: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_TRANS_ROW');
405: oe_debug_pub.add('header' ||p_header_id);
406: oe_debug_pub.add('version' ||p_version);
407: END IF;
408:
401: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
402: BEGIN
403: IF l_debug_level > 0 THEN
404: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_TRANS_ROW');
405: oe_debug_pub.add('header' ||p_header_id);
406: oe_debug_pub.add('version' ||p_version);
407: END IF;
408:
409: l_org_id := OE_GLOBALS.G_ORG_ID;
402: BEGIN
403: IF l_debug_level > 0 THEN
404: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_TRANS_ROW');
405: oe_debug_pub.add('header' ||p_header_id);
406: oe_debug_pub.add('version' ||p_version);
407: END IF;
408:
409: l_org_id := OE_GLOBALS.G_ORG_ID;
410:
888: l_encrypted VARCHAR2(30); --PADSS
889: l_encrypted1 VARCHAR2(30); --PADSS
890:
891:
892: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
893: BEGIN
894:
895: oe_debug_pub.add('Entering OE_VERSION_COMP'||l_debug_level);
896: IF l_debug_level > 0 THEN
891:
892: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
893: BEGIN
894:
895: oe_debug_pub.add('Entering OE_VERSION_COMP'||l_debug_level);
896: IF l_debug_level > 0 THEN
897: oe_debug_pub.add('Entering OE_VERSION_COMP.COMPARE_HEADER_VERSIONS');
898: oe_debug_pub.add('header' ||p_header_id);
899: oe_debug_pub.add('prior_version' ||p_prior_version);
893: BEGIN
894:
895: oe_debug_pub.add('Entering OE_VERSION_COMP'||l_debug_level);
896: IF l_debug_level > 0 THEN
897: oe_debug_pub.add('Entering OE_VERSION_COMP.COMPARE_HEADER_VERSIONS');
898: oe_debug_pub.add('header' ||p_header_id);
899: oe_debug_pub.add('prior_version' ||p_prior_version);
900: oe_debug_pub.add('curr_version' ||p_current_version);
901: oe_debug_pub.add('next_version' ||p_next_version);
894:
895: oe_debug_pub.add('Entering OE_VERSION_COMP'||l_debug_level);
896: IF l_debug_level > 0 THEN
897: oe_debug_pub.add('Entering OE_VERSION_COMP.COMPARE_HEADER_VERSIONS');
898: oe_debug_pub.add('header' ||p_header_id);
899: oe_debug_pub.add('prior_version' ||p_prior_version);
900: oe_debug_pub.add('curr_version' ||p_current_version);
901: oe_debug_pub.add('next_version' ||p_next_version);
902: oe_debug_pub.add('max_version' ||g_max_version);
895: oe_debug_pub.add('Entering OE_VERSION_COMP'||l_debug_level);
896: IF l_debug_level > 0 THEN
897: oe_debug_pub.add('Entering OE_VERSION_COMP.COMPARE_HEADER_VERSIONS');
898: oe_debug_pub.add('header' ||p_header_id);
899: oe_debug_pub.add('prior_version' ||p_prior_version);
900: oe_debug_pub.add('curr_version' ||p_current_version);
901: oe_debug_pub.add('next_version' ||p_next_version);
902: oe_debug_pub.add('max_version' ||g_max_version);
903: oe_debug_pub.add('trans_version' ||g_trans_version);
896: IF l_debug_level > 0 THEN
897: oe_debug_pub.add('Entering OE_VERSION_COMP.COMPARE_HEADER_VERSIONS');
898: oe_debug_pub.add('header' ||p_header_id);
899: oe_debug_pub.add('prior_version' ||p_prior_version);
900: oe_debug_pub.add('curr_version' ||p_current_version);
901: oe_debug_pub.add('next_version' ||p_next_version);
902: oe_debug_pub.add('max_version' ||g_max_version);
903: oe_debug_pub.add('trans_version' ||g_trans_version);
904: oe_debug_pub.add('prior phase chagne' ||g_prior_phase_change_flag);
897: oe_debug_pub.add('Entering OE_VERSION_COMP.COMPARE_HEADER_VERSIONS');
898: oe_debug_pub.add('header' ||p_header_id);
899: oe_debug_pub.add('prior_version' ||p_prior_version);
900: oe_debug_pub.add('curr_version' ||p_current_version);
901: oe_debug_pub.add('next_version' ||p_next_version);
902: oe_debug_pub.add('max_version' ||g_max_version);
903: oe_debug_pub.add('trans_version' ||g_trans_version);
904: oe_debug_pub.add('prior phase chagne' ||g_prior_phase_change_flag);
905: oe_debug_pub.add('curr phase chagne' ||g_curr_phase_change_flag);
898: oe_debug_pub.add('header' ||p_header_id);
899: oe_debug_pub.add('prior_version' ||p_prior_version);
900: oe_debug_pub.add('curr_version' ||p_current_version);
901: oe_debug_pub.add('next_version' ||p_next_version);
902: oe_debug_pub.add('max_version' ||g_max_version);
903: oe_debug_pub.add('trans_version' ||g_trans_version);
904: oe_debug_pub.add('prior phase chagne' ||g_prior_phase_change_flag);
905: oe_debug_pub.add('curr phase chagne' ||g_curr_phase_change_flag);
906: oe_debug_pub.add('next phase chagne' ||g_next_phase_change_flag);
899: oe_debug_pub.add('prior_version' ||p_prior_version);
900: oe_debug_pub.add('curr_version' ||p_current_version);
901: oe_debug_pub.add('next_version' ||p_next_version);
902: oe_debug_pub.add('max_version' ||g_max_version);
903: oe_debug_pub.add('trans_version' ||g_trans_version);
904: oe_debug_pub.add('prior phase chagne' ||g_prior_phase_change_flag);
905: oe_debug_pub.add('curr phase chagne' ||g_curr_phase_change_flag);
906: oe_debug_pub.add('next phase chagne' ||g_next_phase_change_flag);
907: END IF;
900: oe_debug_pub.add('curr_version' ||p_current_version);
901: oe_debug_pub.add('next_version' ||p_next_version);
902: oe_debug_pub.add('max_version' ||g_max_version);
903: oe_debug_pub.add('trans_version' ||g_trans_version);
904: oe_debug_pub.add('prior phase chagne' ||g_prior_phase_change_flag);
905: oe_debug_pub.add('curr phase chagne' ||g_curr_phase_change_flag);
906: oe_debug_pub.add('next phase chagne' ||g_next_phase_change_flag);
907: END IF;
908:
901: oe_debug_pub.add('next_version' ||p_next_version);
902: oe_debug_pub.add('max_version' ||g_max_version);
903: oe_debug_pub.add('trans_version' ||g_trans_version);
904: oe_debug_pub.add('prior phase chagne' ||g_prior_phase_change_flag);
905: oe_debug_pub.add('curr phase chagne' ||g_curr_phase_change_flag);
906: oe_debug_pub.add('next phase chagne' ||g_next_phase_change_flag);
907: END IF;
908:
909: IF p_prior_version IS NOT NULL THEN
902: oe_debug_pub.add('max_version' ||g_max_version);
903: oe_debug_pub.add('trans_version' ||g_trans_version);
904: oe_debug_pub.add('prior phase chagne' ||g_prior_phase_change_flag);
905: oe_debug_pub.add('curr phase chagne' ||g_curr_phase_change_flag);
906: oe_debug_pub.add('next phase chagne' ||g_next_phase_change_flag);
907: END IF;
908:
909: IF p_prior_version IS NOT NULL THEN
910: OE_VERSION_COMP.QUERY_HEADER_ROW(p_header_id => p_header_id,
7184: p_phase_change_flag VARCHAR2,
7185: x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type)
7186: IS
7187: l_org_id NUMBER;
7188: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7189: BEGIN
7190: IF l_debug_level > 0 THEN
7191: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_LINE_ROW');
7192: oe_debug_pub.add('header' ||p_header_id);
7187: l_org_id NUMBER;
7188: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7189: BEGIN
7190: IF l_debug_level > 0 THEN
7191: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_LINE_ROW');
7192: oe_debug_pub.add('header' ||p_header_id);
7193: oe_debug_pub.add('version' ||p_version);
7194: END IF;
7195:
7188: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7189: BEGIN
7190: IF l_debug_level > 0 THEN
7191: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_LINE_ROW');
7192: oe_debug_pub.add('header' ||p_header_id);
7193: oe_debug_pub.add('version' ||p_version);
7194: END IF;
7195:
7196: l_org_id := OE_GLOBALS.G_ORG_ID;
7189: BEGIN
7190: IF l_debug_level > 0 THEN
7191: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_LINE_ROW');
7192: oe_debug_pub.add('header' ||p_header_id);
7193: oe_debug_pub.add('version' ||p_version);
7194: END IF;
7195:
7196: l_org_id := OE_GLOBALS.G_ORG_ID;
7197:
7886: p_version NUMBER,
7887: x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type)
7888: IS
7889: l_org_id NUMBER;
7890: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7891: BEGIN
7892: IF l_debug_level > 0 THEN
7893: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_LINE_TRANS_ROW', 1);
7894: oe_debug_pub.add('header' ||p_header_id);
7889: l_org_id NUMBER;
7890: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7891: BEGIN
7892: IF l_debug_level > 0 THEN
7893: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_LINE_TRANS_ROW', 1);
7894: oe_debug_pub.add('header' ||p_header_id);
7895: oe_debug_pub.add('version' ||p_version);
7896: END IF;
7897:
7890: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7891: BEGIN
7892: IF l_debug_level > 0 THEN
7893: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_LINE_TRANS_ROW', 1);
7894: oe_debug_pub.add('header' ||p_header_id);
7895: oe_debug_pub.add('version' ||p_version);
7896: END IF;
7897:
7898: l_org_id := OE_GLOBALS.G_ORG_ID;
7891: BEGIN
7892: IF l_debug_level > 0 THEN
7893: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_LINE_TRANS_ROW', 1);
7894: oe_debug_pub.add('header' ||p_header_id);
7895: oe_debug_pub.add('version' ||p_version);
7896: END IF;
7897:
7898: l_org_id := OE_GLOBALS.G_ORG_ID;
7899:
8669: x_prior_item_rel_type VARCHAR2(240);
8670: x_current_item_rel_type VARCHAR2(240);
8671: x_next_item_rel_type VARCHAR2(240);
8672:
8673: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
8674: p_prior_rec_exists VARCHAR2(1) := 'N';
8675: p_curr_rec_exists VARCHAR2(1) := 'N';
8676: p_next_rec_exists VARCHAR2(1) := 'N';
8677: p_trans_rec_exists VARCHAR2(1) := 'N';
8678: ind NUMBER;
8679: BEGIN
8680:
8681: IF l_debug_level > 0 THEN
8682: oe_debug_pub.add('Entering Compare_line_attributes');
8683: oe_debug_pub.add('header' ||p_header_id);
8684: oe_debug_pub.add('line' ||p_line_id);
8685: oe_debug_pub.add('line number' ||x_line_number);
8686: oe_debug_pub.add('prior version' ||p_prior_version);
8679: BEGIN
8680:
8681: IF l_debug_level > 0 THEN
8682: oe_debug_pub.add('Entering Compare_line_attributes');
8683: oe_debug_pub.add('header' ||p_header_id);
8684: oe_debug_pub.add('line' ||p_line_id);
8685: oe_debug_pub.add('line number' ||x_line_number);
8686: oe_debug_pub.add('prior version' ||p_prior_version);
8687: oe_debug_pub.add('current version' ||p_current_version);
8680:
8681: IF l_debug_level > 0 THEN
8682: oe_debug_pub.add('Entering Compare_line_attributes');
8683: oe_debug_pub.add('header' ||p_header_id);
8684: oe_debug_pub.add('line' ||p_line_id);
8685: oe_debug_pub.add('line number' ||x_line_number);
8686: oe_debug_pub.add('prior version' ||p_prior_version);
8687: oe_debug_pub.add('current version' ||p_current_version);
8688: oe_debug_pub.add('next version' ||p_next_version);
8681: IF l_debug_level > 0 THEN
8682: oe_debug_pub.add('Entering Compare_line_attributes');
8683: oe_debug_pub.add('header' ||p_header_id);
8684: oe_debug_pub.add('line' ||p_line_id);
8685: oe_debug_pub.add('line number' ||x_line_number);
8686: oe_debug_pub.add('prior version' ||p_prior_version);
8687: oe_debug_pub.add('current version' ||p_current_version);
8688: oe_debug_pub.add('next version' ||p_next_version);
8689: oe_debug_pub.add('max version' ||g_max_version);
8682: oe_debug_pub.add('Entering Compare_line_attributes');
8683: oe_debug_pub.add('header' ||p_header_id);
8684: oe_debug_pub.add('line' ||p_line_id);
8685: oe_debug_pub.add('line number' ||x_line_number);
8686: oe_debug_pub.add('prior version' ||p_prior_version);
8687: oe_debug_pub.add('current version' ||p_current_version);
8688: oe_debug_pub.add('next version' ||p_next_version);
8689: oe_debug_pub.add('max version' ||g_max_version);
8690: oe_debug_pub.add('trans version' ||g_trans_version);
8683: oe_debug_pub.add('header' ||p_header_id);
8684: oe_debug_pub.add('line' ||p_line_id);
8685: oe_debug_pub.add('line number' ||x_line_number);
8686: oe_debug_pub.add('prior version' ||p_prior_version);
8687: oe_debug_pub.add('current version' ||p_current_version);
8688: oe_debug_pub.add('next version' ||p_next_version);
8689: oe_debug_pub.add('max version' ||g_max_version);
8690: oe_debug_pub.add('trans version' ||g_trans_version);
8691: END IF;
8684: oe_debug_pub.add('line' ||p_line_id);
8685: oe_debug_pub.add('line number' ||x_line_number);
8686: oe_debug_pub.add('prior version' ||p_prior_version);
8687: oe_debug_pub.add('current version' ||p_current_version);
8688: oe_debug_pub.add('next version' ||p_next_version);
8689: oe_debug_pub.add('max version' ||g_max_version);
8690: oe_debug_pub.add('trans version' ||g_trans_version);
8691: END IF;
8692:
8685: oe_debug_pub.add('line number' ||x_line_number);
8686: oe_debug_pub.add('prior version' ||p_prior_version);
8687: oe_debug_pub.add('current version' ||p_current_version);
8688: oe_debug_pub.add('next version' ||p_next_version);
8689: oe_debug_pub.add('max version' ||g_max_version);
8690: oe_debug_pub.add('trans version' ||g_trans_version);
8691: END IF;
8692:
8693: if p_total_lines > 0 THEN
8686: oe_debug_pub.add('prior version' ||p_prior_version);
8687: oe_debug_pub.add('current version' ||p_current_version);
8688: oe_debug_pub.add('next version' ||p_next_version);
8689: oe_debug_pub.add('max version' ||g_max_version);
8690: oe_debug_pub.add('trans version' ||g_trans_version);
8691: END IF;
8692:
8693: if p_total_lines > 0 THEN
8694: IF l_debug_level > 0 THEN
8691: END IF;
8692:
8693: if p_total_lines > 0 THEN
8694: IF l_debug_level > 0 THEN
8695: oe_debug_pub.add(' p_total_lines '||p_total_lines);
8696: end if;
8697: ind := p_total_lines;
8698: ELSE
8699: ind := 0;
8705: p_curr_rec := NULL;
8706: p_next_rec := NULL;
8707:
8708: IF l_debug_level > 0 THEN
8709: oe_debug_pub.add(' Quering prior line version details');
8710: oe_debug_pub.add('prior version' ||p_prior_version);
8711: END IF;
8712: /***************************************/
8713: IF p_prior_version IS NOT NULL THEN
8706: p_next_rec := NULL;
8707:
8708: IF l_debug_level > 0 THEN
8709: oe_debug_pub.add(' Quering prior line version details');
8710: oe_debug_pub.add('prior version' ||p_prior_version);
8711: END IF;
8712: /***************************************/
8713: IF p_prior_version IS NOT NULL THEN
8714: OE_VERSION_COMP.QUERY_LINE_ROW(p_header_id => p_header_id,
8722: p_prior_rec_exists := 'Y';
8723: END IF;
8724: END IF;
8725: IF l_debug_level > 0 THEN
8726: oe_debug_pub.add(' Quering current line version details');
8727: oe_debug_pub.add('current version' ||p_current_version);
8728: END IF;
8729:
8730: IF p_current_version IS NOT NULL THEN
8723: END IF;
8724: END IF;
8725: IF l_debug_level > 0 THEN
8726: oe_debug_pub.add(' Quering current line version details');
8727: oe_debug_pub.add('current version' ||p_current_version);
8728: END IF;
8729:
8730: IF p_current_version IS NOT NULL THEN
8731: OE_VERSION_COMP.QUERY_LINE_ROW(p_header_id => p_header_id,
8740: END IF;
8741:
8742: END IF;
8743: IF l_debug_level > 0 THEN
8744: oe_debug_pub.add(' Quering next/trans line version details');
8745: oe_debug_pub.add('next version' ||p_next_version);
8746: oe_debug_pub.add('trans version' ||g_trans_version);
8747: END IF;
8748: IF p_next_version = g_trans_version then
8741:
8742: END IF;
8743: IF l_debug_level > 0 THEN
8744: oe_debug_pub.add(' Quering next/trans line version details');
8745: oe_debug_pub.add('next version' ||p_next_version);
8746: oe_debug_pub.add('trans version' ||g_trans_version);
8747: END IF;
8748: IF p_next_version = g_trans_version then
8749: IF g_trans_version is not null then
8742: END IF;
8743: IF l_debug_level > 0 THEN
8744: oe_debug_pub.add(' Quering next/trans line version details');
8745: oe_debug_pub.add('next version' ||p_next_version);
8746: oe_debug_pub.add('trans version' ||g_trans_version);
8747: END IF;
8748: IF p_next_version = g_trans_version then
8749: IF g_trans_version is not null then
8750: --p_next_version := g_trans_version;
8777:
8778: --select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;
8779:
8780: IF l_debug_level > 0 THEN
8781: oe_debug_pub.add(' before finding new lines ');
8782: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
8783: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
8784: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
8785: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
8778: --select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;
8779:
8780: IF l_debug_level > 0 THEN
8781: oe_debug_pub.add(' before finding new lines ');
8782: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
8783: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
8784: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
8785: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
8786: END IF;
8779:
8780: IF l_debug_level > 0 THEN
8781: oe_debug_pub.add(' before finding new lines ');
8782: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
8783: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
8784: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
8785: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
8786: END IF;
8787: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR
8780: IF l_debug_level > 0 THEN
8781: oe_debug_pub.add(' before finding new lines ');
8782: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
8783: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
8784: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
8785: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
8786: END IF;
8787: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR
8788: (p_curr_rec_exists = 'N' and p_next_rec_exists ='Y') THEN
8781: oe_debug_pub.add(' before finding new lines ');
8782: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
8783: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
8784: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
8785: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
8786: END IF;
8787: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR
8788: (p_curr_rec_exists = 'N' and p_next_rec_exists ='Y') THEN
8789: IF p_prior_version IS NOT NULL and p_curr_rec_exists = 'Y' THEN
8787: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR
8788: (p_curr_rec_exists = 'N' and p_next_rec_exists ='Y') THEN
8789: IF p_prior_version IS NOT NULL and p_curr_rec_exists = 'Y' THEN
8790: IF l_debug_level > 0 THEN
8791: oe_debug_pub.add(' Prior is not there - current is there');
8792: END IF;
8793: ind := ind+1;
8794: x_line_changed_attr_tbl(ind).line_number := x_line_number;
8795: x_line_changed_attr_tbl(ind).prior_value := null;
8796: x_line_changed_attr_tbl(ind).current_value := 'ADD';
8797: x_line_changed_attr_tbl(ind).next_value := null;
8798: ELSIF (p_curr_rec_exists = 'N' and p_next_rec_exists = 'Y') THEN
8799: IF l_debug_level > 0 THEN
8800: oe_debug_pub.add(' Current is not there - next is there');
8801: END IF;
8802: ind := ind+1;
8803: x_line_changed_attr_tbl(ind).line_number := x_line_number;
8804: x_line_changed_attr_tbl(ind).prior_value := null;
8807: end if;
8808: END IF;
8809:
8810: IF l_debug_level > 0 THEN
8811: oe_debug_pub.add(' before finding deleted lines');
8812: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
8813: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
8814: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
8815: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
8808: END IF;
8809:
8810: IF l_debug_level > 0 THEN
8811: oe_debug_pub.add(' before finding deleted lines');
8812: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
8813: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
8814: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
8815: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
8816: oe_debug_pub.add(' x_line_numer '||x_line_number);
8809:
8810: IF l_debug_level > 0 THEN
8811: oe_debug_pub.add(' before finding deleted lines');
8812: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
8813: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
8814: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
8815: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
8816: oe_debug_pub.add(' x_line_numer '||x_line_number);
8817: END IF;
8810: IF l_debug_level > 0 THEN
8811: oe_debug_pub.add(' before finding deleted lines');
8812: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
8813: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
8814: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
8815: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
8816: oe_debug_pub.add(' x_line_numer '||x_line_number);
8817: END IF;
8818: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR
8811: oe_debug_pub.add(' before finding deleted lines');
8812: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
8813: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
8814: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
8815: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
8816: oe_debug_pub.add(' x_line_numer '||x_line_number);
8817: END IF;
8818: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR
8819: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='N') THEN
8812: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
8813: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
8814: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
8815: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
8816: oe_debug_pub.add(' x_line_numer '||x_line_number);
8817: END IF;
8818: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR
8819: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='N') THEN
8820: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N' THEN
8818: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR
8819: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='N') THEN
8820: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N' THEN
8821: IF l_debug_level > 0 THEN
8822: oe_debug_pub.add(' Prior is there - current is not there');
8823: END IF;
8824: ind := ind+1;
8825: x_line_changed_attr_tbl(ind).line_number := x_line_number;
8826: x_line_changed_attr_tbl(ind).prior_value := null;
8827: x_line_changed_attr_tbl(ind).current_value := 'DELETE';
8828: x_line_changed_attr_tbl(ind).next_value := null;
8829: ELSIF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'N' THEN
8830: IF l_debug_level > 0 THEN
8831: oe_debug_pub.add(' p_next_version'||p_next_version);
8832: oe_debug_pub.add(' g_trans_version'||g_trans_version);
8833: END IF;
8834: --if p_next_version != g_trans_version THEN
8835: IF l_debug_level > 0 THEN
8828: x_line_changed_attr_tbl(ind).next_value := null;
8829: ELSIF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'N' THEN
8830: IF l_debug_level > 0 THEN
8831: oe_debug_pub.add(' p_next_version'||p_next_version);
8832: oe_debug_pub.add(' g_trans_version'||g_trans_version);
8833: END IF;
8834: --if p_next_version != g_trans_version THEN
8835: IF l_debug_level > 0 THEN
8836: oe_debug_pub.add(' Current is there - next is not there');
8832: oe_debug_pub.add(' g_trans_version'||g_trans_version);
8833: END IF;
8834: --if p_next_version != g_trans_version THEN
8835: IF l_debug_level > 0 THEN
8836: oe_debug_pub.add(' Current is there - next is not there');
8837: END IF;
8838: ind := ind+1;
8839: x_line_changed_attr_tbl(ind).line_number := x_line_number;
8840: x_line_changed_attr_tbl(ind).prior_value := null;
8844: end if;
8845: END IF;
8846: --dbms_output.put_line(' No line number'||x_line_number);
8847: IF l_debug_level > 0 THEN
8848: oe_debug_pub.add('******BEFORE COMPARING ATTRIBUTES*************');
8849: oe_debug_pub.add('current ind '|| ind);
8850: END IF;
8851:
8852: IF (p_prior_version IS NOT NULL and p_prior_rec_exists ='Y') OR
8845: END IF;
8846: --dbms_output.put_line(' No line number'||x_line_number);
8847: IF l_debug_level > 0 THEN
8848: oe_debug_pub.add('******BEFORE COMPARING ATTRIBUTES*************');
8849: oe_debug_pub.add('current ind '|| ind);
8850: END IF;
8851:
8852: IF (p_prior_version IS NOT NULL and p_prior_rec_exists ='Y') OR
8853: (p_current_version IS NOT NULL and p_curr_rec_exists ='Y') OR
18614: NULL;
18615: END IF;
18616: END IF; /* line_id not null */
18617: IF l_debug_level > 0 THEN
18618: oe_debug_pub.add('******AFTER COMPARING ATTRIBUTES*************');
18619: oe_debug_pub.add('current ind '|| ind);
18620: END IF;
18621: IF l_debug_level > 0 THEN
18622: oe_debug_pub.add(' Exiting OE_VERSION_COMP.Compare_Line_Attributes ');
18615: END IF;
18616: END IF; /* line_id not null */
18617: IF l_debug_level > 0 THEN
18618: oe_debug_pub.add('******AFTER COMPARING ATTRIBUTES*************');
18619: oe_debug_pub.add('current ind '|| ind);
18620: END IF;
18621: IF l_debug_level > 0 THEN
18622: oe_debug_pub.add(' Exiting OE_VERSION_COMP.Compare_Line_Attributes ');
18623: END IF;
18618: oe_debug_pub.add('******AFTER COMPARING ATTRIBUTES*************');
18619: oe_debug_pub.add('current ind '|| ind);
18620: END IF;
18621: IF l_debug_level > 0 THEN
18622: oe_debug_pub.add(' Exiting OE_VERSION_COMP.Compare_Line_Attributes ');
18623: END IF;
18624: /*
18625: j := 0;
18626: dbms_output.put_line('No of records'||x_line_changed_attr_tbl.count);
18670: and version_number in (p_prior_version,p_current_version,p_next_version);
18671: ind1 NUMBER;
18672: total_lines NUMBER;
18673: x_line_number VARCHAR2(30);
18674: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
18675: BEGIN
18676: IF l_debug_level > 0 THEN
18677: oe_debug_pub.add('Entering Compare_Line_versions');
18678: oe_debug_pub.add('header' ||p_header_id);
18673: x_line_number VARCHAR2(30);
18674: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
18675: BEGIN
18676: IF l_debug_level > 0 THEN
18677: oe_debug_pub.add('Entering Compare_Line_versions');
18678: oe_debug_pub.add('header' ||p_header_id);
18679: oe_debug_pub.add('prior version' ||p_prior_version);
18680: oe_debug_pub.add('current version' ||p_current_version);
18681: oe_debug_pub.add('next version' ||p_next_version);
18674: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
18675: BEGIN
18676: IF l_debug_level > 0 THEN
18677: oe_debug_pub.add('Entering Compare_Line_versions');
18678: oe_debug_pub.add('header' ||p_header_id);
18679: oe_debug_pub.add('prior version' ||p_prior_version);
18680: oe_debug_pub.add('current version' ||p_current_version);
18681: oe_debug_pub.add('next version' ||p_next_version);
18682: oe_debug_pub.add('max version' ||g_max_version);
18675: BEGIN
18676: IF l_debug_level > 0 THEN
18677: oe_debug_pub.add('Entering Compare_Line_versions');
18678: oe_debug_pub.add('header' ||p_header_id);
18679: oe_debug_pub.add('prior version' ||p_prior_version);
18680: oe_debug_pub.add('current version' ||p_current_version);
18681: oe_debug_pub.add('next version' ||p_next_version);
18682: oe_debug_pub.add('max version' ||g_max_version);
18683: oe_debug_pub.add('trans version' ||g_trans_version);
18676: IF l_debug_level > 0 THEN
18677: oe_debug_pub.add('Entering Compare_Line_versions');
18678: oe_debug_pub.add('header' ||p_header_id);
18679: oe_debug_pub.add('prior version' ||p_prior_version);
18680: oe_debug_pub.add('current version' ||p_current_version);
18681: oe_debug_pub.add('next version' ||p_next_version);
18682: oe_debug_pub.add('max version' ||g_max_version);
18683: oe_debug_pub.add('trans version' ||g_trans_version);
18684: END IF;
18677: oe_debug_pub.add('Entering Compare_Line_versions');
18678: oe_debug_pub.add('header' ||p_header_id);
18679: oe_debug_pub.add('prior version' ||p_prior_version);
18680: oe_debug_pub.add('current version' ||p_current_version);
18681: oe_debug_pub.add('next version' ||p_next_version);
18682: oe_debug_pub.add('max version' ||g_max_version);
18683: oe_debug_pub.add('trans version' ||g_trans_version);
18684: END IF;
18685:
18678: oe_debug_pub.add('header' ||p_header_id);
18679: oe_debug_pub.add('prior version' ||p_prior_version);
18680: oe_debug_pub.add('current version' ||p_current_version);
18681: oe_debug_pub.add('next version' ||p_next_version);
18682: oe_debug_pub.add('max version' ||g_max_version);
18683: oe_debug_pub.add('trans version' ||g_trans_version);
18684: END IF;
18685:
18686: ind1:=0;
18679: oe_debug_pub.add('prior version' ||p_prior_version);
18680: oe_debug_pub.add('current version' ||p_current_version);
18681: oe_debug_pub.add('next version' ||p_next_version);
18682: oe_debug_pub.add('max version' ||g_max_version);
18683: oe_debug_pub.add('trans version' ||g_trans_version);
18684: END IF;
18685:
18686: ind1:=0;
18687: total_lines:=0;
18691: LOOP
18692: FETCH C_GET_LINES INTO l_line_id;
18693: EXIT WHEN C_GET_LINES%NOTFOUND;
18694: IF l_debug_level > 0 THEN
18695: oe_debug_pub.add('*************lines found(trans)******************'||l_line_id);
18696: END IF;
18697:
18698: IF l_line_id IS NOT NULL THEN
18699: IF l_debug_level > 0 THEN
18696: END IF;
18697:
18698: IF l_line_id IS NOT NULL THEN
18699: IF l_debug_level > 0 THEN
18700: oe_debug_pub.add('*************before call total lines(trans) ******************'||ind1);
18701: END IF;
18702: select oe_order_misc_pub.get_concat_line_number(l_line_id) into x_line_number from dual;
18703: IF x_line_number IS NULL THEN
18704: -- bug 9299752
18710: end;
18711: -- bug 9299752
18712: END IF;
18713: IF l_debug_level > 0 THEN
18714: oe_debug_pub.add('*************line_number ******************'||x_line_number);
18715: END IF;
18716: COMPARE_LINE_ATTRIBUTES(p_header_id => p_header_id,
18717: p_line_id => l_line_id,
18718: p_prior_version => p_prior_version,
18730: ind1 := x_line_changed_attr_tbl.count;
18731: -- ind1 := ind1 + total_lines;
18732: END IF;
18733: IF l_debug_level > 0 THEN
18734: oe_debug_pub.add('*************after call total lines(trans) ******************'||ind1);
18735: END IF;
18736: END IF; /* line_id is not null */
18737: END LOOP;
18738: CLOSE C_GET_LINES;
18741: LOOP
18742: FETCH C_GET_HIST_LINES INTO l_line_id;
18743: EXIT WHEN C_GET_HIST_LINES%NOTFOUND;
18744: IF l_debug_level > 0 THEN
18745: oe_debug_pub.add('*************lines found******************'||l_line_id);
18746: END IF;
18747:
18748: IF l_line_id IS NOT NULL THEN
18749: IF l_debug_level > 0 THEN
18746: END IF;
18747:
18748: IF l_line_id IS NOT NULL THEN
18749: IF l_debug_level > 0 THEN
18750: oe_debug_pub.add('*************before call total lines ******************'||ind1);
18751: END IF;
18752: -- bug 9299752
18753: begin
18754: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
18770: x_line_changed_attr_tbl => x_line_changed_attr_tbl,
18771: p_total_lines => ind1,
18772: x_line_number => x_line_number);
18773: IF l_debug_level > 0 THEN
18774: oe_debug_pub.add('*************after call total lines ******************'||ind1);
18775: END IF;
18776: IF x_line_changed_attr_tbl.count > 0 THEN
18777: ind1 := x_line_changed_attr_tbl.count;
18778: -- ind1 := ind1 + total_lines;
18793: x_header_scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type)
18794: IS
18795: l_org_id NUMBER;
18796: l_phase_change_flag VARCHAR2(1);
18797: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
18798: BEGIN
18799:
18800: IF l_debug_level > 0 THEN
18801: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_SC_ROW', 1);
18797: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
18798: BEGIN
18799:
18800: IF l_debug_level > 0 THEN
18801: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_SC_ROW', 1);
18802: oe_debug_pub.add('header' ||p_header_id);
18803: oe_debug_pub.add('sales credit' ||p_sales_credit_id);
18804: oe_debug_pub.add('version' ||p_version);
18805: END IF;
18798: BEGIN
18799:
18800: IF l_debug_level > 0 THEN
18801: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_SC_ROW', 1);
18802: oe_debug_pub.add('header' ||p_header_id);
18803: oe_debug_pub.add('sales credit' ||p_sales_credit_id);
18804: oe_debug_pub.add('version' ||p_version);
18805: END IF;
18806:
18799:
18800: IF l_debug_level > 0 THEN
18801: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_SC_ROW', 1);
18802: oe_debug_pub.add('header' ||p_header_id);
18803: oe_debug_pub.add('sales credit' ||p_sales_credit_id);
18804: oe_debug_pub.add('version' ||p_version);
18805: END IF;
18806:
18807: l_org_id := OE_GLOBALS.G_ORG_ID;
18800: IF l_debug_level > 0 THEN
18801: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_SC_ROW', 1);
18802: oe_debug_pub.add('header' ||p_header_id);
18803: oe_debug_pub.add('sales credit' ||p_sales_credit_id);
18804: oe_debug_pub.add('version' ||p_version);
18805: END IF;
18806:
18807: l_org_id := OE_GLOBALS.G_ORG_ID;
18808:
18911: x_header_scredit_rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type)
18912: IS
18913: l_org_id NUMBER;
18914: l_phase_change_flag VARCHAR2(1);
18915: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
18916: BEGIN
18917: IF l_debug_level > 0 THEN
18918: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_SC_TRANS_ROW');
18919: oe_debug_pub.add('header' ||p_header_id);
18914: l_phase_change_flag VARCHAR2(1);
18915: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
18916: BEGIN
18917: IF l_debug_level > 0 THEN
18918: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_SC_TRANS_ROW');
18919: oe_debug_pub.add('header' ||p_header_id);
18920: oe_debug_pub.add('version' ||p_version);
18921: END IF;
18922:
18915: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
18916: BEGIN
18917: IF l_debug_level > 0 THEN
18918: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_SC_TRANS_ROW');
18919: oe_debug_pub.add('header' ||p_header_id);
18920: oe_debug_pub.add('version' ||p_version);
18921: END IF;
18922:
18923: l_org_id := OE_GLOBALS.G_ORG_ID;
18916: BEGIN
18917: IF l_debug_level > 0 THEN
18918: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_SC_TRANS_ROW');
18919: oe_debug_pub.add('header' ||p_header_id);
18920: oe_debug_pub.add('version' ||p_version);
18921: END IF;
18922:
18923: l_org_id := OE_GLOBALS.G_ORG_ID;
18924:
19038: v_header_col VARCHAR2(50);
19039: ind NUMBER;
19040: prior_exists VARCHAR2(1) := 'N';
19041: j NUMBER;
19042: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
19043: p_prior_rec_exists VARCHAR2(1) := 'N';
19044: p_curr_rec_exists VARCHAR2(1) := 'N';
19045: p_next_rec_exists VARCHAR2(1) := 'N';
19046: p_trans_rec_exists VARCHAR2(1) := 'N';
19046: p_trans_rec_exists VARCHAR2(1) := 'N';
19047: BEGIN
19048:
19049: IF l_debug_level > 0 THEN
19050: oe_debug_pub.add('Entering comparing_header_sc_attributes');
19051: oe_debug_pub.add('header' ||p_header_id);
19052: oe_debug_pub.add('Sales Credit' ||p_sales_credit_id);
19053: oe_debug_pub.add('prior version' ||p_prior_version);
19054: oe_debug_pub.add('current version' ||p_current_version);
19047: BEGIN
19048:
19049: IF l_debug_level > 0 THEN
19050: oe_debug_pub.add('Entering comparing_header_sc_attributes');
19051: oe_debug_pub.add('header' ||p_header_id);
19052: oe_debug_pub.add('Sales Credit' ||p_sales_credit_id);
19053: oe_debug_pub.add('prior version' ||p_prior_version);
19054: oe_debug_pub.add('current version' ||p_current_version);
19055: oe_debug_pub.add('next version' ||p_next_version);
19048:
19049: IF l_debug_level > 0 THEN
19050: oe_debug_pub.add('Entering comparing_header_sc_attributes');
19051: oe_debug_pub.add('header' ||p_header_id);
19052: oe_debug_pub.add('Sales Credit' ||p_sales_credit_id);
19053: oe_debug_pub.add('prior version' ||p_prior_version);
19054: oe_debug_pub.add('current version' ||p_current_version);
19055: oe_debug_pub.add('next version' ||p_next_version);
19056: oe_debug_pub.add('max version' ||g_max_version);
19049: IF l_debug_level > 0 THEN
19050: oe_debug_pub.add('Entering comparing_header_sc_attributes');
19051: oe_debug_pub.add('header' ||p_header_id);
19052: oe_debug_pub.add('Sales Credit' ||p_sales_credit_id);
19053: oe_debug_pub.add('prior version' ||p_prior_version);
19054: oe_debug_pub.add('current version' ||p_current_version);
19055: oe_debug_pub.add('next version' ||p_next_version);
19056: oe_debug_pub.add('max version' ||g_max_version);
19057: oe_debug_pub.add('trans version' ||g_trans_version);
19050: oe_debug_pub.add('Entering comparing_header_sc_attributes');
19051: oe_debug_pub.add('header' ||p_header_id);
19052: oe_debug_pub.add('Sales Credit' ||p_sales_credit_id);
19053: oe_debug_pub.add('prior version' ||p_prior_version);
19054: oe_debug_pub.add('current version' ||p_current_version);
19055: oe_debug_pub.add('next version' ||p_next_version);
19056: oe_debug_pub.add('max version' ||g_max_version);
19057: oe_debug_pub.add('trans version' ||g_trans_version);
19058: END IF;
19051: oe_debug_pub.add('header' ||p_header_id);
19052: oe_debug_pub.add('Sales Credit' ||p_sales_credit_id);
19053: oe_debug_pub.add('prior version' ||p_prior_version);
19054: oe_debug_pub.add('current version' ||p_current_version);
19055: oe_debug_pub.add('next version' ||p_next_version);
19056: oe_debug_pub.add('max version' ||g_max_version);
19057: oe_debug_pub.add('trans version' ||g_trans_version);
19058: END IF;
19059:
19052: oe_debug_pub.add('Sales Credit' ||p_sales_credit_id);
19053: oe_debug_pub.add('prior version' ||p_prior_version);
19054: oe_debug_pub.add('current version' ||p_current_version);
19055: oe_debug_pub.add('next version' ||p_next_version);
19056: oe_debug_pub.add('max version' ||g_max_version);
19057: oe_debug_pub.add('trans version' ||g_trans_version);
19058: END IF;
19059:
19060: if p_total_lines > 0 THEN
19053: oe_debug_pub.add('prior version' ||p_prior_version);
19054: oe_debug_pub.add('current version' ||p_current_version);
19055: oe_debug_pub.add('next version' ||p_next_version);
19056: oe_debug_pub.add('max version' ||g_max_version);
19057: oe_debug_pub.add('trans version' ||g_trans_version);
19058: END IF;
19059:
19060: if p_total_lines > 0 THEN
19061: IF l_debug_level > 0 THEN
19058: END IF;
19059:
19060: if p_total_lines > 0 THEN
19061: IF l_debug_level > 0 THEN
19062: oe_debug_pub.add(' p_total_lines '||p_total_lines);
19063: end if;
19064: ind := p_total_lines;
19065: ELSE
19066: ind := 0;
19072: p_curr_rec := NULL;
19073: p_next_rec := NULL;
19074:
19075: IF l_debug_level > 0 THEN
19076: oe_debug_pub.add(' Quering prior line version details');
19077: oe_debug_pub.add('prior version' ||p_prior_version);
19078: END IF;
19079:
19080: IF p_prior_version IS NOT NULL THEN
19073: p_next_rec := NULL;
19074:
19075: IF l_debug_level > 0 THEN
19076: oe_debug_pub.add(' Quering prior line version details');
19077: oe_debug_pub.add('prior version' ||p_prior_version);
19078: END IF;
19079:
19080: IF p_prior_version IS NOT NULL THEN
19081: OE_VERSION_COMP.QUERY_HEADER_SC_ROW(p_header_id => p_header_id,
19089: p_prior_rec_exists := 'Y';
19090: END IF;
19091: END IF;
19092: IF l_debug_level > 0 THEN
19093: oe_debug_pub.add(' Quering current line version details');
19094: oe_debug_pub.add('current version' ||p_current_version);
19095: END IF;
19096:
19097: IF p_current_version IS NOT NULL THEN
19090: END IF;
19091: END IF;
19092: IF l_debug_level > 0 THEN
19093: oe_debug_pub.add(' Quering current line version details');
19094: oe_debug_pub.add('current version' ||p_current_version);
19095: END IF;
19096:
19097: IF p_current_version IS NOT NULL THEN
19098: OE_VERSION_COMP.QUERY_HEADER_SC_ROW(p_header_id => p_header_id,
19107: END IF;
19108:
19109: END IF;
19110: IF l_debug_level > 0 THEN
19111: oe_debug_pub.add(' Quering next/trans line version details');
19112: oe_debug_pub.add('next version' ||p_next_version);
19113: oe_debug_pub.add('trans version' ||g_trans_version);
19114: END IF;
19115:
19108:
19109: END IF;
19110: IF l_debug_level > 0 THEN
19111: oe_debug_pub.add(' Quering next/trans line version details');
19112: oe_debug_pub.add('next version' ||p_next_version);
19113: oe_debug_pub.add('trans version' ||g_trans_version);
19114: END IF;
19115:
19116: IF p_next_version = g_trans_version then
19109: END IF;
19110: IF l_debug_level > 0 THEN
19111: oe_debug_pub.add(' Quering next/trans line version details');
19112: oe_debug_pub.add('next version' ||p_next_version);
19113: oe_debug_pub.add('trans version' ||g_trans_version);
19114: END IF;
19115:
19116: IF p_next_version = g_trans_version then
19117: IF g_trans_version is not null then
19141: END IF;
19142: END IF;
19143:
19144: IF l_debug_level > 0 THEN
19145: oe_debug_pub.add(' p_prior_rec salesrep'||p_prior_rec.salesrep_id);
19146: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.salesrep_id);
19147: oe_debug_pub.add(' p_next_rec '||p_next_rec.salesrep_id);
19148: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);
19149: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
19142: END IF;
19143:
19144: IF l_debug_level > 0 THEN
19145: oe_debug_pub.add(' p_prior_rec salesrep'||p_prior_rec.salesrep_id);
19146: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.salesrep_id);
19147: oe_debug_pub.add(' p_next_rec '||p_next_rec.salesrep_id);
19148: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);
19149: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
19150: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
19143:
19144: IF l_debug_level > 0 THEN
19145: oe_debug_pub.add(' p_prior_rec salesrep'||p_prior_rec.salesrep_id);
19146: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.salesrep_id);
19147: oe_debug_pub.add(' p_next_rec '||p_next_rec.salesrep_id);
19148: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);
19149: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
19150: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
19151: oe_debug_pub.add(' checking whether salesreps are same or not');
19144: IF l_debug_level > 0 THEN
19145: oe_debug_pub.add(' p_prior_rec salesrep'||p_prior_rec.salesrep_id);
19146: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.salesrep_id);
19147: oe_debug_pub.add(' p_next_rec '||p_next_rec.salesrep_id);
19148: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);
19149: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
19150: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
19151: oe_debug_pub.add(' checking whether salesreps are same or not');
19152: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
19145: oe_debug_pub.add(' p_prior_rec salesrep'||p_prior_rec.salesrep_id);
19146: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.salesrep_id);
19147: oe_debug_pub.add(' p_next_rec '||p_next_rec.salesrep_id);
19148: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);
19149: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
19150: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
19151: oe_debug_pub.add(' checking whether salesreps are same or not');
19152: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
19153: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
19146: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.salesrep_id);
19147: oe_debug_pub.add(' p_next_rec '||p_next_rec.salesrep_id);
19148: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);
19149: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
19150: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
19151: oe_debug_pub.add(' checking whether salesreps are same or not');
19152: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
19153: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
19154: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
19147: oe_debug_pub.add(' p_next_rec '||p_next_rec.salesrep_id);
19148: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);
19149: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
19150: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
19151: oe_debug_pub.add(' checking whether salesreps are same or not');
19152: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
19153: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
19154: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
19155: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
19148: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);
19149: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
19150: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
19151: oe_debug_pub.add(' checking whether salesreps are same or not');
19152: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
19153: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
19154: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
19155: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
19156: END IF;
19149: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
19150: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
19151: oe_debug_pub.add(' checking whether salesreps are same or not');
19152: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
19153: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
19154: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
19155: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
19156: END IF;
19157: IF l_debug_level > 0 THEN
19150: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
19151: oe_debug_pub.add(' checking whether salesreps are same or not');
19152: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
19153: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
19154: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
19155: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
19156: END IF;
19157: IF l_debug_level > 0 THEN
19158: oe_debug_pub.add('******AFTER COMPARING SC ATTRIBUTES*************');
19151: oe_debug_pub.add(' checking whether salesreps are same or not');
19152: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
19153: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
19154: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
19155: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
19156: END IF;
19157: IF l_debug_level > 0 THEN
19158: oe_debug_pub.add('******AFTER COMPARING SC ATTRIBUTES*************');
19159: oe_debug_pub.add('current ind '|| ind);
19154: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
19155: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
19156: END IF;
19157: IF l_debug_level > 0 THEN
19158: oe_debug_pub.add('******AFTER COMPARING SC ATTRIBUTES*************');
19159: oe_debug_pub.add('current ind '|| ind);
19160: END IF;
19161: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists ='Y') OR
19162: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='Y') THEN
19155: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
19156: END IF;
19157: IF l_debug_level > 0 THEN
19158: oe_debug_pub.add('******AFTER COMPARING SC ATTRIBUTES*************');
19159: oe_debug_pub.add('current ind '|| ind);
19160: END IF;
19161: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists ='Y') OR
19162: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='Y') THEN
19163: IF l_debug_level > 0 THEN
19160: END IF;
19161: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists ='Y') OR
19162: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='Y') THEN
19163: IF l_debug_level > 0 THEN
19164: oe_debug_pub.add(' both exists - checking if both are same');
19165: END IF;
19166: IF OE_Globals.Equal(p_prior_rec.salesrep_id,p_curr_rec.salesrep_id) OR
19167: OE_Globals.Equal( p_curr_rec.salesrep_id, p_next_rec.salesrep_id) THEN
19168: /****************************/
19995: END IF;
19996: END IF; /* p and c = Y or c and n=y */
19997:
19998: IF l_debug_level > 0 THEN
19999: oe_debug_pub.add(' before finding new sales credits ');
20000: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20001: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20002: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
20003: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
19996: END IF; /* p and c = Y or c and n=y */
19997:
19998: IF l_debug_level > 0 THEN
19999: oe_debug_pub.add(' before finding new sales credits ');
20000: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20001: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20002: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
20003: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
20004: END IF;
19997:
19998: IF l_debug_level > 0 THEN
19999: oe_debug_pub.add(' before finding new sales credits ');
20000: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20001: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20002: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
20003: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
20004: END IF;
20005: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR
19998: IF l_debug_level > 0 THEN
19999: oe_debug_pub.add(' before finding new sales credits ');
20000: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20001: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20002: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
20003: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
20004: END IF;
20005: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR
20006: (p_curr_rec_exists = 'N' and p_next_rec_exists ='Y') THEN
19999: oe_debug_pub.add(' before finding new sales credits ');
20000: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20001: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20002: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
20003: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
20004: END IF;
20005: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR
20006: (p_curr_rec_exists = 'N' and p_next_rec_exists ='Y') THEN
20007: IF p_prior_version IS NOT NULL and p_curr_rec_exists = 'Y' THEN
20005: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR
20006: (p_curr_rec_exists = 'N' and p_next_rec_exists ='Y') THEN
20007: IF p_prior_version IS NOT NULL and p_curr_rec_exists = 'Y' THEN
20008: IF l_debug_level > 0 THEN
20009: oe_debug_pub.add(' Prior is not there - current is there');
20010: END IF;
20011: ind := ind+1;
20012: x_header_sc_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.Salesrep(p_curr_rec.salesrep_id);
20013: x_header_sc_changed_attr_tbl(ind).prior_value := null;
20014: x_header_sc_changed_attr_tbl(ind).current_value := 'ADD';
20015: x_header_sc_changed_attr_tbl(ind).next_value := null;
20016: ELSIF (p_curr_rec_exists = 'N' and p_next_rec_exists = 'Y') THEN
20017: IF l_debug_level > 0 THEN
20018: oe_debug_pub.add(' Current is not there - next is there');
20019: END IF;
20020: ind := ind+1;
20021: x_header_sc_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.Salesrep(p_next_rec.salesrep_id);
20022: x_header_sc_changed_attr_tbl(ind).prior_value := null;
20025: end if;
20026: END IF;
20027:
20028: IF l_debug_level > 0 THEN
20029: oe_debug_pub.add(' before finding deleted salesreps');
20030: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20031: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20032: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
20033: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
20026: END IF;
20027:
20028: IF l_debug_level > 0 THEN
20029: oe_debug_pub.add(' before finding deleted salesreps');
20030: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20031: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20032: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
20033: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
20034: END IF;
20027:
20028: IF l_debug_level > 0 THEN
20029: oe_debug_pub.add(' before finding deleted salesreps');
20030: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20031: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20032: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
20033: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
20034: END IF;
20035: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR
20028: IF l_debug_level > 0 THEN
20029: oe_debug_pub.add(' before finding deleted salesreps');
20030: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20031: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20032: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
20033: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
20034: END IF;
20035: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR
20036: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='N') THEN
20029: oe_debug_pub.add(' before finding deleted salesreps');
20030: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20031: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20032: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
20033: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
20034: END IF;
20035: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR
20036: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='N') THEN
20037: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N' THEN
20035: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR
20036: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='N') THEN
20037: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N' THEN
20038: IF l_debug_level > 0 THEN
20039: oe_debug_pub.add(' Prior is there - current is not there');
20040: END IF;
20041: ind := ind+1;
20042: x_header_sc_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.Salesrep(p_prior_rec.salesrep_id);
20043: x_header_sc_changed_attr_tbl(ind).prior_value := null;
20044: x_header_sc_changed_attr_tbl(ind).current_value := 'DELETE';
20045: x_header_sc_changed_attr_tbl(ind).next_value := null;
20046: ELSIF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'N' THEN
20047: IF l_debug_level > 0 THEN
20048: oe_debug_pub.add(' p_next_version'||p_next_version);
20049: oe_debug_pub.add(' g_trans_version'||g_trans_version);
20050: END IF;
20051: --if p_next_version != g_trans_version THEN
20052: IF l_debug_level > 0 THEN
20045: x_header_sc_changed_attr_tbl(ind).next_value := null;
20046: ELSIF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'N' THEN
20047: IF l_debug_level > 0 THEN
20048: oe_debug_pub.add(' p_next_version'||p_next_version);
20049: oe_debug_pub.add(' g_trans_version'||g_trans_version);
20050: END IF;
20051: --if p_next_version != g_trans_version THEN
20052: IF l_debug_level > 0 THEN
20053: oe_debug_pub.add(' Current is there - next is not there');
20049: oe_debug_pub.add(' g_trans_version'||g_trans_version);
20050: END IF;
20051: --if p_next_version != g_trans_version THEN
20052: IF l_debug_level > 0 THEN
20053: oe_debug_pub.add(' Current is there - next is not there');
20054: END IF;
20055: ind := ind+1;
20056: x_header_sc_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.Salesrep(p_curr_rec.salesrep_id);
20057: x_header_sc_changed_attr_tbl(ind).prior_value := null;
20060: --end if;
20061: end if;
20062: END IF;
20063: IF l_debug_level > 0 THEN
20064: oe_debug_pub.add('******BEFORE COMPARING ATTRIBUTES*************');
20065: oe_debug_pub.add('current ind '|| ind);
20066: END IF;
20067:
20068: END IF; /* line_id not null */
20061: end if;
20062: END IF;
20063: IF l_debug_level > 0 THEN
20064: oe_debug_pub.add('******BEFORE COMPARING ATTRIBUTES*************');
20065: oe_debug_pub.add('current ind '|| ind);
20066: END IF;
20067:
20068: END IF; /* line_id not null */
20069: IF l_debug_level > 0 THEN
20066: END IF;
20067:
20068: END IF; /* line_id not null */
20069: IF l_debug_level > 0 THEN
20070: oe_debug_pub.add(' Exiting OE_VERSION_COMP.Compare_header_sc_Attributes ');
20071: END IF;
20072: /*
20073: j := 0;
20074: dbms_output.put_line('No of resales dreditcords'||x_header_sc_changed_attr_tbl.count);
20124: ind1 NUMBER;
20125: l_sales_credit_id NUMBER;
20126: total_lines NUMBER;
20127: x_sales_rep VARCHAR2(200);
20128: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
20129: BEGIN
20130: IF l_debug_level > 0 THEN
20131: oe_debug_pub.add('Entering Compare_header_sc_versions');
20132: oe_debug_pub.add('header' ||p_header_id);
20127: x_sales_rep VARCHAR2(200);
20128: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
20129: BEGIN
20130: IF l_debug_level > 0 THEN
20131: oe_debug_pub.add('Entering Compare_header_sc_versions');
20132: oe_debug_pub.add('header' ||p_header_id);
20133: oe_debug_pub.add('prior version' ||p_prior_version);
20134: oe_debug_pub.add('current version' ||p_current_version);
20135: oe_debug_pub.add('next version' ||p_next_version);
20128: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
20129: BEGIN
20130: IF l_debug_level > 0 THEN
20131: oe_debug_pub.add('Entering Compare_header_sc_versions');
20132: oe_debug_pub.add('header' ||p_header_id);
20133: oe_debug_pub.add('prior version' ||p_prior_version);
20134: oe_debug_pub.add('current version' ||p_current_version);
20135: oe_debug_pub.add('next version' ||p_next_version);
20136: oe_debug_pub.add('max version' ||g_max_version);
20129: BEGIN
20130: IF l_debug_level > 0 THEN
20131: oe_debug_pub.add('Entering Compare_header_sc_versions');
20132: oe_debug_pub.add('header' ||p_header_id);
20133: oe_debug_pub.add('prior version' ||p_prior_version);
20134: oe_debug_pub.add('current version' ||p_current_version);
20135: oe_debug_pub.add('next version' ||p_next_version);
20136: oe_debug_pub.add('max version' ||g_max_version);
20137: oe_debug_pub.add('trans version' ||g_trans_version);
20130: IF l_debug_level > 0 THEN
20131: oe_debug_pub.add('Entering Compare_header_sc_versions');
20132: oe_debug_pub.add('header' ||p_header_id);
20133: oe_debug_pub.add('prior version' ||p_prior_version);
20134: oe_debug_pub.add('current version' ||p_current_version);
20135: oe_debug_pub.add('next version' ||p_next_version);
20136: oe_debug_pub.add('max version' ||g_max_version);
20137: oe_debug_pub.add('trans version' ||g_trans_version);
20138: END IF;
20131: oe_debug_pub.add('Entering Compare_header_sc_versions');
20132: oe_debug_pub.add('header' ||p_header_id);
20133: oe_debug_pub.add('prior version' ||p_prior_version);
20134: oe_debug_pub.add('current version' ||p_current_version);
20135: oe_debug_pub.add('next version' ||p_next_version);
20136: oe_debug_pub.add('max version' ||g_max_version);
20137: oe_debug_pub.add('trans version' ||g_trans_version);
20138: END IF;
20139:
20132: oe_debug_pub.add('header' ||p_header_id);
20133: oe_debug_pub.add('prior version' ||p_prior_version);
20134: oe_debug_pub.add('current version' ||p_current_version);
20135: oe_debug_pub.add('next version' ||p_next_version);
20136: oe_debug_pub.add('max version' ||g_max_version);
20137: oe_debug_pub.add('trans version' ||g_trans_version);
20138: END IF;
20139:
20140: ind1:=0;
20133: oe_debug_pub.add('prior version' ||p_prior_version);
20134: oe_debug_pub.add('current version' ||p_current_version);
20135: oe_debug_pub.add('next version' ||p_next_version);
20136: oe_debug_pub.add('max version' ||g_max_version);
20137: oe_debug_pub.add('trans version' ||g_trans_version);
20138: END IF;
20139:
20140: ind1:=0;
20141: total_lines:=0;
20145: LOOP
20146: FETCH C_GET_sales_credits INTO l_sales_credit_id;
20147: EXIT WHEN C_GET_sales_credits%NOTFOUND;
20148: IF l_debug_level > 0 THEN
20149: oe_debug_pub.add('*************sales_credits found(trans)******************'||l_sales_credit_id); END IF;
20150:
20151: IF l_sales_credit_id IS NOT NULL THEN
20152: IF l_debug_level > 0 THEN
20153: oe_debug_pub.add('*************before call total sales_credits(trans) ******************'||ind1);
20149: oe_debug_pub.add('*************sales_credits found(trans)******************'||l_sales_credit_id); END IF;
20150:
20151: IF l_sales_credit_id IS NOT NULL THEN
20152: IF l_debug_level > 0 THEN
20153: oe_debug_pub.add('*************before call total sales_credits(trans) ******************'||ind1);
20154: END IF;
20155: COMPARE_HEADER_SC_ATTRIBUTES(p_header_id => p_header_id,
20156: p_sales_credit_id => l_sales_credit_id,
20157: p_prior_version => p_prior_version,
20168: ind1 := x_header_sc_changed_attr_tbl.count;
20169: -- ind1 := ind1 + total_lines;
20170: END IF;
20171: IF l_debug_level > 0 THEN
20172: oe_debug_pub.add('*************after call total sales_credits(trans) ******************'||ind1);
20173: END IF;
20174: END IF; /* sales_Credit_id is not null */
20175: END LOOP;
20176: CLOSE C_GET_sales_credits;
20179: LOOP
20180: FETCH C_GET_HIST_sales_credits INTO l_sales_credit_id;
20181: EXIT WHEN C_GET_HIST_sales_credits%NOTFOUND;
20182: IF l_debug_level > 0 THEN
20183: oe_debug_pub.add('*************sales_credits found******************'||l_sales_credit_id);
20184: END IF;
20185:
20186: IF l_sales_credit_id IS NOT NULL THEN
20187: IF l_debug_level > 0 THEN
20184: END IF;
20185:
20186: IF l_sales_credit_id IS NOT NULL THEN
20187: IF l_debug_level > 0 THEN
20188: oe_debug_pub.add('*************before call total sales_credits ******************'||ind1);
20189: END IF;
20190: COMPARE_HEADER_SC_ATTRIBUTES(p_header_id => p_header_id,
20191: p_sales_credit_id => l_sales_credit_id,
20192: p_prior_version => p_prior_version,
20199: g_next_phase_change_flag => g_next_phase_change_flag,
20200: x_header_sc_changed_attr_tbl => x_header_sc_changed_attr_tbl,
20201: p_total_lines => ind1);
20202: IF l_debug_level > 0 THEN
20203: oe_debug_pub.add('*************after call total sales credits ******************'||ind1);
20204: END IF;
20205: IF x_header_sc_changed_attr_tbl.count > 0 THEN
20206: ind1 := x_header_sc_changed_attr_tbl.count;
20207: -- ind1 := ind1 + total_lines;
20223: l_org_id NUMBER;
20224: l_phase_change_flag VARCHAR2(1);
20225: BEGIN
20226:
20227: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_line_SC_ROW', 1);
20228:
20229: l_org_id := OE_GLOBALS.G_ORG_ID;
20230:
20231: IF l_org_id IS NULL THEN
20333: x_line_scredit_rec IN OUT NOCOPY OE_Order_PUB.line_Scredit_Rec_Type)
20334: IS
20335: l_org_id NUMBER;
20336: l_phase_change_flag VARCHAR2(1);
20337: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
20338: BEGIN
20339: IF l_debug_level > 0 THEN
20340: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_line_SC_TRANS_ROW');
20341: oe_debug_pub.add('header' ||p_header_id);
20336: l_phase_change_flag VARCHAR2(1);
20337: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
20338: BEGIN
20339: IF l_debug_level > 0 THEN
20340: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_line_SC_TRANS_ROW');
20341: oe_debug_pub.add('header' ||p_header_id);
20342: oe_debug_pub.add('version' ||p_version);
20343: END IF;
20344:
20337: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
20338: BEGIN
20339: IF l_debug_level > 0 THEN
20340: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_line_SC_TRANS_ROW');
20341: oe_debug_pub.add('header' ||p_header_id);
20342: oe_debug_pub.add('version' ||p_version);
20343: END IF;
20344:
20345: l_org_id := OE_GLOBALS.G_ORG_ID;
20338: BEGIN
20339: IF l_debug_level > 0 THEN
20340: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_line_SC_TRANS_ROW');
20341: oe_debug_pub.add('header' ||p_header_id);
20342: oe_debug_pub.add('version' ||p_version);
20343: END IF;
20344:
20345: l_org_id := OE_GLOBALS.G_ORG_ID;
20346:
20462: v_line_col VARCHAR2(50);
20463: ind NUMBER;
20464: prior_exists VARCHAR2(1) := 'N';
20465: j NUMBER;
20466: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
20467: p_prior_rec_exists VARCHAR2(1) := 'N';
20468: p_curr_rec_exists VARCHAR2(1) := 'N';
20469: p_next_rec_exists VARCHAR2(1) := 'N';
20470: p_trans_rec_exists VARCHAR2(1) := 'N';
20470: p_trans_rec_exists VARCHAR2(1) := 'N';
20471: BEGIN
20472:
20473: IF l_debug_level > 0 THEN
20474: oe_debug_pub.add('Entering comparing_line_sc_attributes');
20475: oe_debug_pub.add('header' ||p_header_id);
20476: oe_debug_pub.add('Sales Credit' ||p_sales_credit_id);
20477: oe_debug_pub.add('prior version' ||p_prior_version);
20478: oe_debug_pub.add('current version' ||p_current_version);
20471: BEGIN
20472:
20473: IF l_debug_level > 0 THEN
20474: oe_debug_pub.add('Entering comparing_line_sc_attributes');
20475: oe_debug_pub.add('header' ||p_header_id);
20476: oe_debug_pub.add('Sales Credit' ||p_sales_credit_id);
20477: oe_debug_pub.add('prior version' ||p_prior_version);
20478: oe_debug_pub.add('current version' ||p_current_version);
20479: oe_debug_pub.add('next version' ||p_next_version);
20472:
20473: IF l_debug_level > 0 THEN
20474: oe_debug_pub.add('Entering comparing_line_sc_attributes');
20475: oe_debug_pub.add('header' ||p_header_id);
20476: oe_debug_pub.add('Sales Credit' ||p_sales_credit_id);
20477: oe_debug_pub.add('prior version' ||p_prior_version);
20478: oe_debug_pub.add('current version' ||p_current_version);
20479: oe_debug_pub.add('next version' ||p_next_version);
20480: oe_debug_pub.add('max version' ||g_max_version);
20473: IF l_debug_level > 0 THEN
20474: oe_debug_pub.add('Entering comparing_line_sc_attributes');
20475: oe_debug_pub.add('header' ||p_header_id);
20476: oe_debug_pub.add('Sales Credit' ||p_sales_credit_id);
20477: oe_debug_pub.add('prior version' ||p_prior_version);
20478: oe_debug_pub.add('current version' ||p_current_version);
20479: oe_debug_pub.add('next version' ||p_next_version);
20480: oe_debug_pub.add('max version' ||g_max_version);
20481: oe_debug_pub.add('trans version' ||g_trans_version);
20474: oe_debug_pub.add('Entering comparing_line_sc_attributes');
20475: oe_debug_pub.add('header' ||p_header_id);
20476: oe_debug_pub.add('Sales Credit' ||p_sales_credit_id);
20477: oe_debug_pub.add('prior version' ||p_prior_version);
20478: oe_debug_pub.add('current version' ||p_current_version);
20479: oe_debug_pub.add('next version' ||p_next_version);
20480: oe_debug_pub.add('max version' ||g_max_version);
20481: oe_debug_pub.add('trans version' ||g_trans_version);
20482: END IF;
20475: oe_debug_pub.add('header' ||p_header_id);
20476: oe_debug_pub.add('Sales Credit' ||p_sales_credit_id);
20477: oe_debug_pub.add('prior version' ||p_prior_version);
20478: oe_debug_pub.add('current version' ||p_current_version);
20479: oe_debug_pub.add('next version' ||p_next_version);
20480: oe_debug_pub.add('max version' ||g_max_version);
20481: oe_debug_pub.add('trans version' ||g_trans_version);
20482: END IF;
20483:
20476: oe_debug_pub.add('Sales Credit' ||p_sales_credit_id);
20477: oe_debug_pub.add('prior version' ||p_prior_version);
20478: oe_debug_pub.add('current version' ||p_current_version);
20479: oe_debug_pub.add('next version' ||p_next_version);
20480: oe_debug_pub.add('max version' ||g_max_version);
20481: oe_debug_pub.add('trans version' ||g_trans_version);
20482: END IF;
20483:
20484: if p_total_lines > 0 THEN
20477: oe_debug_pub.add('prior version' ||p_prior_version);
20478: oe_debug_pub.add('current version' ||p_current_version);
20479: oe_debug_pub.add('next version' ||p_next_version);
20480: oe_debug_pub.add('max version' ||g_max_version);
20481: oe_debug_pub.add('trans version' ||g_trans_version);
20482: END IF;
20483:
20484: if p_total_lines > 0 THEN
20485: IF l_debug_level > 0 THEN
20482: END IF;
20483:
20484: if p_total_lines > 0 THEN
20485: IF l_debug_level > 0 THEN
20486: oe_debug_pub.add(' p_total_lines '||p_total_lines);
20487: end if;
20488: ind := p_total_lines;
20489: ELSE
20490: ind := 0;
20496: p_curr_rec := NULL;
20497: p_next_rec := NULL;
20498:
20499: IF l_debug_level > 0 THEN
20500: oe_debug_pub.add(' Quering prior line version details');
20501: oe_debug_pub.add('prior version' ||p_prior_version);
20502: END IF;
20503:
20504: IF p_prior_version IS NOT NULL THEN
20497: p_next_rec := NULL;
20498:
20499: IF l_debug_level > 0 THEN
20500: oe_debug_pub.add(' Quering prior line version details');
20501: oe_debug_pub.add('prior version' ||p_prior_version);
20502: END IF;
20503:
20504: IF p_prior_version IS NOT NULL THEN
20505: OE_VERSION_COMP.QUERY_line_SC_ROW(p_header_id => p_header_id,
20513: p_prior_rec_exists := 'Y';
20514: END IF;
20515: END IF;
20516: IF l_debug_level > 0 THEN
20517: oe_debug_pub.add(' Quering current line version details');
20518: oe_debug_pub.add('current version' ||p_current_version);
20519: END IF;
20520:
20521: IF p_current_version IS NOT NULL THEN
20514: END IF;
20515: END IF;
20516: IF l_debug_level > 0 THEN
20517: oe_debug_pub.add(' Quering current line version details');
20518: oe_debug_pub.add('current version' ||p_current_version);
20519: END IF;
20520:
20521: IF p_current_version IS NOT NULL THEN
20522: OE_VERSION_COMP.QUERY_line_SC_ROW(p_header_id => p_header_id,
20531: END IF;
20532:
20533: END IF;
20534: IF l_debug_level > 0 THEN
20535: oe_debug_pub.add(' Quering next/trans line version details');
20536: oe_debug_pub.add('next version' ||p_next_version);
20537: oe_debug_pub.add('trans version' ||g_trans_version);
20538: END IF;
20539:
20532:
20533: END IF;
20534: IF l_debug_level > 0 THEN
20535: oe_debug_pub.add(' Quering next/trans line version details');
20536: oe_debug_pub.add('next version' ||p_next_version);
20537: oe_debug_pub.add('trans version' ||g_trans_version);
20538: END IF;
20539:
20540: IF p_next_version = g_trans_version then
20533: END IF;
20534: IF l_debug_level > 0 THEN
20535: oe_debug_pub.add(' Quering next/trans line version details');
20536: oe_debug_pub.add('next version' ||p_next_version);
20537: oe_debug_pub.add('trans version' ||g_trans_version);
20538: END IF;
20539:
20540: IF p_next_version = g_trans_version then
20541: IF g_trans_version is not null then
20565: END IF;
20566: END IF;
20567:
20568: IF l_debug_level > 0 THEN
20569: oe_debug_pub.add(' p_prior_rec salesrep'||p_prior_rec.salesrep_id);
20570: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.salesrep_id);
20571: oe_debug_pub.add(' p_next_rec '||p_next_rec.salesrep_id);
20572: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);
20573: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
20566: END IF;
20567:
20568: IF l_debug_level > 0 THEN
20569: oe_debug_pub.add(' p_prior_rec salesrep'||p_prior_rec.salesrep_id);
20570: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.salesrep_id);
20571: oe_debug_pub.add(' p_next_rec '||p_next_rec.salesrep_id);
20572: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);
20573: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
20574: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
20567:
20568: IF l_debug_level > 0 THEN
20569: oe_debug_pub.add(' p_prior_rec salesrep'||p_prior_rec.salesrep_id);
20570: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.salesrep_id);
20571: oe_debug_pub.add(' p_next_rec '||p_next_rec.salesrep_id);
20572: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);
20573: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
20574: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
20575: oe_debug_pub.add(' checking whether salesreps are same or not');
20568: IF l_debug_level > 0 THEN
20569: oe_debug_pub.add(' p_prior_rec salesrep'||p_prior_rec.salesrep_id);
20570: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.salesrep_id);
20571: oe_debug_pub.add(' p_next_rec '||p_next_rec.salesrep_id);
20572: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);
20573: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
20574: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
20575: oe_debug_pub.add(' checking whether salesreps are same or not');
20576: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20569: oe_debug_pub.add(' p_prior_rec salesrep'||p_prior_rec.salesrep_id);
20570: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.salesrep_id);
20571: oe_debug_pub.add(' p_next_rec '||p_next_rec.salesrep_id);
20572: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);
20573: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
20574: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
20575: oe_debug_pub.add(' checking whether salesreps are same or not');
20576: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20577: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20570: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.salesrep_id);
20571: oe_debug_pub.add(' p_next_rec '||p_next_rec.salesrep_id);
20572: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);
20573: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
20574: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
20575: oe_debug_pub.add(' checking whether salesreps are same or not');
20576: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20577: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20578: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
20571: oe_debug_pub.add(' p_next_rec '||p_next_rec.salesrep_id);
20572: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);
20573: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
20574: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
20575: oe_debug_pub.add(' checking whether salesreps are same or not');
20576: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20577: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20578: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
20579: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
20572: oe_debug_pub.add(' p_prior_rec sales group'||p_prior_rec.sales_group_id);
20573: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
20574: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
20575: oe_debug_pub.add(' checking whether salesreps are same or not');
20576: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20577: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20578: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
20579: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
20580: END IF;
20573: oe_debug_pub.add(' p_curr_rec '||p_curr_rec.sales_group_id);
20574: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
20575: oe_debug_pub.add(' checking whether salesreps are same or not');
20576: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20577: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20578: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
20579: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
20580: END IF;
20581: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists ='Y') OR
20574: oe_debug_pub.add(' p_next_rec '||p_next_rec.sales_group_id);
20575: oe_debug_pub.add(' checking whether salesreps are same or not');
20576: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20577: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20578: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
20579: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
20580: END IF;
20581: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists ='Y') OR
20582: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='Y') THEN
20575: oe_debug_pub.add(' checking whether salesreps are same or not');
20576: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
20577: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
20578: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
20579: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
20580: END IF;
20581: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists ='Y') OR
20582: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='Y') THEN
20583: IF l_debug_level > 0 THEN
20580: END IF;
20581: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists ='Y') OR
20582: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='Y') THEN
20583: IF l_debug_level > 0 THEN
20584: oe_debug_pub.add(' both exists - checking if both are same');
20585: END IF;
20586: IF OE_Globals.Equal(p_prior_rec.salesrep_id,p_curr_rec.salesrep_id) OR
20587: OE_Globals.Equal( p_curr_rec.salesrep_id, p_next_rec.salesrep_id) THEN
20588: /****************************/
21453: END IF;
21454: END IF; /* p and c = Y or c and n=y */
21455:
21456: IF l_debug_level > 0 THEN
21457: oe_debug_pub.add(' before finding new sales credits ');
21458: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
21459: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
21460: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
21461: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
21454: END IF; /* p and c = Y or c and n=y */
21455:
21456: IF l_debug_level > 0 THEN
21457: oe_debug_pub.add(' before finding new sales credits ');
21458: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
21459: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
21460: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
21461: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
21462: END IF;
21455:
21456: IF l_debug_level > 0 THEN
21457: oe_debug_pub.add(' before finding new sales credits ');
21458: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
21459: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
21460: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
21461: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
21462: END IF;
21463: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR
21456: IF l_debug_level > 0 THEN
21457: oe_debug_pub.add(' before finding new sales credits ');
21458: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
21459: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
21460: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
21461: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
21462: END IF;
21463: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR
21464: (p_curr_rec_exists = 'N' and p_next_rec_exists ='Y') THEN
21457: oe_debug_pub.add(' before finding new sales credits ');
21458: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
21459: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
21460: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
21461: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
21462: END IF;
21463: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR
21464: (p_curr_rec_exists = 'N' and p_next_rec_exists ='Y') THEN
21465: IF p_prior_version IS NOT NULL and p_curr_rec_exists = 'Y' THEN
21463: IF (p_prior_rec_exists = 'N' and p_curr_rec_exists = 'Y') OR
21464: (p_curr_rec_exists = 'N' and p_next_rec_exists ='Y') THEN
21465: IF p_prior_version IS NOT NULL and p_curr_rec_exists = 'Y' THEN
21466: IF l_debug_level > 0 THEN
21467: oe_debug_pub.add(' Prior is not there - current is there');
21468: END IF;
21469: ind := ind+1;
21470: x_line_sc_changed_attr_tbl(ind).line_number := x_line_number;
21471: x_line_sc_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.Salesrep(p_curr_rec.salesrep_id);
21473: x_line_sc_changed_attr_tbl(ind).current_value := 'ADD';
21474: x_line_sc_changed_attr_tbl(ind).next_value := null;
21475: ELSIF (p_curr_rec_exists = 'N' and p_next_rec_exists = 'Y') THEN
21476: IF l_debug_level > 0 THEN
21477: oe_debug_pub.add(' Current is not there - next is there');
21478: END IF;
21479: ind := ind+1;
21480: x_line_sc_changed_attr_tbl(ind).line_number := x_line_number;
21481: x_line_sc_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.Salesrep(p_next_rec.salesrep_id);
21485: end if;
21486: END IF;
21487:
21488: IF l_debug_level > 0 THEN
21489: oe_debug_pub.add(' before finding deleted salesreps');
21490: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
21491: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
21492: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
21493: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
21486: END IF;
21487:
21488: IF l_debug_level > 0 THEN
21489: oe_debug_pub.add(' before finding deleted salesreps');
21490: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
21491: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
21492: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
21493: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
21494: END IF;
21487:
21488: IF l_debug_level > 0 THEN
21489: oe_debug_pub.add(' before finding deleted salesreps');
21490: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
21491: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
21492: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
21493: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
21494: END IF;
21495: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR
21488: IF l_debug_level > 0 THEN
21489: oe_debug_pub.add(' before finding deleted salesreps');
21490: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
21491: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
21492: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
21493: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
21494: END IF;
21495: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR
21496: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='N') THEN
21489: oe_debug_pub.add(' before finding deleted salesreps');
21490: oe_debug_pub.add(' p_prior_rec_exists'||p_prior_rec_exists);
21491: oe_debug_pub.add(' p_curr_rec_exists'||p_curr_rec_exists);
21492: oe_debug_pub.add(' p_next_rec_exists'||p_next_rec_exists);
21493: oe_debug_pub.add(' p_trans_rec_exists'||p_trans_rec_exists);
21494: END IF;
21495: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR
21496: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='N') THEN
21497: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N' THEN
21495: IF (p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N') OR
21496: (p_curr_rec_exists = 'Y' and p_next_rec_exists ='N') THEN
21497: IF p_prior_rec_exists = 'Y' and p_curr_rec_exists = 'N' THEN
21498: IF l_debug_level > 0 THEN
21499: oe_debug_pub.add(' Prior is there - current is not there');
21500: END IF;
21501: ind := ind+1;
21502: x_line_sc_changed_attr_tbl(ind).line_number := x_line_number;
21503: x_line_sc_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.Salesrep(p_prior_rec.salesrep_id);
21505: x_line_sc_changed_attr_tbl(ind).current_value := 'DELETE';
21506: x_line_sc_changed_attr_tbl(ind).next_value := null;
21507: ELSIF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'N' THEN
21508: IF l_debug_level > 0 THEN
21509: oe_debug_pub.add(' p_next_version'||p_next_version);
21510: oe_debug_pub.add(' g_trans_version'||g_trans_version);
21511: END IF;
21512: --if p_next_version != g_trans_version THEN
21513: IF l_debug_level > 0 THEN
21506: x_line_sc_changed_attr_tbl(ind).next_value := null;
21507: ELSIF p_curr_rec_exists = 'Y' and p_next_rec_exists = 'N' THEN
21508: IF l_debug_level > 0 THEN
21509: oe_debug_pub.add(' p_next_version'||p_next_version);
21510: oe_debug_pub.add(' g_trans_version'||g_trans_version);
21511: END IF;
21512: --if p_next_version != g_trans_version THEN
21513: IF l_debug_level > 0 THEN
21514: oe_debug_pub.add(' Current is there - next is not there');
21510: oe_debug_pub.add(' g_trans_version'||g_trans_version);
21511: END IF;
21512: --if p_next_version != g_trans_version THEN
21513: IF l_debug_level > 0 THEN
21514: oe_debug_pub.add(' Current is there - next is not there');
21515: END IF;
21516: ind := ind+1;
21517: x_line_sc_changed_attr_tbl(ind).line_number := x_line_number;
21518: x_line_sc_changed_attr_tbl(ind).attribute_value := OE_ID_TO_VALUE.Salesrep(p_curr_rec.salesrep_id);
21522: --end if;
21523: end if;
21524: END IF;
21525: IF l_debug_level > 0 THEN
21526: oe_debug_pub.add('******BEFORE COMPARING ATTRIBUTES*************');
21527: oe_debug_pub.add('current ind '|| ind);
21528: END IF;
21529:
21530: IF (p_prior_version IS NOT NULL and p_prior_rec_exists ='Y') OR
21523: end if;
21524: END IF;
21525: IF l_debug_level > 0 THEN
21526: oe_debug_pub.add('******BEFORE COMPARING ATTRIBUTES*************');
21527: oe_debug_pub.add('current ind '|| ind);
21528: END IF;
21529:
21530: IF (p_prior_version IS NOT NULL and p_prior_rec_exists ='Y') OR
21531: (p_current_version IS NOT NULL and p_curr_rec_exists ='Y') OR
21537: NULL;
21538: END IF;
21539: END IF; /* line_id not null */
21540: IF l_debug_level > 0 THEN
21541: oe_debug_pub.add('******AFTER COMPARING ATTRIBUTES*************');
21542: oe_debug_pub.add('current ind '|| ind);
21543: END IF;
21544: IF l_debug_level > 0 THEN
21545: oe_debug_pub.add(' Exiting OE_VERSION_COMP.Compare_line_sc_Attributes ');
21538: END IF;
21539: END IF; /* line_id not null */
21540: IF l_debug_level > 0 THEN
21541: oe_debug_pub.add('******AFTER COMPARING ATTRIBUTES*************');
21542: oe_debug_pub.add('current ind '|| ind);
21543: END IF;
21544: IF l_debug_level > 0 THEN
21545: oe_debug_pub.add(' Exiting OE_VERSION_COMP.Compare_line_sc_Attributes ');
21546: END IF;
21541: oe_debug_pub.add('******AFTER COMPARING ATTRIBUTES*************');
21542: oe_debug_pub.add('current ind '|| ind);
21543: END IF;
21544: IF l_debug_level > 0 THEN
21545: oe_debug_pub.add(' Exiting OE_VERSION_COMP.Compare_line_sc_Attributes ');
21546: END IF;
21547: /*
21548: j := 0;
21549: dbms_output.put_line('No of resales dreditcords'||x_line_sc_changed_attr_tbl.count);
21601: total_lines NUMBER;
21602: l_line_id NUMBER;
21603: x_sales_rep VARCHAR2(200);
21604: x_line_number VARCHAR2(30);
21605: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
21606: BEGIN
21607: IF l_debug_level > 0 THEN
21608: oe_debug_pub.add('Entering Compare_line_sc_versions');
21609: oe_debug_pub.add('header' ||p_header_id);
21604: x_line_number VARCHAR2(30);
21605: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
21606: BEGIN
21607: IF l_debug_level > 0 THEN
21608: oe_debug_pub.add('Entering Compare_line_sc_versions');
21609: oe_debug_pub.add('header' ||p_header_id);
21610: oe_debug_pub.add('prior version' ||p_prior_version);
21611: oe_debug_pub.add('current version' ||p_current_version);
21612: oe_debug_pub.add('next version' ||p_next_version);
21605: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
21606: BEGIN
21607: IF l_debug_level > 0 THEN
21608: oe_debug_pub.add('Entering Compare_line_sc_versions');
21609: oe_debug_pub.add('header' ||p_header_id);
21610: oe_debug_pub.add('prior version' ||p_prior_version);
21611: oe_debug_pub.add('current version' ||p_current_version);
21612: oe_debug_pub.add('next version' ||p_next_version);
21613: oe_debug_pub.add('max version' ||g_max_version);
21606: BEGIN
21607: IF l_debug_level > 0 THEN
21608: oe_debug_pub.add('Entering Compare_line_sc_versions');
21609: oe_debug_pub.add('header' ||p_header_id);
21610: oe_debug_pub.add('prior version' ||p_prior_version);
21611: oe_debug_pub.add('current version' ||p_current_version);
21612: oe_debug_pub.add('next version' ||p_next_version);
21613: oe_debug_pub.add('max version' ||g_max_version);
21614: oe_debug_pub.add('trans version' ||g_trans_version);
21607: IF l_debug_level > 0 THEN
21608: oe_debug_pub.add('Entering Compare_line_sc_versions');
21609: oe_debug_pub.add('header' ||p_header_id);
21610: oe_debug_pub.add('prior version' ||p_prior_version);
21611: oe_debug_pub.add('current version' ||p_current_version);
21612: oe_debug_pub.add('next version' ||p_next_version);
21613: oe_debug_pub.add('max version' ||g_max_version);
21614: oe_debug_pub.add('trans version' ||g_trans_version);
21615: END IF;
21608: oe_debug_pub.add('Entering Compare_line_sc_versions');
21609: oe_debug_pub.add('header' ||p_header_id);
21610: oe_debug_pub.add('prior version' ||p_prior_version);
21611: oe_debug_pub.add('current version' ||p_current_version);
21612: oe_debug_pub.add('next version' ||p_next_version);
21613: oe_debug_pub.add('max version' ||g_max_version);
21614: oe_debug_pub.add('trans version' ||g_trans_version);
21615: END IF;
21616:
21609: oe_debug_pub.add('header' ||p_header_id);
21610: oe_debug_pub.add('prior version' ||p_prior_version);
21611: oe_debug_pub.add('current version' ||p_current_version);
21612: oe_debug_pub.add('next version' ||p_next_version);
21613: oe_debug_pub.add('max version' ||g_max_version);
21614: oe_debug_pub.add('trans version' ||g_trans_version);
21615: END IF;
21616:
21617: ind1:=0;
21610: oe_debug_pub.add('prior version' ||p_prior_version);
21611: oe_debug_pub.add('current version' ||p_current_version);
21612: oe_debug_pub.add('next version' ||p_next_version);
21613: oe_debug_pub.add('max version' ||g_max_version);
21614: oe_debug_pub.add('trans version' ||g_trans_version);
21615: END IF;
21616:
21617: ind1:=0;
21618: total_lines:=0;
21622: LOOP
21623: FETCH C_GET_sales_credits INTO l_sales_credit_id,l_line_id;
21624: EXIT WHEN C_GET_sales_credits%NOTFOUND;
21625: IF l_debug_level > 0 THEN
21626: oe_debug_pub.add('*************sales_credits found(trans)******************'||l_sales_credit_id);
21627: oe_debug_pub.add('*************sales_credits found(line_id)******************'||l_line_id);
21628: END IF;
21629:
21630: IF l_sales_credit_id IS NOT NULL THEN
21623: FETCH C_GET_sales_credits INTO l_sales_credit_id,l_line_id;
21624: EXIT WHEN C_GET_sales_credits%NOTFOUND;
21625: IF l_debug_level > 0 THEN
21626: oe_debug_pub.add('*************sales_credits found(trans)******************'||l_sales_credit_id);
21627: oe_debug_pub.add('*************sales_credits found(line_id)******************'||l_line_id);
21628: END IF;
21629:
21630: IF l_sales_credit_id IS NOT NULL THEN
21631: IF l_debug_level > 0 THEN
21628: END IF;
21629:
21630: IF l_sales_credit_id IS NOT NULL THEN
21631: IF l_debug_level > 0 THEN
21632: oe_debug_pub.add('*************before call total sales_credits(trans) ******************'||ind1);
21633: END IF;
21634:
21635: IF l_line_id IS NOT NULL THEN
21636: -- bug 9299752
21663: ind1 := x_line_sc_changed_attr_tbl.count;
21664: -- ind1 := ind1 + total_lines;
21665: END IF;
21666: IF l_debug_level > 0 THEN
21667: oe_debug_pub.add('*************after call total sales_credits(trans) ******************'||ind1);
21668: END IF;
21669: END IF; /* sales_Credit_id is not null */
21670: END LOOP;
21671: CLOSE C_GET_sales_credits;
21674: LOOP
21675: FETCH C_GET_HIST_sales_credits INTO l_sales_credit_id,l_line_id;
21676: EXIT WHEN C_GET_HIST_sales_credits%NOTFOUND;
21677: IF l_debug_level > 0 THEN
21678: oe_debug_pub.add('*************sales_credits found******************'||l_sales_credit_id);
21679: END IF;
21680:
21681: IF l_sales_credit_id IS NOT NULL THEN
21682: IF l_debug_level > 0 THEN
21679: END IF;
21680:
21681: IF l_sales_credit_id IS NOT NULL THEN
21682: IF l_debug_level > 0 THEN
21683: oe_debug_pub.add('*************before call total sales_credits ******************'||ind1);
21684: END IF;
21685: -- bug 9299752
21686: begin
21687: select oe_order_misc_pub.get_concat_hist_line_number(l_line_id) into x_line_number from dual;
21703: x_line_sc_changed_attr_tbl => x_line_sc_changed_attr_tbl,
21704: p_total_lines => ind1,
21705: x_line_number => x_line_number);
21706: IF l_debug_level > 0 THEN
21707: oe_debug_pub.add('*************after call total sales credits ******************'||ind1);
21708: END IF;
21709: IF x_line_sc_changed_attr_tbl.count > 0 THEN
21710: ind1 := x_line_sc_changed_attr_tbl.count;
21711: -- ind1 := ind1 + total_lines;
21722: ) RETURN VARCHAR2
21723: IS
21724: l_line_status VARCHAR2(80) := NULL;
21725: --
21726: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
21727: --
21728: BEGIN
21729:
21730: IF p_line_status_code IS NOT NULL THEN
21742: EXCEPTION
21743:
21744: WHEN NO_DATA_FOUND THEN
21745: IF l_debug_level > 0 THEN
21746: oe_debug_pub.add('could not find line_status meaning');
21747: END IF;
21748: RETURN NULL;
21749: WHEN OTHERS THEN
21750: IF l_debug_level > 0 THEN
21747: END IF;
21748: RETURN NULL;
21749: WHEN OTHERS THEN
21750: IF l_debug_level > 0 THEN
21751: oe_debug_pub.add('others exception - line_status meaning');
21752: END IF;
21753: RETURN NULL;
21754: END line_status;
21755:
21767:
21768: l_attribute_value1 VARCHAR2(80);
21769: l_attribute_value2 VARCHAR2(80);
21770: --
21771: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
21772: --
21773: l_encrypted VARCHAR2(30); --PADSS
21774:
21775: BEGIN
21774:
21775: BEGIN
21776:
21777: IF l_debug_level > 0 THEN
21778: oe_debug_pub.add('Entering OE_VERSION_COMP.Card_Equal. ', 3);
21779: END IF;
21780:
21781: IF p_attribute_name = 'CREDIT_CARD_HOLDER_NAME' THEN
21782: -- instrument_id stores the card_history_change_id
22052: and application_column_name =p_application_column_name
22053: and DESCRIPTIVE_FLEX_CONTEXT_CODE in (p_descriptive_flex_context_cod, p_desc_flex_context_cod_prior, p_desc_flex_context_cod_next, 'Global Data Elements');
22054:
22055: BEGIN
22056: oe_debug_pub.add('Entering get_dff_seg_prompt');
22057: fnd_message.set_name('ONT','ONT_SLASH_SEPARATOR');
22058: slash:=FND_MESSAGE.GET;
22059:
22060: IF p_application_column_name = 'CONTEXT' THEN --Context Prompt
22061: select FORM_CONTEXT_PROMPT into l_prompt from FND_DESCRIPTIVE_FLEXS_VL
22062: where APPLICATION_ID = p_application_id
22063: and DESCRIPTIVE_FLEXFIELD_NAME = p_descriptive_flexfield_name;
22064:
22065: oe_debug_pub.add('Context Prompt='||l_prompt);
22066: ELSE --Attribute Prompt
22067:
22068: IF p_descriptive_flex_context_cod IS NULL
22069: AND p_desc_flex_context_cod_prior IS NULL
22071: select form_left_prompt into l_prompt from fnd_descr_flex_col_usage_vl where application_id=660
22072: and descriptive_flexfield_name= p_descriptive_flexfield_name
22073: and application_column_name =p_application_column_name;
22074:
22075: oe_debug_pub.add('Prompt='||l_prompt);
22076:
22077: ELSE --Context has been passed
22078: OPEN C1;
22079: LOOP
22078: OPEN C1;
22079: LOOP
22080: FETCH C1 into l_prompt;
22081: exit When C1%NOTFOUND;
22082: oe_debug_pub.add('lPrompt='||l_prompt);
22083: if x_prompt IS NULL THEN
22084: x_prompt:=l_prompt;
22085: ELSIF x_prompt <> l_prompt THEN
22086: x_prompt:=x_prompt||slash||l_prompt;
22086: x_prompt:=x_prompt||slash||l_prompt;
22087: END IF;
22088: END LOOP;
22089: CLOSE C1;
22090: oe_debug_pub.add('Prompt='||x_prompt);
22091: RETURN(x_prompt);
22092: END IF; --Context been passed
22093: END IF; --Context/Attribute Prompt
22094: RETURN(l_prompt);
22095: EXCEPTION
22096: WHEN no_data_found THEN
22097: Return null;
22098: WHEN OTHERS THEN
22099: oe_debug_pub.add('error is'||SQLCODE||'message'||SQLERRM);
22100: Return Null;
22101: END get_dff_seg_prompt;
22102: --bug 4302049}
22103: