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_CORE_S dependencies on PO_TBL_NUMBER

Line 922: l_period_year_tbl po_tbl_number;

918: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'GET_PERIOD_NAME';
919: l_progress VARCHAR2(3) := '000';
920:
921: l_period_name_tbl po_tbl_varchar30;
922: l_period_year_tbl po_tbl_number;
923: l_period_num_tbl po_tbl_number;
924: l_quarter_num_tbl po_tbl_number;
925: l_invalid_period_flag VARCHAR2(1);
926:

Line 923: l_period_num_tbl po_tbl_number;

919: l_progress VARCHAR2(3) := '000';
920:
921: l_period_name_tbl po_tbl_varchar30;
922: l_period_year_tbl po_tbl_number;
923: l_period_num_tbl po_tbl_number;
924: l_quarter_num_tbl po_tbl_number;
925: l_invalid_period_flag VARCHAR2(1);
926:
927: BEGIN

Line 924: l_quarter_num_tbl po_tbl_number;

920:
921: l_period_name_tbl po_tbl_varchar30;
922: l_period_year_tbl po_tbl_number;
923: l_period_num_tbl po_tbl_number;
924: l_quarter_num_tbl po_tbl_number;
925: l_invalid_period_flag VARCHAR2(1);
926:
927: BEGIN
928:

Line 3907: , p_doc_level_id_tbl IN po_tbl_number

3903: -------------------------------------------------------------------------------
3904: PROCEDURE get_document_ids(
3905: p_doc_type IN VARCHAR2
3906: , p_doc_level IN VARCHAR2
3907: , p_doc_level_id_tbl IN po_tbl_number
3908: , x_doc_id_tbl OUT NOCOPY po_tbl_number
3909: )
3910: IS
3911:

Line 3908: , x_doc_id_tbl OUT NOCOPY po_tbl_number

3904: PROCEDURE get_document_ids(
3905: p_doc_type IN VARCHAR2
3906: , p_doc_level IN VARCHAR2
3907: , p_doc_level_id_tbl IN po_tbl_number
3908: , x_doc_id_tbl OUT NOCOPY po_tbl_number
3909: )
3910: IS
3911:
3912: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'GET_DOCUMENT_IDS';

Line 4242: , p_doc_level_id_tbl IN po_tbl_number

4238: -------------------------------------------------------------------------------
4239: PROCEDURE get_line_ids(
4240: p_doc_type IN VARCHAR2
4241: , p_doc_level IN VARCHAR2
4242: , p_doc_level_id_tbl IN po_tbl_number
4243: , x_line_id_tbl OUT NOCOPY po_tbl_number
4244: )
4245: IS
4246:

Line 4243: , x_line_id_tbl OUT NOCOPY po_tbl_number

4239: PROCEDURE get_line_ids(
4240: p_doc_type IN VARCHAR2
4241: , p_doc_level IN VARCHAR2
4242: , p_doc_level_id_tbl IN po_tbl_number
4243: , x_line_id_tbl OUT NOCOPY po_tbl_number
4244: )
4245: IS
4246:
4247: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'GET_LINE_IDS';

Line 4569: , p_doc_level_id_tbl IN po_tbl_number

4565: -------------------------------------------------------------------------------
4566: PROCEDURE get_line_location_ids(
4567: p_doc_type IN VARCHAR2
4568: , p_doc_level IN VARCHAR2
4569: , p_doc_level_id_tbl IN po_tbl_number
4570: , x_line_location_id_tbl OUT NOCOPY po_tbl_number
4571: )
4572: IS
4573:

Line 4570: , x_line_location_id_tbl OUT NOCOPY po_tbl_number

4566: PROCEDURE get_line_location_ids(
4567: p_doc_type IN VARCHAR2
4568: , p_doc_level IN VARCHAR2
4569: , p_doc_level_id_tbl IN po_tbl_number
4570: , x_line_location_id_tbl OUT NOCOPY po_tbl_number
4571: )
4572: IS
4573:
4574: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'GET_LINE_LOCATION_IDS';

Line 4816: , p_doc_level_id_tbl IN po_tbl_number

4812: -------------------------------------------------------------------------------
4813: PROCEDURE get_distribution_ids(
4814: p_doc_type IN VARCHAR2
4815: , p_doc_level IN VARCHAR2
4816: , p_doc_level_id_tbl IN po_tbl_number
4817: , x_distribution_id_tbl OUT NOCOPY po_tbl_number
4818: )
4819: IS
4820:

Line 4817: , x_distribution_id_tbl OUT NOCOPY po_tbl_number

4813: PROCEDURE get_distribution_ids(
4814: p_doc_type IN VARCHAR2
4815: , p_doc_level IN VARCHAR2
4816: , p_doc_level_id_tbl IN po_tbl_number
4817: , x_distribution_id_tbl OUT NOCOPY po_tbl_number
4818: )
4819: IS
4820:
4821: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'GET_DISTRIBUTION_IDS';

Line 5100: , p_doc_level_id_tbl IN po_tbl_number

5096: -------------------------------------------------------------------------------
5097: PROCEDURE get_dist_ids_from_archive(
5098: p_doc_type IN VARCHAR2
5099: , p_doc_level IN VARCHAR2
5100: , p_doc_level_id_tbl IN po_tbl_number
5101: , p_doc_revision_num IN NUMBER
5102: , x_distribution_id_tbl OUT NOCOPY po_tbl_number
5103: , x_distribution_rev_num_tbl OUT NOCOPY po_tbl_number
5104: )

Line 5102: , x_distribution_id_tbl OUT NOCOPY po_tbl_number

5098: p_doc_type IN VARCHAR2
5099: , p_doc_level IN VARCHAR2
5100: , p_doc_level_id_tbl IN po_tbl_number
5101: , p_doc_revision_num IN NUMBER
5102: , x_distribution_id_tbl OUT NOCOPY po_tbl_number
5103: , x_distribution_rev_num_tbl OUT NOCOPY po_tbl_number
5104: )
5105: IS
5106:

Line 5103: , x_distribution_rev_num_tbl OUT NOCOPY po_tbl_number

5099: , p_doc_level IN VARCHAR2
5100: , p_doc_level_id_tbl IN po_tbl_number
5101: , p_doc_revision_num IN NUMBER
5102: , x_distribution_id_tbl OUT NOCOPY po_tbl_number
5103: , x_distribution_rev_num_tbl OUT NOCOPY po_tbl_number
5104: )
5105: IS
5106:
5107: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'GET_DIST_IDS_FROM_ARCHIVE';