eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_VERSION_COMP dependencies on OE_VERSION_COMP

Line 1: PACKAGE BODY OE_VERSION_COMP AS

1: PACKAGE BODY OE_VERSION_COMP AS
2: /* $Header: OEXSCOMB.pls 120.11.12010000.2 2008/11/25 08:40:34 msundara ship $ */
3:
4: PROCEDURE QUERY_HEADER_ROW
5: (p_header_id NUMBER,

Line 15: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_ROW'||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;

Line 404: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_TRANS_ROW');

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:

Line 804: x_header_changed_attr_tbl IN OUT NOCOPY OE_VERSION_COMP.header_tbl_type)

800: g_trans_version NUMBER,
801: g_prior_phase_change_flag VARCHAR2,
802: g_curr_phase_change_flag VARCHAR2,
803: g_next_phase_change_flag VARCHAR2,
804: x_header_changed_attr_tbl IN OUT NOCOPY OE_VERSION_COMP.header_tbl_type)
805: IS
806: p_curr_rec OE_Order_PUB.Header_Rec_Type;
807: p_next_rec OE_Order_PUB.Header_Rec_Type;
808: p_prior_rec OE_Order_PUB.Header_Rec_Type;

Line 893: oe_debug_pub.add('Entering OE_VERSION_COMP'||l_debug_level);

889:
890: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
891: BEGIN
892:
893: oe_debug_pub.add('Entering OE_VERSION_COMP'||l_debug_level);
894: IF l_debug_level > 0 THEN
895: oe_debug_pub.add('Entering OE_VERSION_COMP.COMPARE_HEADER_VERSIONS');
896: oe_debug_pub.add('header' ||p_header_id);
897: oe_debug_pub.add('prior_version' ||p_prior_version);

Line 895: oe_debug_pub.add('Entering OE_VERSION_COMP.COMPARE_HEADER_VERSIONS');

891: BEGIN
892:
893: oe_debug_pub.add('Entering OE_VERSION_COMP'||l_debug_level);
894: IF l_debug_level > 0 THEN
895: oe_debug_pub.add('Entering OE_VERSION_COMP.COMPARE_HEADER_VERSIONS');
896: oe_debug_pub.add('header' ||p_header_id);
897: oe_debug_pub.add('prior_version' ||p_prior_version);
898: oe_debug_pub.add('curr_version' ||p_current_version);
899: oe_debug_pub.add('next_version' ||p_next_version);

Line 908: OE_VERSION_COMP.QUERY_HEADER_ROW(p_header_id => p_header_id,

904: oe_debug_pub.add('next phase chagne' ||g_next_phase_change_flag);
905: END IF;
906:
907: IF p_prior_version IS NOT NULL THEN
908: OE_VERSION_COMP.QUERY_HEADER_ROW(p_header_id => p_header_id,
909: p_version => p_prior_version,
910: p_phase_change_flag => g_prior_phase_change_flag,
911: x_header_rec => p_prior_rec);
912: END IF;

Line 914: OE_VERSION_COMP.QUERY_HEADER_ROW(p_header_id => p_header_id,

910: p_phase_change_flag => g_prior_phase_change_flag,
911: x_header_rec => p_prior_rec);
912: END IF;
913: IF p_current_version IS NOT NULL THEN
914: OE_VERSION_COMP.QUERY_HEADER_ROW(p_header_id => p_header_id,
915: p_version => p_current_version,
916: p_phase_change_flag => g_curr_phase_change_flag,
917: x_header_rec => p_curr_rec);
918: END IF;

Line 922: OE_VERSION_COMP.QUERY_HEADER_TRANS_ROW(p_header_id => p_header_id,

918: END IF;
919: IF p_next_version = g_trans_version then
920: IF g_trans_version is not null then
921: --p_next_version := g_trans_version;
922: OE_VERSION_COMP.QUERY_HEADER_TRANS_ROW(p_header_id => p_header_id,
923: p_version => g_trans_version,
924: x_header_rec => p_next_rec);
925: END IF;
926: ELSE

Line 928: OE_VERSION_COMP.QUERY_HEADER_ROW(p_header_id => p_header_id,

924: x_header_rec => p_next_rec);
925: END IF;
926: ELSE
927: IF p_next_version IS NOT NULL THEN
928: OE_VERSION_COMP.QUERY_HEADER_ROW(p_header_id => p_header_id,
929: p_version => p_next_version,
930: p_phase_change_flag => g_next_phase_change_flag,
931: x_header_rec => p_next_rec);
932: END IF;

Line 7066: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_LINE_ROW');

7062: l_org_id NUMBER;
7063: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7064: BEGIN
7065: IF l_debug_level > 0 THEN
7066: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_LINE_ROW');
7067: oe_debug_pub.add('header' ||p_header_id);
7068: oe_debug_pub.add('version' ||p_version);
7069: END IF;
7070:

Line 7752: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_LINE_TRANS_ROW', 1);

7748: l_org_id NUMBER;
7749: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7750: BEGIN
7751: IF l_debug_level > 0 THEN
7752: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_LINE_TRANS_ROW', 1);
7753: oe_debug_pub.add('header' ||p_header_id);
7754: oe_debug_pub.add('version' ||p_version);
7755: END IF;
7756:

Line 8436: x_line_changed_attr_tbl IN OUT NOCOPY OE_VERSION_COMP.line_tbl_type,

8432: g_trans_version NUMBER,
8433: g_prior_phase_change_flag VARCHAR2,
8434: g_curr_phase_change_flag VARCHAR2,
8435: g_next_phase_change_flag VARCHAR2,
8436: x_line_changed_attr_tbl IN OUT NOCOPY OE_VERSION_COMP.line_tbl_type,
8437: p_total_lines NUMBER,
8438: x_line_number VARCHAR2)
8439: IS
8440: p_curr_rec OE_Order_PUB.line_rec_type;

Line 8557: OE_VERSION_COMP.QUERY_LINE_ROW(p_header_id => p_header_id,

8553: oe_debug_pub.add('prior version' ||p_prior_version);
8554: END IF;
8555: /***************************************/
8556: IF p_prior_version IS NOT NULL THEN
8557: OE_VERSION_COMP.QUERY_LINE_ROW(p_header_id => p_header_id,
8558: p_line_id => p_line_id,
8559: p_version => p_prior_version,
8560: p_phase_change_flag => g_prior_phase_change_flag,
8561: x_line_rec => p_prior_rec);

Line 8574: OE_VERSION_COMP.QUERY_LINE_ROW(p_header_id => p_header_id,

8570: oe_debug_pub.add('current version' ||p_current_version);
8571: END IF;
8572:
8573: IF p_current_version IS NOT NULL THEN
8574: OE_VERSION_COMP.QUERY_LINE_ROW(p_header_id => p_header_id,
8575: p_line_id => p_line_id,
8576: p_version => p_current_version,
8577: p_phase_change_flag => g_curr_phase_change_flag,
8578: x_line_rec => p_curr_rec);

Line 8594: OE_VERSION_COMP.QUERY_LINE_TRANS_ROW(p_header_id => p_header_id,

8590: END IF;
8591: IF p_next_version = g_trans_version then
8592: IF g_trans_version is not null then
8593: --p_next_version := g_trans_version;
8594: OE_VERSION_COMP.QUERY_LINE_TRANS_ROW(p_header_id => p_header_id,
8595: p_line_id => p_line_id,
8596: p_version => g_trans_version,
8597: x_line_rec => p_next_rec);
8598: END IF;

Line 8607: OE_VERSION_COMP.QUERY_LINE_ROW(p_header_id => p_header_id,

8603: p_next_rec_exists := 'Y';
8604: END IF;
8605: ELSE
8606: IF p_next_version IS NOT NULL THEN
8607: OE_VERSION_COMP.QUERY_LINE_ROW(p_header_id => p_header_id,
8608: p_line_id => p_line_id,
8609: p_version => p_next_version,
8610: p_phase_change_flag => g_next_phase_change_flag,
8611: x_line_rec => p_next_rec);

Line 18115: oe_debug_pub.add(' Exiting OE_VERSION_COMP.Compare_Line_Attributes ');

18111: oe_debug_pub.add('******AFTER COMPARING ATTRIBUTES*************');
18112: oe_debug_pub.add('current ind '|| ind);
18113: END IF;
18114: IF l_debug_level > 0 THEN
18115: oe_debug_pub.add(' Exiting OE_VERSION_COMP.Compare_Line_Attributes ');
18116: END IF;
18117: /*
18118: j := 0;
18119: dbms_output.put_line('No of records'||x_line_changed_attr_tbl.count);

Line 18139: x_line_changed_attr_tbl IN OUT NOCOPY OE_VERSION_COMP.line_tbl_type)

18135: g_trans_version NUMBER,
18136: g_prior_phase_change_flag VARCHAR2,
18137: g_curr_phase_change_flag VARCHAR2,
18138: g_next_phase_change_flag VARCHAR2,
18139: x_line_changed_attr_tbl IN OUT NOCOPY OE_VERSION_COMP.line_tbl_type)
18140: IS
18141:
18142: l_line_id NUMBER;
18143: CURSOR C_get_lines(p_header_id IN NUMBER,p_prior_version IN NUMBER, p_current_version IN NUMBER, p_next_version IN NUMBER) IS

Line 18276: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_SC_ROW', 1);

18272: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
18273: BEGIN
18274:
18275: IF l_debug_level > 0 THEN
18276: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_SC_ROW', 1);
18277: oe_debug_pub.add('header' ||p_header_id);
18278: oe_debug_pub.add('sales credit' ||p_sales_credit_id);
18279: oe_debug_pub.add('version' ||p_version);
18280: END IF;

Line 18393: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_SC_TRANS_ROW');

18389: l_phase_change_flag VARCHAR2(1);
18390: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
18391: BEGIN
18392: IF l_debug_level > 0 THEN
18393: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_HEADER_SC_TRANS_ROW');
18394: oe_debug_pub.add('header' ||p_header_id);
18395: oe_debug_pub.add('version' ||p_version);
18396: END IF;
18397:

Line 18504: x_header_sc_changed_attr_tbl IN OUT NOCOPY OE_VERSION_COMP.header_sc_tbl_type,

18500: g_trans_version NUMBER,
18501: g_prior_phase_change_flag VARCHAR2,
18502: g_curr_phase_change_flag VARCHAR2,
18503: g_next_phase_change_flag VARCHAR2,
18504: x_header_sc_changed_attr_tbl IN OUT NOCOPY OE_VERSION_COMP.header_sc_tbl_type,
18505: p_total_lines NUMBER)
18506: IS
18507: p_curr_rec OE_Order_PUB.Header_scredit_Rec_Type;
18508: p_next_rec OE_Order_PUB.Header_scredit_Rec_Type;

Line 18556: OE_VERSION_COMP.QUERY_HEADER_SC_ROW(p_header_id => p_header_id,

18552: oe_debug_pub.add('prior version' ||p_prior_version);
18553: END IF;
18554:
18555: IF p_prior_version IS NOT NULL THEN
18556: OE_VERSION_COMP.QUERY_HEADER_SC_ROW(p_header_id => p_header_id,
18557: p_sales_credit_id => p_sales_credit_id,
18558: p_version => p_prior_version,
18559: p_phase_change_flag => g_prior_phase_change_flag,
18560: x_header_scredit_rec => p_prior_rec);

Line 18573: OE_VERSION_COMP.QUERY_HEADER_SC_ROW(p_header_id => p_header_id,

18569: oe_debug_pub.add('current version' ||p_current_version);
18570: END IF;
18571:
18572: IF p_current_version IS NOT NULL THEN
18573: OE_VERSION_COMP.QUERY_HEADER_SC_ROW(p_header_id => p_header_id,
18574: p_sales_credit_id => p_sales_credit_id,
18575: p_version => p_current_version,
18576: p_phase_change_flag => g_curr_phase_change_flag,
18577: x_header_scredit_rec => p_curr_rec);

Line 18593: OE_VERSION_COMP.QUERY_HEADER_SC_TRANS_ROW(p_header_id => p_header_id,

18589: END IF;
18590:
18591: IF p_next_version = g_trans_version then
18592: IF g_trans_version is not null then
18593: OE_VERSION_COMP.QUERY_HEADER_SC_TRANS_ROW(p_header_id => p_header_id,
18594: p_sales_credit_id => p_sales_credit_id,
18595: p_version => p_next_version,
18596: x_header_scredit_rec => p_next_rec);
18597: END IF;

Line 18606: OE_VERSION_COMP.QUERY_HEADER_SC_ROW(p_header_id => p_header_id,

18602: p_next_rec_exists := 'Y';
18603: END IF;
18604: ELSE
18605: IF p_next_version IS NOT NULL THEN
18606: OE_VERSION_COMP.QUERY_HEADER_SC_ROW(p_header_id => p_header_id,
18607: p_sales_credit_id => p_sales_credit_id,
18608: p_version => p_next_version,
18609: p_phase_change_flag => g_next_phase_change_flag,
18610: x_header_scredit_rec => p_next_rec);

Line 19545: oe_debug_pub.add(' Exiting OE_VERSION_COMP.Compare_header_sc_Attributes ');

19541: END IF;
19542:
19543: END IF; /* line_id not null */
19544: IF l_debug_level > 0 THEN
19545: oe_debug_pub.add(' Exiting OE_VERSION_COMP.Compare_header_sc_Attributes ');
19546: END IF;
19547: /*
19548: j := 0;
19549: dbms_output.put_line('No of resales dreditcords'||x_header_sc_changed_attr_tbl.count);

Line 19571: x_header_sc_changed_attr_tbl IN OUT NOCOPY OE_VERSION_COMP.header_sc_tbl_type)

19567: g_trans_version NUMBER,
19568: g_prior_phase_change_flag VARCHAR2,
19569: g_curr_phase_change_flag VARCHAR2,
19570: g_next_phase_change_flag VARCHAR2,
19571: x_header_sc_changed_attr_tbl IN OUT NOCOPY OE_VERSION_COMP.header_sc_tbl_type)
19572: IS
19573:
19574: CURSOR C_get_sales_credits(p_header_id IN NUMBER,p_prior_version IN NUMBER, p_current_version IN NUMBER, p_next_version IN NUMBER) IS
19575: SELECT distinct sales_credit_id

Line 19698: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_line_SC_ROW', 1);

19694: l_org_id NUMBER;
19695: l_phase_change_flag VARCHAR2(1);
19696: BEGIN
19697:
19698: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_line_SC_ROW', 1);
19699:
19700: l_org_id := OE_GLOBALS.G_ORG_ID;
19701:
19702: IF l_org_id IS NULL THEN

Line 19809: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_line_SC_TRANS_ROW');

19805: l_phase_change_flag VARCHAR2(1);
19806: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
19807: BEGIN
19808: IF l_debug_level > 0 THEN
19809: oe_debug_pub.add('Entering OE_VERSION_COMP.QUERY_line_SC_TRANS_ROW');
19810: oe_debug_pub.add('header' ||p_header_id);
19811: oe_debug_pub.add('version' ||p_version);
19812: END IF;
19813:

Line 19921: x_line_sc_changed_attr_tbl IN OUT NOCOPY OE_VERSION_COMP.line_sc_tbl_type,

19917: g_trans_version NUMBER,
19918: g_prior_phase_change_flag VARCHAR2,
19919: g_curr_phase_change_flag VARCHAR2,
19920: g_next_phase_change_flag VARCHAR2,
19921: x_line_sc_changed_attr_tbl IN OUT NOCOPY OE_VERSION_COMP.line_sc_tbl_type,
19922: p_total_lines NUMBER,
19923: x_line_number VARCHAR2)
19924: IS
19925: p_curr_rec OE_Order_PUB.line_scredit_Rec_Type;

Line 19974: OE_VERSION_COMP.QUERY_line_SC_ROW(p_header_id => p_header_id,

19970: oe_debug_pub.add('prior version' ||p_prior_version);
19971: END IF;
19972:
19973: IF p_prior_version IS NOT NULL THEN
19974: OE_VERSION_COMP.QUERY_line_SC_ROW(p_header_id => p_header_id,
19975: p_sales_credit_id => p_sales_credit_id,
19976: p_version => p_prior_version,
19977: p_phase_change_flag => g_prior_phase_change_flag,
19978: x_line_scredit_rec => p_prior_rec);

Line 19991: OE_VERSION_COMP.QUERY_line_SC_ROW(p_header_id => p_header_id,

19987: oe_debug_pub.add('current version' ||p_current_version);
19988: END IF;
19989:
19990: IF p_current_version IS NOT NULL THEN
19991: OE_VERSION_COMP.QUERY_line_SC_ROW(p_header_id => p_header_id,
19992: p_sales_credit_id => p_sales_credit_id,
19993: p_version => p_current_version,
19994: p_phase_change_flag => g_curr_phase_change_flag,
19995: x_line_scredit_rec => p_curr_rec);

Line 20011: OE_VERSION_COMP.QUERY_line_SC_TRANS_ROW(p_header_id => p_header_id,

20007: END IF;
20008:
20009: IF p_next_version = g_trans_version then
20010: IF g_trans_version is not null then
20011: OE_VERSION_COMP.QUERY_line_SC_TRANS_ROW(p_header_id => p_header_id,
20012: p_sales_credit_id => p_sales_credit_id,
20013: p_version => p_next_version,
20014: x_line_scredit_rec => p_next_rec);
20015: END IF;

Line 20024: OE_VERSION_COMP.QUERY_line_SC_ROW(p_header_id => p_header_id,

20020: p_next_rec_exists := 'Y';
20021: END IF;
20022: ELSE
20023: IF p_next_version IS NOT NULL THEN
20024: OE_VERSION_COMP.QUERY_line_SC_ROW(p_header_id => p_header_id,
20025: p_sales_credit_id => p_sales_credit_id,
20026: p_version => p_next_version,
20027: p_phase_change_flag => g_prior_phase_change_flag,
20028: x_line_scredit_rec => p_next_rec);

Line 21014: oe_debug_pub.add(' Exiting OE_VERSION_COMP.Compare_line_sc_Attributes ');

21010: oe_debug_pub.add('******AFTER COMPARING ATTRIBUTES*************');
21011: oe_debug_pub.add('current ind '|| ind);
21012: END IF;
21013: IF l_debug_level > 0 THEN
21014: oe_debug_pub.add(' Exiting OE_VERSION_COMP.Compare_line_sc_Attributes ');
21015: END IF;
21016: /*
21017: j := 0;
21018: dbms_output.put_line('No of resales dreditcords'||x_line_sc_changed_attr_tbl.count);

Line 21040: x_line_sc_changed_attr_tbl IN OUT NOCOPY OE_VERSION_COMP.line_sc_tbl_type)

21036: g_trans_version NUMBER,
21037: g_prior_phase_change_flag VARCHAR2,
21038: g_curr_phase_change_flag VARCHAR2,
21039: g_next_phase_change_flag VARCHAR2,
21040: x_line_sc_changed_attr_tbl IN OUT NOCOPY OE_VERSION_COMP.line_sc_tbl_type)
21041: IS
21042:
21043: CURSOR C_get_sales_credits(p_header_id IN NUMBER,p_prior_version IN NUMBER, p_current_version IN NUMBER, p_next_version IN NUMBER) IS
21044: SELECT distinct sales_credit_id,line_id

Line 21228: oe_debug_pub.add('Entering OE_VERSION_COMP.Card_Equal. ', 3);

21224:
21225: BEGIN
21226:
21227: IF l_debug_level > 0 THEN
21228: oe_debug_pub.add('Entering OE_VERSION_COMP.Card_Equal. ', 3);
21229: END IF;
21230:
21231: IF p_attribute_name = 'CREDIT_CARD_HOLDER_NAME' THEN
21232: -- instrument_id stores the card_history_change_id

Line 21487: END OE_VERSION_COMP;

21483: Return Null;
21484: END get_dff_seg_prompt;
21485: --bug 4302049}
21486:
21487: END OE_VERSION_COMP;