DBA Data[Home] [Help]

APPS.OKL_QPY_PVT dependencies on OKL_QUOTE_PARTIES_V

Line 219: p_token2_value => 'OKL_QUOTE_PARTIES_V',

215: p_msg_name => G_NO_PARENT_RECORD,
216: p_token1 => G_COL_NAME_TOKEN,
217: p_token1_value => 'qte_id',
218: p_token2 => G_CHILD_TABLE_TOKEN,
219: p_token2_value => 'OKL_QUOTE_PARTIES_V',
220: p_token3 => G_PARENT_TABLE_TOKEN,
221: p_token3_value => 'OKL_TRX_QUOTES_V');
222:
223: -- notify caller of an error

Line 303: p_token2_value => 'OKL_QUOTE_PARTIES_V',

299: p_msg_name => G_NO_PARENT_RECORD,
300: p_token1 => G_COL_NAME_TOKEN,
301: p_token1_value => 'cpl_id',
302: p_token2 => G_CHILD_TABLE_TOKEN,
303: p_token2_value => 'OKL_QUOTE_PARTIES_V',
304: p_token3 => G_PARENT_TABLE_TOKEN,
305: p_token3_value => 'OKC_K_PARTY_ROLES_V');
306:
307: -- notify caller of an error

Line 370: p_token2_value => 'OKL_QUOTE_PARTIES_V',

366: p_msg_name => G_NO_PARENT_RECORD,
367: p_token1 => G_COL_NAME_TOKEN,
368: p_token1_value => 'party_jtot_object1_code',
369: p_token2 => G_CHILD_TABLE_TOKEN,
370: p_token2_value => 'OKL_QUOTE_PARTIES_V',
371: p_token3 => G_PARENT_TABLE_TOKEN,
372: p_token3_value => 'JTF_OBJECTS_VL');
373:
374: -- notify caller of an error

Line 523: p_token2_value => 'OKL_QUOTE_PARTIES_V',

519: p_msg_name => G_NO_PARENT_RECORD,
520: p_token1 => G_COL_NAME_TOKEN,
521: p_token1_value => 'contact_jtot_object1_code',
522: p_token2 => G_CHILD_TABLE_TOKEN,
523: p_token2_value => 'OKL_QUOTE_PARTIES_V',
524: p_token3 => G_PARENT_TABLE_TOKEN,
525: p_token3_value => 'JTF_OBJECTS_VL');
526:
527: -- notify caller of an error

Line 810: -- FUNCTION get_rec for: OKL_QUOTE_PARTIES_V

806: BEGIN
807: RETURN(get_rec(p_qpy_rec, l_row_notfound));
808: END get_rec;
809: ---------------------------------------------------------------------------
810: -- FUNCTION get_rec for: OKL_QUOTE_PARTIES_V
811: ---------------------------------------------------------------------------
812: FUNCTION get_rec (
813: p_qpyv_rec IN qpyv_rec_type,
814: x_no_data_found OUT NOCOPY BOOLEAN

Line 838: FROM Okl_Quote_Parties_V

834: CREATION_DATE,
835: LAST_UPDATED_BY,
836: LAST_UPDATE_DATE,
837: LAST_UPDATE_LOGIN
838: FROM Okl_Quote_Parties_V
839: WHERE okl_quote_parties_v.id = p_id;
840: l_okl_qpyv_pk okl_qpyv_pk_csr%ROWTYPE;
841: l_qpyv_rec qpyv_rec_type;
842: BEGIN

Line 839: WHERE okl_quote_parties_v.id = p_id;

835: LAST_UPDATED_BY,
836: LAST_UPDATE_DATE,
837: LAST_UPDATE_LOGIN
838: FROM Okl_Quote_Parties_V
839: WHERE okl_quote_parties_v.id = p_id;
840: l_okl_qpyv_pk okl_qpyv_pk_csr%ROWTYPE;
841: l_qpyv_rec qpyv_rec_type;
842: BEGIN
843: x_no_data_found := TRUE;

Line 881: -- FUNCTION null_out_defaults for: OKL_QUOTE_PARTIES_V --

877: RETURN(get_rec(p_qpyv_rec, l_row_notfound));
878: END get_rec;
879:
880: ---------------------------------------------------------
881: -- FUNCTION null_out_defaults for: OKL_QUOTE_PARTIES_V --
882: ---------------------------------------------------------
883: FUNCTION null_out_defaults (
884: p_qpyv_rec IN qpyv_rec_type
885: ) RETURN qpyv_rec_type IS

Line 953: -- Validate_Attributes for:OKL_QUOTE_PARTIES_V --

949: -- Post-Generation Change
950: -- By RMUNJULU on 31-MAY-2001
951: ---------------------------------------------------------------------------
952: -------------------------------------------------
953: -- Validate_Attributes for:OKL_QUOTE_PARTIES_V --
954: -------------------------------------------------
955: FUNCTION Validate_Attributes (
956: p_qpyv_rec IN qpyv_rec_type
957: ) RETURN VARCHAR2 IS

Line 1103: -- Validate_Record for:OKL_QUOTE_PARTIES_V --

1099: ---------------------------------------------------------------------------
1100: -- PROCEDURE Validate_Record
1101: ---------------------------------------------------------------------------
1102: ---------------------------------------------
1103: -- Validate_Record for:OKL_QUOTE_PARTIES_V --
1104: ---------------------------------------------
1105: FUNCTION Validate_Record (
1106: p_qpyv_rec IN qpyv_rec_type
1107: ) RETURN VARCHAR2 IS

Line 1246: -- validate_row for:OKL_QUOTE_PARTIES_V --

1242: ---------------------------------------------------------------------------
1243: -- PROCEDURE validate_row
1244: ---------------------------------------------------------------------------
1245: ------------------------------------------
1246: -- validate_row for:OKL_QUOTE_PARTIES_V --
1247: ------------------------------------------
1248: PROCEDURE validate_row(
1249: p_api_version IN NUMBER,
1250: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1515: -- insert_row for:OKL_QUOTE_PARTIES_V --

1511: '_PVT'
1512: );
1513: END insert_row;
1514: ----------------------------------------
1515: -- insert_row for:OKL_QUOTE_PARTIES_V --
1516: ----------------------------------------
1517: PROCEDURE insert_row(
1518: p_api_version IN NUMBER,
1519: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 1549: -- Set_Attributes for:OKL_QUOTE_PARTIES_V --

1545: l_qpyv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1546: RETURN(l_qpyv_rec);
1547: END fill_who_columns;
1548: --------------------------------------------
1549: -- Set_Attributes for:OKL_QUOTE_PARTIES_V --
1550: --------------------------------------------
1551: FUNCTION Set_Attributes (
1552: p_qpyv_rec IN qpyv_rec_type,
1553: x_qpyv_rec OUT NOCOPY qpyv_rec_type

Line 1854: -- lock_row for:OKL_QUOTE_PARTIES_V --

1850: '_PVT'
1851: );
1852: END lock_row;
1853: --------------------------------------
1854: -- lock_row for:OKL_QUOTE_PARTIES_V --
1855: --------------------------------------
1856: PROCEDURE lock_row(
1857: p_api_version IN NUMBER,
1858: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2228: -- update_row for:OKL_QUOTE_PARTIES_V --

2224: '_PVT'
2225: );
2226: END update_row;
2227: ----------------------------------------
2228: -- update_row for:OKL_QUOTE_PARTIES_V --
2229: ----------------------------------------
2230: PROCEDURE update_row(
2231: p_api_version IN NUMBER,
2232: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 2359: -- Set_Attributes for:OKL_QUOTE_PARTIES_V --

2355: END IF;
2356: RETURN(l_return_status);
2357: END populate_new_record;
2358: --------------------------------------------
2359: -- Set_Attributes for:OKL_QUOTE_PARTIES_V --
2360: --------------------------------------------
2361: FUNCTION Set_Attributes (
2362: p_qpyv_rec IN qpyv_rec_type,
2363: x_qpyv_rec OUT NOCOPY qpyv_rec_type

Line 2620: -- delete_row for:OKL_QUOTE_PARTIES_V --

2616: '_PVT'
2617: );
2618: END delete_row;
2619: ----------------------------------------
2620: -- delete_row for:OKL_QUOTE_PARTIES_V --
2621: ----------------------------------------
2622: PROCEDURE delete_row(
2623: p_api_version IN NUMBER,
2624: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,