DBA Data[Home] [Help]

APPS.OE_VERSION_BLANKET_COMP dependencies on OE_VERSION_BLANKET_COMP

Line 1: PACKAGE BODY OE_VERSION_BLANKET_COMP AS

1: PACKAGE BODY OE_VERSION_BLANKET_COMP AS
2: /* $Header: OEXBCOMB.pls 120.3 2006/04/07 00:15:10 mbhoumik noship $ */
3:
4: PROCEDURE QUERY_HEADER_ROW
5: (p_header_id NUMBER,

Line 15: oe_debug_pub.add('Entering OE_VERSION_BLANKET_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_BLANKET_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 464: x_header_changed_attr_tbl IN OUT NOCOPY OE_VERSION_BLANKET_COMP.header_tbl_type)

460: g_trans_version NUMBER,
461: g_prior_phase_change_flag VARCHAR2,
462: g_curr_phase_change_flag VARCHAR2,
463: g_next_phase_change_flag VARCHAR2,
464: x_header_changed_attr_tbl IN OUT NOCOPY OE_VERSION_BLANKET_COMP.header_tbl_type)
465: IS
466: p_curr_rec OE_Blanket_PUB.Header_Rec_Type;
467: p_next_rec OE_Blanket_PUB.Header_Rec_Type;
468: p_prior_rec OE_Blanket_PUB.Header_Rec_Type;

Line 564: OE_VERSION_BLANKET_COMP.QUERY_HEADER_ROW(p_header_id => p_header_id,

560: oe_debug_pub.add(' Querying prior version details');
561: oe_debug_pub.add('prior_versio' ||p_prior_version);
562: END IF;
563: IF p_prior_version IS NOT NULL THEN
564: OE_VERSION_BLANKET_COMP.QUERY_HEADER_ROW(p_header_id => p_header_id,
565: p_version => p_prior_version,
566: p_phase_change_flag => g_prior_phase_change_flag,
567: x_header_rec => p_prior_rec);
568: END IF;

Line 574: OE_VERSION_BLANKET_COMP.QUERY_HEADER_ROW(p_header_id => p_header_id,

570: oe_debug_pub.add(' Querying current version details');
571: oe_debug_pub.add('current_versio' ||p_current_version);
572: END IF;
573: IF p_current_version IS NOT NULL THEN
574: OE_VERSION_BLANKET_COMP.QUERY_HEADER_ROW(p_header_id => p_header_id,
575: p_version => p_current_version,
576: p_phase_change_flag => g_curr_phase_change_flag,
577: x_header_rec => p_curr_rec);
578: END IF;

Line 586: OE_VERSION_BLANKET_COMP.QUERY_HEADER_TRANS_ROW(p_header_id => p_header_id,

582: oe_debug_pub.add('trans_version' ||g_trans_version);
583: END IF;
584: IF p_next_version = g_trans_version then
585: IF g_trans_version is not null then
586: OE_VERSION_BLANKET_COMP.QUERY_HEADER_TRANS_ROW(p_header_id => p_header_id,
587: p_version => g_trans_version,
588: x_header_rec => p_next_rec);
589: END IF;
590: ELSE

Line 592: OE_VERSION_BLANKET_COMP.QUERY_HEADER_ROW(p_header_id => p_header_id,

588: x_header_rec => p_next_rec);
589: END IF;
590: ELSE
591: IF p_next_version IS NOT NULL THEN
592: OE_VERSION_BLANKET_COMP.QUERY_HEADER_ROW(p_header_id => p_header_id,
593: p_version => p_next_version,
594: p_phase_change_flag => g_next_phase_change_flag,
595: x_header_rec => p_next_rec);
596: END IF;

Line 4042: oe_debug_pub.add('Entering OE_VERSION_BLANKET_COMP.QUERY_LINE_ROW');

4038: l_org_id NUMBER;
4039: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4040: BEGIN
4041: IF l_debug_level > 0 THEN
4042: oe_debug_pub.add('Entering OE_VERSION_BLANKET_COMP.QUERY_LINE_ROW');
4043: oe_debug_pub.add('header' ||p_header_id);
4044: oe_debug_pub.add('version' ||p_version);
4045: oe_debug_pub.add('phase_change_lfag' ||p_phase_change_flag);
4046: END IF;

Line 4252: oe_debug_pub.add('Entering OE_VERSION_BLANKET_COMP.QUERY_LINE_TRANS_ROW', 1);

4248: l_org_id NUMBER;
4249: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4250: BEGIN
4251: IF l_debug_level > 0 THEN
4252: oe_debug_pub.add('Entering OE_VERSION_BLANKET_COMP.QUERY_LINE_TRANS_ROW', 1);
4253: oe_debug_pub.add('header' ||p_header_id);
4254: oe_debug_pub.add('version' ||p_version);
4255: END IF;
4256:

Line 4459: x_line_changed_attr_tbl IN OUT NOCOPY OE_VERSION_BLANKET_COMP.line_tbl_type,

4455: g_trans_version NUMBER,
4456: g_prior_phase_change_flag VARCHAR2,
4457: g_curr_phase_change_flag VARCHAR2,
4458: g_next_phase_change_flag VARCHAR2,
4459: x_line_changed_attr_tbl IN OUT NOCOPY OE_VERSION_BLANKET_COMP.line_tbl_type,
4460: p_total_lines NUMBER,
4461: x_line_number NUMBER)
4462: IS
4463: p_curr_rec OE_Blanket_PUB.line_rec_type;

Line 4573: OE_VERSION_BLANKET_COMP.QUERY_LINE_ROW(p_header_id => p_header_id,

4569: oe_debug_pub.add('prior version' ||p_prior_version);
4570: END IF;
4571:
4572: IF p_prior_version IS NOT NULL THEN
4573: OE_VERSION_BLANKET_COMP.QUERY_LINE_ROW(p_header_id => p_header_id,
4574: p_line_id => p_line_id,
4575: p_version => p_prior_version,
4576: p_phase_change_flag => g_prior_phase_change_flag,
4577: x_line_rec => p_prior_rec);

Line 4590: OE_VERSION_BLANKET_COMP.QUERY_LINE_ROW(p_header_id => p_header_id,

4586: oe_debug_pub.add('current version' ||p_current_version);
4587: END IF;
4588:
4589: IF p_current_version IS NOT NULL THEN
4590: OE_VERSION_BLANKET_COMP.QUERY_LINE_ROW(p_header_id => p_header_id,
4591: p_line_id => p_line_id,
4592: p_version => p_current_version,
4593: p_phase_change_flag => g_curr_phase_change_flag,
4594: x_line_rec => p_curr_rec);

Line 4612: OE_VERSION_BLANKET_COMP.QUERY_LINE_TRANS_ROW(p_header_id => p_header_id,

4608:
4609: IF p_next_version = g_trans_version then
4610: IF g_trans_version is not null then
4611: --p_next_version := g_trans_version;
4612: OE_VERSION_BLANKET_COMP.QUERY_LINE_TRANS_ROW(p_header_id => p_header_id,
4613: p_line_id => p_line_id,
4614: p_version => g_trans_version,
4615: x_line_rec => p_next_rec);
4616: END IF;

Line 4625: OE_VERSION_BLANKET_COMP.QUERY_LINE_ROW(p_header_id => p_header_id,

4621: p_next_rec_exists := 'Y';
4622: END IF;
4623: ELSE
4624: IF p_next_version IS NOT NULL THEN
4625: OE_VERSION_BLANKET_COMP.QUERY_LINE_ROW(p_header_id => p_header_id,
4626: p_line_id => p_line_id,
4627: p_version => p_next_version,
4628: p_phase_change_flag => g_next_phase_change_flag,
4629: x_line_rec => p_next_rec);

Line 7694: x_line_changed_attr_tbl IN OUT NOCOPY OE_VERSION_BLANKET_COMP.line_tbl_type)

7690: g_trans_version NUMBER,
7691: g_prior_phase_change_flag VARCHAR2,
7692: g_curr_phase_change_flag VARCHAR2,
7693: g_next_phase_change_flag VARCHAR2,
7694: x_line_changed_attr_tbl IN OUT NOCOPY OE_VERSION_BLANKET_COMP.line_tbl_type)
7695: IS
7696:
7697: l_line_id NUMBER;
7698:

Line 7916: END OE_VERSION_BLANKET_COMP;

7912: Return Null;
7913: END get_dff_seg_prompt;
7914: --bug 4302049
7915:
7916: END OE_VERSION_BLANKET_COMP;