DBA Data[Home] [Help]

APPS.PO_CORE_S dependencies on PO_LOOKUP_CODES

Line 1010: table po_lookup_codes. These values are validated

1006: descriptioni VARCHAR2
1007: validate BOOLEAN
1008:
1009: ALGORITHM : Get the displayed field and description from the
1010: table po_lookup_codes. These values are validated
1011: against the inactive date if x_validate is set to TRUE
1012: No validation is performed if x_validate is set to
1013: FALSE.
1014: NOTES :

Line 1033: FROM po_lookup_codes plc

1029: SELECT plc.displayed_field,
1030: plc.description
1031: INTO x_disp_value,
1032: x_description
1033: FROM po_lookup_codes plc
1034: WHERE plc.lookup_code = x_lookup_code
1035: AND plc.lookup_type = x_lookup_type
1036: AND sysdate < nvl(plc.inactive_date,sysdate + 1);
1037:

Line 1076: table po_lookup_codes.

1072: displayed_field VARCHAR2
1073: descriptioni VARCHAR2
1074:
1075: ALGORITHM : Get the displayed field and description from the
1076: table po_lookup_codes.
1077:
1078: NOTES :
1079:
1080: =========================================================================== */

Line 1094: FROM po_lookup_codes plc

1090: SELECT plc.displayed_field,
1091: plc.description
1092: INTO x_disp_value,
1093: x_description
1094: FROM po_lookup_codes plc
1095: WHERE plc.lookup_code = x_lookup_code
1096: AND plc.lookup_type = x_lookup_type;
1097:
1098: EXCEPTION

Line 1129: ALGORITHM : Get the displayed field from the table po_lookup_codes.

1125: lookup_code VARCHAR2
1126: displayed_field VARCHAR2
1127:
1128:
1129: ALGORITHM : Get the displayed field from the table po_lookup_codes.
1130:
1131: NOTES :
1132:
1133: =========================================================================== */

Line 1146: FROM po_lookup_codes plc

1142: x_progress := 10;
1143:
1144: SELECT plc.displayed_field
1145: INTO x_disp_value
1146: FROM po_lookup_codes plc
1147: WHERE plc.lookup_code = x_lookup_code
1148: AND plc.lookup_type = x_lookup_type;
1149:
1150: EXCEPTION

Line 3950: FROM po_lookup_codes

3946:
3947:
3948: cursor C is
3949: SELECT inactive_date
3950: FROM po_lookup_codes
3951: WHERE
3952: lookup_type = p_lookup_rec.lookup_type and
3953: lookup_code = p_lookup_rec.lookup_code;
3954:

Line 3957: X_inactive_date po_lookup_codes.INACTIVE_DATE%TYPE;

3953: lookup_code = p_lookup_rec.lookup_code;
3954:
3955: X_sysdate Date := sysdate;
3956:
3957: X_inactive_date po_lookup_codes.INACTIVE_DATE%TYPE;
3958:
3959: BEGIN
3960:
3961: OPEN C;

Line 7015: -- PO_LOOKUP_CODES.displayed_field%TYPE

7011: -- Gets the text to display for the "Reserved" keyword.
7012: --Parameters:
7013: --OUT:
7014: --x_displayed_field
7015: -- PO_LOOKUP_CODES.displayed_field%TYPE
7016: -- The text corresponding to the 'RESERVED' code.
7017: --End of Comments
7018: --------------------------------------------------------------------------------
7019: PROCEDURE get_reserved_lookup(

Line 7038: FROM PO_LOOKUP_CODES POLC

7034: l_progress := '010';
7035:
7036: SELECT POLC.displayed_field
7037: INTO x_displayed_field
7038: FROM PO_LOOKUP_CODES POLC
7039: WHERE POLC.lookup_type = 'DOCUMENT STATE'
7040: AND POLC.lookup_code = 'RESERVED'
7041: ;
7042:

Line 7197: l_status_code PO_LOOKUP_CODES.displayed_field%TYPE;

7193:
7194: l_sep VARCHAR2(8) := ', ';
7195: l_ret_sts VARCHAR2(1);
7196:
7197: l_status_code PO_LOOKUP_CODES.displayed_field%TYPE;
7198: l_cancel_status PO_LOOKUP_CODES.displayed_field%TYPE;
7199: l_closed_status PO_LOOKUP_CODES.displayed_field%TYPE;
7200: l_frozen_status PO_LOOKUP_CODES.displayed_field%TYPE;
7201: l_hold_status PO_LOOKUP_CODES.displayed_field%TYPE;

Line 7198: l_cancel_status PO_LOOKUP_CODES.displayed_field%TYPE;

7194: l_sep VARCHAR2(8) := ', ';
7195: l_ret_sts VARCHAR2(1);
7196:
7197: l_status_code PO_LOOKUP_CODES.displayed_field%TYPE;
7198: l_cancel_status PO_LOOKUP_CODES.displayed_field%TYPE;
7199: l_closed_status PO_LOOKUP_CODES.displayed_field%TYPE;
7200: l_frozen_status PO_LOOKUP_CODES.displayed_field%TYPE;
7201: l_hold_status PO_LOOKUP_CODES.displayed_field%TYPE;
7202: l_auth_status PO_HEADERS.authorization_status%TYPE;

Line 7199: l_closed_status PO_LOOKUP_CODES.displayed_field%TYPE;

7195: l_ret_sts VARCHAR2(1);
7196:
7197: l_status_code PO_LOOKUP_CODES.displayed_field%TYPE;
7198: l_cancel_status PO_LOOKUP_CODES.displayed_field%TYPE;
7199: l_closed_status PO_LOOKUP_CODES.displayed_field%TYPE;
7200: l_frozen_status PO_LOOKUP_CODES.displayed_field%TYPE;
7201: l_hold_status PO_LOOKUP_CODES.displayed_field%TYPE;
7202: l_auth_status PO_HEADERS.authorization_status%TYPE;
7203: l_offline_status PO_LOOKUP_CODES.displayed_field%TYPE;

Line 7200: l_frozen_status PO_LOOKUP_CODES.displayed_field%TYPE;

7196:
7197: l_status_code PO_LOOKUP_CODES.displayed_field%TYPE;
7198: l_cancel_status PO_LOOKUP_CODES.displayed_field%TYPE;
7199: l_closed_status PO_LOOKUP_CODES.displayed_field%TYPE;
7200: l_frozen_status PO_LOOKUP_CODES.displayed_field%TYPE;
7201: l_hold_status PO_LOOKUP_CODES.displayed_field%TYPE;
7202: l_auth_status PO_HEADERS.authorization_status%TYPE;
7203: l_offline_status PO_LOOKUP_CODES.displayed_field%TYPE;
7204: l_reserved_status PO_LOOKUP_CODES.displayed_field%TYPE;

Line 7201: l_hold_status PO_LOOKUP_CODES.displayed_field%TYPE;

7197: l_status_code PO_LOOKUP_CODES.displayed_field%TYPE;
7198: l_cancel_status PO_LOOKUP_CODES.displayed_field%TYPE;
7199: l_closed_status PO_LOOKUP_CODES.displayed_field%TYPE;
7200: l_frozen_status PO_LOOKUP_CODES.displayed_field%TYPE;
7201: l_hold_status PO_LOOKUP_CODES.displayed_field%TYPE;
7202: l_auth_status PO_HEADERS.authorization_status%TYPE;
7203: l_offline_status PO_LOOKUP_CODES.displayed_field%TYPE;
7204: l_reserved_status PO_LOOKUP_CODES.displayed_field%TYPE;
7205:

Line 7203: l_offline_status PO_LOOKUP_CODES.displayed_field%TYPE;

7199: l_closed_status PO_LOOKUP_CODES.displayed_field%TYPE;
7200: l_frozen_status PO_LOOKUP_CODES.displayed_field%TYPE;
7201: l_hold_status PO_LOOKUP_CODES.displayed_field%TYPE;
7202: l_auth_status PO_HEADERS.authorization_status%TYPE;
7203: l_offline_status PO_LOOKUP_CODES.displayed_field%TYPE;
7204: l_reserved_status PO_LOOKUP_CODES.displayed_field%TYPE;
7205:
7206: l_cancel_flag PO_HEADERS.cancel_flag%TYPE;
7207: l_closed_code PO_HEADERS.closed_code%TYPE;

Line 7204: l_reserved_status PO_LOOKUP_CODES.displayed_field%TYPE;

7200: l_frozen_status PO_LOOKUP_CODES.displayed_field%TYPE;
7201: l_hold_status PO_LOOKUP_CODES.displayed_field%TYPE;
7202: l_auth_status PO_HEADERS.authorization_status%TYPE;
7203: l_offline_status PO_LOOKUP_CODES.displayed_field%TYPE;
7204: l_reserved_status PO_LOOKUP_CODES.displayed_field%TYPE;
7205:
7206: l_cancel_flag PO_HEADERS.cancel_flag%TYPE;
7207: l_closed_code PO_HEADERS.closed_code%TYPE;
7208: l_frozen_flag PO_HEADERS.frozen_flag%TYPE;

Line 7236: FROM po_requisition_headers prh, po_lookup_codes plc_sta, po_lookup_codes plc_clo

7232: SELECT plc_sta.displayed_field
7233: , prh.authorization_status
7234: , DECODE(nvl(prh.closed_code,'OPEN'), 'OPEN', NULL, plc_clo.displayed_field)
7235: INTO l_status_code, l_auth_status, l_closed_status
7236: FROM po_requisition_headers prh, po_lookup_codes plc_sta, po_lookup_codes plc_clo
7237: WHERE plc_sta.lookup_code = DECODE(prh.authorization_status,
7238: 'SYSTEM_SAVED', 'INCOMPLETE',
7239: nvl(prh.authorization_status, 'INCOMPLETE')
7240: )

Line 7252: FROM po_lookup_codes polc, po_action_history poah

7248: BEGIN
7249:
7250: SELECT polc.displayed_field, nvl(poah.offline_code, 'N')
7251: INTO l_offline_status, l_offline_flag
7252: FROM po_lookup_codes polc, po_action_history poah
7253: WHERE polc.lookup_type = 'DOCUMENT STATE'
7254: AND polc.lookup_code = poah.offline_code
7255: AND poah.object_id = p_document_id
7256: AND poah.object_type_code = 'REQUISITION'

Line 7292: , po_lookup_codes plc_sta

7288: , l_closed_code
7289: , l_frozen_flag
7290: , l_user_hold_flag
7291: FROM po_headers poh
7292: , po_lookup_codes plc_sta
7293: , po_lookup_codes plc_can
7294: , po_lookup_codes plc_clo
7295: , po_lookup_codes plc_fro
7296: , po_lookup_codes plc_hld

Line 7293: , po_lookup_codes plc_can

7289: , l_frozen_flag
7290: , l_user_hold_flag
7291: FROM po_headers poh
7292: , po_lookup_codes plc_sta
7293: , po_lookup_codes plc_can
7294: , po_lookup_codes plc_clo
7295: , po_lookup_codes plc_fro
7296: , po_lookup_codes plc_hld
7297: WHERE plc_sta.lookup_code = DECODE(poh.approved_flag,

Line 7294: , po_lookup_codes plc_clo

7290: , l_user_hold_flag
7291: FROM po_headers poh
7292: , po_lookup_codes plc_sta
7293: , po_lookup_codes plc_can
7294: , po_lookup_codes plc_clo
7295: , po_lookup_codes plc_fro
7296: , po_lookup_codes plc_hld
7297: WHERE plc_sta.lookup_code = DECODE(poh.approved_flag,
7298: 'R', poh.approved_flag,

Line 7295: , po_lookup_codes plc_fro

7291: FROM po_headers poh
7292: , po_lookup_codes plc_sta
7293: , po_lookup_codes plc_can
7294: , po_lookup_codes plc_clo
7295: , po_lookup_codes plc_fro
7296: , po_lookup_codes plc_hld
7297: WHERE plc_sta.lookup_code = DECODE(poh.approved_flag,
7298: 'R', poh.approved_flag,
7299: nvl(poh.authorization_status, 'INCOMPLETE')

Line 7296: , po_lookup_codes plc_hld

7292: , po_lookup_codes plc_sta
7293: , po_lookup_codes plc_can
7294: , po_lookup_codes plc_clo
7295: , po_lookup_codes plc_fro
7296: , po_lookup_codes plc_hld
7297: WHERE plc_sta.lookup_code = DECODE(poh.approved_flag,
7298: 'R', poh.approved_flag,
7299: nvl(poh.authorization_status, 'INCOMPLETE')
7300: )

Line 7318: FROM po_lookup_codes polc, po_action_history poah

7314: BEGIN
7315:
7316: SELECT polc.displayed_field, nvl(poah.offline_code, 'N')
7317: INTO l_offline_status, l_offline_flag
7318: FROM po_lookup_codes polc, po_action_history poah
7319: WHERE polc.lookup_type = 'DOCUMENT STATE'
7320: AND polc.lookup_code = poah.offline_code
7321: AND poah.object_id = p_document_id
7322: AND poah.object_type_code IN ('PO', 'PA')

Line 7358: , po_lookup_codes plc_sta

7354: , l_closed_code
7355: , l_frozen_flag
7356: , l_user_hold_flag
7357: FROM po_releases por
7358: , po_lookup_codes plc_sta
7359: , po_lookup_codes plc_can
7360: , po_lookup_codes plc_clo
7361: , po_lookup_codes plc_fro
7362: , po_lookup_codes plc_hld

Line 7359: , po_lookup_codes plc_can

7355: , l_frozen_flag
7356: , l_user_hold_flag
7357: FROM po_releases por
7358: , po_lookup_codes plc_sta
7359: , po_lookup_codes plc_can
7360: , po_lookup_codes plc_clo
7361: , po_lookup_codes plc_fro
7362: , po_lookup_codes plc_hld
7363: WHERE plc_sta.lookup_code = DECODE(por.approved_flag,

Line 7360: , po_lookup_codes plc_clo

7356: , l_user_hold_flag
7357: FROM po_releases por
7358: , po_lookup_codes plc_sta
7359: , po_lookup_codes plc_can
7360: , po_lookup_codes plc_clo
7361: , po_lookup_codes plc_fro
7362: , po_lookup_codes plc_hld
7363: WHERE plc_sta.lookup_code = DECODE(por.approved_flag,
7364: 'R', por.approved_flag,

Line 7361: , po_lookup_codes plc_fro

7357: FROM po_releases por
7358: , po_lookup_codes plc_sta
7359: , po_lookup_codes plc_can
7360: , po_lookup_codes plc_clo
7361: , po_lookup_codes plc_fro
7362: , po_lookup_codes plc_hld
7363: WHERE plc_sta.lookup_code = DECODE(por.approved_flag,
7364: 'R', por.approved_flag,
7365: nvl(por.authorization_status, 'INCOMPLETE')

Line 7362: , po_lookup_codes plc_hld

7358: , po_lookup_codes plc_sta
7359: , po_lookup_codes plc_can
7360: , po_lookup_codes plc_clo
7361: , po_lookup_codes plc_fro
7362: , po_lookup_codes plc_hld
7363: WHERE plc_sta.lookup_code = DECODE(por.approved_flag,
7364: 'R', por.approved_flag,
7365: nvl(por.authorization_status, 'INCOMPLETE')
7366: )

Line 7384: FROM po_lookup_codes polc, po_action_history poah

7380: BEGIN
7381:
7382: SELECT polc.displayed_field, nvl(poah.offline_code, 'N')
7383: INTO l_offline_status, l_offline_flag
7384: FROM po_lookup_codes polc, po_action_history poah
7385: WHERE polc.lookup_type = 'DOCUMENT STATE'
7386: AND polc.lookup_code = poah.offline_code
7387: AND poah.object_id = p_document_id
7388: AND poah.object_type_code = 'RELEASE'