APPS.GMIVDBL dependencies on SY_REAS_CDS

Line 1493: FUNCTION sy_reas_cds_select

1489: GMIGUTL.DB_ERRMSG:= SQLERRM;
1490: RETURN FALSE;
1491: END ic_adjs_jnl_insert;
1492:
1493: FUNCTION sy_reas_cds_select
1494: (p_sy_reas_cds_row IN sy_reas_cds%ROWTYPE, x_sy_reas_cds_row IN OUT NOCOPY sy_reas_cds%ROWTYPE)
1495: RETURN BOOLEAN
1496: IS
1497: BEGIN

Line 1494: (p_sy_reas_cds_row IN sy_reas_cds%ROWTYPE, x_sy_reas_cds_row IN OUT NOCOPY sy_reas_cds%ROWTYPE)

1490: RETURN FALSE;
1491: END ic_adjs_jnl_insert;
1492:
1493: FUNCTION sy_reas_cds_select
1494: (p_sy_reas_cds_row IN sy_reas_cds%ROWTYPE, x_sy_reas_cds_row IN OUT NOCOPY sy_reas_cds%ROWTYPE)
1495: RETURN BOOLEAN
1496: IS
1497: BEGIN
1498: SELECT * INTO x_sy_reas_cds_row FROM sy_reas_cds

Line 1498: SELECT * INTO x_sy_reas_cds_row FROM sy_reas_cds

1494: (p_sy_reas_cds_row IN sy_reas_cds%ROWTYPE, x_sy_reas_cds_row IN OUT NOCOPY sy_reas_cds%ROWTYPE)
1495: RETURN BOOLEAN
1496: IS
1497: BEGIN
1498: SELECT * INTO x_sy_reas_cds_row FROM sy_reas_cds
1499: WHERE reason_code = p_sy_reas_cds_row.reason_code;
1500:
1501: GMIGUTL.DB_ERRNUM := NULL;
1502: RETURN TRUE;

Line 1499: WHERE reason_code = p_sy_reas_cds_row.reason_code;

1495: RETURN BOOLEAN
1496: IS
1497: BEGIN
1498: SELECT * INTO x_sy_reas_cds_row FROM sy_reas_cds
1499: WHERE reason_code = p_sy_reas_cds_row.reason_code;
1500:
1501: GMIGUTL.DB_ERRNUM := NULL;
1502: RETURN TRUE;
1503:

Line 1524: END sy_reas_cds_select;

1520:
1521: GMIGUTL.DB_ERRNUM := SQLCODE;
1522: GMIGUTL.DB_ERRMSG:= SQLERRM;
1523: RETURN FALSE;
1524: END sy_reas_cds_select;
1525:
1526:
1527:
1528:

Line 1537: x_reason_code SY_REAS_CDS.REASON_CODE%TYPE := null;

1533:
1534:
1535: IS
1536: x_conv_audit_id GMI_ITEM_CONV_AUDIT.CONV_AUDIT_ID%TYPE;
1537: x_reason_code SY_REAS_CDS.REASON_CODE%TYPE := null;
1538: x_type_factor IC_ITEM_CNV.TYPE_FACTOR%TYPE := null;
1539: x_event_spec_disp_id IC_ITEM_CNV.EVENT_SPEC_DISP_ID%TYPE := null;
1540:
1541: BEGIN