Search Results s_letter_parameter_type




Overview
Explore in AI Chat

Overview

The IGS_CO_S_LTR_PR_ARG table is a core technical metadata table within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (Oracle's Student Systems) product family. Its primary role is to manage the relationship between dynamic SQL code blocks and their associated bind variables within the system letter generation framework. The table acts as a mapping layer, defining which bind variables are used in the executable code (code_block) of a system letter parameter and how they interface with the calling function's variables. This enables the flexible and dynamic construction of personalized correspondence, such as letters and notifications, based on predefined parameter types.

Key Information Stored

The table's structure is designed to capture the binding metadata for dynamic SQL execution. The most critical columns are the composite primary key and the direction indicator.

  • S_LETTER_PARAMETER_TYPE (VARCHAR2(10)): A foreign key to the parent system letter parameter type (e.g., SURNAME, LOCATION). It identifies the specific parameter whose code block uses the bind variable.
  • BIND_VARIABLE (VARCHAR2(50)): The name of the bind variable as it appears within the dynamic SQL code_block of the parent parameter.
  • DIRECTION (VARCHAR2): A crucial flag indicating the data flow for the bind variable. It specifies whether the variable is an input parameter passed into the dynamic SQL, an output parameter passed out of it, or both.
  • Standard WHO Columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN for audit trail purposes.

Common Use Cases and Queries

This table is primarily accessed during the runtime generation of a system letter. When a letter template is processed and a system parameter (like ATT_MODE) is encountered, the application references this table to understand how to execute the associated dynamic code block, correctly mapping application variables to the SQL bind variables. Common queries involve analyzing the bind variable setup for a given parameter or troubleshooting letter generation errors related to missing variable mappings.

Sample Query 1: List all bind variables for a specific letter parameter type.

SELECT bind_variable, direction
FROM igs.igs_co_s_ltr_pr_arg
WHERE s_letter_parameter_type = 'ATT_MODE'
ORDER BY bind_variable;

Sample Query 2: Review the complete metadata for all letter parameter bindings.

SELECT s_letter_parameter_type,
       bind_variable,
       direction,
       creation_date,
       last_updated_by
FROM igs.igs_co_s_ltr_pr_arg
ORDER BY s_letter_parameter_type, bind_variable;

Related Objects

The IGS_CO_S_LTR_PR_ARG table has a direct, documented relationship with the parent table that defines the system letter parameters themselves.

  • Primary Key: IGS_CO_S_LTR_PR_ARG_PK on (S_LETTER_PARAMETER_TYPE, BIND_VARIABLE).
  • Foreign Key Relationship: The S_LETTER_PARAMETER_TYPE column references the IGS_CO_S_LTR_PARAM table (or a similarly named parent table for system letter parameter types). This enforces referential integrity, ensuring every bind variable record is associated with a valid, existing system letter parameter type.