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.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_LOG

Line 9: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := PO_LOG.get_package_base(G_PKG_NAME);

5: G_MODULE_PREFIX CONSTANT VARCHAR2(60) := 'po.plsql.' || G_PKG_NAME || '.';
6: G_FND_DEBUG VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
7: G_FND_DEBUG_LEVEL VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_LEVEL'),'0');
8:
9: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := PO_LOG.get_package_base(G_PKG_NAME);
10: D_archive_attribute_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'archive_attribute_values');
11: D_archive_attr_values_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'archive_attr_values_tlp');
12:
13: PROCEDURE archive_attribute_values

Line 10: D_archive_attribute_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'archive_attribute_values');

6: G_FND_DEBUG VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
7: G_FND_DEBUG_LEVEL VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_LEVEL'),'0');
8:
9: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := PO_LOG.get_package_base(G_PKG_NAME);
10: D_archive_attribute_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'archive_attribute_values');
11: D_archive_attr_values_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'archive_attr_values_tlp');
12:
13: PROCEDURE archive_attribute_values
14: (

Line 11: D_archive_attr_values_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'archive_attr_values_tlp');

7: G_FND_DEBUG_LEVEL VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_LEVEL'),'0');
8:
9: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := PO_LOG.get_package_base(G_PKG_NAME);
10: D_archive_attribute_values CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'archive_attribute_values');
11: D_archive_attr_values_tlp CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'archive_attr_values_tlp');
12:
13: PROCEDURE archive_attribute_values
14: (
15: p_po_header_id IN NUMBER

Line 3404: IF PO_LOG.d_proc THEN

3400: l_progress VARCHAR2(4) := '000';
3401: BEGIN
3402: l_progress := '000';
3403:
3404: IF PO_LOG.d_proc THEN
3405: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
3406: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
3407: END IF;
3408:

Line 3405: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);

3401: BEGIN
3402: l_progress := '000';
3403:
3404: IF PO_LOG.d_proc THEN
3405: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
3406: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
3407: END IF;
3408:
3409: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Calling INSERT'); END IF;

Line 3406: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);

3402: l_progress := '000';
3403:
3404: IF PO_LOG.d_proc THEN
3405: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
3406: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
3407: END IF;
3408:
3409: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Calling INSERT'); END IF;
3410:

Line 3409: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Calling INSERT'); END IF;

3405: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
3406: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
3407: END IF;
3408:
3409: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Calling INSERT'); END IF;
3410:
3411: l_progress := '010';
3412:
3413: INSERT INTO PO_ATTR_VALUES_ARCHIVE

Line 4076: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows INSERTed into ATTR archive='||SQL%rowcount); END IF;

4072: PO_LINES_ALL POL
4073: WHERE ATTR.po_line_id = POL.po_line_id
4074: AND POL.po_header_id = p_po_header_id;
4075:
4076: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows INSERTed into ATTR archive='||SQL%rowcount); END IF;
4077:
4078: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4079: EXCEPTION
4080: WHEN OTHERS THEN

Line 4078: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;

4074: AND POL.po_header_id = p_po_header_id;
4075:
4076: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows INSERTed into ATTR archive='||SQL%rowcount); END IF;
4077:
4078: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4079: EXCEPTION
4080: WHEN OTHERS THEN
4081: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
4082: RAISE;

Line 4081: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;

4077:
4078: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4079: EXCEPTION
4080: WHEN OTHERS THEN
4081: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
4082: RAISE;
4083: END archive_attribute_values;
4084:
4085: -------------------------------------------------------------------------------

Line 4115: IF PO_LOG.d_proc THEN

4111: l_progress VARCHAR2(4) := '000';
4112: BEGIN
4113: l_progress := '000';
4114:
4115: IF PO_LOG.d_proc THEN
4116: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
4117: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
4118: END IF;
4119:

Line 4116: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);

4112: BEGIN
4113: l_progress := '000';
4114:
4115: IF PO_LOG.d_proc THEN
4116: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
4117: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
4118: END IF;
4119:
4120: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Calling INSERT'); END IF;

Line 4117: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);

4113: l_progress := '000';
4114:
4115: IF PO_LOG.d_proc THEN
4116: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
4117: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
4118: END IF;
4119:
4120: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Calling INSERT'); END IF;
4121:

Line 4120: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Calling INSERT'); END IF;

4116: PO_LOG.proc_begin(d_mod,'p_po_header_id',p_po_header_id);
4117: PO_LOG.proc_begin(d_mod,'p_revision_num',p_revision_num);
4118: END IF;
4119:
4120: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Calling INSERT'); END IF;
4121:
4122: l_progress := '010';
4123:
4124: INSERT INTO PO_ATTR_VALUES_TLP_ARCHIVE

Line 4483: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows INSERTed into TLP archive='||SQL%rowcount); END IF;

4479: PO_LINES_ALL POL
4480: WHERE TLP.po_line_id = POL.po_line_id
4481: AND POL.po_header_id = p_po_header_id;
4482:
4483: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows INSERTed into TLP archive='||SQL%rowcount); END IF;
4484:
4485: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4486: EXCEPTION
4487: WHEN OTHERS THEN

Line 4485: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;

4481: AND POL.po_header_id = p_po_header_id;
4482:
4483: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Number of rows INSERTed into TLP archive='||SQL%rowcount); END IF;
4484:
4485: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4486: EXCEPTION
4487: WHEN OTHERS THEN
4488: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
4489: RAISE;

Line 4488: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;

4484:
4485: IF PO_LOG.d_proc THEN PO_LOG.proc_end(d_mod); END IF;
4486: EXCEPTION
4487: WHEN OTHERS THEN
4488: IF PO_LOG.d_exc THEN PO_LOG.exc(d_mod,l_progress,'Unhandled exception'); END IF;
4489: RAISE;
4490: END archive_attr_values_tlp;
4491:
4492: END PO_DOCUMENT_ARCHIVE_PVT;